I'm trying to install Omeka on localhost (xampp on win7) and i got the following error:
Schema task failed on table 'omeka_item_types' with Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '1' for key 'PRIMARY'
Can anybody help me? Thanks in advance
This would happen if you're trying to install on top of tables which already have a partially-installed Omeka on them.
This could happen if there was an error in the installer when you first tried to install Omeka.
There's a bug in the Zend Framework (which Omeka uses) which affects many people using Windows. Basically, long SQL queries cause PHP to crash. We've got some long description strings that get installed in Omeka's item_types and elements tables. Some users have reported success with installing after removing or shortening the long lines in those files (the table data is located in application/core/schema).
Note, we only test on and officially support Linux -based hosts for Omeka. If you're just trying to set up a development or local server, using a Linux distribution through a virtual machine might be the better option.
Thank you for your quick answer.
I've droped the database and recreate it under different name, i've also update the db.inf, same problem.
I will try to install it under a live linux server as a virtual machine will break down my old computer :)