Neeeko | 13 Jun 2012 22:27
Picon
Favicon
Gravatar

[RCU] 0.8-rc / contacts table structure ?

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 :

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 ?

Thanks for your help.

_______________________________________________
Roundcube Users mailing list
users@...
http://lists.roundcube.net/mailman/listinfo/users

Claudio Kuenzler | 14 Jun 2012 08:09
Favicon

Re: [RCU] 0.8-rc / contacts table structure ?

On Wed, Jun 13, 2012 at 10:27 PM, Neeeko <neeeko <at> 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-g9ZBwUv/Ih/43r0bJudG79HuzzzSOjJt@public.gmane.org
http://lists.roundcube.net/mailman/listinfo/users

_______________________________________________
Roundcube Users mailing list
users@...
http://lists.roundcube.net/mailman/listinfo/users
Neeeko | 14 Jun 2012 09:53
Picon
Favicon
Gravatar

Re: [RCU] 0.8-rc / contacts table structure ?

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

_______________________________________________
Roundcube Users mailing list
users@...
http://lists.roundcube.net/mailman/listinfo/users


Gmane