Welcome Visitor, Please Login or Register Now Tuesday, April 23, 2024 09:01 AM 
Forums Index > Mewsoft Products > Classifiedawy > Posting Ads
New Topic   New Reply
Search for:
Author Message
valleysales valleysales's personal page
Registered Member
Posts: 21 Display member's posts
Joined: 12-02-06 11:18 PM
Location: Australia
Member Offline
View Member's Profile Visit member's website Valley Sales Send private message MSN Messenger: donnaaust@hotmail.com
 
Back to top
Posting Ads Edit Delete Reply with quote Quote
First Post Posted on: 11-22-12 03:03 PM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-23-24 09:01 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: Posting Ads Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 11-22-12 05:22 PM next post previous post
What's that? You did not say any problem.

Mewsoft Support
www.mewsoft.com
valleysales valleysales's personal page
Registered Member
Posts: 21 Display member's posts
Joined: 12-02-06 11:18 PM
Location: Australia
Member Offline
View Member's Profile Visit member's website Valley Sales Send private message MSN Messenger: donnaaust@hotmail.com
 
Back to top
Re: Posting Ads Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 11-23-12 07:29 PM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-23-24 09:01 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: Posting Ads Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 11-24-12 06:46 AM next post previous post
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 valleysales's personal page
Registered Member
Posts: 21 Display member's posts
Joined: 12-02-06 11:18 PM
Location: Australia
Member Offline
View Member's Profile Visit member's website Valley Sales Send private message MSN Messenger: donnaaust@hotmail.com
 
Back to top
Re: Posting Ads Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 11-24-12 09:17 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-23-24 09:01 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: Posting Ads Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 11-24-12 06:19 PM next post previous post

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 valleysales's personal page
Registered Member
Posts: 21 Display member's posts
Joined: 12-02-06 11:18 PM
Location: Australia
Member Offline
View Member's Profile Visit member's website Valley Sales Send private message MSN Messenger: donnaaust@hotmail.com
 
Back to top
error Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 11-25-12 07:24 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-23-24 09:01 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: Posting Ads Edit Delete Reply with quote Quote
Reply #: 7 Posted on: 11-25-12 08:46 AM next post previous post

He's got a Typo:

Auction_Categories

NOT

Action_Categories


Mewsoft Support
www.mewsoft.com
valleysales valleysales's personal page
Registered Member
Posts: 21 Display member's posts
Joined: 12-02-06 11:18 PM
Location: Australia
Member Offline
View Member's Profile Visit member's website Valley Sales Send private message MSN Messenger: donnaaust@hotmail.com
 
Back to top
Re: Posting Ads Edit Delete Reply with quote Quote
Reply #: 8 Posted on: 11-25-12 01:29 PM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-23-24 09:01 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: Posting Ads Edit Delete Reply with quote Quote
Reply #: 9 Posted on: 11-25-12 04:35 PM last post previous post

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
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.3038 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation