SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds [#2075485]

Hi,

This is the follow up of: https://drupal.org/node/1346846#comment-7793803

I got a lot of:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 'WHERE (item_id = 'NUMBER'

I got this when anonymous users browse my site and look at product_displays.
I think the item_id's are also commerce products.

I use all latest .dev's from all search api submodules.
I tried everything from https://drupal.org/node/1346846 , like resaving the formfield but not working.

Thanks a lot in advance for your reply.
Greetings, Martijn

Comments

Comment #1

Summit CreditAttribution: Summit commented 27 August 2013 at 21:30

Hi,
May be helps with this bugreport that the error is shown 9 logpages long with the same error on the same page with another item_id! In my case item_id from first 10100590 and latest 10100352. So my log is really filled with this error.

Greetings, Martijn

Comment #2

drunken monkey

he/him

German

Vienna, Austria

CreditAttribution: drunken monkey commented 27 August 2013 at 21:33

Could you install the Devel module and switch error output to "Backtrace"? Or is this a live site?
Would be really helpful to know where this is coming from.

Would also be great if you could find out the complete SQL statement that causes the error – either from MySQL's error log, or by adding a debugging statement to the code.

Comment #3

Summit CreditAttribution: Summit commented 27 August 2013 at 21:43

Hi,
I have a testwebsite set up.
DO you mean

Error handlers
Select the error handler(s) to use, in case you choose to show errors on screen.
None is a good option when stepping through the site in your debugger.
Standard Drupal does not display all the information that is often needed to resolve an issue.
==> Krumo backtrace displays nice debug information when any type of error is noticed, but only to users with the Access developer information permission.
==> This one?

Greetings, Martijn