Renewal Question

[Bucketman]

I have set most of my listings to 60 day expiration and some are getting close to end of life. A few users have emailed me saying they've received an email saying the ads about to expire, please visit and renew the ad (all good - that's working as it should).

However, all are saying that when they log into the site, go to modify an ad, then click on the 'click here to renew' option for the ad, it takes them to verify ad info screen, then the verify user info screen, then back to the modify ad screen, with 'click here to renew' still there as an option - as if nothing has happened.

I have tested this myself and yes, I get the same thing and ads are not being renewed - they still show the same expiry date after going through the renew process.

I'm running version 3.014 on my site - is there any known issues. I remember reading some posts before the fateful crash day about people with renew problems.

Any ideas - as a workaround I'm having to go into Admin and manually change the expiry date, but would be better if the renew process was working - especially if I will soon be charging for it.

[Eric Barnes]

Ashley,

I just tested this and it does appear to be a bug. If you would open the file userrenew.php and locate this around line 57:

PHP Code:

//verify the package details
$sSQL="SELECT oPackageID,oTotal,oDiscount,pBold,pHighlighted,featured FROM ".PREFIX."orders LEFT JOIN ".PREFIX."products ON oProductID=id WHERE id=".$lid; 


Then change to:

PHP Code:

//verify the package details
$sSQL="SELECT oPackageID,oTotal,oDiscount,pBold,pHighlighted,featured FROM ".PREFIX."orders LEFT JOIN ".PREFIX."products ON oProductID=id WHERE id=".$listingid; 


Basically all that is different is id=".$lid becomes id=".$listingid

[Bucketman]

changed that line (it was at line 139 in my userrenew.php file) but hasn't made any difference.

Any other ideas ????

I have attached my userrenew.php file for reference -

[Chaslie]

I'm running version 3.014 on my site - is there any known issues. I remember reading some posts before the fateful crash day about people with renew problems.

Yes I was experiencing those problems - was around v3.0.9/10

[Chaslie]

Ashley,
Go to administration > browse listings.

Can you see any 'listing doubles' - the original listing status may be 'active' and you may have a duplicate of the original listing (after is was renewed) with a status of 'not completed'.

Can you confirm/deny you are seeing the above please?

This is what I am experiencing - didn't notice it until just now. However the expire date (after renewal) of the 'original listing' has transferred OK - it's just that there are doubles of renewed listing in admin with a status of 'not completed'.

[Chaslie]

Ashley,
Go to administration > browse listings.

Can you see any 'listing doubles' - the original listing status may be 'active' and you may have a duplicate of the original listing (after is was renewed) with a status of 'not completed'.

Can you confirm/deny you are seeing the above please?

This is what I am experiencing - didn't notice it until just now. However the expire date (after renewal) of the 'original listing' has transferred OK - it's just that there are doubles of renewed listing in admin with a status of 'not completed'.

[Bucketman]

I have just confirmed by going into my Admin area and clicking on Browse Listings. There is definately no double listings. The one listing I am trying to renew just shows as expiring on 26th april - as it always has.

[Eric Barnes]

I will have to double check your file against the latest tommorow. However in the mean time what payment provider are you using? I am not sure if that would make a difference but it could.

[civ]

Ouch, this appears to be happening with .15 as well. I'm glad someone caught this!

[Bucketman]

Sorry to throw this in the mix but all Ads on my Site are free up until end of May - that's why I want to get it sorted out before people start paying for ads. So to confirm there is no charge at present for any ads - all listing packages are FREE.

It appears it doesn't go through to the verfiy listing package screen. Just goes from Verify account details then back to browse listings.