1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

FreeBSD Hotfix 8 - Horde 3.1.1 Problems!

Discussion in 'Plesk for Linux - 8.x and Older' started by kevin@, Apr 25, 2006.

  1. kevin@

    kevin@ Basic Pleskian

    24
    23%
    Joined:
    Nov 30, 2001
    Messages:
    50
    Likes Received:
    0
    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
     
  2. fredrik.haglund

    fredrik.haglund Guest

    0
     
    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
     
Loading...