Re: column "increment_by" does not exist

Michael J Rubinsky <[email protected]> Thu, 27 Dec 2018 15:52:25 +0000
Newsgroups	gmane.comp.horde.user
Message-ID	<20181227155225.Horde.VJUMGVsV6AlZm4EXdc46wOy@tarn.theupstairsroom.com>
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/a876681131889217614144593aa9cbe537069c5a




> 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]



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject

-- 
Horde mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]
(unnamed) (application/pgp-keys, 9.1 KB) - not displayed
signature.asc (application/pgp-signature, 821 B)