Article ID: 3521, created on Dec 24, 2007, last review on Apr 18, 2012

  • Applies to:
  • Odin Business Automation Standard 3.3

Resolution

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);

b91f0e51a581aafeed4e0834068081e0 400e18f6ede9f8be5575a475d2d6b0a6 95c731ef6bb58e30865e046f2135d4c1 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF