MySQL: Duplicate entry '1' and Query:INSERT INTO jos_menu

[compass]

If you are getting errors during migration associated with this, try these steps:

1. Redo the installation
2. In step 4 (database) select drop table in advanced
3. Click next
4. Go into phpMyAdmin and truncate the jos_menu table (empty it)
5. Finish the installation/migration

These solutions are gleaned from other posts in the forum here, but I have reposted the solution to aid people searching.

[ErnstQ]

I did a trial migration today from 1.0.15 to 1.5.2
The trial was on a local PC, on which I had a WAMPserver running.

I had this duplicate entry error for the tables jos_menu and jos_modules. When I truncated the tables, this error disappeared, but I kept getting other errors in the SQL like: "INSERT INTO josjos_migrationjos_backlinks....." , it looked like the _ was replaced with jos_. Similar problem like: http://forum.joomlafacile.com/showthread.php?t=51071

Installation from scratch did not help. Finally I booted my PC and ... it worked even without truncating the tables.