Welcome Visitor, Please Login or Register Now Sunday, December 17, 2017 03:57 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: 02-10-12 04:17 PM 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.

Thanks,

ecisme

mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-17-17 03:57 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: 02-10-12 04:40 PM last post previous post
Do fresh install of the latest version. You need always to apply upgrades once released.

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