[horde] column "increment_by" does not exist

[ASV]

Hi to you all!

After using Horde happily for +1 year I've upgraded the backend database from PostgreSQL 9.4 to 11.
Everything works well but Horde which always encounter the issue (output) below which seems to be related to a change made on PostgreSQL side in the way it implements ID sequences. The column "increment_by" was changed to "Increment" apparently. I'm wondering if anybody else had such a problem and if renaming the column is the way to go to fix it.

Thanks in advance.


PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column "increment_by" does not exist LINE 1: ...seq', (SELECT COALESCE(MAX("object_id") + (SELECT increment_... ^ in /usr/local/share/pear/Horde/Db/Adapter/Pdo/Base.php:233 Stack trace: #0 /usr/local/share/pear/Horde/Db/Adapter/Pdo/Base.php(233): PDO->query('SELECT setval('...') #1 /usr/local/share/pear/Horde/Db/Adapter/Pdo/Base.php(151): Horde_Db_Adapter_Pdo_Base->execute('SELECT setval('...', Array, NULL) #2 /usr/local/share/pear/Horde/Db/Adapter/Base/Schema.php(166): Horde_Db_Adapter_Pdo_Base->selectValue('SELECT setval('...', 'Reset sequence') #3 /usr/local/share/pear/Horde/Db/Adapter/Postgresql/Schema.php(1067): Horde_Db_Adapter_Base_Schema->__call('selectValue', Array) #4 /usr/local/share/pear/Horde/Db/Adapter/Base.php(274): Horde_Db_Adapter_Postgresql_Schema->resetPkSequence('rampage_objects', 'object_id', 'rampage_objects...') #5 /usr/local/share/pear/Horde/Db/Adapter/Pdo/Pgsql.php(135): Horde_Db_Adapter_Base->__call('resetPkSequence', Array) #6 /usr/local/www/horde/content/lib/Objects/Manager.php(191): Horde_Db_Adapter_Pdo_Pgsql->insert('INSERT INTO "ra...') #7 /usr/local/www/horde/content/lib/Tagger.php(835): Content_Objects_Manager->ensureObjects(Array, 3) #8 /usr/local/www/horde/content/lib/Tagger.php(170): Content_Tagger->_ensureObject(Array) #9 /usr/local/share/pear/Horde/Core/Tagger.php(200): Content_Tagger->removeTagFromObject(Array, Array) #10 /usr/local/share/pear/Horde/Core/Tagger.php(247): Horde_Core_Tagger->untag('20180515135603....', Array, 'contact') #11 /usr/local/www/horde/turba/lib/Driver.php(1136): Horde_Core_Tagger->replaceTags('20180515135603....', Array, 'asv at inhio.n...', 'contact') #12 /usr/local/www/horde/turba/lib/Object.php(566): Turba_Driver->save(Object(Turba_Object)) #13 /usr/local/www/horde/turba/lib/Form/EditContact.php(90): Turba_Object->store() #14 /usr/local/www/horde/turba/edit.php(80): Turba_Form_EditContact->execute() #15 {main} Next Horde_Db_Exception: SQLSTATE[42703]: Undefined column: 7 ERROR: column "increment_by" does not exist LINE 1: ...seq', (SELECT COALESCE(MAX("object_id") + (SELECT increment_... ^ in /usr/local/share/pear/Horde/Db/Adapter/Pdo/Base.php:237 Stack trace: #0 /usr/local/share/pear/Horde/Db/Adapter/Pdo/Base.php(151): Horde_Db_Adapter_Pdo_Base->execute('SELECT setval('...', Array, NULL) #1 /usr/local/share/pear/Horde/Db/Adapter/Base/Schema.php(166): Horde_Db_Adapter_Pdo_Base->selectValue('SELECT setval('...', 'Reset sequence') #2 /usr/local/share/pear/Horde/Db/Adapter/Postgresql/Schema.php(1067): Horde_Db_Adapter_Base_Schema->__call('selectValue', Array) #3 /usr/local/share/pear/Horde/Db/Adapter/Base.php(274): Horde_Db_Adapter_Postgresql_Schema->resetPkSequence('rampage_objects', 'object_id', 'rampage_objects...') #4 /usr/local/share/pear/Horde/Db/Adapter/Pdo/Pgsql.php(135): Horde_Db_Adapter_Base->__call('resetPkSequence', Array) #5 /usr/local/www/horde/content/lib/Objects/Manager.php(191): Horde_Db_Adapter_Pdo_Pgsql->insert('INSERT INTO "ra...') #6 /usr/local/www/horde/content/lib/Tagger.php(835): Content_Objects_Manager->ensureObjects(Array, 3) #7 /usr/local/www/horde/content/lib/Tagger.php(170): Content_Tagger->_ensureObject(Array) #8 /usr/local/share/pear/Horde/Core/Tagger.php(200): Content_Tagger->removeTagFromObject(Array, Array) #9 /usr/local/share/pear/Horde/Core/Tagger.php(247): Horde_Core_Tagger->untag('20180515135603....', Array, 'contact') #10 /usr/local/www/horde/turba/lib/Driver.php(1136): Horde_Core_Tagger->replaceTags('20180515135603....', Array, 'asv at inhio.n...', 'contact') #11 /usr/local/www/horde/turba/lib/Object.php(566): Turba_Driver->save(Object(Turba_Object)) #12 /usr/local/www/horde/turba/lib/Form/EditContact.php(90): Turba_Object->store() #13 /usr/local/www/horde/turba/edit.php(80): Turba_Form_EditContact->execute() #14 {main} Next Content_Exception: SQLSTATE[42703]: Undefined column: 7 ERROR: column "increment_by" does not exist LINE 1: ...seq', (SELECT COALESCE(MAX("object_id") + (SELECT increment_... ^ in /usr/local/www/horde/content/lib/Objects/Manager.php:194 Stack trace: #0 /usr/local/www/horde/content/lib/Tagger.php(835): Content_Objects_Manager->ensureObjects(Array, 3) #1 /usr/local/www/horde/content/lib/Tagger.php(170): Content_Tagger->_ensureObject(Array) #2 /usr/local/share/pear/Horde/Core/Tagger.php(200): Content_Tagger->removeTagFromObject(Array, Array) #3 /usr/local/share/pear/Horde/Core/Tagger.php(247): Horde_Core_Tagger->untag('20180515135603....', Array, 'contact') #4 /usr/local/www/horde/turba/lib/Driver.php(1136): Horde_Core_Tagger->replaceTags('20180515135603....', Array, 'asv at inhio.n...', 'contact') #5 /usr/local/www/horde/turba/lib/Object.php(566): Turba_Driver->save(Object(Turba_Object)) #6 /usr/local/www/horde/turba/lib/Form/EditContact.php(90): Turba_Object->store() #7 /usr/local/www/horde/turba/edit.php(80): Turba_Form_EditContact->execute() #8 {main}