Roundcube Community Forum

Release Support => Pending Issues => Topic started by: rroeske on May 20, 2026, 12:59:44 PM

Title: MySQL-Problem (solved)
Post by: rroeske on May 20, 2026, 12:59:44 PM
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é
Title: Re: MySQL-Problem
Post by: SKaero on May 20, 2026, 02:29:14 PM
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
Title: Re: MySQL-Problem
Post by: rroeske on May 21, 2026, 04:51:05 PM
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.

Title: Re: MySQL-Problem
Post by: rroeske on May 21, 2026, 04:52:25 PM
Thanks again for the great program.