Roundcube sort error on inbox for one account after migration

Operating System & Version
Linux
cPanel & WHM Version
86.0 (build 36)

torsprings

Registered
Feb 11, 2021
2
0
1
Uk
cPanel Access Level
Root Administrator
Hi all,

Hostgator migrated us to an upgraded cloud account including hosted webmail to webmail migration. Had email
migration problems so they resynced the email servers after DNS change. Now just seem to have a problem with one account:

On Roundcube login get error: (600+ messages in inbox but non displayed)

Server Error: UID SORT: Internal error occurred. Refer to server log for more information. [2021-02-09 04:53:13] (0.028 + 0.000 + 0.027 secs).

Here's the error log:


09-Feb-2021 04:53:12 -0600]: <ef82fc7f> DB Error: [] (SQL Query: ) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /cpsess0128869814/3rdparty/roundcube/index.php?login=1&post_login=24082992209

I've opened HG support ticket and waiting for sys admin support but.....

Has anyone encountered this or got any thoughts ?

Thanks
Jon
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,491
1,008
313
cPanel Access Level
Root Administrator
Hey there! Depending on how the final secondary sync happened, there could be permission or ownership issues on the mailbox or mail files causing this issue. Do you see any odd permissions in /home/username/mail that could explain this?
 

torsprings

Registered
Feb 11, 2021
2
0
1
Uk
cPanel Access Level
Root Administrator
Hey there! Depending on how the final secondary sync happened, there could be permission or ownership issues on the mailbox or mail files causing this issue. Do you see any odd permissions in /home/username/mail that could explain this?
Thanks for your reply.
Permissions seem ok. Actually I think it's something to do with squiirel mail plugins missing as I found this:-

[11-Feb-2021 13:47:46 -0600]: PHP Error: Failed to load plugin file /usr/local/cpanel/base/3rdparty/roundcube/plugins/cpanel_squirrelmail_contact_import/cpanel_squirrelmail_contact_import.php in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_plugin_api.php on line 181 (GET /cpsess7149237067/3rdparty/roundcube/index.php?_task=mail&_action=list&_sort=subject_ASC&_mbox=INBOX&_remote=1&_unlock=loading1613072866392&_=1613072790799)

Which is a bit weird, as I thought squirrel mail was obsolete ? ( and the user doesn't have a squirrel mail contacts book )
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,491
1,008
313
cPanel Access Level
Root Administrator
Squirrelmail hasn't been included with the product for some time, but that doesn't mean something related to it may have been accidentally synced from the Source machine.

For this issue it may be best to wait to hear from Hostgator since they would know exactly what commands were used to sync the data.