Bug report: Expiration date of subscriptions is not changed

[Thomas Becker]

Bug report: Limits (e.g. expiration date) of subscriptions are not changed

This is serious issue!

---------------------------------------------------------------
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE
10.4.4 Update #27, CentOS 6.2 x64

PROBLEM DESCRIPTION
Expiration date of a subscription is not changed.

STEPS TO REPRODUCE
Create a service plan with expiration of 1 month then add it to a subscription. After that create a service plan with expiration of 1 year and change the subscription to use the new service plan with expiration of 1 month.

ACTUAL RESULT
The expiration date is not changed in MySQL table psa --> Limits --> [Limits-ID of domain] --> expiration

EXPECTED RESULT
Expiration date should be changed.

ANY ADDITIONAL INFORMATION
Other users having this problem too.
See also:
http://forum.parallels.com/showthread.php?t=259110
http://forum.parallels.com/showthread.php?t=259179
--------------------------------------------------------------

 

[IgorG]

Thank you for report. I have forwarded it to developers. I will update thread with results of investigation.

 

[Thomas Becker]

Hey guys,
still no fix out!?

We do have to manually edit the limits every time when changing the service plan of a subscription. That causes a lot of trouble. That is a basic function of Plesk and should work all the time, so why do I have to manually edit the limits in the Database?

The expiration date and some other limits are still not changed in PSA database when changing the service plan of a subscription!

Am I the only one with that problem? Please provide an update of the state of that case.

Thanks
Thomas

 

[IgorG]

From Plesk documentation:

To renew an expired subscription:
Go to Subscriptions, and click the <Subscription Name> in the list.
Click Activate.
Click Customize.
On the Resources tab, set up a new expiration date, or select Unlimited.
Click Update & Lock.
Click Unlock & Sync.

As you can see it should be performed manually and it is not necessary to change Service Plan to watch this behaviour. Expiration date will not be changed during Service Plan changing.
This behaviour was changed in Plesk 11. Now after synchronization new expiration date = creation data + expiration period. So, I suggest you upgrade to Plesk 11 if it is critical for you.

 

[Ehsana]

Any update?

When I unlock & sync the subscription, expiration date will changed unfortunately!

 

[Jose AlbertoH]

Script to set all domains to unlimited

Hi, to solve this bug, I use this script (in Plesk 10 on Debian):

vhosts="/var/www/vhosts/"
httpdocs="/httpdocs"
find /var/www/vhosts -type d -wholename "*/httpdocs" | while read file;
do
    domain_temp=${file%$httpdocs}
    domain=${domain_temp#$vhosts}
    /usr/local/psa/bin/subscription_settings -u $domain -expiration -1
done

I hope this can help.

 

[IgorG]

Hi, to solve this bug, I use this script (in Plesk 10 on Debian):

vhosts="/var/www/vhosts/"
httpdocs="/httpdocs"
find /var/www/vhosts -type d -wholename "*/httpdocs" | while read file;
do
    domain_temp=${file%$httpdocs}
    domain=${domain_temp#$vhosts}
    /usr/local/psa/bin/subscription_settings -u $domain -expiration -1
done

I hope this can help.

Other possible script:

for i in `mysql -uadmin -p\`cat /etc/psa/.psa.shadow\` psa -Ns -e "select name from domains"`; do /usr/local/psa/bin/subscription_settings -u $i -expiration -1; done