Expired Listings

[Mark Brindley]

Hello,

 

Today I had 180+ listings expire.

This was an error on my side because I set the incorrect expiry date when I first set up the listings.

 

I needed to get them all back online ASAP and tried to simply mark them in the #paid_order table as active

 

order_expires: 0000-00-00

order_never_expires: 1

order_active: 1

 

I also changed these values in the #_content table

 

state: 1

publish_down: 0000-00-00 00:00:00

 

Sadly none of the order came back online.

 

I now have to go into Paid Listing - open the order - set Order Active to No - save - reopen the item and set Order Active Yes, clear the cache and then the listing is visible on the frontend of the site.

 

What step / location am I missing in the database - to do each one will just take far too much time.

Is there a simpler way to do this?

 

Maybe a batch process option for admin could be an option in a future release.

[Alejandro]

This section is only visible with a valid subscription. If you have a valid subscription, please login.

[Mark Brindley]

This section is only visible with a valid subscription. If you have a valid subscription, please login.

[Alejandro]

This section is only visible with a valid subscription. If you have a valid subscription, please login.