Wim,
Not sure really where to take this one. It happened after upgrading to D 5.15
I get a pop-up Stack Overflow line 132 - when I enter an exposed filter page
The message on the Exposed Query Box - said to click update
I received the below when I clicked update
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/me.com/includes/database.mysql.inc on line 402.
user warning: 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 '= '') AND (. IN ('',''))' at line 1 query: SELECT count(node.nid) FROM node node LEFT JOIN content_field_location content_field_location ON node.vid = content_field_location.vid LEFT JOIN content_field_location content_field_location2 ON node.vid = content_field_location2.vid LEFT JOIN content_field_category content_field_category ON node.vid = content_field_category.vid WHERE (node.type IN ('classifieds')) AND (content_field_location.field_location_value = '') AND (. = '') AND (. IN ('','')) in /home/me.com/includes/database.mysql.inc on line 174.
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/me.com/includes/database.mysql.inc on line 402.
user warning: 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 '= '') AND (. IN ('','')) LIMIT 0, 25' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_location content_field_location ON node.vid = content_field_location.vid LEFT JOIN content_field_location content_field_location2 ON node.vid = content_field_location2.vid LEFT JOIN content_field_category content_field_category ON node.vid = content_field_category.vid WHERE (node.type IN ('classifieds')) AND (content_field_location.field_location_value = '') AND (. = '') AND (. IN ('','')) LIMIT 0, 25 in /home/me.com/includes/database.mysql.inc on line 174.
note: I remebered to reload jquery_update to /misc and the Site Status page says - installed correctly
Comments
Comment #1
green monkey commented...... duh - Stack Overflow is Winodws error isn't it
please exciuse ------
after upgrade freak out happened - looks like it was some cache issue
Comment #2
wim leersHeh :P
I was already wondering how you managed to get such a weird error :)
Comment #3
md2 commentedHi,
I'm re opening this issue as I am also getting the error. I have cleared cache through devel and browser.
Running Drupal 5.16 , Hierarchical Select 5.x-3.0-rc7.
I get Stack Overflow at line:140
Any help on this would be greatly appreciated!
Thanks,
Mark
Comment #4
wim leersI can't reproduce this. You'll have to track down the exact cause yourself I'm afraid. Many hundreds (thousands?) of other users don't have this problem. Feel free to set back to active when you've found the cause.
Comment #5
buddaI'm also getting the same problem. You can see it on a live site at http://www.sen .org .uk/user/register
The field is used on a profile node. The same error occurs when editing a users profile once logged in.
Line numbers form IE7 JavaScript dialogs are pretty much useless.
I realise this is not any more a solution/fix, but thought it may provide a public way to see the problem without having to find a way to recreate?
Comment #6
wim leersAlso errors in Safari:
Please check your Status Report page. You're not using jQuery 1.2.6. You're using version 1.0.4:
I bet that's also the cause of the problem for others. You probably overwrote the previous jQuery file while updating core. If you were using SVN to manage your Drupal installation, this would probably not have happened :)
Comment #7
buddaThat would explain it. The recent Core update. doh.
Comment #9
summit commentedBookmarking, having same problem after clean update to 5.18.
greetings, Martijn
Comment #10
green monkey commentedMartijn, try rebooting your box
Comment #11
summit commentedYes, it was the jquery_update problem.. why is drupal core still on the old one...greetings, Martijn