Welcome Visitor, Please Login or Register Now Thursday, April 18, 2024 05:03 AM 
Forums Index > Mewsoft Products > Classifiedawy > Ads Mangers error after changing...
New Topic   New Reply
Search for:
Author Message
hara hara's personal page
Registered Member
Posts: 144 Display member's posts
Joined: 10-26-05 03:19 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Ads Mangers error after changing... Edit Delete Reply with quote Quote
First Post Posted on: 11-23-12 07:55 AM next post first post
Dear Sir,\ \ Unaccessable on Admin>>Ads Manager after changing a Parnet Category ID. Always get the following error masseage:\ \ 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 'AND Lang='Chinese')' at line 1\ Query: \ SELECT Name FROM Ads_Categories_Name WHERE (Cat_ID= AND Lang='Chinese')\ Line 1273, File /home/xxxx/public_html/classifieds/cgi-bin/ads/SQLlib.pm.\ \ Could you please advise where I can fix it? Because this is first time relate to SQL, I want to get advises from you where is SQL syntax and to avoid SQL crash by any uncorrect action.\ \ Thanks!
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 05:03 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: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 11-23-12 08:06 AM next post previous post
It means you set the parnet ID to none existant category number, restore your database or categories tables.

Mewsoft Support
www.mewsoft.com
hara hara's personal page
Registered Member
Posts: 144 Display member's posts
Joined: 10-26-05 03:19 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 11-26-12 02:45 AM next post previous post
Sorry to bother you again. I tried to restore the database but did not resolve the error.\ \ Could you advise any other way could resolve it?\ \ Could you advise where to restore categories tables?\ Admin>Database & SQL Manager>?
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 05:03 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: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 11-26-12 04:41 PM next post previous post

See this topic it may help you:

http://mewsoft.com/cgi-bin/forum/forum.cgi?action=ViewTopic&Topic=2233&Forum=3&Page=1&Period=0a&Lang=English


Mewsoft Support
www.mewsoft.com
hara hara's personal page
Registered Member
Posts: 144 Display member's posts
Joined: 10-26-05 03:19 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 11-27-12 02:02 AM next post previous post
I followed this topic and even updated SQLlib.pm, still same error.\ \ Please help at your earlier convinience.\ \ Thanks!
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 05:03 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: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 11-27-12 05:49 AM next post previous post

I have no other other clues but you have to reverse what you did wrong using SQL commands, you can unload (backup ) the categories tables, edit them manually using any text editor to remove the category you messed up then load the tables again. Remember you should replace the category number in the topic you followed by the category number issuing your error.


Mewsoft Support
www.mewsoft.com
hara hara's personal page
Registered Member
Posts: 144 Display member's posts
Joined: 10-26-05 03:19 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 12-02-12 03:04 AM next post previous post
I unloaded the table of Ad_categories, found and corrected the wrong SQL commond from Ad_Categories.sql.pm on server file. \ \ Next step I need to load it from Amin>Load/Unload SQL Tables, is that right? \ \ I want to make sure before I do load this. because I don't want to loose something uncoverable.\ \ Your help would be appreciated.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 05:03 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: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 7 Posted on: 12-02-12 03:29 AM next post previous post
Correct.

Mewsoft Support
www.mewsoft.com
hara hara's personal page
Registered Member
Posts: 144 Display member's posts
Joined: 10-26-05 03:19 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Ads Mangers error after changing... Edit Delete Reply with quote Quote
Reply #: 8 Posted on: 12-02-12 11:07 AM last post previous post
PROBLEM FIXED. THANK YOU VERY MUCH!
Page 1 of 1
Go to page:

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

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.2435 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation