问题描述
Roundcubemail 登陆时报错:
For some reason in 1.1 whenever I click the junk folder (imap) it is empty when it contains mail, or i get the dreaded:
"
Service Unavailable
Error No. [0x01F4]
"
错误日志:
The error logs show the following SQL error over and over:
"
[Native code: 1064]
[Native message: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '), ?, ?, ?)' at line 3]
in /var/www/mail/htdocs/program/include/rcube_mdb2.inc on line 265
[09-Jul-2008 09:27:28 -0500] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE
MDB2_STATEMENT_mysql_7ef2e0df4b33a023e2ca48a69edbd ab52b3e77826 FROM
'INSERT INTO messages\n (user_id, del, cache_key, created, idx, uid,
subject, `from`, `to`, cc, date, size, headers, structure)\n VALUES (?,
0, ?, now(), ?, ?, ?, ?, ?, ?, FROM_UNIXTIME(), ?, ?, ?)']
"
原因:
改用户的磁盘使用严重超出磁盘限额
测试:
只要把用户超出磁盘限额的部分给移出,用户就能正常登陆
但是这不是长久之计
最终解决办法:
参考:
http://roundcubeforum.net/showthread.php?t=3234
参考 :
将/var/www//roundcubemail/config/db.inc.php 中的
// database backend to use (only db or mdb2 are supported)
$rcmail_config['db_backend'] = 'mdb2';
修改为:
// database backend to use (only db or mdb2 are supported)
$rcmail_config['db_backend'] = 'db';
目前用户 可以正常登录了
根据需要在postfiadmin中调整用户的磁盘限额
问题解决
阅读(2790) | 评论(0) | 转发(0) |