Support Forums

bowers01 + · 05-05-2010, 10:10 AM

What version of 68 Classifieds are you running?
Example: V4.1.1 Developerr

Please describe in detail the issue you are having:
Hi,
I have deleted my packages a while ago and now anyone with a older listing can not modify it.
I started a thread about this back in 2009 but it has been locked. Eric said he was looking at making a default package for if the package gets deleted, is this in the works?
Is there any way to fix this? Can i change the package on the listing though phpmyadmin? Is so what query do i need to run?
Cheers,
Nick

Eric Barnes · 05-05-2010, 10:39 AM

Something like this will work. !!!PLEASE BACKUP FIRST!!!

Code:

UPDATE prefix_orders SET oProductID=2 WHERE oProductID = 1;

Where "2" is the new product id and "1" is the old id.

05-05-2010, 10:10 AM	#1
bowers01 + Genius At Work Join Date: May 2008 Location: Geelong, Victoria, Australia Posts: 1,089 Rep Power: 37	Deleted a package now cant change listings What version of 68 Classifieds are you running? Example: V4.1.1 Developerr Please describe in detail the issue you are having: Hi, I have deleted my packages a while ago and now anyone with a older listing can not modify it. I started a thread about this back in 2009 but it has been locked. Eric said he was looking at making a default package for if the package gets deleted, is this in the works? Is there any way to fix this? Can i change the package on the listing though phpmyadmin? Is so what query do i need to run? Cheers, Nick __________________ Nick Bowers 68c v4.1.10 Developer Custom Template

05-05-2010, 10:39 AM	#2
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,489 Rep Power: 136	Something like this will work. !!!PLEASE BACKUP FIRST!!! Code: UPDATE prefix_orders SET oProductID=2 WHERE oProductID = 1; Where "2" is the new product id and "1" is the old id. __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleted a package now cant change listings	bowers01	Technical Support	6	10-29-2009 06:18 PM
Show deleted listings, how?	Isje	Technical Support	4	08-31-2009 04:02 PM
Please help, all listings deleted!	nomaxal	Technical Support	2	05-11-2009 11:52 AM
Change package of order	nickhaughton	Technical Support	8	11-03-2008 08:11 PM

Support Forums

Deleted a package now cant change listings