Error No. 0x01f4 Roundcube
Sign in Pricing Blog Support Search GitHub This repository Watch 193 Star 1,884 Fork 757 roundcube/roundcubemail Code Issues 185 Pull requests 30 Projects 0 Wiki Pulse Graphs New issue Error 0x01F4 while editing signature #1744 Closed rcubetrac opened this Issue Sep 5, 2008 · 4 comments Projects None yet Labels bug C: Database Milestone 0.2-beta Assignees No one assigned 1 participant rcubetrac commented Sep 5, 2008 Reported by hayalci on 5 Sep 2008 17:36 UTC as Trac ticket #1485321 I am using roundcube 0.2-alpha with sqlite backend. While editing an identity, if the last two lines end with dashes and text like this; -- text I get the following error. SERVICE CURRENTLY NOT AVAILABLE Error No. [logs are as follows. [05-Sep-2008 20:28:12](0x01F4] The) MDB2 Error: syntax error (-2): _skipDelimitedStrings: [message: query with an unterminated text string specified](Error) [executed query: SELECT * FROM users WHERE user_id='10'](Last) [code: 0](Native) [message: not an error](Native) [20:28:12 +0300](05-Sep-2008) DB Error: _skipDelimitedStrings: [message: query with an unterminated text string specified](Error) [executed query: SELECT * FROM users WHERE user_id='10'](Last) [code: 0](Native) [message: not an error](Native) in /web/roundcubemail-0.2-alpha/program/include/rcube_mdb2.php on line 259 On Debian etch, php version 5.2.0-8+etch11 php5-sqlite version 5.2.0-8+etch11 Migrated-From: http://trac.roundcube.net/ticket/1485321 rcubetrac commented Sep 5, 2008 Comment by hayalci on 5 Sep 2008 17:37 UTC #1484954, #1485032 and #1485289 seem related rcubetrac commented Sep 5, 2008 Comment by @alecpl on 5 Sep 2008 20:56 UTC Was fixed in trunk by mdb2 update. rcubetrac commented Sep 5, 2008 Status changed by @alecpl on 5 Sep 2008 20:56 UTC new => closed rcubetrac commented Sep 5, 2008 Milestone changed by @alecpl on 5 Sep 2008 20:56 UTC later => 0.2-beta rcubetrac closed this Sep 5, 2008 rcubetrac added bug C: Database labels Mar 20, 2016 rcubetrac added this to the 0.2-beta milestone Mar 20, 2016 Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment Contact GitHub API Training Shop Blog About © 2016 GitHub, Inc. Terms Privacy Security Status Help You can't perform that action at this time. You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reloa
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`, https://github.com/roundcube/roundcubemail/issues/1744 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 http://www.ktchost.com/blog/service-currently-not-available-error-no-0x01f4-roundcube/ 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 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.
Plans & Pricing Partners Support Resources Preview Forums Forums Quick Links Search Forums New Posts Search titles only Posted by Member: Separate names with https://forums.cpanel.net/threads/roundcube-error.112473/ a comma. Newer Than: Search this thread only Search this forum https://www.howtoforge.com/community/threads/roundcube-webmail-10-easy-steps-changes.30829/ only Display results as threads More... Useful Searches Recent Posts Resources Resources Quick Links Search Resources Most Active Authors Latest Reviews Feature Requests Defects Menu Log in Sign up The Community Forums Interact with an entire community of cPanel & WHM users! cPanel Forums > cPanel & WHM® error no. (for Linux® Servers) > E-mail Discussions > This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More. roundcube error Discussion in 'E-mail Discussions' started by Zion Ahead, Apr 1, 2009. Zion Ahead Well-Known Member Joined: Nov 10, 2006 Messages: 347 Likes Received: 0 Trophy Points: 16 Getting this when logging error no. 0x01f4 into roundcube SERVICE CURRENTLY NOT AVAILABLE! Error No. [0x01F4] forced cpanel upgrade did not resolve it either #1 Zion Ahead, Apr 1, 2009 psfrog Member Joined: Jul 13, 2004 Messages: 20 Likes Received: 0 Trophy Points: 1 Location: Sweden cPanel Access Level: Root Administrator You can try the following also - that might help: Code: /usr/local/cpanel/bin/update-roundcube --force /Best regards Erik. www.manufrog.com #2 psfrog, Apr 1, 2009 Zion Ahead Well-Known Member Joined: Nov 10, 2006 Messages: 347 Likes Received: 0 Trophy Points: 16 Code: root@server [~]# /usr/local/cpanel/bin/update-roundcube --force Updating RoundCube (using cPanel version) tar -x -p -z --no-same-owner -f /usr/local/cpanel/src/3rdparty/gpl/roundcube-0.2b.cpanel.tar.gz -C /usr/local/cpanel/base/3rdparty Archiving current Roundcube data to /var/cpanel/roundcube/roundcube.backup.sql.1238632810 mysqldump: Got error: 1033: Incorrect information in file: './roundcube/cache.frm' when using LOCK TABLES Failed to backup existing Roundcube DB. DB likely did not exist.Database "roundcube" dropped Cleaning old Roundcube data archives Creating Roundcube database Roundcube updated to 0.2b #3 Zion Ahead, Apr 1, 2009 Kailash1 Well-Known Member Joined: Nov 27, 2006 Messages: 252 Likes Received: 2 Trophy Points: 18 cPanel Access Level: Root Administrator Twitter: Follow @webhost
HowtoForge Supporter I have been working through the how to "RoundCube Webmail On Your ISPConfig Server Within 10 Easy Steps." Clearly there have been some changes to RoundCube as HOWTO is written for v0.1.1 and I installed v0.2 stable. When I got to step 7, I could not find the 'line 709' in the /program/include/main.inc file (which I located at /home/admispconfig/ispconfig/web/roundcubemail/program/include) to change as indicated. I searched the entire file (visually) and a "trim" instruction could not be found. So, I skipped that step and continued with the how to. I then went to my web browser and tried to access my web address (http://mail1.mydomain.com) and received this: Code: SERVICE CURRENTLY NOT AVAILABLE! Error No. [0x01F4] Forum searches keep referencing RoundCube v0.1.0, so, I was reluctant to try any of those changes and instead chose to post this question. Does my not finding 'line 709' have anything to do with my problem? If not, what now? bobwdn, Feb 2, 2009 #1 falko Super Moderator ISPConfig Developer Maybe these links help: http://trac.roundcube.net/ticket/1485414 http://209.85.129.132/search?q=cach...930-error-no-0x01f4.html roundcube Error No. [0x01F4]&hl=en&ct=clnk&cd=3&client=firefox-a falko, Feb 2, 2009 #2 Hans Moderator ISPConfig Developer bobwdn said: ↑ I have been working through the how to "RoundCube Webmail On Your ISPConfig Server Within 10 Easy Steps." Clearly there have been some changes to RoundCube as HOWTO is written for v0.1.1 and I installed v0.2 stable. When I got to step 7, I could not find the 'line 709' in the /program/include/main.inc file (which I located at /home/admispconfig/ispconfig/web/roundcubemail/program/include) to change as indicated. I searched the entire file (visually) and a "trim" instruction could not be found. So, I skipped that step and continued with the how to. I then went to my web browser and tried to access my web address (http://mail1.mydomain.com) and received this: Code: SERVICE CURRENTLY NOT AVAILABLE! Error No. [0x01F4] Forum searches keep referencing RoundCube v0.1.0, so, I was reluctant to try any of those changes and instead c