Stackover FLow line 132 after 5.15 upgrade

Posted by tweaker on January 15, 2009 at 10:50pm

Issue Summary

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

#1

Posted by tweaker on January 18, 2009 at 1:44am

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

please exciuse ------

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

#2

Posted by Wim Leers on February 7, 2009 at 12:18pm

Category:	bug report	» support request
Priority:	critical	» normal
Assigned to:	Anonymous	» Wim Leers
Status:	active	» closed (fixed)

Heh :P

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

#3

Posted by md2 on March 5, 2009 at 11:08am

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

#4

Posted by Wim Leers on March 7, 2009 at 3:34pm

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.

#5

Posted by budda on March 13, 2009 at 12:53am

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?

#6

Posted by Wim Leers on March 13, 2009 at 11:31am

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

#7

Posted by budda on March 13, 2009 at 1:01pm

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

#8

Posted by System Message on March 27, 2009 at 1:10pm

Status:

fixed

» closed (fixed)

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

Stackover FLow line 132 after 5.15 upgrade

Jump to:

Issue Summary

Comments

#1

#2

#3

#4

#5

#6

#7

#8

#9

#10

#11

Project:	Hierarchical Select
Version:	5.x-3.0-rc7
Component:	Code
Category:	support request
Priority:	normal
Assigned:	Wim Leers
Status:	closed (fixed)