Applicable to:
- Plesk for Linux
Symptoms
-
After a Plesk upgrade, it is not possible to access Horde webmail with the following error message in a web-browser:
PLESK_INFO: Base table or view not found
-
The following error messages appear in the Horde logfile
/var/log/psa-horde/psa-horde.log:CONFIG_TEXT: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.rampage_types' doesn't exist
SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN
('calendar','event') [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
Base table or view not found: 1051 Unknown table 'horde_vfs_seq'
Base table or view not found: 1051 Unknown table 'horde_muvfs_seq'
Base table or view not found: 1051 Unknown table 'kronolith_shares_seq'
Base table or view not found: 1051 Unknown table 'kronolith_resources_seq'
CONFIG_TEXT: HORDE [horde] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attribute_color' in 'field list' [pid 21827 on line 1601 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
Cause
The Horde database is corrupted.
Resolution
-
Connect to the Plesk server via SSH.
-
For security reasons, create a backup of the Horde database:
# plesk db dump horde > /root/horde_dump.sql
-
Reinstall Horde using this KB article.
Comments
2 comments
We don't have this specific problem (fortunately) as we have never used Horde, only Roundcube, but we've noticed, that despite this choice i.e. Horde not being installed** We see that listed under Open tables within the Obsidian MySQL Process List are these two Horde database tables: rampage _types and rampage_objects. We've never had any database related errors, but should they still be there?
**It might have been, but only by default, way back in our Plesk Onyx days. Could that explain why?
Hello, this likely means you still have "horde" database in MySQL. It is not necessarily should be in use for MySQL in order to display it as these tables can be opened to cache with MySQL start. Basically you see here output of native MySQL command "show open tables" you may see here how it works: https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
Please sign in to leave a comment.