Welcome Visitor, Please Login or Register Now Thursday, November 30, 2023 10:33 AM 
New Topic   New Reply
Search for:
Author Message
brianm brianm's personal page
Registered Member
Posts: 9 Display member's posts
Joined: 07-23-06 02:59 AM
Member Offline
View Member's Profile Send private message
 
Back to top
SQL Error Edit Delete Reply with quote Quote
First Post Posted on: 03-16-12 04:12 AM next post first post
SQL Error \ 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 'ORDER BY Score DESC, Rank DESC, Price DESC, Title ASC' at line \ Query: \ SELECT ID FROM Links WHERE Score>= ORDER BY Score DESC, Rank DESC, Price DESC, Title ASC\ Line 84, File /home/tiresale/public_html/cgi-bin/dir/Search.pm.\ \ All other functions work including search, account sign up, etc. \ \ Is there an update for this?\ Thank you.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 11-30-23 10:33 AM
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: 03-16-12 09:47 AM next post previous post
The error shows:\ \ WHERE Score>= ORDER\ \ The field is empty Score>= should be numeric value, you need to set these values in your admin center, values for scores.

Mewsoft Support
www.mewsoft.com

brianm brianm's personal page
Registered Member
Posts: 9 Display member's posts
Joined: 07-23-06 02:59 AM
Member Offline
View Member's Profile Send private message
 
Back to top
My SQL error still exists Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 03-18-12 02:36 PM next post previous post
I have tried the values and saved them separately as 0, 1, 2 etc. in my admin panel under 'Engine Control' and next to heading 'Default Score' and 'Default Rank' but still receive same SQL error. \ Am I in the correct area?\ Is there a way to reupload this table?\ Thank you.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 11-30-23 10:33 AM
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: 03-18-12 08:11 PM last post previous post
If it is only one site or so you can delete it. However this error is setting error not a database contents error. Can you post a URL to this error?.

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