Error No. [0x01F4]

[CarlosinFL]

Just installed RoundCube and everything looked like it did fine when I walked through the interactive installer. I then removed the 'installer/' directory from my web server and restarted both Apache & MySQL. When I then pointed my browser to http://localhost/webmail/index.php, I get the following error:

SERVICE CURRENTLY NOT AVAILABLE!

Error No. [0x01F4]

I found this link but it's 8 months old and the version is way older than what I am working with. I am using the latest version 0.2.1.

Also I have no idea what file to edit or the bug link above is referencing. Is it a PHP file or a Roundcube file?

Please help!


***EDIT***

I checked /var/www/html/webmail/logs/errors file and the following is repeated over and over:

Code: [Select]

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

[13-May-2009 15:39:35 -0400] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1053a2a54003b3ed4f64a69843281b9dc92055507 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1146]
[Native message: Table 'roundcube.session' doesn't exist]
 in /var/www/html/webmail/program/include/rcube_mdb2.php on line 255 (GET /webmail/index.php)

[CarlosinFL]

Anyone?

[JohnDoh]

Please take a minute to search the forum and see if your question has already been answered before posting. For example http://www.roundcubeforum.net/issues-bugs/4728-service-currently-not-available-error-no-0x01f4.html and http://www.roundcubeforum.net/pending-issues/4659-error-no-0x01f4-dont-know-what-do.html

[CarlosinFL]

Thanks for the tip. I see that the problem is due to the installer missing the "initialize database" option to create tables in my 'roundcube' database:

Code: [Select]

mysql> use roundcube;
Database changed
mysql> show tables;
Empty set (0.00 sec)

I looked at all the threads in relation to this problem and I don't understand how people resolved the issue. I found this link.

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

How do you "load" the sql file from the specified directory?

I see the file in question here that generates all tables in the roundcube database...

Code: [Select]

[root@mail SQL]# ls -l
total 40
-rw-r--r-- 1 apache root 7726 Dec  3 09:42 mssql.initial.sql
-rw-r--r-- 1 apache root 4458 Mar  4 03:24 mysql.initial.sql
-rw-r--r-- 1 apache root 1161 Nov 25 05:17 mysql.update.sql
-rw-r--r-- 1 apache root 5230 Dec  3 03:02 postgres.initial.sql
-rw-r--r-- 1 apache root 1668 Dec  3 03:02 postgres.update.sql
-rw-r--r-- 1 apache root 3622 Nov 25 05:17 sqlite.initial.sql
-rw-r--r-- 1 apache root 1157 Nov 24 02:59 sqlite.update.sql