Roundcube Community Forum

 

Install Troube.

Started by n0rbertt, March 25, 2009, 07:28:28 PM

Previous topic - Next topic

n0rbertt

First off , I would like to say I love your product :D . Tried to install on one of my domains and got the following error :

SERVICE CURRENTLY NOT AVAILABLE!

Error No. [0x01F4]

You may see this at : RoundCube|Mail : ERROR 500

I've searched google and saw it was fixed by editing "program/include/rcube_db.inc"

But I don't have that file , was that an older version ?

JohnDoh

take a look in [RC Root]/logs/errors hopefully there are some more detaild errors in there. and yes program/include/rcube_db.inc is old, its program/include/rcube_mdb2.inc now.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more...

n0rbertt

[25-Mar-2009 19:15:18] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1e5062e6961a5afe33e9b6a9054662e9312c7bdf8 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1146]
[Native message: Table 'realm_RoundCube.session' doesn't exist]

[25-Mar-2009 19:15:18 -0400] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1e5062e6961a5afe33e9b6a9054662e9312c7bdf8 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1146]
[Native message: Table 'realm_RoundCube.session' doesn't exist]
 in /home/realm/public_html/mail/program/include/rcube_mdb2.php on line 255 (GET /mail/)
[25-Mar-2009 19:21:45] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_13c521e5e80a7bba9a0b8d56b1bc8b0092bb03b5f FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1146]
[Native message: Table 'realm_RoundCube.session' doesn't exist]

[25-Mar-2009 19:21:45 -0400] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE

swie

Take a look if there are tables in the Roundcube database (via phpmyadmin e.g.) if not load the matching sql file from roundcubedir/SQL/*.initial.sql.
* stands for your db system (MySQL, SQLite, ...)

n0rbertt

Quote from: swie;18071Take a look if there are tables in the Roundcube database (via phpmyadmin e.g.) if not load the matching sql file from roundcubedir/SQL/*.initial.sql.
* stands for your db system (MySQL, SQLite, ...)

TYVM ! IT's now working :D

CarlosinFL

I'm having the same problem guys! It appears I don't have any tables generated in my roundcube database via MySQL. I don't have any graphical admin utilities loaded on the machine in question and don't understand how you guys resolved it. I read above you have to 'load' the matching SQL file in a specified database but I have no idea what that means?

Can someone please help me?