roundcube db.inc.php,Roundcubemail 登陆时报错

问题描述

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中调整用户的磁盘限额

问题解决

阅读(1662) | 评论(0) | 转发(0) |