[horde] horde_prefs table doesn't exist...

[lst_hoe02 at kwsoft.de]

Zitat von Michael Robinson <plug_1 at robinson-west.com>:

> A fatal error has occurred
> SQLSTATE[42S02]: Base table or view not found: 1146 Table
> 'horde.horde_prefs' doesn't exist
>
>  1. Horde_Prefs->getValue() /var/www/horde5/index.php:62
>  2. Horde_Prefs->_getScope() /usr/lib/php/Horde/Prefs.php:253
>  3. Horde_Prefs->_loadScope() /usr/lib/php/Horde/Prefs.php:346
>  4. Horde_Prefs_Storage_Sql->get() /usr/lib/php/Horde/Prefs.php:416
>  5. Horde_Prefs->getValue() /var/www/horde5/index.php:62
>  6. Horde_Prefs->_getScope() /usr/lib/php/Horde/Prefs.php:253
>  7. Horde_Prefs->_loadScope() /usr/lib/php/Horde/Prefs.php:346
>  8. Horde_Prefs_Storage_Sql->get() /usr/lib/php/Horde/Prefs.php:416
>  9. Horde_Db_Adapter_Pdo_Base->selectAll()  
> /usr/lib/php/Horde/Prefs/Storage/Sql.php:74
> 10. Horde_Db_Adapter_Pdo_Base->execute()  
> /usr/lib/php/Horde/Db/Adapter/Pdo/Base.php:109
> 11. Horde_Prefs->getValue() /var/www/horde5/index.php:62
> 12. Horde_Prefs->_getScope() /usr/lib/php/Horde/Prefs.php:253
> 13. Horde_Prefs->_loadScope() /usr/lib/php/Horde/Prefs.php:346
> 14. Horde_Prefs_Storage_Sql->get() /usr/lib/php/Horde/Prefs.php:416
> 15. Horde_Db_Adapter_Pdo_Base->selectAll()  
> /usr/lib/php/Horde/Prefs/Storage/Sql.php:74
> 16. Horde_Db_Adapter_Pdo_Base->execute()  
> /usr/lib/php/Horde/Db/Adapter/Pdo/Base.php:109
> 17. PDO->query() /usr/lib/php/Horde/Db/Adapter/Pdo/Base.php:201
>
> I have specifically attempted to set up mariadb just for the preferences
> not knowing how to get my postgresql database to store them.  Same
> problem, the table doesn't get created and the preferences aren't
> written out.  I have blown a whole day on this :-(

If the table referenced does not exist it does not solve the problem  
to use another database. This works with postgres for all users around  
so you have to check what special setting or config error *you* have.  
As said by other try executing "horde-db-migrate" which should tell  
you what tables are missing. If it doesn't check you database access  
settings (hostname, user, passwort, DB-Name...).

Regards

Andreas