• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Problem with Webmail Horde

igraf

Regular Pleskian
Problem with Webmail Horde | DB Error: no such table

hello,

the log file psa-horde.log in folder
/var/log/psa-horde/

give an error message when i send a email over webmail

Jun 07 16:28:56 HORDE [error] [imp] Could not log message details to Horde_History. Error returned: DB Error: no such table [on line 67 of "/usr/share/psa-horde/imp/lib/Maillog.php"]

i have:
psa v8.0.0_build80060427.19 os_SuSE 9.3

who can help??

greets ivan
 
the following folder
/usr/share/psa-horde/scripts/upgrades/

is inclusive file 3.0_to_3.1.mysql.sql

PHP:
-- $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;

as I can implement this??
$ mysql --user=root --password=<MySQL-root-password> <db name> < 3.0_to_3.1.mysql.sql
 
hello,
fix to this bug

rpm -e psa-horde psa-ingo psa-kronolith psa-mnemo psa-passwd psa-turba psa-imp

reinstalled in plesk via updater
 
Back
Top