Merging Address book & Preferences after upgrade

[bswinnerton]

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]

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]

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]

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]

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

Thanks