Forums: Search Error

Tags:

  1. snackeru : Member | 1 year ago

    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)?

  2. DaveLester : Member | 1 year ago

    It's strange that it happened suddenly. Have you recently added or modified items in your Omeka database?

  3. snackeru : Member | 1 year ago

    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?

  4. snackeru : Member | 1 year ago

    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?

  5. DaveLester : Member | 1 year ago

    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

  6. snackeru : Member | 1 year ago

    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.

  7. JeremyBoggs : Omeka Dev Team Manager | 1 year ago

    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!)

Reply

You must log in to post.