hello, can anyone know what this error means?
the installation of Roundcube was ok, connection to db is ok, test message ok, but when i try to access via web, this error appears:
SERVICE CURRENTLY NOT AVAILABLE!
Error No. [0x01F4]
in the roundcube log file i see this error:
[09-Mar-2009 12:25:47 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_179fc0516c122dbc2eabb7a2ad7856d9b5264769f FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n FROM session\n WHERE sess_id=?']
[Native code: 1146]
[Native message: Table 'casan.session' doesn't exist]
in C:\wwwroot\PHPWebAdmin\roundcube\program\include\rcube_mdb2.php on line 255 (GET /roundcube/index.php)
the mail server is hMail and the database is MySql.
everything works greate except the webmail :(
sorry for my english....
thanks!
Hi
(my english isn't very great too...)
I had the same error.
I solved the problem with this command :
mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql
Your root sql password
Now I access to the homepage of roundcube, but I can't loggin a user.
When I try, I type the user name, the system's password of this user, and whenever there's an authentication error.
I don't know why.
A log file extract :
[10-Mar-2009 18:11:08 +0100] IMAP Error: Authentication for
[email protected] failed (LOGIN): "a001 No Login failed." (POST /roundcubemail/?_task=&_action=login)
EDIT : I understood why the authentications failed, there's no user on database.
How can I create a user with the web interface ?
Thanks for answers
if i run the mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql command i have the following error in MySQL Query Browser
:(
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 'mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql' at line 1
`mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql` should be run on the command line, not in MySQL Query Browser. In Query Browser, one you have connected to the database, you can do File > Open Script and run the SQL that way.
it's ok, but now i have another error :(
[18-Mar-2009 18:12:11 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1ceaf80e546346e7b739755d8c4b0885fe8380468 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n FROM session\n WHERE sess_id=?']
[Native code: 1054]
[Native message: Unknown column 'vars' in 'field list']
in C:\wwwroot\PHPWebAdmin\roundcube\program\include\rcube_mdb2.php on line 255 (GET /roundcube/index.php)
[18-Mar-2009 18:12:11] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_147012dcc822931867c06b43c725cf29986aef962 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n FROM session\n WHERE sess_id=?']
[Native code: 1054]
[Native message: Unknown column 'vars' in 'field list']
[18-Mar-2009 18:12:11 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_147012dcc822931867c06b43c725cf29986aef962 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n FROM session\n WHERE sess_id=?']
[Native code: 1054]
[Native message: Unknown column 'vars' in 'field list']
in C:\wwwroot\PHPWebAdmin\roundcube\program\include\rcube_mdb2.php on line 255 (GET /roundcube/index.php)
the data base name is casan ....if that help.
thanks