telson
Joined: 29 Nov 2006
Posts: 123
|
 Posted: Mon Oct 06, 2008 6:41 pm Post subject: RoundCube SERVICE CURRENTLY NOT AVAILABLE Error No. [0x01F4] |
 |
|
SERVICE CURRENTLY NOT AVAILABLE Error No. [0x01F4] - RoundCube
I came accross the error:
SERVICE CURRENTLY NOT AVAILABLE Error No. [0x01F4]
I checked for the logs at /var/cpanel/roundcube/log
and could see the following:
| Code: | [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
[06-Oct-2008 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 |
It seems Mysql could not insert the values from UNIXTIME and it errors out.
Fix:
Open the file:
/usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.inc
Search for the following code:
return "FROM_UNIXTIME($timestamp)";
Change it to:
return sprintf("FROM_UNIXTIME(%d)", $timestamp);
Now clear your browser cache and try. 
_________________
Regards,
Telson Thomas
Linux Web Server Administrator |
|
Home 
Services 
Contact Us 
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Free Tutorials - 
