We've been running Omeka for a while now, but all of the sudden yesterday the search form stopped working. I turned on the error log and I get this error when attempting a search:
2009-06-18T14:02:46-05:00 ERR (3): 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 'Object id #134) AS s ON s.item_id = i.id' at line 7
I've tried to turn on the SQL log but for whatever reason I can't get it to log the SQL statements.
Does anyone have any ideas (running 1.0beta)?
It's strange that it happened suddenly. Have you recently added or modified items in your Omeka database?
Yes, probably. I thought the same thing. Maybe some metadata has changed that is throwing it off. How can I tell what are the most recently updated items?
A better way to troubleshoot this would be to enable the sql.log. However, when I set it to true and have a corresponding sql.log in the "logs" directory, nothing gets captured. How can I enable this?
Hi Snackeru,
When sql logging is on, the SQL shows up in errors.log.. it makes more sense to me to be in sql.log (for obvious reason), so I'll make note of it on TRAC.
Let me know how it goes.
Dave
OK, that is what I did and where I got the error message from in my original post:
2009-06-18T15:47:11-05:00 ERR (3): 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 'Object id #134) AS s ON s.item_id = i.id' at line 7
But this is too short, it doesn't tell me the file that generates it, or the full query. Is there any way to get this information? I am absolutely stumped.
I am stumped too, especially if it was working and stopped suddenly. Did you install any plugins immediately before getting the error? If so, try deactivating them to see if the error goes away (and let us know which plugin!)