[horde] column "increment_by" does not exist

Thu Dec 27 15:52:25 UTC 2018

Quoting ASV <asv at inhio.net>:

> 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,  
> '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: 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,  
> '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("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,  
> '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}
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org

-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 9272 bytes
Desc: PGP Public Key
URL: <https://lists.horde.org/archives/horde/attachments/20181227/007f671d/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 821 bytes
Desc: PGP Digital Signature
URL: <https://lists.horde.org/archives/horde/attachments/20181227/007f671d/attachment-0003.bin>