here is the error message (received when trying to submit an auction) :\
\
SQL Error: 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 'WHERE Cat_ID=10000' at line 1\
Query:\
UPDATE Auction_Categories SET Count = 0, Sub_Count = WHERE Cat_ID=10000\
Line 234, File auction/SQLlib.pm.
I tried to check your installation and it said you are disk over quote, check with your hosting company to give you your full disk space you purchased. Then email me your FTP again ad I'll check your installation.
I just started getting that same error today too.\
\
I know I am not over my diskspace, 200Gigs! The auction still posts but I get that error now everytime I try to sell something.\
\
This wasn't happening to me before today.\
\
After I get this error, I get a timeout page and left at this point:\
\
http://fanatic-fan.com/cgi-bin/auction/auction.cgi
I fixed your error in your "Custom work" order. That was generated because you changed a category partent to 1000 which does not exist using database & SQL commander -> SQL Commander then used this command:
UPDATE Auction_Categories SET Parent=0 WHERE Parent=1000
Iam posting this as a solution for others also who may face this.
Quote
