Hello,
Just upgraded from 0.4.2 to 0.8-rc but i cannot save, add, modify any existing contact. Looks like my contact table structure is obsolete.
Here it is :
contact_id | integer
user_id | integer
changed | timestamp with time zone
del | smallint
name | character varying(128)
email | character varying(255)
firstname | character varying(128)
surname | character varying(128)
vcard | text
Can somebody help me restructuring it ?
Thanks for your help.
On Wed, Jun 13, 2012 at 10:27 PM, Neeeko neeeko@free.fr wrote:
Hello,
Just upgraded from 0.4.2 to 0.8-rc but i cannot save, add, modify any existing contact. Looks like my contact table structure is obsolete.
How did you upgrade? Manually or by a script?
Here it is :
column Name | Type
contact_id | integer user_id | integer changed | timestamp with time zone del | smallint name | character varying(128) email | character varying(255) firstname | character varying(128) surname | character varying(128) vcard | text
Can somebody help me restructuring it ?
Check out the file SQL/mysql.update.sql - if you ugpraded manually you will have to do all the table restructuring steps - nicely described for each version.
Thanks for your help.
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
OK i checked the fresh install script and i compared it with mine, one column was missing at the end of the contacts table.
Column name : Words Format : text
Added it and now there is no problem.i can add/delete/edit/save/etc.
Oh and before i check the upgrade SQL script that i ran (was upgrading from 0.4.2) but it didn't add this, i guess it was missing from the beginning. After all this roundcube is installed on a Synology and it might be a custom installation..
Thanks