Is it OK to update a listing expire_date via SQL on the database

This topic contains 4 replies, has 3 voices, and was last updated by  adriangraham 9 years, 8 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • January 21, 2015 at 3:49 pm #28298

    adriangraham
    Expired Member
    Post count: 426

    Hi guys,

    Is it OK to update a listing/advert’s “expire_date” field via SQL on the database. Reason I ask as I remember some time back there was an issue about changing this date (perhaps in the admin panel) and then the subsequent renewal?

    I am wondering if I update it in the database directly will the auto-renewal email etc etc all still work ok?

    Reason I ask is that I have about 30 to do and DB is faster

    Adrian

    January 21, 2015 at 3:54 pm #28299

    Simone
    Expired Member
    Post count: 3515

    It “should” be ok as long as you maintain the same date-format in sql..Asking for a confirm by the wizard (Stiofan), notified

    January 21, 2015 at 3:58 pm #28303

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    should be fine (but not tested)

    Stiofan

    January 21, 2015 at 4:03 pm #28304

    Simone
    Expired Member
    Post count: 3515

    Tested now, and it works.

    January 21, 2015 at 4:13 pm #28306

    adriangraham
    Expired Member
    Post count: 426

    Thanks guys, great to know!

    It’s only a date right? Listings don’t have a date AND time of expiry?

    Adrian

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount