[horde] column "increment_by" does not exist
ASV
asv at inhio.net
Sat Jan 26 12:38:31 UTC 2019
Hi again,
it seems this is taking quite a long time to get committed. Is there
any special reason why despite the change was approved the 15th of May
2018? At this point I'm considering patching it manually. :-/
Thanks in advance.
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/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
>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: This is a digitally signed message part
URL: <https://lists.horde.org/archives/horde/attachments/20190126/b7fb9230/attachment.bin>
More information about the horde
mailing list