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

Created:

2016-11-16 12:45:45 UTC

Modified:

2017-04-24 12:12:34 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Web Presence Builder 11.5 for Linux

Symptoms

  • Trials sites cannot be deleted if trial time is set to 24 hours in Web Presence Builder:

    # grep trial /usr/local/sb/config
    trial_site_life_time = 86400
  • There are many not deleted trials websites in Web Presence Builder database:

    mysql> select site.creation_date, site.state, site.is_published, site_version.finish_date from site inner join site_version on site.id= 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)

Cause

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 ".

Resolution

Such behavior was fixed in Web Presence Builder 12.0. Please upgrade WPB.

Have more questions? Submit a request
Please sign in to leave a comment.