Troubleshooting: Error gets displayed for all new templates in upgraded db environment for Page Composer.
Several new templates and widgets are added to Page Composer version 9.1.9.0.
Problem
If you have an existing store which was configured to use Page Composer prior to HCL Commerce version 9.1.9.0, you will need to configure your store to recognize these new templates and widgets. If you attempt to select a new template or widget without configuring your store, you will see a message indicating that the widget does not exist.
Solution
Additional layout templates and widgets' definitions are added for the React base
store Page Composer tool in version 9.1.9.0 compared to version 9.1.8.0.
PLWIDGETDEFINITON_ID | Page name |
---|---|
-8005 | Cart page |
-8006 | Checkout page |
-8007 | Order confirmation page |
-8008 | Bundle page |
-8514 | Bundle widget |
-8515 | Content carousel widget |
- In order to make layout templates and widgets available in Management Center for store, run the following SQL to add widget
subscriptions for those Widget Definitions.
INSERT INTO PLSTOREWIDGET (PLSTOREWIDGET_ID, STOREENT_ID, PLWIDGETDEF_ID, STATE) VALUES (UNIQUE_PLSTOREWIDGET_ID, STOREFRONTASSETSTORE_ID, -8005, 1); INSERT INTO PLSTOREWIDGET (PLSTOREWIDGET_ID, STOREENT_ID, PLWIDGETDEF_ID, STATE) VALUES (UNIQUE_PLSTOREWIDGET_ID, STOREFRONTASSETSTORE_ID, -8006, 1); INSERT INTO PLSTOREWIDGET (PLSTOREWIDGET_ID, STOREENT_ID, PLWIDGETDEF_ID, STATE) VALUES (UNIQUE_PLSTOREWIDGET_ID, STOREFRONTASSETSTORE_ID, -8007, 1); INSERT INTO PLSTOREWIDGET (PLSTOREWIDGET_ID, STOREENT_ID, PLWIDGETDEF_ID, STATE) VALUES (UNIQUE_PLSTOREWIDGET_ID, STOREFRONTASSETSTORE_ID, -8008, 1); INSERT INTO PLSTOREWIDGET (PLSTOREWIDGET_ID, STOREENT_ID, PLWIDGETDEF_ID, STATE) VALUES (UNIQUE_PLSTOREWIDGET_ID, STOREFRONTASSETSTORE_ID, -8514, 1); INSERT INTO PLSTOREWIDGET (PLSTOREWIDGET_ID, STOREENT_ID, PLWIDGETDEF_ID, STATE) VALUES (UNIQUE_PLSTOREWIDGET_ID, STOREFRONTASSETSTORE_ID, -8515, 1);
- Replace
UNIQUE_PLSTOREWIDGET_ID:
with an integer value of your choice, that is the unique primary key of PLSTOREWIDGET table. For example, 9999. - Replace
STOREFRONTASSETSTORE_ID:
with theStorefrontAssetStore ID
of your store. This can be found in theSTOREENT
table. For OOTB Emerald Store front asset store EmeraldSAS, it is 12501.
There are additional Content pages and SEO definitions added in the HCL Commerce version 9.1.9.0 for React-based store. These pages are
CartPage, CheckOutPage, and
OrderConfirmationPage. If you are upgrading from HCL Commerce version 9.1.8.0, in order to be able to modify the widgets
assignment for those pages using the Page Composer tool, run the below SQLs to add
definitions into the HCL Commerce version 9.1.9.0 database for your
store.
- For Cart page
- Insert into PLPAGE
(PLPAGE_ID,ADMINNAME,MEMBER_ID,STOREENT_ID,PAGELAYOUTTYPE_ID,DELETABLE,ADMINNAMEEDITABLE,URLCONFIGURABLE,OPTCOUNTER)
values.({CART_PAGE_UNIQUEID},'CartPage',STOREFRONTASSETSTORE_MEMBER_ID,{STOREFRONTASSETSTORE_ID},'Content',0,0,0,1);
- Insert into SEOPAGEDEF
(SEOPAGEDEF_ID,PAGENAME,STOREENT_ID,LASTUPDATE,CREATEDTIME,OPTCOUNTER)
values.(CART_PAGE_SEOPAGEDEF_UNIQUEID,'Content_CART_PAGE_UNIQUEID',STOREFRONTASSETSTORE_MEMBER_ID,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
- Insert into SEOPAGEDEFDESC
(SEOPAGEDEF_ID,LANGUAGE_ID,TITLE,META_DESC,META_KEYWORD,IMAGE_ALT_DESC,LASTUPDATE,CREATEDTIME,OPTCOUNTER)
values.(CART_PAGE_SEOPAGEDEF_UNIQUEID,-1,'<seo: StoreName/>|Cart','<seo: StoreName/> shopping cart','<seo: StoreName/>','Image for <seo: StoreName/> cart page',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
- Insert into SEOPAGEDEFOVR
(SEOPAGEDEFOVR_ID, SEOPAGEDEF_ID, APPLY_TO_CHILD, OBJECTTYPE, OBJECT_ID, OPTCOUNTER)
values.(CART_PAGE_SEOPAGEDEFOVR_UNIQUEID, {CART_PAGE_SEOPAGEDEF_UNIQUEID}, 1, 'Content', 'CART_PAGE_UNIQUEID', 1);
- Insert into SEOURL
(SEOURL_ID,TOKENNAME,TOKENVALUE,OPTCOUNTER)
values.({CART_PAGE_SEOURL_UNIQUEID},'StaticPagesToken','{CART_PAGE_UNIQUEID}',1);
- Insert into SEOURLKEYWORD
(SEOURLKEYWORD_ID,SEOURL_ID,LANGUAGE_ID,STOREENT_ID,URLKEYWORD,STATUS,OPTCOUNTER)
values.({CART_PAGE_SEOURLKEYWORD_UNIQUEID},{CART_PAGE_SEOURL_UNIQUEID},-1,STOREFRONTASSETSTORE_ID,'cart',1,1);
- Insert into PLPAGE
- For Checkout page
- Insert into PLPAGE
(PLPAGE_ID,ADMINNAME,MEMBER_ID,STOREENT_ID,PAGELAYOUTTYPE_ID,DELETABLE,ADMINNAMEEDITABLE,URLCONFIGURABLE,OPTCOUNTER)
values.(-7000,'checkoutPage',7000000000000004501,13001,'Content',0,0,0,1);
- Insert into SEOPAGEDEF
(SEOPAGEDEF_ID,PAGENAME,STOREENT_ID,LASTUPDATE,CREATEDTIME,OPTCOUNTER)
values.(CHECKOUT_PAGE_SEOPAGEDEF_UNIQUEID,'Content_CHECKOUT_PAGE_UNIQUEID',STOREFRONTASSETSTORE_MEMBER_ID,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
- Insert into SEOPAGEDEFDESC
(SEOPAGEDEF_ID,LANGUAGE_ID,TITLE,META_DESC,META_KEYWORD,IMAGE_ALT_DESC,LASTUPDATE,CREATEDTIME,OPTCOUNTER)
values.({CHECKOUT_PAGE_SEOPAGEDEF_UniqueID},-1,'<seo: StoreName/>|checkout','<seo: StoreName/> checkout','<seo: StoreName/>','Image for <seo: StoreName/> checkout page',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
- Insert into SEOPAGEDEFOVR
(SEOPAGEDEFOVR_ID, SEOPAGEDEF_ID, APPLY_TO_CHILD, OBJECTTYPE, OBJECT_ID, OPTCOUNTER)
values.({CHECKOUT_PAGE_SEOPAGEDEFOVR_UniqueID}, {CHECKOUT_PAGE_SEOPAGEDEF_UniqueID}, 1, 'Content', '{CHECKOUT_PAGE_UniqueId}', 1);
- Insert into SEOURL
(SEOURL_ID,TOKENNAME,TOKENVALUE,OPTCOUNTER)
values.({CHECKOUT_PAGE_SEOURL_UniqueID},'StaticPagesToken','{CHECKOUT_PAGE_UniqueId}',1);
- Insert into SEOURLKEYWORD
(SEOURLKEYWORD_ID,SEOURL_ID,LANGUAGE_ID,STOREENT_ID,URLKEYWORD,STATUS,OPTCOUNTER)
values.(Unknown macro: {CHECKOUT_PAGE_SEOURLKEYWORD_UniqueID} ,{CHECKOUT_PAGE_SEOURL_UniqueID},-1,{storefrontassetstoreId},'checkout',1,1); }}
- Insert into PLPAGE
- For Order confirmation page
- Insert into PLPAGE
(PLPAGE_ID,ADMINNAME,MEMBER_ID,STOREENT_ID,PAGELAYOUTTYPE_ID,DELETABLE,ADMINNAMEEDITABLE,URLCONFIGURABLE,OPTCOUNTER)
values.(-6000,'order confirmationPage',7000000000000004501,13001,'Content',0,0,0,1);
- Insert into SEOPAGEDEF
(SEOPAGEDEF_ID,PAGENAME,STOREENT_ID,LASTUPDATE,CREATEDTIME,OPTCOUNTER)
values.({ORDER_CONFIRMATION_PAGE_SEOPAGEDEF_UniqueID},'Content_{ORDER_CONFIRMATION_PAGE_UniqueId}',{storefrontassetstoreMemberId},CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
- Insert into SEOPAGEDEFDESC
(SEOPAGEDEF_ID,LANGUAGE_ID,TITLE,META_DESC,META_KEYWORD,IMAGE_ALT_DESC,LASTUPDATE,CREATEDTIME,OPTCOUNTER)
values.({ORDER_CONFIRMATION_PAGE_SEOPAGEDEF_UniqueID},-1,'<seo: StoreName/>|order confirmation','<seo: StoreName/> order confirmation','<seo: StoreName/>','Image for <seo: StoreName/> order confirmation page',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
- Insert into SEOPAGEDEFOVR
(SEOPAGEDEFOVR_ID, SEOPAGEDEF_ID, APPLY_TO_CHILD, OBJECTTYPE, OBJECT_ID, OPTCOUNTER)
values.({ORDER_CONFIRMATION_PAGE_SEOPAGEDEFOVR_UniqueID}, {ORDER_CONFIRMATION_PAGE_SEOPAGEDEF_UniqueID}, 1, 'Content', '{ORDER_CONFIRMATION_PAGE_UniqueId}', 1);
- Insert into SEOURL
(SEOURL_ID,TOKENNAME,TOKENVALUE,OPTCOUNTER)
values.({ORDER_CONFIRMATION_PAGE_SEOURL_UniqueID},'StaticPagesToken','{ORDER_CONFIRMATION_PAGE_UniqueId}',1);
- Insert into SEOURLKEYWORD
(SEOURLKEYWORD_ID,SEOURL_ID,LANGUAGE_ID,STOREENT_ID,URLKEYWORD,STATUS,OPTCOUNTER)
values.({ORDER_CONFIRMATION_PAGE_SEOURLKEYWORD_UniqueID},{ORDER_CONFIRMATION_PAGE_SEOURL_UniqueID},-1,{storefrontassetstoreId},'order-confirmation',1,1);
- Insert into PLPAGE
- After inserting values, refresh the registry or restart the transaction server.
- Re-build the search index.