Unable to access Roundcube webmail (Whoops something went wrong)
Answered
Some of my clients suddenly have this problem when opening webmail
Oops... something went wrong!
An internal error has occurred. Your request cannot be processed at this time.
For administrators: Please check the application and/or server error logs for more information.
I already the following fix
https://support.cpanel.net/hc/en-us/articles/25845651314839-v120-Unable-to-access-Roundcube-webmail-DB-Error-in-view-caldav-calendars-merged
But it does not do anything, the problem is still there. The problem happened overnight.
What can I do ?
-
We experience the same problem on multiple users, on multiple servers.
If I rename the users primary sqlite database, it works again.Say I have a mailbox user1@domain1, then in /home/user/etc/ there is a user1.rcube.db file. If I rename that to e.g. user1.rcube.db.x, it works again.
This error shows up in /home/user/logs/roundcube/error.log:
[30-May-2025 10:23:32 +0200]: <d55edc45> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '1'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsessXXX/3rdparty/roundcube/index.php?_task=mail&_token=XXX)0 -
It also seems to fix it, creating the carddav_accounts table manually.
CREATE TABLE carddav_accounts (
id integer NOT NULL PRIMARY KEY,
accountname TEXT NOT NULL,
username TEXT NOT NULL,
password TEXT NOT NULL,
discovery_url TEXT,
user_id integer NOT NULL,
last_discovered BIGINT NOT NULL DEFAULT 0,
rediscover_time INT NOT NULL DEFAULT 86400,
presetname TEXT,
flags integer NOT NULL DEFAULT 0,
UNIQUE(user_id,presetname),
FOREIGN KEY(user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE
);Doing so though, does not create a default cpanel carddav account in Roundcube. Renaming the file seems to create the table and populate it with a cpanel carddav account
0 -
Found in other forum thread.
Seems to work for me
1 -
y000 amazing find, that worked for me also. Thank you :)
0 -
Update - we released a fix for this that automatically resolved the issue on all servers receiving updates.
0 -
Hi,
I can't solve this issue.
I try 2 or 3 different workaround, System Update, Update Server Software, Upgrade Cpanel Version to 128.0.9 and nothing works.
Could you please help me.
Thanks0 -
Armando Lopez - can you let me know specifically what you're seeing in the Roundcube logs when this happens?
0 -
This the log
[05-Jun-2025 00:49:25 +0000]: <da50f8df> DB Error: [1] index carddav_xsubtypes_abook_id_idx already exists (SQL Query: CREATE INDEX carddav_xsubtypes_abook_id_idx ON carddav_xsubtypes(abook_id)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php)
[05-Jun-2025 00:49:25 +0000]: <da50f8df> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '59'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php)
[05-Jun-2025 00:49:26 +0000]: <da50f8df> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '59'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php?_task=mail&_token=E772)0 -
Ah, so that isn't the issue from the case in this thread, but a DB problem.
You'll likely need to work through this guide to resolve this issue - https://docs.cpanel.net/knowledge-base/email/how-to-rebuild-the-roundcube-database/
0 -
But we have problem only with one account of one domain
How can apply this solution only for this account?0 -
You would want to use the file locations in the first section of that guide to ensure that you have a backup. You could then use the details here to restore just one account's database:
0 -
I followed the guide, restore an old file, delete the .db to create new one but same error message
Oops... something went wrong!
An internal error has occurred. Your request cannot be processed at this time.
For administrators: Please check the application and/or server error logs for more information.
0 -
This is the log:
[05-Jun-2025 03:54:17 UTC] [CPANELICSIMPORT: Touch file user/.cpanel/icals/.cpanel_ics_import_email exists for email and cpanel_run_once is true, exiting]
[05-Jun-2025 03:54:17 UTC] [CPANELVCFIMPORT: Touch file user/.cpanel/vcards/.cpanel_vcf_import_email exists for email and cpanel_run_once is true, exiting]
[05-Jun-2025 03:54:17 +0000]: <e6dbf3ed> DB Error: [1] index carddav_xsubtypes_abook_id_idx already exists (SQL Query: CREATE INDEX carddav_xsubtypes_abook_id_idx ON carddav_xsubtypes(abook_id)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php)
[05-Jun-2025 03:54:17 +0000]: <e6dbf3ed> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '59'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php)
[05-Jun-2025 03:54:17 +0000]: <e6dbf3ed> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '59'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php?_task=mail&_token=YY)
[05-Jun-2025 03:54:21 +0000]: <e6dbf3ed> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '59'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php?_task=mail&_token=YY)
[05-Jun-2025 03:54:45 UTC] [CPANELICSIMPORT: Touch file user/.cpanel/icals/.cpanel_ics_import_email exists for email and cpanel_run_once is true, exiting]
[05-Jun-2025 03:54:45 UTC] [CPANELVCFIMPORT: Touch file user/.cpanel/vcards/.cpanel_vcf_import_email exists for email and cpanel_run_once is true, exiting]
[05-Jun-2025 03:54:45 +0000]: <7202b8e5> DB Error: [1] index carddav_xsubtypes_abook_id_idx already exists (SQL Query: CREATE INDEX carddav_xsubtypes_abook_id_idx ON carddav_xsubtypes(abook_id)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php)
[05-Jun-2025 03:54:45 +0000]: <7202b8e5> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '59'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php)
[05-Jun-2025 03:54:46 +0000]: <7202b8e5> DB Error: [1] no such table: carddav_accounts (SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '59'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess7278977933/3rdparty/roundcube/index.php?_task=mail&_token=Qj)0 -
I made a mistake when I deleting the user.rcube.db file, I did it again and it works.
The user.rcube.db was created again successfully.0 -
Glad to hear things are working well!
0
Please sign in to leave a comment.
Comments
15 comments