Roundcube Community Forum

Release Support => Release Discussion => Topic started by: bswinnerton on August 15, 2008, 05:25:50 PM

Title: Merging Address book & Preferences after upgrade
Post by: bswinnerton on August 15, 2008, 05:25:50 PM

Hi everyone,

Can someone point me in the right direction of merging the old users address book and preferences from 0.1 to 0.2a?

Thanks

Title: Merging Address book & Preferences after upgrade
Post by: bswinnerton on August 15, 2008, 06:06:23 PM

Just for some more info, I created a new database, how can I take the old ones and put them into the new database?  It looks as though there is a different SQL structure.

Title: Merging Address book & Preferences after upgrade
Post by: JohnDoh on August 16, 2008, 11:51:57 AM

There should have been an *.update.sql file that you could have run to simply alter the current database with the 0.2a updates. Loonking at mysql.update.sql there havent been any changes to the contacts table since 0.1-stable so if your using mysql you should be able to just copy the data accross, the same with the preferences, the only change there is a couple of indexes.

Title: Merging Address book & Preferences after upgrade
Post by: bswinnerton on August 25, 2008, 02:17:58 PM

Tried the sql update and keep getting:

Error

SQL query:

ALTER TABLE `messages` DROP INDEX `idx` ,
DROP INDEX `uid` ;

MySQL said: Documentation
#1091 - Can't DROP 'idx'; check that column/key exists

Title: Merging Address book & Preferences after upgrade
Post by: bswinnerton on August 25, 2008, 02:46:03 PM

Woops, was in the wrong database.  It's working now!

Thanks