CMS-recovery
One of my admins to my site has erased "Custom Pages" from the content,..... how do i recover it so that Custom Pages can be seen and new pages can be added easily once again?
Super Suite
Get all extensions for one suite price
Design Extender
Design and create unlimited websites
Data Bridge
Develop database-driven websites
eCart
Build a responsive shopping cart + checkout
MySQLi Server Behaviors
Generate streamlined MySQLi
Free PayPal Toolkit
Paypal, PayPal Credit, and Skype
Help
1/31/2011 1:17 pm | #1 lazyhoofer376912Beta Tester
One of my admins to my site has erased "Custom Pages" from the content,..... how do i recover it so that Custom Pages can be seen and new pages can be added easily once again?
1/31/2011 1:49 pm | #2 Jason ByrnesWebAssist
you will need to access the power store database directly and run the following sql commands to recreate them:
INSERT INTO `ps4_contents` (`ContentID`,`ContentGroup`,`ContentRefID`,`ContentValue`,`ContentDate`,`ContentUserID`,`ContentPageName`,`ContentPageSetParentID`,`ContentPageSetOrder`,`ContentType`,`ContentParentGroup`) VALUES
(8,'Custom Pages','Content','<h2>Using the Custom Pages feature</h2><p>The Custom Pages feature allows you to change the pages and menu items that are listed in the navigation.  Any new pages that you create based on the \'Custom Pages\' template in the Content column will automatically be added to your navigation menu.</p><ol><li>From the Content column, hover over the Custom Pages option and press the green (+) icon to create a new page based on that template.</li><li>Enter a name for that page (this is what will be listed in the navigation.</li><li>Now that the page has been inserted, you can edit the Header and the Content to say what you would like.</li></ol>','2009-11-19 14:33:24',0,NULL,8,NULL,'WYG','Custom Menu');
INSERT INTO `ps4_contents` (`ContentID`,`ContentGroup`,`ContentRefID`,`ContentValue`,`ContentDate`,`ContentUserID`,`ContentPageName`,`ContentPageSetParentID`,`ContentPageSetOrder`,`ContentType`,`ContentParentGroup`) VALUES
(9,'Custom Pages','Header','Your page header','2009-11-19 14:33:24',0,NULL,9,NULL,'TXT','Custom Menu');
INSERT INTO `ps4_contents` (`ContentID`,`ContentGroup`,`ContentRefID`,`ContentValue`,`ContentDate`,`ContentUserID`,`ContentPageName`,`ContentPageSetParentID`,`ContentPageSetOrder`,`ContentType`,`ContentParentGroup`) VALUES ('111', 'Custom Pages', 'meta-title', 'Page - [Site Name]', '2010-09-27 13:47:34', '0', '', '111', null, 'WYG', '0');
INSERT INTO `ps4_contents` (`ContentID`,`ContentGroup`,`ContentRefID`,`ContentValue`,`ContentDate`,`ContentUserID`,`ContentPageName`,`ContentPageSetParentID`,`ContentPageSetOrder`,`ContentType`,`ContentParentGroup`) VALUES ('114', 'Custom Pages', 'meta-keywords', '', '2010-09-27 13:47:43', '0', '', '114', null, 'WYG', '0');
INSERT INTO `ps4_contents` (`ContentID`,`ContentGroup`,`ContentRefID`,`ContentValue`,`ContentDate`,`ContentUserID`,`ContentPageName`,`ContentPageSetParentID`,`ContentPageSetOrder`,`ContentType`,`ContentParentGroup`) VALUES ('117', 'Custom Pages', 'meta-description', '', '2010-09-27 13:47:50', '0', '', '117', null, 'WYG', '0');
1/31/2011 7:56 pm | #3 lazyhoofer376912Beta Tester
i ran the script but it did not work,... siad theres was duplicates.
i then erase all things names custom pages within the ps4 contents and ran the script again, this time it was successful.... however,..... it still does not show up on the admin page admin/cms_index.php? under the menu.
still stuck in the same spot, any other suggestions?
2/01/2011 9:00 am | #4 Jason ByrnesWebAssist
try this the query attached to this post
if that does not work the only way to get it back will be to drop the table completely and run the original install script for that table.
3/11/2011 7:24 am | #5 Marleen I stupidly errased the custom menu out of the admin. The custom pages are now shown on the top level. How can I make this work properly again.
3/11/2011 7:41 am | #6 Jason ByrnesWebAssist
did you try the query in post 4 of this thread?
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.
©1999-2024 WebAssist.com Corporation. All rights reserved and all that jazz.
Account or customer service questions?
Please user our contact form.
Need technical support?
Please visit support to ask a question
Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...
Uploading file...