FreeBSD Hotfix 8 - Horde 3.1.1 Problems!

[kevin@]

Another problem since the upgrade to hotfix 8, is that it takes me 74 seconds to send an email through IMP now!

I see this logged in /usr/local/psa/var/log/psa-horde.log

Apr 25 09:36:52 HORDE [error] [imp] Could not log message details to Horde_History. Error returned: DB Error: no such table [on line 67 of "/usr/local/psa/psa-horde/imp/lib/Maillog.php"]

It appears that I am missing a table used for error reporting? Is that the jist here?

Does any one have a PROPER horde setup that works? Could someone perhaps lend me a hand in creating this missing table properly?

Thanks

 

[fredrik.haglund]

I had the same problem after applying the latest patch on PLESK 7.5.4 (FC2).

I run a part of the script that is used to update horde from 3.0 to 3.1: /usr/share/psa-horde/scripts/upgrades/3.0_to_3.1.mysql.sql

-- $Horde: horde/scripts/upgrades/3.0_to_3.1.mysql.sql,v 1.1.2.1 2006/01/06 10:41:13 jan Exp $
--
-- You can simply execute this file in your database.
--
-- Run as:
--
-- $ mysql --user=root --password=<MySQL-root-password> <db name> < 3.0_to_3.1.mysql.sql

ALTER TABLE horde_users ADD COLUMN user_soft_expiration_date INT;
ALTER TABLE horde_users ADD COLUMN user_hard_expiration_date INT;

CREATE TABLE horde_histories (
    history_id       BIGINT NOT NULL,
    object_uid       VARCHAR(255) NOT NULL,
    history_action   VARCHAR(32) NOT NULL,
    history_ts       BIGINT NOT NULL,
    history_desc     TEXT,
    history_who      VARCHAR(255),
    history_extra    TEXT,
--
    PRIMARY KEY (history_id)
);

CREATE INDEX history_action_idx ON horde_histories (history_action);
CREATE INDEX history_ts_idx ON horde_histories (history_ts);
CREATE INDEX history_uid_idx ON horde_histories (object_uid);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_histories TO horde@localhost;

/Fredrik