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

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
User avatar
Joomla! Ace
Joomla! Ace
Posts: 1347
Joined: Fri Aug 26, 2005 1:31 am

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

Post by compass » Thu Jan 31, 2008 4:36 pm

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.
Follow me on Twitter @compassdesign - Get get free templates and news for Joomla - Fully Managed Joomla Hosting - Unlimited Support

Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Mar 26, 2008 4:35 pm

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

Post by ErnstQ » Wed Mar 26, 2008 4:57 pm

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:

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


Return to “Migrating and Upgrading to Joomla! 1.5”