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

[Administrator Beckspaced.com]

Am 05.08.2014 12:29, schrieb 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
>
>
hello jan,

thanks for your help. horde_history down & up did the trick.

db tables were successfully created. will monitor the logs for further 
errors ... if any ;-)

thanks & all the best
becki