Magento MySQL help please!

Discussion in 'MySQL' started by NetBastard, Mar 23, 2010.

0
  1. #1
    I’m using a database from magento 1.4, something happened to our website so we had to take it down and then put magento back up.
    We are using 1.4 for the previous database, and 1.4 version for importing the database.

    When I try to go to phpmyadmin to import the database I get this error, “Duplicate entry ‘1’ for key 1 “

    I tried deleting cache, deleting files in var/cache and var/session , no luck same error.
    I used the magento cleanup tool and tried again.

    Now I get this after trying to import in phpmyadmin

    import.php: Missing parameter: import_type (FAQ 2.8)
    import.php: Missing parameter: format (FAQ 2.8)

    then I tried to import again and I got the same "“Duplicate entry ‘1’ for key 1 “"

    help is very much appreciated
     
    NetBastard, Mar 23, 2010 IP
  2. jetsett

    jetsett Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It sounds like your table id is not incrementing. Each table entry must have a unique id. Enable 'auto increment' for the table and it should work.
     
    jetsett, Apr 1, 2010 IP