[solved] Migrating from akoobook to easybook reloaded

11 years 11 months ago - 11 years 11 months ago #7184 by gruz

[solved] Migrating from akoobook to easybook reloaded was created by gruz

I have an old Joomla 1.0 book with akobook installed.

So migrating was VERY easy, as Easybook Reloaded is a successor of akobook.

I copied my old table to the new database, installed Easybook Reloaded.

My new database contained both tables:
old mos_akoobook
and new j25_easybook

Next I executed the query:

INSERT INTO j25_easybook

SELECT 
gbid as id,
gbip,
gbname,
gbmail,
0 AS gbmailshow,
gbloca,
gbpage,
gbvote,
gbtext,
FROM_UNIXTIME(gbdate) as gbdate,
'' as gbtitle,
NULL as gbcomment,
published,
gbicq,
gbaim,
gbmsn,
'' as gbyah,
'' as gbskype

FROM `mos_akobook` WHERE 1

Done!

The topic has been locked.