Mostly we received following error aftre browsing RoundCube

SERVICE CURRENTLY NOT AVAILABLE Error No. [0x01F4] – RoundCube

As well as RoundCube error logs showing following logs

[06-Oct-2008 08:34:56 -0400] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE MDB2_STATEMENT_mysql_8c77e0752a8db2da365c3c7a19fe8842c84663aa7 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(), ?, ?, ?)’]
[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 /usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.inc on line 265

The error is occur becasue Mysql could not insert the values from UNIXTIME. To avoid this error simply open file

/usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.php and replace following code

From

return “FROM_UNIXTIME($timestamp)”;

To

return sprintf(“FROM_UNIXTIME(%d)”, $timestamp);

Now clear cache from your local machine refresh RoundCube error page.

If you still get same error, you should check the roundcube database permission.

root@server [/var/lib/mysql]# ll | grep roundcube
d——— 2 mysql mysql 4096 Jul 14 21:56 roundcube/
root@queen [/var/lib/mysql]#

If the database permission is zero, you need to make it 700

root@server [/var/lib/mysql]# chmod 700 roundcube

thats all.