Tickets :: [#12101] nag does not work properly after migrating db to version 11

6.0.0-beta1

7/13/25

Summary	nag does not work properly after migrating db to version 11
Queue	Horde Framework Packages
Queue Version	Git master
Type	Bug
State	Resolved
Priority	1. Low
Owners	jan (at) horde (dot) org
Requester	kudrevatykh (at) gmail (dot) com
Created	03/08/2013 (4510 days ago)
Due
Updated	03/11/2013 (4507 days ago)
Assigned	03/11/2013 (4507 days ago)
Resolved	03/11/2013 (4507 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

03/11/2013 02:50:28 PM	Jan Schneider	State ⇒ Resolved

03/11/2013 02:50:04 PM	Git Commit	Comment #4	Reply to this comment
Changes have been made in Git (master): commit 813ad65bee1954c1fc2ccb4da5ca421644811a10 Author: Jan Schneider <jan@horde.org> Date: Mon Mar 11 15:49:16 2013 +0100 [jan] Update broken rows due to migration bug in PostgreSQL (~~Bug #12101~~). nag/docs/CHANGES \| 1 + nag/migration/12_nag_fix_smartlists.php \| 32 +++++++++++++++++++++++++++++++ nag/package.xml \| 10 ++++++-- 3 files changed, 40 insertions(+), 3 deletions(-) http://git.horde.org/horde-git/-/commit/813ad65bee1954c1fc2ccb4da5ca421644811a10

03/11/2013 02:49:56 PM	Git Commit	Comment #3	Reply to this comment
Changes have been made in Git (master): commit 1fef494ee185eff9c1d0900232173e616120895d Author: Jan Schneider <jan@horde.org> Date: Mon Mar 11 15:48:05 2013 +0100 [jan] Fix updating existing rows with default values when adding columns in PostgreSQL (~~Bug #12101~~). .../Db/lib/Horde/Db/Adapter/Postgresql/Schema.php \| 5 +++++ framework/Db/package.xml \| 4 ++-- framework/Db/test/Horde/Db/Adapter/MysqlTest.php \| 4 ++++ framework/Db/test/Horde/Db/Adapter/MysqliTest.php \| 4 ++++ .../Db/test/Horde/Db/Adapter/Pdo/MysqlTest.php \| 4 ++++ .../Db/test/Horde/Db/Adapter/Pdo/PgsqlTest.php \| 4 ++++ .../Db/test/Horde/Db/Adapter/Pdo/SqliteTest.php \| 4 ++++ 7 files changed, 27 insertions(+), 2 deletions(-) http://git.horde.org/horde-git/-/commit/1fef494ee185eff9c1d0900232173e616120895d

03/11/2013 02:03:52 PM	Jan Schneider	Comment #2 Version ⇒ Git master Queue ⇒ Horde Framework Packages	Reply to this comment
Indeed a pgsql-only problem.

03/11/2013 02:01:51 PM	Jan Schneider	State ⇒ Assigned Assigned to Jan Schneider

03/08/2013 09:43:15 AM	kudrevatykh (at) gmail (dot) com	Comment #1 Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ nag does not work properly after migrating db to version 11 Queue ⇒ Nag Milestone ⇒ Patch ⇒ No State ⇒ Unconfirmed	Reply to this comment
After last update I found, that user can't see their default task lists in 'My Task Lists'. after Investigatigation I found, that problem was in attribute_issmart column added to nag_sharesng, after migration old tasklist have null value in that column, and when I changed it to 0 all started to work properly. I use postgresql 8.4, if bug not in migration script but in postgresql adapter please, reassign it accordinly. Thanks.