Hi, i have just installed Roundcube, and as far as I know everything is set-up correctly but after i try to login I immediatley get an error saying: Service unnavailble.
Here is my error log...
[13-Apr-2009 21:20:10 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_2114fc6e12a5eb2d3a584d21698980707ad472d72 FROM 'SELECT * FROM users WHERE mail_host=? AND username=?']
[Native code: 1054]
[Native message: Unknown column 'mail_host' in 'where clause']
in /customers/domsyard.com/domsyard.com/httpd.www/webmail/program/include/rcube_mdb2.php on line 255 (POST /webmail/?_task=&_action=login)
As i only have one Mysql database it has to share it with Drupal. Is this the problem?
I am new to PHP, Mysql and Roundcube so any help is appreciated!
UPDATE:
When trying to log in to RoundCube I get this error:
[13-Apr-2009 22:40:48 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_27332065430ab182adc38938a563aa47bdfedbcaf FROM 'SELECT * FROM users WHERE mail_host=? AND username=?']
[Native code: 1054]
[Native message: Unknown column 'mail_host' in 'where clause']
in /customers/domsyard.com/domsyard.com/httpd.www/webmail/program/include/rcube_mdb2.php on line 255 (POST /webmail/?_task=&_action=login)
Any ideas?
UPDATE:
Solved by adding a prefix to each table in 'mysql.initial.sql' then updating the 'db.inc.php' file to match
