Roundcube Community Forum

 

Database Problem

Started by quwax, January 30, 2014, 03:08:17 AM

Previous topic - Next topic

quwax

Hello,
when I check my database I get the alert:
    Missing table 'contactgroups'
    Missing table 'contactgroupmembers'

the update scheme does nothing. When I chekc the database these tables are not there. So I guess I have to insert them manually.

How?

Thanks
quwax

quwax

#1
Hello,
would be somebody please be so kind and post the structure of these 2 tables or at least a pointer where I can find it?
So that I can update the database with the proper tables and fields.

I just updated the installation to 1.0-rc and find the same problem after running the update script or trying to update the database schema from the webinterface.

I know how to insert the tables, but I need to know which fields are required and which dataformat they should have.

thanks
quwax

JohnDoh

I'm not sure which type of database you are using but you'll find *.initial.sql files in the SQL folder of your roundcube installation or here https://github.com/roundcube/roundcubemail/tree/release-1.0/SQL
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more...

quwax

it's mysql, but thanks that did it.
Just wondering, why the installer wasn't able to do it ... ?
cheers
quwax