MySQL-Problem (solved)

[rroeske]

First of all, thanks to the developers for this excellent program. I have been using Roundcube since version 0.9. Since updating from version 1.6 to 1.7, I have encountered a problem: I can no longer create new identities. The error log displays the following message: DB Error: [1030] Got error 194 "Tablespace is missing for a table" from storage engine InnoDB. Upon checking via my MySQL management tool (HeidiSQL), I am unable to open the "identities" and "responses" tables. Furthermore, the "users" table appears to be outdated; the "last login" timestamp for all users is listed as one year ago. Is there a way to fix this? Many thanks in advance. — René

[SKaero]

It sounds like the database is corrupted, see if this fixes the issue: https://dba.stackexchange.com/questions/56849/innodb-tablespace-is-missing-for-table

[rroeske]

Hi SKaereo, thanks for your reply. Yes, the tables were corrupted. I couldn't find a way to repair them—it didn't lead anywhere for me. I created a new database using the installer script instead. I did lose a bit of data, but nothing major.

[rroeske]

Thanks again for the great program.