Hi all,
I hope this is the right area to post my problem: I have a server with Centos 5.9 64 bit, DirectAdmin and Roundcube 0.9.1. Using the webmail, every times I send an email I have to write the sender. So, I would like to add an identity but when I try to save it an error "An error occured when saving... ".
Log:
DB Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (GET /?_task=settings&_action=refresh&_remote=1&_unlock=loading1371117519539&_=1371117519544)
DB Error: [1054] Unknown column 'changed' in 'field list' (SQL Query: INSERT INTO identities (changed, `name`, `email`, `organization`, `reply-to`, `bcc`, `signature`, `standard`, `html_signature`, user_id) VALUES (now(), 'myuser', 'myemail', '', '', '', '', '0', '0', '3')) in /var/www/html/roundcubemail-0.9.1/program/lib/Roundcube/rcube_db.php on line 416 (POST /?_task=settings&_action=save-identity)
I tried to search for the solution but I didn't understand well if and how I have to upgrade the db.
Please, anyone could be explain me the steps I have to follow in order to solve the problem ?
Thank you very much
If you've updated RoundCube you need to run the corresponding sql files from your previous version found it <RC root>/SQL/mysql
Hi SKaero,
first of all thank you for the answer.
I bought this server 3 months ago and this feature never works.
I've updated Roundcube (and Custombuild package) this morning.
In the folder you said, I can see these files:
-rw-r--r-- 1 webapps webapps 362 May 16 18:06 2008030300.sql
-rw-r--r-- 1 webapps webapps 340 May 16 18:06 2008040500.sql
-rw-r--r-- 1 webapps webapps 101 May 16 18:06 2008060900.sql
-rw-r--r-- 1 webapps webapps 515 May 16 18:06 2008092100.sql
-rw-r--r-- 1 webapps webapps 293 May 16 18:06 2009090400.sql
-rw-r--r-- 1 webapps webapps 2685 May 16 18:06 2009103100.sql
-rw-r--r-- 1 webapps webapps 193 May 16 18:06 2010042300.sql
-rw-r--r-- 1 webapps webapps 239 May 16 18:06 2010100600.sql
-rw-r--r-- 1 webapps webapps 344 May 16 18:06 2011011200.sql
-rw-r--r-- 1 webapps webapps 2817 May 16 18:06 2011092800.sql
-rw-r--r-- 1 webapps webapps 106 May 16 18:06 2011111600.sql
-rw-r--r-- 1 webapps webapps 1017 May 16 18:06 2011121400.sql
-rw-r--r-- 1 webapps webapps 192 May 16 18:06 2012080700.sql
-rw-r--r-- 1 webapps webapps 220 May 16 18:06 2013011000.sql
Could you tell me what file I have to run, please?
Thank you very much
Regards,
Marco
Which version of RoundCube are you upgraded from?
0.9.0
but I don't remember the first version included in the initial DirectAdmin package (started 3 months ago).
You need to know the first version, do you have any backups?
sorry, no backups :(
The first version of OS was CentOS 5.4 64 bit (now is upgraded to 5.9) and Directadmin with Custombuild 1.0
Tomorrow morning can I try to investigate with my provider if they know which version they installing from scratch.
Because this feature (saving the identity) never worked fine, what is the risk if I run a wrong version of those .sql file? Could it compromise user emails?
You should also investigate existence of UPGRADING file.
Hi,
my provider staff is investigating about the Roundcube initial version, but is very difficult...
Thank you Alec for your answer but I didn't understand it, what do you mean with "upgrading files"?
I'm a noob, where I have to search them?
thank toy very much
There should be the UPGRADING file describing upgrade process. https://github.com/roundcube/roundcubemail/blob/master/UPGRADING
Into /var/www/html/roundcubemail-0.9.1/bin/ I can see UPGRADING file, with the same content you have linked.
What have I do?
Hi,
my provider answered me that the default version is 0.9.2.
Of course, the distro they used is updated at last version so I can suppose that the first version on the server was 0.9.0.
Please, could you let me know which file I have to run and what is the correct command to do it? 2013011000.sql ?
Thank you very much
Regards
There where no SQL upgrade from 0.9 to 0.9.2, It probably was a different version. Can you post your RoundCube database schema?
Hi,
I solved using this http://tuxette.nathalievilla.org/?p=855&lang=en (http://tuxette.nathalievilla.org/?p=855&lang=en). Do you think is it a good solution?
Thank you very much for your support.