I upgraded from very old 0.52 beta to 0.95 stable.
Everything else works-so far- except when I select Addressbook and go to my error logs, then it already shows an error (it isnt displayed on screen).
DB Error:  no such table: searches (SQL Query: SELECT search_id AS id, "name" FROM searches WHERE user_id = '1' AND "type" = '1' ORDER BY "name") in /var/www/testingmeil_changed.com/program/lib/Roundcube/rcube_db.php on line 416 (GET /?_task=addressbook)
And when I actually click to add new contact and trying to save, then it gives error on screen as well. Saying: "An error occurred while saving".
And in error log this error appeared.
DB Error:  table contacts has no column named words (SQL Query: INSERT INTO contacts (user_id, changed, del, "vcard", "name", "email", "firstname", "surname", "words") VALUES (1, now(), 0, 'BEGIN:VCARD
END:VCARD', 'Sten', 'firstname.lastname@example.org', 'Sten', '', ' sten email@example.com')) in /var/www/testingmeil_changed.com/program/lib/Roundcube/rcube_db.php on line 416 (POST /?_orig_source=0?_task=addressbook&_action=save)
As I used an upgrade route to install this stable Rouncube and didn't use blank DB, instead used sqlite to sqlite3 DB conversion that was described in README Upgrade file, now I am facing this problem because of that upgrade?
So some brand new tables are missing that are actually needed?
The easiest way to fix this? My contacts table schema right now (no column named "words" in it...):
CREATE TABLE contacts (
contact_id integer NOT NULL PRIMARY KEY,
user_id integer NOT NULL default '0',
changed datetime NOT NULL default '0000-00-00 00:00:00',
del tinyint NOT NULL default '0',
name varchar(128) NOT NULL default '',
email varchar(255) NOT NULL default '',
firstname varchar(128) NOT NULL default '',
surname varchar(128) NOT NULL default '',
vcard text NOT NULL default ''
" is entirely separete TABLE?
In a hurry for quick answer- fix-possibly?