Roundcube cant save contact

[markmg]

I get a error when trying to save a contact in roundcube


error occurd while saving

anyone know why ? using custombuild

 

[markmg]

re

getting this error

[25-Feb-2016 12:18:30 +0000]: <7d49f43c> DB Error: [1146] Table 'da_roundcube.searches' doesn't exist (SQL Query: SELECT `search_id` AS id, `name` FROM `searches` WHERE `user_id` = '5' AND `type` = '1' ORDER BY `name`) in /var/www/html/roundcubemail-1.1.4/program/lib/Roundcube/rcube_db.php on line 543 (GET /roundcube/?_task=addressbook)
[25-Feb-2016 12:18:37 +0000]: <7d49f43c> DB Error: [1054] Unknown column 'words' in 'field list' (SQL Query: INSERT INTO `contacts` (`user_id`, `changed`, `del`, `vcard`, `name`, `email`, `firstname`, `surname`, `words`) VALUES (5, now(), 0, 'BEGIN:VCARD\r\nVERSION:3.0\r\nN:;mark;;;\r\nFN:mark\r\nEND:VCARD', 'mark', '', 'mark', '', ' mark')) in /var/www/html/roundcubemail-1.1.4/program/lib/Roundcube/rcube_db.php on line 543 (POST /roundcube/?_task=addressbook&_framed=1&_orig_source=0?_task=addressbook&_action=save)

 

[smtalk]

Is that a new install? Please try:

cd /usr/local/directadmin/custombuild
./build update
./build roundcube

 

[markmg]

re

thanks tried it but same result, error while saving

it was an upgrade to custombuild

 

[zEitEr]

Hello,

Manually fix tables structure in phpMyAdmin or completely reinstall Roundcube.

 

[markmg]

A reinstall would mean the users also lose their current contacts also? not a option i would make them happy with unfortunatly

is there a simpel way of fixing it in phpmyadmin ? is there a manual around by anychance

 

[zEitEr]

1. create table 'da_roundcube.searches' that doesn't exist. Find its structure in roundcube installation directory.
2. add column 'words' in table 'da_roundcube.contacts' that doesn't exist. Find its details in roundcube installation directory.

Read official docs on how to work in phpMyAdmin

 

[markmg]

thanks

how can i get to roundcube with phpmyadmin ?

if i use my main directadmin account (admin/password) i only see 1 db wich is from a wordpress install, how can i get phpmyadmin to show/view the roundcube databse ?

 

[zEitEr]

Use da_admin account. You can get the login/pass from:
/usr/local/directadmin/conf/mysql.conf


This is the master DA mysql account used for creating databases/users.

 

[markmg]

Great that got it working!

Thank you very much