Big problem with Roundcube
#1
Big problem with Roundcube
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. Sad
Reply
#2
RE: Big problem with Roundcube
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. Smile
-TGates - Project Council

SEARCH the Forums or read theĀ DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
#3
RE: Big problem with Roundcube
(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. Smile

I downloaded roundcube, replaced old with new files, delete SQL database and create and installed again

BUT i have this error again..
Reply
#4
RE: Big problem with Roundcube
You should not have deleted the database Confused I said to upgrade according to their documentation!

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
-TGates - Project Council

SEARCH the Forums or read theĀ DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
#5
RE: Big problem with Roundcube
(08-12-2015, 02:32 AM)TGates Wrote: You should not have deleted the database Confused I said to upgrade according to their documentation!

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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
How to upgrade RoundCube rajeevrrs 0 2 ,746 11-01-2022, 10:19 PM
Last Post: rajeevrrs
can not send email - SMTP error on roundcube wolvepy 9 35 ,594 01-03-2020, 08:37 AM
Last Post: Telepuzik
How to add password reset option in roundcube hakunamatata 15 75 ,731 02-08-2019, 12:20 PM
Last Post: republicus

Forum Jump:


Users browsing this thread: 1 Guest(s)