Zend_Db_Statement_Mysqli_Exception

Hi all,

I've been trying to install Omeka on my WebFaction server with no success. After resolving the mod_rewrite issue, I know get the following message after filling out the install form:

Schema task failed on table 'omeka_item_types' with Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO omeka_item_types VALUES
(1, 'Text', 'A resource consisting primar' at line 9

I have dropped the tables from the original because I saw a post here that suggested that. That didn't work. I created a new database. That didn't work either. Any ideas?

A.

Which version of Omeka is this?

Hi John,

Omeka 2.0. I just downloaded it.

The first thing I'd try is deleting and re-uploading the Omeka files. You may have a corrupted copy of them, or your FTP client or other server may have changed some of the characters in the files.

Uploading just the zip file and unzipping it once it's on the server would be a good way to go. If you're FTP-ing the files separately, make sure your client is set to transfer in "binary" mode.

Hi,

Did you have any luck resolving this? I'm having the same issue on Webfaction. Tried again with Omeka 2.02 but no luck.

k

Hi Kate, yeah. I was able to get the 2.0 running using John's recommendation. The 1.5 I gave up on, but then again I don't need it anymore because my plugins are all getting 2.0 makeovers in the near future.

Seems it was that pesky binary setting that I'd missed. Sorted now. Thanks.