Error No. 0x01f4
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 Service Unavailable - Error No. [0x01F4] -> return "FROM_UNIXTIME($timestamp)"; #1753 Closed rcubetrac opened this Issue Sep 10, 2008 · 3 comments Projects None yet Labels bug C: PHP backend Milestone 0.2-beta Assignees No one assigned 1 participant rcubetrac commented Sep 10, 2008 Reported by Makc666 on 10 Sep 2008 07:16 UTC as Trac ticket #1485332 'Service Unavailable - Error No. [say: [Tue Sep 9 13:40:42 2008](0x01F4]''' ''Logs) [PHP Notice: _doQuery: [Error message: Could not execute statement](error])\n[executed query: PREPARE MDB2_STATEMENT_mysql_e6b07f044db4874a5a1a9d9fb1e64 d4ce9b805cd7 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(), ?, ?, ?)'](Last)\n[code: 1064](Native)\n[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](Native)\n in /www/program/include/bugs.inc on line 95 Found out how to fix for 0.1.1 Really there is a bug (a misprint in coding)... File: program/include/rcube_mdb2.inc Code: function fromunixtime($timestamp) { switch($this->db_provider) { case 'mysqli': case 'mysql': case 'sqlite': return "FROM_UNIXTIME($timestamp)"; default: return date("'Y-m-d H:i:s'", $timestamp); } } Problem line: return "FROM_UNIXTIME($timestamp)"; Must be: return sprintf("FROM_UNIXTIME(%d)", $timestamp); Saying the truth if we look into file: program/include/rcube_db.inc We will see that there is the same function there: function fromunixtime($timestamp) { switch($this->db_provider) { case '
Plans & Pricing Partners Support Resources Preview Forums Forums Quick Links Search Forums New Posts Search titles only Posted by Member: Separate names with a comma. Newer Than: Search this thread only Search this forum 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® (for Linux® Servers) > E-mail Discussions > This site uses cookies. https://github.com/roundcube/roundcubemail/issues/1753 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 into roundcube SERVICE CURRENTLY NOT AVAILABLE! Error No. [0x01F4] forced cpanel upgrade did not resolve it https://forums.cpanel.net/threads/roundcube-error.112473/ 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 @webhosttalk /usr/local/cpanel/bin/update-roundcube --force The above command will force upgrade the roundcube on the server. It will drop your existing roundcube database and will create new one. Are you still facing the problem
is currently Fri Oct 14, 2016 7:04 am All times are UTC+01:00 error no. 0x01f4 Information You have been permanently banned from this board.Please contact the Board Administrator for more information.A ban has been issued on your IP address. Board index All times are UTC+01:00 Delete all board cookies Powered by phpBB Forum Software © phpBB Limited
el siguiente error al acceder all servicio de webmail Roundcube en un servidor con cPanel: SERVICE CURRENTLY NOT AVAILABLE! Error No. [0x01F4] Debéis revisar en primera instancia si habéis desactivado en el servicio MySQL el motor de base de datos INNODB, si aparece lo siguiente en el fichero de configuración my.cnf es que lo habéis desactivado: skip-innodb En ese caso, la solución pasa por volver a activar INNODB, o forzar a Roundcube a usar MyISAM, para ello, simplemente forzad la reinstalación del webmail con el siguiente comando: /usr/local/cpanel/bin/update-roundcube --force TwitterGoogle+LinkedInE-mail cPanel cPanel, error, innodb, myisam, MySQL, Roundcube, webmail. permalink. 3 comentarios en “cPanel: Roundcube SERVICE CURRENTLY NOT AVAILABLE! Error No. [0x01F4]” dracks says: noviembre 5, 2009 at 4:36 pm Hola Alex, Escucha, si no pones el enlace a contactar, como mínimo podrías poner algún foro o algo aunque fuera cutre no? Lo digo, porque seguro que no soy el unico que te hace preguntas. Primero de todo, perdona que te moleste otra vez por tema de curro, parece que me están delegando lo poco que hacíamos en el curro de administración a mi :S Escucha, tenemos subcontractada una empresa que nos administra las maquinas y ahora necesitavamos instalar el paquete php-mssql, y no han dicho que les ha dado muchos problemas en un pasado, y que da muchos problemas. A ver en desarrollo yo lo instale, pero me han solicitado que verifique si tienen razon o no. La maquina que queremos instalarlo tiene un cpanel. Sabes tu algo? Gracias y disculpa las molestias. Jaume. Responder Alex says: noviembre 6, 2009 at 11:41 am Hola Dracks, La verdad es que nunca he trabajado con ese módulo de PHP por lo que no sabría aconsejarte. Lo mejor es instalarlo en una máquina fuera de producción y testear si os da algún tipo de problemas. Saludos Responder dracks says: noviembre 9, 2009 at 12:00 pm Hola Alex, Ya