Change domain validity from a period to unlimited

[tvengel]

Hello,

I have hundreds of domains on my plesk server, all configured with a validity period. I think I will be more easy for me to lock the domain status in case an invoice would not be paid on time.
Is there an sql-query to change all domains configured with a validity period to unlimited? At this moment it is a huge job to check all domains one per one.

Regards,
Tim Van Engeland

 

[Amin Taheri]

I am not sure if this is exactly what you need, so make a DB backup first.

update Limits set value = '-1' where 'limit_name' = 'expiration';

This will update all of the values in the Limits table where the limit_name is expiration, setting it to -1 (unlimited)

This should also then not need any further updates to the domains or clients tables as each is tied to a limit ID in the Limits table.

Let me know if that works