Mysql error

maliy0 · Joined: 31 Jul 2010 Posts: 1

Hello everybody. I'm new here, and hoping to find solution to this problem.
I have an auction website, that is currently setup for coins only. I'm trying to restore original categories.

When I upload phpMyAdmin SQL Dump file for categories, and then go to my website and click on any categories, I get this error:

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 probid_auctions a WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND a.list_in!='store' AND a.catfeat='1' AND (a.category_id IN () OR a.addl_category_id IN ())

I know there is something wrong with the dump file, I just can't figure out what. Please note, when I upload my other file, with limited categories for coins only, everything works as it should, with no errors.

If someone knows what to do to fix it, please let me know. It's been driving me crazy for the past week. Thanks

lostboy · Joined: 02 May 2004 Posts: 6058 Location: toronto, canada

The IN parameters of your query are empty...that will make it fail