tried installing Omeka on XAMPP following the instructions, but this error persists, HELP NEEDED !
THIS IS THE ERROR MESSAGE>>>>
Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Duplicate entry '1' for key
'PRIMARY'' in C:\xampp\htdocs\omeka\application\libraries\Zend\Db\Statement\Mysqli.php:221 Stack trace: #0
C:\xampp\htdocs\omeka\application\libraries\Zend\Db\Statement.php(284): Zend_Db_Statement_Mysqli->_execute(Array) #1
C:\xampp\htdocs\omeka\application\libraries\Zend\Db\Adapter\Abstract.php(468): Zend_Db_Statement->execute(Array) #2 [internal function]:
Zend_Db_Adapter_Abstract->query('??-- ?-- Dumpin...', Array) #3 C:\xampp\htdocs\omeka\application\libraries\Omeka\Db.php(70):
call_user_func_array(Array, Array) #4 [internal function]: Omeka_Db->__call('query', Array) #5
C:\xampp\htdocs\omeka\application\libraries\Omeka\Db.php(230): Omeka_Db->query('??-- ?-- Dumpin...', Array) #6
C:\xampp\htdocs\omeka\application\libraries\Omeka\Db.php(244): Omeka_Db->exec('??-- ?-- Dumpin...') #7
C:\xampp\htdocs\omeka\install\models\Installer.php(253): Omeka_Db->execBlock('CREATE TABLE IF...' in
C:\xampp\htdocs\omeka\application\libraries\Zend\Db\Statement\Mysqli.php on line 221
I will try installing it on XAMPP and see if I can reproduce the error.
I'm not exactly sure what your XAMPP settings are, but I was able to successfully install Omeka on XAMPP for the Mac under the /Applications/XAMPP/htdocs directory, although XAMPP had .htaccess problems for mod_rewrite and setting php settings under my user's Sites directory. I'm not sure yet what the issue is. Can someone else try to install Omeka using XAMPP for windows?
thanks a lot dear wanderingwill ...am waiting for some guidance... deploying "omeka" on windows can make a world of difference to the students i work with to curate their art projects...am sure i will get the breakthrough with more guidance from omeka fraternity..thank god, i discovered omeka... many dreaded archiving since it was made to appear complicated by many CMS..Omeka simplified it all...
Unfortunately, we do not test, develop, or support Omeka for Windows. We don't know of anyone who has been able to get Omeka to work on Windows. I don't know enough about XAMPP to know how it handles file paths for Windows. Internally, Omeka uses Unix file paths with Unix directory separators. Let us know if you are able to get it to work somehow on Windows.
Trying to install omeka on windows, I get the same error from zendDB. This is a fresh install of Xampp under c:/xampp. Will tell you if I find something new.
When you use xampp (1.7.2 at least) it seems that omeka encounters a limitation in query size. The queries in file install/install.sql.php which are more than 400 characters can't be executed. I couldn't find the parameter which could correct this problem. So for now I removed some characters in this query. In omeka 1.1, the queries are at lines 100 & 309. If you remove some characters at the end of description, it should be fine.
If someone has a real solution to correct this please tell it.
@symac: interesting. I looked at lines 100 & 309, and both have long descriptions (in one case, for an element, in another, for an item type) which makes the query lengthy. We don't support XAMPP, nor do I run it on my machine so I can't exactly tell you why this is occurring. This may be a question that you could ask the XAMPP people (on their forums or whatever feedback systems they have). I'd be interested to hear what you learn.