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

green monkey’s picture

...... duh - Stack Overflow is Winodws error isn't it

please exciuse ------

after upgrade freak out happened - looks like it was some cache issue

wim leers’s picture

Assigned: Unassigned » wim leers
Category: bug » support
Priority: Critical » Normal
Status: Active » Closed (fixed)

Heh :P

I was already wondering how you managed to get such a weird error :)

md2’s picture

Status: Closed (fixed) » Active

Hi,
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

wim leers’s picture

Status: Active » Closed (won't fix)

I 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.

budda’s picture

Status: Closed (won't fix) » Active

I'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?

wim leers’s picture

Status: Active » Fixed

Also errors in Safari:

effects.core.js:198TypeError: Result of expression 'jQuery.fx.step' [undefined] is not an object.
RangeError: Maximum call stack size exceeded.

Please check your Status Report page. You're not using jQuery 1.2.6. You're using version 1.0.4:

jQuery.fn.jquery
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 :)

budda’s picture

That would explain it. The recent Core update. doh.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

summit’s picture

Bookmarking, having same problem after clean update to 5.18.
greetings, Martijn

green monkey’s picture

Martijn, try rebooting your box

summit’s picture

Yes, it was the jquery_update problem.. why is drupal core still on the old one...greetings, Martijn