Re: column "increment_by" does not exist
ASV <[email protected]>
| Newsgroups | gmane.comp.horde.user |
|---|---|
| Message-ID | <[email protected]> |
Sounds good, thanks for the info. On Thu, 2018-12-27 at 15:52 +0000, Michael J Rubinsky wrote: > Quoting ASV <[email protected]>: > > > 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. > > There is a pull request waiting for review that fixes this issue > already in git master. > > https://github.com/horde/Db/pull/3/commits/a876681131889217614144593a > a9cbe537069c5a > > > > > > 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, > > '[email protected]...', '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: SQLSTA > > TE[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, > > '[email protected]...', '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("o > > bject_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, > > '[email protected]...', '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} > > -- > > Horde mailing list > > Frequently Asked Questions: http://horde.org/faq/ > > To unsubscribe, mail: [email protected] > > > -- Horde mailing list Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]