Hi Amilcar

Thanks for trying V3 upgrade, the 'Duplicate entry 'book_genre_id' etc probably indicates you applied the full V3 sql patch for a new V3 install, rather than an upgrade patch?

You're supposed to use the update sql patch if you already have V2 book installed, maybe I didn't make that clear

Restore your backup V2 book database before your upgrade attempt, (you may now have the V3 actual books fileset uploaded, but thats ok)

now apply the update sql 'sql_update_V2_TO_V3LANGS.txt' in folder 3_UPGRADE_EXISTING_BOOK_V2_TO_V3_LANGS

This is a cut-down sql patch, that only updates some book table fields (and keys) in the database,

The full V3 sql that you appear to have used will indeed probably only half complete, and the missing authors etc are probably due to that. Cross fingers..