Welcome Visitor, Please Login or Register Now |
|
Saturday, July 27, 2024 04:26 AM |
![](http://www.mewsoft.com/forums//theme/Default/dot.gif) |
brianm ![brianm's personal page](http://www.mewsoft.com/forums//theme/Default/aboutme.gif) |
Registered Member |
Posts: 9 ![Display member's posts](http://www.mewsoft.com/forums//theme/Default/searchauthor.gif) |
Joined: 07-23-06 02:59 AM |
|
|
|
![Member Offline](http://www.mewsoft.com/forums//theme/Default/offline.gif) |
|
|
|
![Back to top](http://www.mewsoft.com/forums//theme/Default/top.gif) |
|
SQL Error |
Edit Delete Quote |
First Post Posted on: 03-16-12 04:12 AM |
![first post](http://www.mewsoft.com/forums//theme/Default/up-disabled.gif) |
|
|
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](http://www.mewsoft.com/forums//theme/Default/aboutme.gif) |
Administrator Team Member |
Posts: 5381 ![Display member's posts](http://www.mewsoft.com/forums//theme/Default/searchauthor.gif) |
Joined: 07-27-24 04:26 AM |
Location: knxoville, TN, USA |
![](http://www.mewsoft.com/forums//avatars/mewsoft.png) |
|
![Member Offline](http://www.mewsoft.com/forums//theme/Default/offline.gif) |
![MSN Messenger: MSN](http://www.mewsoft.com/forums//theme/Default/msn.gif) |
|
|
![Back to top](http://www.mewsoft.com/forums//theme/Default/top.gif) |
|
|
brianm ![brianm's personal page](http://www.mewsoft.com/forums//theme/Default/aboutme.gif) |
Registered Member |
Posts: 9 ![Display member's posts](http://www.mewsoft.com/forums//theme/Default/searchauthor.gif) |
Joined: 07-23-06 02:59 AM |
|
|
|
![Member Offline](http://www.mewsoft.com/forums//theme/Default/offline.gif) |
|
|
|
![Back to top](http://www.mewsoft.com/forums//theme/Default/top.gif) |
|
My SQL error still exists |
Edit Delete Quote |
Reply #: 2 Posted on: 03-18-12 02:36 PM |
![previous post](http://www.mewsoft.com/forums//theme/Default/up.gif) |
|
|
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](http://www.mewsoft.com/forums//theme/Default/aboutme.gif) |
Administrator Team Member |
Posts: 5381 ![Display member's posts](http://www.mewsoft.com/forums//theme/Default/searchauthor.gif) |
Joined: 07-27-24 04:26 AM |
Location: knxoville, TN, USA |
![](http://www.mewsoft.com/forums//avatars/mewsoft.png) |
|
![Member Offline](http://www.mewsoft.com/forums//theme/Default/offline.gif) |
![MSN Messenger: MSN](http://www.mewsoft.com/forums//theme/Default/msn.gif) |
|
|
![Back to top](http://www.mewsoft.com/forums//theme/Default/top.gif) |
|
|
|
|
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.2031 Seconds |
|