Package: ilohamail
Version: 0.8.14-0rc3
Severity: important
I installed ilohamail with the intent of using a mysql backend for it. Per
the README.Debian, I created a database user and database for ilohamail. I
then executed the following and got the accompanying error:
[EMAIL PROTECTED]:/usr/share/doc/ilohamail# mysql -p webmail < sql
Enter password:
ERROR 1072 (42000) at line 183: Key column 'cache_ts' doesn't exist in table
and later, after fiddling a bit, an error for:
ERROR 1072 (42000) at line 184: Key column 'volatile' doesn't exist in table
The table being referred to in each case is the 'cache' table.
So I downloaded the source from ilohamail.org and checked out the sql. The
latest sql they have for a mysql installation has the following for the
'cache' table:
CREATE TABLE cache(
id int NOT NULL auto_increment,
owner int NOT NULL,
cache_key varchar(64),
cache_data text,
PRIMARY KEY(id),
KEY id (id),
KEY owner (owner),
KEY cache_key (cache_key)
);
No reference to 'cache_ts' or 'volatile'.
I looked at the sql for older versions of ilohamail and they included
'cache_ts' and 'volatile'. So I would presume the sql in the current deb is
just a bit out of date.
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-k7
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages ilohamail depends on:
ii apache [httpd] 1.3.33-4 versatile, high-performance HTTP s
ii debconf 1.4.30.11 Debian configuration management sy
ii php4 4:4.3.10-8 server-side, HTML-embedded scripti
ii php4-cgi 4:4.3.10-8 server-side, HTML-embedded scripti
ii postfix [mail-transport-agent 2.1.5-6 A high-performance mail transport
-- debconf information:
* ilohamail/restart: false
* ilohamail/webserver_type: apache
* ilohamail/weblocation: /webmail
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
