Error 1064 only on Firefox, but not in Explorer and Chrome

[Guest]

http://alturl.com/tk7wb

 

Something very estrange

 

Everything works fine on chrome, and explorer

 

But in Firefox Shows an error

 

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 ') and p.products_id = pc.products_id AND c.categories_id = pc.categories_id' at line 8

 

select c.categories_id FROM products p, products_to_categories pc, categories c, categories_description cd WHERE p.products_id in () and p.products_id = pc.products_id AND c.categories_id = pc.categories_id AND p.products_status = '1' AND c.categories_id = 23 AND c.categories_id = cd.categories_id AND cd.language_id = '1' LIMIT 1

[burt]

I see no error in Firefox.

 

[b][b]WHERE p.products_id in () [/b][/b]

 

is incorrect, here you should have 1 or more product id's

[Guest]

Thanks

the pic just taken, shows how is the error on my firefox... is something with my firefox?

 

http://oi40.tinypic.com/2uztpnr.jpg

[Guest]

I guess the problem is local to you, because I've visited the site and got no error in my FF when accessing cPath=22.

Can you check your site using FF from another PC (a friend or so)?

[Bob Terveuren]

Hi - can you post the chunk of code that is generating the SQL query - there should be an array in there that's missing

[tgely]

There is an inconsistent query string when cPath=22.

 

categories_id = 23 

 

Your query string is misconfigured. Your browser system probably hurt. Try to delete cookies or session.