[horde] Documentation not accurate anymore regarding postgresql
pierre
pierre.m at nikolov.fr
Sun Apr 19 01:12:00 UTC 2020
Hi,
Just to let you know that the documentation is not accurate anymore.
Horde documentation state:
For SQL database preferences storage, Horde Groupware is thoroughly
tested on MySQL(i) (--with-mysql(i)) and PostgreSQL (--with-pgsql), and
has been reported to work with SQLite (enabled by default).
I have tested new install and I get the following error for PostgreSQL
V10, V11, V12. It look like they are well known issue for postgres.
Postgresql 12:
groupware-install
...
Creating and updating database
tables...
Fatal
Error:
SQLSTATE[42703]: Undefined column: 7 ERROR: the row def.adsrc does
not exist
LINE 4: WHEN split_part(def.adsrc, '''', 2) ~ '.'
TH...
^
In /usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php on line
233
1. Horde_Core_Bundle->migrateDb() /usr/local/bin/groupware-
install:32
2. Horde_Core_Db_Migration->getMigrator()
/usr/local/lib/php/Horde/Core/Bundle.php:102
3. Horde_Db_Migration_Migrator->__construct()
/usr/local/lib/php/Horde/Core/Db/Migration.php:123
4. Horde_Db_Migration_Migrator-
>_initializeSchemaInformation()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:77
5. Horde_Db_Adapter_Pdo_Pgsql->insert()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:282
6. Horde_Db_Adapter_Base->__call()
/usr/local/lib/php/Horde/Db/Adapter/Pdo/Pgsql.php:131
7. Horde_Db_Adapter_Postgresql_Schema->pkAndSequenceFor()
/usr/local/lib/php/Horde/Db/Adapter/Base.php:274
8. Horde_Db_Adapter_Base_Schema->__call()
/usr/local/lib/php/Horde/Db/Adapter/Postgresql/Schema.php:1125
9. Horde_Db_Adapter_Pdo_Base->selectOne()
/usr/local/lib/php/Horde/Db/Adapter/Base/Schema.php:166
10. Horde_Db_Adapter_Pdo_Base->execute()
/usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php:131
11. Horde_Core_Bundle->migrateDb() /usr/local/bin/groupware-
install:32
12. Horde_Core_Db_Migration->getMigrator()
/usr/local/lib/php/Horde/Core/Bundle.php:102
13. Horde_Db_Migration_Migrator->__construct()
/usr/local/lib/php/Horde/Core/Db/Migration.php:123
14. Horde_Db_Migration_Migrator-
>_initializeSchemaInformation()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:77
15. Horde_Db_Adapter_Pdo_Pgsql->insert()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:282
16. Horde_Db_Adapter_Base->__call()
/usr/local/lib/php/Horde/Db/Adapter/Pdo/Pgsql.php:131
17. Horde_Db_Adapter_Postgresql_Schema->pkAndSequenceFor()
/usr/local/lib/php/Horde/Db/Adapter/Base.php:274
18. Horde_Db_Adapter_Base_Schema->__call()
/usr/local/lib/php/Horde/Db/Adapter/Postgresql/Schema.php:1125
19. Horde_Db_Adapter_Pdo_Base->selectOne()
/usr/local/lib/php/Horde/Db/Adapter/Base/Schema.php:166
20. Horde_Db_Adapter_Pdo_Base->execute()
/usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php:131
21. PDO->query() /usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php:233
Same issue for Postgresql 10 and 11:
groupware-install
...
Writing main configuration file... done.
Creating and updating database
tables...
Fatal
Error:
SQLSTATE[42703]: Undefined column: 7 ERROR: the row « increment_by »
does not exist
LINE 1: ..._seq', (SELECT COALESCE(MAX("share_id") + (SELECT
increment_...
^
In /usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php on line
233
1. Horde_Core_Bundle->migrateDb() /usr/local/bin/groupware-
install:32
2. Horde_Db_Migration_Migrator->up()
/usr/local/lib/php/Horde/Core/Bundle.php:107
3. Horde_Db_Migration_Migrator->_doMigrate()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:102
4. Horde_Db_Migration_Base->migrate()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:182
5. KronolithUpgradeAutoIncrement->up()
/usr/local/lib/php/Horde/Db/Migration/Base.php:121
6. Horde_Db_Migration_Base-
>__call()
/var/www/html/kronolith/migration/2_kronolith_upgrade_autoincremen
t.php:22
7. Horde_Db_Adapter_Base->__call()
/usr/local/lib/php/Horde/Db/Migration/Base.php:86
8. Horde_Db_Adapter_Postgresql_Schema->changeColumn()
/usr/local/lib/php/Horde/Db/Adapter/Base.php:274
9. Horde_Db_Adapter_Postgresql_Schema-
>resetPkSequence()
/usr/local/lib/php/Horde/Db/Adapter/Postgresql/Schema.php:563
10. Horde_Db_Adapter_Base_Schema->__call()
/usr/local/lib/php/Horde/Db/Adapter/Postgresql/Schema.php:1067
11. Horde_Db_Adapter_Pdo_Base->selectValue()
/usr/local/lib/php/Horde/Db/Adapter/Base/Schema.php:166
12. Horde_Db_Adapter_Pdo_Base->execute()
/usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php:151
13. Horde_Core_Bundle->migrateDb() /usr/local/bin/groupware-
install:32
14. Horde_Db_Migration_Migrator->up()
/usr/local/lib/php/Horde/Core/Bundle.php:107
15. Horde_Db_Migration_Migrator->_doMigrate()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:102
16. Horde_Db_Migration_Base->migrate()
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:182
17. KronolithUpgradeAutoIncrement->up()
/usr/local/lib/php/Horde/Db/Migration/Base.php:121
18. Horde_Db_Migration_Base-
>__call()
/var/www/html/kronolith/migration/2_kronolith_upgrade_autoincremen
t.php:22
19. Horde_Db_Adapter_Base->__call()
/usr/local/lib/php/Horde/Db/Migration/Base.php:86
20. Horde_Db_Adapter_Postgresql_Schema->changeColumn()
/usr/local/lib/php/Horde/Db/Adapter/Base.php:274
21. Horde_Db_Adapter_Postgresql_Schema-
>resetPkSequence()
/usr/local/lib/php/Horde/Db/Adapter/Postgresql/Schema.php:563
22. Horde_Db_Adapter_Base_Schema->__call()
/usr/local/lib/php/Horde/Db/Adapter/Postgresql/Schema.php:1067
23. Horde_Db_Adapter_Pdo_Base->selectValue()
/usr/local/lib/php/Horde/Db/Adapter/Base/Schema.php:166
24. Horde_Db_Adapter_Pdo_Base->execute()
/usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php:151
25. PDO->query() /usr/local/lib/php/Horde/Db/Adapter/Pdo/Base.php:233
Postgres 9.6: Shoud work as it was my previous database for horde but
it hat reached end of life and is not supported anymore.
I will migrate to mariadb or mysql.
Regards,
Pierre
More information about the horde
mailing list