This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

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
Thanks given by:
#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
Thanks given by:
#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
Thanks given by:
#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
Thanks given by:
#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
Thanks given by:


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

Forum Jump:


Users browsing this thread: 1 Guest(s)