A Mysql error

[RedBolt]

Hi everyone.
I have a last problem until my site is finishet. Its really nice to be at the finishing line after a lot of months of fixing problems.

I hpe someone can really help me with this last thing because im really stuck.

The problem is this:

I have 3 languages in my website, English, Swedish and German. On the site i have on the top of the page Categories, when you put the arrow on it then a list of Categories show up. In the English version you can click on one of the categories on the list and it takes you there, but on the swedish and german version i get this message:

A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: 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 ') OR a.addl_category_id IN ())' at line 2
SQL Query: SELECT count(*) AS count_rows FROM shrimpau_auctions a LEFT JOIN shrimpau_users u ON u.user_id=a.owner_id WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.list_in!='store' AND a.catfeat='1' AND a.closed=0 AND (a.category_id IN () OR a.addl_category_id IN ())

I have tried hard to find it on google and other wbsites to fix it but no success, i hope someone nice and smart can help me with this last thing

Please help

Best regards
Meduart

[ErnieAlex]

I don’t see anything wrong. You might want to use MySQL’s query browser. You can download it and install it on your Windows system or others and then test queries. Not sure if it will help. But, worth a try…

http://dev.mysql.com/doc/query-browser/en/index.html

[RedBolt]

Do they have that for Mac?
And what does it do?

[ErnieAlex]

I think they have it for MAC, not sure though. It is MySQL’s system for testing queries against your database. It is a way to test before going live. I have never used it. But, your query is tricky with all of the JOIN’s. You might want to ask this question again on the MySQL’s support forum. But, maybe someone else here will see what I do not… Sorry… Good luck!