Article ID: 121761, created on May 26, 2014, last review on May 26, 2014

Symptoms

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

Resolution

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" 

Search Words

find what sites were created in Web Presence Builder

not published sites

Email subscription for changes to this article
Save as PDF