Error during save identity

[marcozeus]

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

[SKaero]

If you've updated RoundCube you need to run the corresponding sql files from your previous version found it <RC root>/SQL/mysql

[marcozeus]

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

[SKaero]

Which version of RoundCube are you upgraded from?

[marcozeus]

0.9.0
but I don't remember the first version included in the initial DirectAdmin package (started 3 months ago).

[SKaero]

You need to know the first version, do you have any backups?

[marcozeus]

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?

[alec]

You should also investigate existence of UPGRADING file.

[marcozeus]

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

[alec]

There should be the UPGRADING file describing upgrade process. https://github.com/roundcube/roundcubemail/blob/master/UPGRADING

[marcozeus]

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?

[marcozeus]

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

[SKaero]

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?

[marcozeus]

Hi,
I solved using this http://tuxette.nathalievilla.org/?p=855&lang=en. Do you think is it a good solution?
Thank you very much for your support.