English
Chinese
French
German
Italian
Japanese
Russian
Spanish
Subscriptions
RSS feedsResolution
1. Find a page set id in the HSPcomplete database.2. Using the MySQL shell command, add a page set to a Sitebuilder plan.
3. Synchronize this plan with Sitebuilder node.
A page set id can be found using following MySQL command:
mysql> SELECT sb_node.id as 'Node ID',sb_account.name as 'Account Name', sb_pageset.id as 'Page Set ID', sb_pageset.code, sb_pageset.title FROM sb_pageset LEFT JOIN sb_pageset_license ON sb_pageset_license.pageset_id=sb_pageset.id LEFT JOIN sb_license ON sb_pageset_license.lic_id=sb_license.id LEFT JOIN sb_account ON sb_license.acc_id = sb_account.id LEFT JOIN sb_node ON sb_account.node_id=sb_node.id;
+--------+-------+---------+-----------------+------------------+
| NodeID |Account|PageSetID| code | title |
+--------+-------+---------+-----------------+------------------+
| 1 | admin | 1 | Home | Personal Page |
| 1 | admin | 2 | Business | Business |
| 1 | admin | 3 | ServiceBusiness | Service Business |
| 1 | admin | 4 | Blog | Blog |
| 1 | admin | 5 | PhotoGallery | Photogallery |
| 1 | admin | 6 | Minimal | Basic |
+--------+-------+---------+-----------------+------------------+In MySQL command shell, run the following SQL command to add a page set to a sitebuilder plan:
mysql> use aspc;
mysql> INSERT INTO sb_plan_pageset VALUES(<pageset_id>, <plan_id>);where
* <plan_id> - Sitebuilder plan id,
* <pageset_id> - page set id.
After this, synchronize the sitebuilder plan:
1. Log in to PCC.
2. Go to Service Director > SiteBuilder Manager > Plans.
3. Select the Sitebuilder plan.
4. Select the "Nodes" tab.
5. Select nodes to be synchronized and then click the "Synchronize" button.
For example, if you want to use "Business" and "PhotoGallery" page sets in the Sitebuilder plan with id #1 you should run the following MySQL commands:
mysql> use aspc;
mysql> INSERT INTO sb_plan_pageset VALUES(2, 1);
mysql> INSERT INTO sb_plan_pageset VALUES(5, 1);Keywords: pageset