Bug#973875: groupware-install: ERROR: column "increment_by" does not exist
On Fri, Nov 6, 2020 at 2:48 PM Mike Gabriel wrote: > > Hi Christopher, > > could you try the php-horde-db version from testing/unstable and > report back if the issue you observe is resolved then? > > If so, I am happy to provide a buster update upload of the package > (containing the relevant pgsql patches that have recently been added > to php-horde-db in testing/unstable). Sorry for the delay, our company-internal infrastructure doesn't allow external mirrors and we don't mirror "testing", so I had to setup KVM first… The testing packages seem to work, thank you very much! (Although I'm not sure if "testing/unstable" is a special repo like "buster/updates", or if you're simply referring to "testing OR unstable"; I assumed the latter.) What I did: -- 8< -- Add testing repo (https://serverfault.com/questions/550855/how-to-add-debian-testing-repository-to-apt-get/550856#550856) # su - postgres > dropdb horde > createdb -O horde horde > exit # apt purge php-horde-groupware php-pgsql # apt autoremove # apt install php-horde-groupware php-pgsql (this gave me php-horde-db 2.4.0-7, php-horde-groupware 5.2.22-6, php-pgsql 2:7.4+76) # groupware-install [… great success …] -- >8 -- (I had to also update php-pgsql because Debian 10 uses php7.3 while testing uses php7.4.) -- Mit freundlichen Grüßen Christopher 'm4z' Holm "We must respect the other fellow's religion, but only in the sense and to the extent that we respect his theory that his wife is beautiful and his children smart." --H. L. Mencken
Bug#973875: groupware-install: ERROR: column "increment_by" does not exist
Hi Christopher, On Fr 06 Nov 2020 12:24:24 CET, Christopher 'm4z' Holm wrote: Package: php-horde-db Version: 2.4.0-3 When trying to do the post-install setup of "php-horde-groupware" (version 5.2.22-3) on Debian 10 (buster) with "postgresql" (version 11+200+deb10u4), /usr/bin/groupware-install fails (this seems to be a variant of #880380): -- 8< -- # groupware-install […] Should Horde log all queries. If selected, queries will be logged at the DEBUG level to your configured logger. (1) Yes (0) No Type your choice [0]: 1 Writing main configuration file... done. Creating and updating database tables... Fatal Error: SQLSTATE[42703]: Undefined column: 7 ERROR: column "increment_by" does not exist LINE 1: ..._seq', (SELECT COALESCE(MAX("share_id") + (SELECT increment_.. could you try the php-horde-db version from testing/unstable and report back if the issue you observe is resolved then? If so, I am happy to provide a buster update upload of the package (containing the relevant pgsql patches that have recently been added to php-horde-db in testing/unstable). Mike -- DAS-NETZWERKTEAM c\o Technik- und Ökologiezentrum Eckernförde Mike Gabriel, Marienthaler Str. 17, 24340 Eckernförde mobile: +49 (1520) 1976 148 landline: +49 (4351) 850 8940 GnuPG Fingerprint: 9BFB AEE8 6C0A A5FF BF22 0782 9AF4 6B30 2577 1B31 mail: mike.gabr...@das-netzwerkteam.de, http://das-netzwerkteam.de pgpyzQhgF1m4X.pgp Description: Digitale PGP-Signatur
Bug#973875: groupware-install: ERROR: column "increment_by" does not exist
Package: php-horde-db Version: 2.4.0-3 When trying to do the post-install setup of "php-horde-groupware" (version 5.2.22-3) on Debian 10 (buster) with "postgresql" (version 11+200+deb10u4), /usr/bin/groupware-install fails (this seems to be a variant of #880380): -- 8< -- # groupware-install […] Should Horde log all queries. If selected, queries will be logged at the DEBUG level to your configured logger. (1) Yes (0) No Type your choice [0]: 1 Writing main configuration file... done. Creating and updating database tables... Fatal Error: SQLSTATE[42703]: Undefined column: 7 ERROR: column "increment_by" does not exist LINE 1: ..._seq', (SELECT COALESCE(MAX("share_id") + (SELECT increment_... ^ In /usr/share/php/Horde/Db/Adapter/Pdo/Base.php on line 233 1. Horde_Core_Bundle->migrateDb() /usr/bin/groupware-install:32 2. Horde_Db_Migration_Migrator->up() /usr/share/php/Horde/Core/Bundle.php:107 3. Horde_Db_Migration_Migrator->_doMigrate() /usr/share/php/Horde/Db/Migration/Migrator.php:102 4. Horde_Db_Migration_Base->migrate() /usr/share/php/Horde/Db/Migration/Migrator.php:182 5. KronolithUpgradeAutoIncrement->up() /usr/share/php/Horde/Db/Migration/Base.php:121 6. Horde_Db_Migration_Base->__call() /usr/share/horde/kronolith/migration/2_kronolith_upgrade_autoincrement.php:22 7. Horde_Db_Adapter_Base->__call() /usr/share/php/Horde/Db/Migration/Base.php:86 8. Horde_Db_Adapter_Postgresql_Schema->changeColumn() /usr/share/php/Horde/Db/Adapter/Base.php:274 9. Horde_Db_Adapter_Postgresql_Schema->resetPkSequence() /usr/share/php/Horde/Db/Adapter/Postgresql/Schema.php:563 10. Horde_Db_Adapter_Base_Schema->__call() /usr/share/php/Horde/Db/Adapter/Postgresql/Schema.php:1067 11. Horde_Db_Adapter_Pdo_Base->selectValue() /usr/share/php/Horde/Db/Adapter/Base/Schema.php:166 12. Horde_Db_Adapter_Pdo_Base->execute() /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:151 13. Horde_Core_Bundle->migrateDb() /usr/bin/groupware-install:32 14. Horde_Db_Migration_Migrator->up() /usr/share/php/Horde/Core/Bundle.php:107 15. Horde_Db_Migration_Migrator->_doMigrate() /usr/share/php/Horde/Db/Migration/Migrator.php:102 16. Horde_Db_Migration_Base->migrate() /usr/share/php/Horde/Db/Migration/Migrator.php:182 17. KronolithUpgradeAutoIncrement->up() /usr/share/php/Horde/Db/Migration/Base.php:121 18. Horde_Db_Migration_Base->__call() /usr/share/horde/kronolith/migration/2_kronolith_upgrade_autoincrement.php:22 19. Horde_Db_Adapter_Base->__call() /usr/share/php/Horde/Db/Migration/Base.php:86 20. Horde_Db_Adapter_Postgresql_Schema->changeColumn() /usr/share/php/Horde/Db/Adapter/Base.php:274 21. Horde_Db_Adapter_Postgresql_Schema->resetPkSequence() /usr/share/php/Horde/Db/Adapter/Postgresql/Schema.php:563 22. Horde_Db_Adapter_Base_Schema->__call() /usr/share/php/Horde/Db/Adapter/Postgresql/Schema.php:1067 23. Horde_Db_Adapter_Pdo_Base->selectValue() /usr/share/php/Horde/Db/Adapter/Base/Schema.php:166 24. Horde_Db_Adapter_Pdo_Base->execute() /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:151 25. PDO->query() /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:233 -- >8 -- After applying the patch from https://github.com/horde/Db/pull/3/files to /usr/share/php/Horde/Db/Adapter/Postgresql/Schema.php (belonging to the package "php-horde-db", hence this bugreport), groupware-install succeeds. How to reproduce: 1. Prepare postgresql: -- 8< -- # apt install postgresql postgresql-client # su - postgres > createuser --pwprompt horde > createdb -O horde horde (Test with:) > psql -h localhost -d horde -U horde -- >8 -- 2. Install horde packages: -- 8< -- # aptitude install php-horde-groupware php-pgsql -- >8 -- 3. Run groupware-install (as described in https://wiki.debian.org/Horde) -- 8< -- # groupware-install Installing Horde Groupware Configuring database settings What database backend should we use? (false) [None] (mysql) MySQL / PDO (mysqli) MySQL (mysqli) (oci8) Oracle (pgsql) PostgreSQL (sqlite) SQLite Type your choice []: pgsql Username to connect to the database as* [] horde Password to connect with How should we connect to the database? (unix) UNIX Sockets (tcp) TCP/IP Type your choice [unix]: tcp Database server/host* [] localhost Port the DB is running on, if non-standard Database name to use* [] horde Internally used charset* [utf-8] Split reads to a different server? (false) Disabled (true) Enabled Type your choice [false]: Should Horde log all queries. If selected, queries will