Welcome Visitor, Please Login or Register Now Sunday, September 19, 2021 10:33 PM 
New Topic   New Reply
Search for:
Author Message
hoverfly hoverfly's personal page
Registered Member
Posts: 2 Display member's posts
Joined: 03-04-07 12:32 AM
Member Offline
View Member's Profile Visit member's website http:// Send private message
 
Back to top
sql error Edit Delete Reply with quote Quote
First Post Posted on: 09-11-10 05:59 PM next post first post
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.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 09-19-21 10:33 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 09-12-10 12:22 AM next post previous post

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.

Thanks


Mewsoft Support
www.mewsoft.com

josephdaigle josephdaigle's personal page
Registered Member
Posts: 36 Display member's posts
Joined: 03-16-07 03:39 PM
Member Offline
View Member's Profile Send private message
 
Back to top
I get the same error Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 09-24-10 11:32 PM next post previous post
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
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 09-19-21 10:33 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 09-25-10 10:36 AM last post previous post

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.


Mewsoft Support
www.mewsoft.com

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print