Thread: Install Troube.

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.

[25-Mar-2009 19:15:18] MDB2 Error: no such table (-1: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1e5062e6961a5afe33e9b6a905466 2e9312c7bdf8 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_1e5062e6961a5afe33e9b6a905466 2e9312c7bdf8 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 (-1: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_13c521e5e80a7bba9a0b8d56b1bc8 b0092bb03b5f 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

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

Originally Posted by 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, ...)

TYVM ! IT's now working

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?