Mysql error

Pages: 1

Posted: 09 Aug 2010 14:28
	Registered User Currently Offline	Posts: 1 Join Date: Aug 2010
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 __________________ www.storeboard.com It is a social networking site for small and medium businesses in the US and Canada for now.

Posted: 25 Jan 2011 10:05
	Registered User Currently Offline	Posts: 1 Join Date: Jan 2011
I have read about this MySQL error and I believe that the problem is with the IN() parts which don’t include parameters. To understand the problem better, check on this link mysql in. If that doesn’t work, I strongly recommend you to get a professional programmer, because they are apt to solve problems like these in a matter of minutes. They have the experience of debugging their own cone almost every day. I hope you found this helpful. __________________ email marketing software

Pages: 1