[horde] Table 'horde.horde_histories_modseq' doesn't exist
Administrator Beckspaced.com
admin at beckspaced.com
Tue Aug 5 08:06:34 UTC 2014
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
More information about the horde
mailing list