[horde] column "increment_by" does not exist

Fri Dec 28 10:54:25 UTC 2018

Sounds good, thanks for the info.

On Thu, 2018-12-27 at 15:52 +0000, Michael J Rubinsky wrote:
> 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/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,  
> > '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
> 
> 
> 