How to find what sites were created in Web Presence Builder but were not published?

Created:

2016-11-16 13:08:57 UTC

Modified:

2017-08-16 16:43:56 UTC

2

Was this article helpful?


Have more questions?

Submit a request

How to find what sites were created in Web Presence Builder but were not published?

Applicable to:

  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • Web Presence Builder for Linux

Question

How to find what sites were created in Web Presence Builder but were not published yet?

Answer

The is_published field of the site table of sitebuilder database is used to determine if site is published.

To find name and corresponding uuis of active sites that were already published in Web Presence Builder the following query can be used:

# sitebuilderdb=`grep dbname /usr/local/sb/config | awk -F" = " '{print $2}'`
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select d.name as 'Plesk Domain', s.uuid as 'Site uuid' from psa.domains d, psa.dom_param dp, "$sitebuilderdb.site" s where d.id=dp.dom_id and dp.param='site_builder_site_id' and s.uuid=dp.val and s.is_published is not null and d.status=0"

The 'active site' means that the site is in active state in Plesk Panel (and so has status=0 in the psa.domains table).

The ones that were not yet published can be found by specifying site.is_published = 0 :

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select d.name as 'Plesk Domain', s.uuid as 'Site uuid' from psa.domains d, psa.dom_param dp, "$sitebuilderdb.site" s where d.id=dp.dom_id and dp.param='site_builder_site_id' and s.uuid=dp.val and s.is_published =0 and d.status=0"
Have more questions? Submit a request
Please sign in to leave a comment.