| hara |
First Post Posted on: 11-23-12 07:55 AM |
| Ads Mangers error after changing... |
|
| 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 |
Reply #: 1 Posted on: 11-23-12 08:06 AM |
| Re: Ads Mangers error after changing... |
|
| It means you set the parnet ID to none existant category number, restore your database or categories tables. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| hara |
Reply #: 2 Posted on: 11-26-12 02:45 AM |
| Re: Ads Mangers error after changing... |
|
| 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 |
Reply #: 3 Posted on: 11-26-12 04:41 PM |
| Re: Ads Mangers error after changing... |
|
|
|
|
| hara |
Reply #: 4 Posted on: 11-27-12 02:02 AM |
| Re: Ads Mangers error after changing... |
|
| I followed this topic and even updated SQLlib.pm, still same error.\
\
Please help at your earlier convinience.\
\
Thanks! |
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 11-27-12 05:49 AM |
| Re: Ads Mangers error after changing... |
|
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 |
Reply #: 6 Posted on: 12-02-12 03:04 AM |
| Re: Ads Mangers error after changing... |
|
| 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 |
Reply #: 7 Posted on: 12-02-12 03:29 AM |
| Re: Ads Mangers error after changing... |
|
|
|
|
| hara |
Reply #: 8 Posted on: 12-02-12 11:07 AM |
| Re: Ads Mangers error after changing... |
|
| PROBLEM FIXED. THANK YOU VERY MUCH! |
|
|
|
|
|
|
