Author Topic: Merging Address book & Preferences after upgrade (Read 3842 times)

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

bswinnerton · « **Reply #1 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.

JohnDoh · « **Reply #2 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.

bswinnerton · « **Reply #3 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

bswinnerton · « **Reply #4 on:** August 25, 2008, 02:46:03 PM »

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

Thanks