UnixServerAdmin

Server Administration & Management

RoundCube – Service currently not available errror no. [0x01F4]

Mostly we received following error after browsing RoundCube – “RoundCube – Service currently not available errror no. [0x01F4]

As well as RoundCube error logs showing following logs

[02-Oct-2012 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
[02-Oct-2012 08:35:20 -0400] DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE MDB2_STATEMENT_mysql_d6ee872839dbf41a18e11e2f09d1f4d9790e462d7 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 because 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

# vim /usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.php

From

return “FROM_UNIXTIME($timestamp)”;

To

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

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

Advertisements

October 9, 2012 Posted by | Mail | , | Leave a comment

How to change language for Roundcube webmail

1. Edit Roundcube main config (/usr/local/cpanel/base/roundcube/config/main.inc.php)

# vi /usr/local/cpanel/base/roundcube/config/main.inc.php

To change language from English to Portuguese Brasil

Find

$rcmail_config[‘locale_string’] = ‘en’;

Replace it to

$rcmail_config[‘locale_string’] = ‘pt_BR’;

You can see the installed languages such as fr(french), en_US(english US) from the folder /usr/local/cpanel/base/roundcube/program/localization.

December 15, 2011 Posted by | cPanel, Mail | , , , | Leave a comment

cPanel RoundCube_ An error occurred while saving

If you are using cPanel Roundcube email services and when you try to modify your signature and getting error of “An error occurred while saving” without able to allow you to save the setting. You may refer to this article.

With this case, I am using email user of user@mickgenie.com, hence you may refer to the step as below to resolve the issue.

1. Log into the SSH, go to the path of /home/username/etc/domain.com where user path will be /home/username/etc/username.com/.

2. Rename or delete the file named user.rcube.db where my case will be user.rcube.db.

3. Visit your RoundCube again and the problem should be resolved.

May 31, 2011 Posted by | cPanel | , | 3 Comments