Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3342895
  • 博文数量: 815
  • 博客积分: 12898
  • 博客等级: 上将
  • 技术积分: 7883
  • 用 户 组: 普通用户
  • 注册时间: 2006-12-25 09:57
文章分类

全部博文(815)

文章存档

2014年(1)

2011年(46)

2010年(192)

2009年(121)

2008年(70)

2007年(385)

分类:

2008-07-15 13:44:14

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

问题解决
阅读(2822) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~