Tickets :: [#5949] upgrade from 2.1 to 2.2 is broken for postgres

6.0.0-beta1

7/18/25

Summary	upgrade from 2.1 to 2.2 is broken for postgres
Queue	Turba
Queue Version	2.2-RC1
Type	Bug
State	Resolved
Priority	1. Low
Owners	jan (at) horde (dot) org, mrubinsk (at) horde (dot) org
Requester	cbs (at) cts (dot) ucla (dot) edu
Created	12/02/2007 (6438 days ago)
Due
Updated	12/06/2007 (6434 days ago)
Assigned	12/04/2007 (6436 days ago)
Resolved	12/06/2007 (6434 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

12/06/2007 03:09:09 AM	Chuck Hagenbuch	State ⇒ Resolved

12/06/2007 01:14:53 AM	cbs (at) cts (dot) ucla (dot) edu	Comment #7	Reply to this comment
Works fine now. Should be fixed with: http://cvs.horde.org/co.php?r=1.18&p=1&f=turba%2Fscripts%2Fupgrades%2F2.1_to_2.2_sql_schema.php

12/06/2007 12:51:52 AM	Jan Schneider	Comment #6	Reply to this comment
Should be fixed with: http://cvs.horde.org/co.php?r=1.18&p=1&f=turba%2Fscripts%2Fupgrades%2F2.1_to_2.2_sql_schema.php

12/05/2007 11:22:03 PM	cbs (at) cts (dot) ucla (dot) edu	Comment #5	Reply to this comment
Can you please try the following version of the upgrade script: http://cvs.horde.org/co.php?r=1.17&p=1&f=turba%2Fscripts%2Fupgrades%2F2.1_to_2.2_sql_schema.php postgres doesn't have a BLOB type. That script failed to creat object_photo and object_logo. Commenting those out, the rest of the script appears to run fine.

12/04/2007 03:38:51 PM	Jan Schneider	Comment #4 State ⇒ Feedback	Reply to this comment
Can you please try the following version of the upgrade script: http://cvs.horde.org/co.php?r=1.17&p=1&f=turba%2Fscripts%2Fupgrades%2F2.1_to_2.2_sql_schema.php

12/03/2007 06:31:59 PM	Michael Rubinsky	Comment #3	Reply to this comment
MDB2 -> DB complete.

12/03/2007 04:37:45 PM	Jan Schneider	Comment #2	Reply to this comment
I fixed loading of core.php. I'm gonna take care of the PostgreSQL stuff after you fixed the MDB2/DB issue, Michael.

12/03/2007 04:35:12 PM	Jan Schneider	Assigned to Michael Rubinsky

12/02/2007 11:53:31 PM	Chuck Hagenbuch	Assigned to Jan Schneider State ⇒ Assigned

12/02/2007 08:08:11 AM	cbs (at) cts (dot) ucla (dot) edu	Comment #1 Priority ⇒ 1. Low State ⇒ Unconfirmed Queue ⇒ Turba Summary ⇒ upgrade from 2.1 to 2.2 is broken for postgres Type ⇒ Bug	Reply to this comment
Postgres doesn't have CHANGE for ALTER TABLE. This fails: 'ALTER TABLE ' . $db_table . ' CHANGE object_name object_lastname VARCHAR(255)', It should be: 'ALTER TABLE ' . $db_table . ' ALTER object_name TYPE VARCHAR(255)', 'ALTER TABLE ' . $db_table . ' RENAME object_name TO object_lastname', Also, require_once HORDE_BASE . '/lib/core.php'; I'm guessing needs to be moved up before require_once 'Horde/CLI.php'; And, lastly, it depends on MDB2 which isn't tested for in any of the test.php scripts or mentioned in any of the included docs that grep could find.