Hi,
I am trying to install roundcube on my server but face an annoying error when populating the database.
"DB Schema: NOT OK (Error creating database schema: MDB2 Error: can not create Query:_doQuery: [Error message: Could not execute statement] [Last executed query: CREATE TABLE ....
I stumble on this whatever I do.
Anyone has any idea??
Thanks a lot
Ben
What is the full error?
Thanks ;o)
This is when trying to force update:
sh-3.2# mysql -f -p -u roundcube roundcubemail Enter password:
ERROR 1091 (42000) at line 7: Can't DROP 'idx'; check that column/key exists
ERROR 1091 (42000) at line 11: Can't DROP 'cache_key'; check that column/key exists
ERROR 7 (HY000) at line 16: Error on rename of './roundcubemail/users.MYI' to './roundcubemail/#sql2-11d34-3a.MYI' (Errcode: 2)
ERROR 1061 (42000) at line 32: Duplicate key name 'created_index'
ERROR 1091 (42000) at line 37: Can't DROP 'session_id'; check that column/key exists
ERROR 7 (HY000) at line 40: Error on rename of './roundcubemail/session.MYI' to './roundcubemail/#sql2-11d34-3a.MYI' (Errcode: 2)
ERROR 1061 (42000) at line 43: Duplicate key name 'created_index'
ERROR 1146 (42S02) at line 46: Table 'roundcubemail.users' doesn't exist
ERROR 7 (HY000) at line 49: Error on rename of './roundcubemail/cache.frm' to './roundcubemail/#sql2-11d34-3a.frm' (Errcode: 2)
ERROR 1146 (42S02) at line 50: Table 'roundcubemail.session' doesn't exist
ERROR 1146 (42S02) at line 52: Table 'roundcubemail.users' doesn't exist
ERROR 7 (HY000) at line 53: Error on rename of './roundcubemail/contacts.frm' to './roundcubemail/#sql2-11d34-3a.frm' (Errcode: 2)
ERROR 1061 (42000) at line 60: Duplicate key name 'index_index'
ERROR 1146 (42S02) at line 63: Table 'roundcubemail.session' doesn't exist
ERROR 1146 (42S02) at line 66: Table 'roundcubemail.contacts' doesn't exist
ERROR 1146 (42S02) at line 77: Table 'roundcubemail.cache' doesn't exist
ERROR 1146 (42S02) at line 78: Table 'roundcubemail.contacts' doesn't exist
ERROR 1146 (42S02) at line 83: Table 'roundcubemail.cache' doesn't exist
ERROR 1146 (42S02) at line 85: Table 'roundcubemail.contacts' doesn't exist
ERROR 1146 (42S02) at line 90: Table 'roundcubemail.contacts' doesn't exist
ERROR 1146 (42S02) at line 91: Table 'roundcubemail.contacts' doesn't exist
ERROR 1146 (42S02) at line 92: Table 'roundcubemail.contacts' doesn't exist
ERROR 1005 (HY000) at line 97: Can't create table './roundcubemail/contactgroups.frm' (errno: 121)
ERROR 1005 (HY000) at line 109: Can't create table './roundcubemail/contactgroupmembers.frm' (errno: 121)
ERROR 1146 (42S02) at line 124: Table 'roundcubemail.users' doesn't exist
ERROR 1146 (42S02) at line 125: Table 'roundcubemail.users' doesn't exist
ERROR 1146 (42S02) at line 129: Table 'roundcubemail.users' doesn't exist
ERROR 1146 (42S02) at line 130: Table 'roundcubemail.users' doesn't exist
ERROR 1146 (42S02) at line 132: Table 'roundcubemail.contacts' doesn't exist
I can't get the same error again unfortunately.
Hope this is sufficient.
Just read the installation instructions again. You're installing, so why you're using mysql.update.sql file?
That was just failing at mysql -f -p -u roundcube roundcubemail
sh-3.2# mysql -p -u roundcube roundcubemail Enter password:
ERROR 1005 (HY000) at line 8: Can't create table './roundcubemail/session.frm' (errno: 121)
Should have started there... Sorry
Using my none existent mysql skills here is what I found:
mysql> use roundcubemail
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql>
No tables have been created at all?
Did you give the mysql user permissions to create tables?
Thanks all for you help. Ended up working.
Not sure if this did it but removed roundcubemail database via the sql commande line.
Restarted the server, restarted the procedure and all worked fine.
Thanks again for the help.