Tickets :: [#6758] mysql Update-Script from Version 3.1.x to 3.2 can't drop Column datatree_updated

6.0.0-beta1

11/4/25

Summary	mysql Update-Script from Version 3.1.x to 3.2 can't drop Column datatree_updated
Queue	Horde Base
Queue Version	3.2
Type	Bug
State	Resolved
Priority	2. Medium
Owners
Requester	shad0wrunner (at) gmx (dot) de
Created	05/26/2008 (6371 days ago)
Due	05/26/2008 (6371 days ago)
Updated	06/11/2008 (6355 days ago)
Assigned	05/26/2008 (6371 days ago)
Resolved	06/11/2008 (6355 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

06/11/2008 08:06:16 AM	CVS Commit	Comment #5	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.msde.sql?r1=1.2.2.14&r2=1.2.2.15&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.mysql.sql?r1=1.3.2.12&r2=1.3.2.13&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.oci8.sql?r1=1.2.2.13&r2=1.2.2.14&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.pgsql.sql?r1=1.2.2.14&r2=1.2.2.15&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.sql?r1=1.2.2.15&r2=1.2.2.16&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.sybase.sql?r1=1.2.2.14&r2=1.2.2.15&ty=u

06/11/2008 07:59:57 AM	Jan Schneider	Comment #4 State ⇒ Resolved	Reply to this comment
I removed the drop query from the update scripts. Leaving the column for people with older Horde versions doesn't hurt them.

06/11/2008 07:58:16 AM	CVS Commit	Comment #3	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.msde.sql?r1=1.15&r2=1.16&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.mysql.sql?r1=1.16&r2=1.17&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.oci8.sql?r1=1.15&r2=1.16&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.pgsql.sql?r1=1.15&r2=1.16&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.sql?r1=1.14&r2=1.15&ty=u http://cvs.horde.org/diff.php/horde/scripts/upgrades/3.1_to_3.2.sybase.sql?r1=1.15&r2=1.16&ty=u

05/26/2008 04:52:35 PM	Chuck Hagenbuch	Comment #2 State ⇒ Feedback	Reply to this comment
Actually it does: http://cvs.horde.org/co.php?r=1.4.6.4&f=horde%2Fscripts%2Fsql%2Fcreate.mysql.sql It was dropped later in the 3.1.x releases though.

05/26/2008 02:57:06 PM	shad0wrunner (at) gmx (dot) de	Comment #1 Priority ⇒ 2. Medium Type ⇒ Bug Summary ⇒ mysql Update-Script from Version 3.1.x to 3.2 can't drop Column datatree_updated Due ⇒ 05/26/2008 Queue ⇒ Horde Base Milestone ⇒ Patch ⇒ No State ⇒ Unconfirmed	Reply to this comment
The update-script 3.1_to_3.2.mysql.sql tries to drop the column datatree_updated from the Table horde_datatree (Line 90). This column does not existis in Version 3.1 .