+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: Email Support v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=35)
+---- Thread: Big problem with Roundcube (/showthread.php?tid=1867)
Big problem with Roundcube - kini - 08-11-2015
I have problem with roundcube in new server.
When i enter in mail account i have this error:
This show in /var/zpanel/logs/roundcube/errors
Code:
[09-Aug-2015 23:23:47 +0300]: DB Error: [1054] Unknown column 'expires' in 'where clause' (SQL Query: DELETE FROM cache WHERE expires < now()) in /etc/sentora/panel/etc/apps/webmail/program/lib/Roundcube/rcube_db.php on line 467 (GET /etc/apps/webmail/?_task=mail)
[09-Aug-2015 23:23:47 +0300]: DB Error: [1146] Table 'sentora_roundcube.cache_shared' doesn't exist (SQL Query: DELETE FROM cache_shared WHERE expires < now()) in /etc/sentora/panel/etc/apps/webmail/program/lib/Roundcube/rcube_db.php on line 467 (GET /etc/apps/webmail/?_task=mail)
[09-Aug-2015 23:23:47 +0300]: DB Error: [1054] Unknown column 'expires' in 'where clause' (SQL Query: DELETE FROM cache_messages WHERE expires < now()) in /etc/sentora/panel/etc/apps/webmail/program/lib/Roundcube/rcube_db.php on line 467 (GET /etc/apps/webmail/?_task=mail)
[09-Aug-2015 23:23:47 +0300]: DB Error: [1054] Unknown column 'expires' in 'where clause' (SQL Query: DELETE FROM cache_index WHERE expires < now()) in /etc/sentora/panel/etc/apps/webmail/program/lib/Roundcube/rcube_db.php on line 467 (GET /etc/apps/webmail/?_task=mail)
[09-Aug-2015 23:23:47 +0300]: DB Error: [1054] Unknown column 'expires' in 'where clause' (SQL Query: DELETE FROM cache_thread WHERE expires < now()) in /etc/sentora/panel/etc/apps/webmail/program/lib/Roundcube/rcube_db.php on line 467 (GET /etc/apps/webmail/?_task=mail)
[09-Aug-2015 23:44:00 Europe/Sofia] Failed to read from socket ():I need help please.. I Cant reinstall sentora because i already make migration from one server to another and uploaded all clients website's.
RE: Big problem with Roundcube - TGates - 08-11-2015
The database is missing a column. You can update roundcube manually by going to their site and downloading the latest version and follow their upgrade documentation. It is a rather simple process.
RE: Big problem with Roundcube - kini - 08-11-2015
(08-11-2015, 04:11 AM)TGates Wrote: The database is missing a column. You can update roundcube manually by going to their site and downloading the latest version and follow their upgrade documentation. It is a rather simple process.
I downloaded roundcube, replaced old with new files, delete SQL database and create and installed again
BUT i have this error again..
RE: Big problem with Roundcube - TGates - 08-12-2015
You should not have deleted the database
I said to upgrade according to their documentation!The error tells you exactly what is wrong:
Code:
Table 'sentora_roundcube.cache_shared' doesn't existAll you needed to do was import that database table into sentora_roundcube. Although I figured by doing the update it would fix it.
At any rate, find the roundcube SQL file, look for the cache_shared table and using phpmyadmin, add/import that table and its contents from the original roundcube SQL file.4
RE: Big problem with Roundcube - kini - 08-12-2015
(08-12-2015, 02:32 AM)TGates Wrote: You should not have deleted the database
The error tells you exactly what is wrong:
Code:Table 'sentora_roundcube.cache_shared' doesn't exist
All you needed to do was import that database table into sentora_roundcube. Although I figured by doing the update it would fix it.
At any rate, find the roundcube SQL file, look for the cache_shared table and using phpmyadmin, add/import that table and its contents from the original roundcube SQL file.4
I get the database from another sentora server and i restore it, but this not fix the problem.
After this i make fresh install OS and sentora and everything again.. Beleave me, this is big shit..
The roundcube error show after this steps:
Copy /var/zpanel/vmail from one server to another, because i think this step move all email accounts, boxes and everything. Yes i try to make migration..
I think sentora support need make easy ways for migration on next update.
Second proposal for sentora support is ways to make backups, mysql or mail or dns etc. can working on another machine from sentora panel.