Welcome Visitor, Please Login or Register Now Saturday, March 17, 2018 02:18 PM 
New Topic   New Reply
Search for:
Author Message
ecisme ecisme's personal page
Registered Member
Posts: 11 Display member's posts
Joined: 11-10-05 01:49 PM
Member Offline
View Member's Profile Send private message
Back to top
Help SQL Error Edit Delete Reply with quote Quote
First Post Posted on: 04-20-12 11:26 AM next post first post

I upgraded my version of Classifiedawy to the newest version. After successfully installing the software to my server, using the Auto Installer, I now get the following SQL error when I try to access my site.

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 Parent=0 0 ORDER BY Sort ASC' at line 1 Query: SELECT Cat_ID FROM WHERE Parent=0 0 ORDER BY Sort ASC Line 179, File /home/azclass/public_html/cgi-bin/classified/CategoriesLib.pm.

Can someone please help to resolve this issue.



mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-17-18 02:18 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: Help SQL Error Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 04-20-12 11:49 AM last post previous post
Do fresh install of the latest version. You need always to apply upgrades once released.

Mewsoft Support

Page 1 of 1
Go to page:

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