Available article translations:

Trial sites in Web Presence Builder are no deleted after the end of trial time


Trial time is set to 24 hours in my Parallels Web Presence Builder:

~# grep trial /usr/local/sb/config

trial_site_life_time = 86400

But old trial sites still exists, they are not deleted. There are still many of them in the database of Parallels Web Presence Builder:

mysql> select site.creation_date, site.state, site.is_published, site_version.finish_date from site inner join site_version on site_version.site_id where site.state=0;

| creation_date             | state | is_published | finish_date         |
| 2013-06-27T12:49:15-04:00 |     0 |         NULL | 2013-11-09 06:56:53 |
| 2013-07-29T15:59:07-04:00 |     0 |         NULL | 2013-11-09 06:59:28 |
| 2013-09-19T16:18:13-04:00 |     0 |         NULL | 2013-11-09 07:02:31 |
| 2013-07-17T11:41:11-04:00 |     0 |         NULL | 2013-11-09 06:58:30 |
| 2013-11-09T12:18:41-05:00 |     0 |         NULL | 2013-11-09 12:18:41 |

mysql> select count(*) from site where site.state=0;

| count(*) |
|   140581 |
1 row in set (0.00 sec)

Why trial sites are not deleted?


Web Presence Builder's action "deleting trial sites" works, but it has limits, i.e. "time to remove trial sites" and "how many sites remove in one attempt".

Such behavior is considered to be a software issue. The fix will be included in future Parallels Web Presence Builder updates released after 11.5. You can track it using the following ID:

PPPM-1322 - Trial sites in Web Presence Builder are no deleted after end of trial time

Hotfix for Parallels Web Presence Builder 11.5

Install the fix to your edition of Parallels Web Presence Builder. Download the file for your WPB version:

Install the fix:

~# tar -zcf PPPM-1322_<verison>.tar.gz -C %wpb_root_dir%

Where %wpb_root_dir% is the directory where Parallels Web Presence builder is installed, for example "/usr/local/sb" on Plesk server.

Add the following options into configuration file /usr/local/sb/config and put proper values, e.i:

daily_maintenance_scheduler_delta = 600    # how often to run deleting
trial_site_remove_per_request = 300    # how many trial sites to delete 

Note: if there are many trial sites (more then 1000), it's a good idea to delete them from the database manually. Contact Parallels Support to remove trial sites from the database.

Related Articles

Trial (Try and Buy) Mode for Presence Builder

Was this article helpful?
Tell us how we may improve it.
Yes No