Home arrow Support arrow Our Main FAQ

When trying to re-install mosDirectory I get DB Error 1062 When trying to re-install mosDirectory I get DB Error 1062

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

If you have uninstalled mosDirectory and then you try to reinstall it you will get an error message like

 SQL Error DB function failed with error number 1062
Duplicate entry '1' for key 1 SQL=INSERT INTO

 This is because my components do NOT remove tables when you uninstall the component - this is by design and prevents you removing your data by mistake and then blaming me :-)

If you need to reinstall mosDirectory after uninstalling it you have two options:

  1. Manually remove the database tables that have "_dir_" in them (use phpMyAdmin) before trying to reinstall mosDirectory - this will DELETE all your data!!!!

  2. Maually edit the XML file in the zip file you download from our site, remove the INSERT lines , they start with <query> INSERT .....   or <query><![CDATA[ INSERT and end the line with </query>, then save the XML file back into the zip and reinstall.

 

 

Article is in the following categories:
KB » mosDirectory


Leave A Comment

or close

Email This Article

or close

Existing Comments

There are currently no comments.

myNotes My Notes

You currently have no notes on this article. You can leave your own note on this page, the note can only be seen by you (and our administrators) but not other users.

You need to login first

Related Articles

The following articles may be related to this one:

  • No related Items

When trying to re-install mosDirectory I get DB Error 1062 Article Information

Hits:
4495
Created:
Wednesday, 14 June 2006
Author:
Joomla Components
Last Modified:
Monday, 29 November 1999
Access:
Public
Version:
1