Forums » Install SQL error

RSS feed for this topic

Info

  1. gnosis_omeka Posted 2 years ago

    When trying to install, I get the following SQL error:

    Mysqli statement execute error : Duplicate entry '1' for key 'PRIMARY'

    any ideas?

  2. DaveLester Posted 2 years ago

    What version of Omeka do you have? And what version of MySQL are you running?

  3. gnosis_omeka Posted 2 years ago

    Hi David,

    Omeka 1.0
    MYSQL 5.1.33

    Any ideas?

    Stephen

  4. Jeremy Boggs (Moderator) Posted 2 years ago

    Hi Stephen,

    Are you getting this error on the installation screen? It almost sounds like you've tried to install it twice. If you can get access to your database thorugh PHPMyAdmin or some other method, can you see if there are existing tables in your database?

  5. gnosis_omeka Posted 2 years ago

    Hi Jeremy,

    I have installed this several times and each time I install, I delete the previous tables in MYSQL using phpMyAdmin. I noticed a hiccup in the install process that potentially populates the database twice.

    I appreciate your feedback.

    Thank you.

    Stephen

  6. gnosis_omeka Posted 2 years ago

    Interesting, the install screipt always create the following three tables:

    collections
    data_types
    elements
    then fails

    Is there a way of running the install in debug mode?

  7. Jeremy Boggs (Moderator) Posted 2 years ago

    Is there a way of running the install in debug mode?

    I do not know the answer to that, but will ask one of our developers and respond here again ASAP.

Reply

You must log in to post.