Install SQL error

gnosis_omeka June 15, 2009

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

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

any ideas?

DaveLester June 17, 2009

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

gnosis_omeka June 23, 2009

Hi David,

Omeka 1.0
MYSQL 5.1.33

Any ideas?

Stephen

Jeremy Boggs June 30, 2009

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?

gnosis_omeka July 1, 2009

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

gnosis_omeka July 1, 2009

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?

Jeremy Boggs July 13, 2009

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.