| valleysales |
First Post Posted on: 11-22-12 03:03 PM |
| Posting Ads |
|
| Can you please explain what this means and what I need to fix the problem....It happens each time I go to place an Ad\
Thank you so much\
Valley sales |
|
|
|
|
|
| mewsoft |
Reply #: 1 Posted on: 11-22-12 05:22 PM |
| Re: Posting Ads |
|
|
|
|
| valleysales |
Reply #: 2 Posted on: 11-23-12 07:29 PM |
| Re: Posting Ads |
|
| 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 Cat_ID=420' at line 1\
Query: \
UPDATE Ads_Categories SET Count=0, Sub_Count= WHERE Cat_ID=420\
Line 258, File /home/donna/public_html/cgi-bin/classified/SQLlib.pm.\
\
PLEASE HELP ASAP..... I would be so grateful, its happening to my customers posting ads too |
|
|
|
|
|
| mewsoft |
Reply #: 3 Posted on: 11-24-12 06:46 AM |
| Re: Posting Ads |
|
| You seems changed some category's Parent ID to none existant one, Try updating the file SQLlib.pm to the latest one it will try to skip it. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| valleysales |
Reply #: 4 Posted on: 11-24-12 09:17 AM |
| Re: Posting Ads |
|
| Sorry to bother you again but we downloaded latest SQL lib from installed it and still getting the same error\
\
Is there anything else you can suggest anything as this is very critical...\
\
Thank you warmest regards\
Valley Sales |
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 11-24-12 06:19 PM |
| Re: Posting Ads |
|
First, Backup your database, then: Admin -> Database & SQL Manager -> SQL Commander, then enter and run this command: UPDATE Auction_Categories SET Parent=0 WHERE Parent=420 It may fix, if not, then this has to be tracked manually by the sql commands |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| valleysales |
Reply #: 6 Posted on: 11-25-12 07:24 AM |
| error |
|
| Dear Ahmed,\
I apologise for asking more questions about the same topic, but I had my web designer look at your response\
This is what he wrote\
\
Donna\
tried what ahmed said\
Backed up then ran sql script got this\
\
SQL Error: Table 'donna_class.Action_Categories' doesn't exist\
Query:\
UPDATE Action_Categories SET Parent=0 WHERE Parent=420\
Line 745, File /home/donna/public_html/cgi-bin/classified/DatabaseMgr.pm.\
\
Have to ask what to do now...\
Have a nice day\
Rod\
\
REALLY HOPE YOU CAN GIVE US ANOTHER SOLUTION\
\
Warmest regards, Awaiting your answer\
Valley Sales |
|
|
|
|
|
| mewsoft |
Reply #: 7 Posted on: 11-25-12 08:46 AM |
| Re: Posting Ads |
|
He's got a Typo: Auction_Categories NOT Action_Categories |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| valleysales |
Reply #: 8 Posted on: 11-25-12 01:29 PM |
| Re: Posting Ads |
|
| Sorry Ahmed\
\
there was a mistake in my line\
this is the error\
\
SQL Error: Table 'donna_class.Auction_Categories' doesn't exist\
Query:\
UPDATE Auction_Categories SET Parent=0 WHERE Parent=420\
Line 745, File /home/donna/public_html/cgi-bin/classified/DatabaseMgr.pm.\
\
He realised the mistake and tried the other, \
\
We are at that stage now....PLEASE HELP !!! \
We are open to any of your suggestions or Advice in anyway...as you are a master of this program..\
\
We Thank you so much\
The team at Valley Sales\
\
Rod |
|
|
|
|
|
| mewsoft |
Reply #: 9 Posted on: 11-25-12 04:35 PM |
| Re: Posting Ads |
|
I posted this as a general for all products but he must be able to distingush what product he is doing, anyway, for the classifieds, it should be: Ads_Categories So, it is : UPDATE Ads_Categories SET Parent=0 WHERE Parent=420 |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|
