[horde] Table 'horde.horde_histories_modseq' doesn't exist

[Jan Schneider]

Zitat von Administrator Beckspaced.com <admin at beckspaced.com>:

> hello there,
>
> did an update to the most recent horde version via PEAR a day ago.
> updated all database schemas via the horde webmail configuration  
> screen and it reported all is updated
>
> but since then i receive the following error in the logs:
>
> Aug  4 06:11:59 ex4 HORDE: [imp] Could not log message details to  
> Horde_History. Error returned: SQLSTATE[42S02]: Base table or view  
> not found: 1146 Table 'horde.horde_histories_modseq' doesn't exist  
> [pid 32136 on line 83 of  
> "/srv/ssl/webmail/httpdocs/imp/lib/Maillog/Storage/History.php"]
>
> did have a look in the horde database via phpmyadmin to check if the  
> table is there. but table horde_histories_modseq doens't exist.
>
> then look for a mysql_create_db.sql script on my server, but wasn't  
> able to find something like that ;-(
>
> what's the best way to create the missing table? is there a .sql  
> script somewhere? or is there a command line command?
>
> or can i use the database setup from this link:
>
> http://kb.parallels.com/Attachments/kcs-5913/horde_structure.txt
>
> --
> -- Table structure for table `horde_histories_modseq`
> --
>
> DROP TABLE IF EXISTS `horde_histories_modseq`;
>
> CREATE TABLE `horde_histories_modseq` (
>   `history_modseq` int(10) unsigned NOT NULL AUTO_INCREMENT,
>   `history_modseqempty` int(11) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`history_modseq`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
> any help would be more than appreciated ;-)
>
> thanks & all the best
> becki

This table is created in schema version 3 for Horde_History, so if you  
have value larger than 2 in your horde_history_schema_info table, the  
table should have been created by the schema scripts.
If not you might want to try again, but will lose all existing history data:

horde-db-migrate Horde_History down
horde-db-migrate Horde_History up


-- 
Jan Schneider
The Horde Project
http://www.horde.org/
https://www.facebook.com/hordeproject