Author Topic: Install Troube. (Read 5041 times)

n0rbertt · « **on:** March 25, 2009, 07:28:28 PM »

First off , I would like to say I love your product

. 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 · « **Reply #1 on:** March 26, 2009, 05:34:41 AM »

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.

n0rbertt · « **Reply #2 on:** March 26, 2009, 11:19:58 AM »

[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 · « **Reply #3 on:** March 26, 2009, 01:02:31 PM »

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 · « **Reply #4 on:** March 26, 2009, 01:08:42 PM »

Quote from: swie;18071

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, ...)

TYVM ! IT's now working

CarlosinFL · « **Reply #5 on:** May 14, 2009, 08:51:02 AM »

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?