• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

FreeBSD Hotfix 8 - Horde 3.1.1 Problems!

kevin@

Basic Pleskian
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
 
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

Code:
-- $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
 
Back
Top