Update to PowerStore 4.01 from 4.00

10/20/2010 7:07 pm | #1 Jason Kline

I get this error below.

Error
SQL query:

INSERT INTO `ps4_contents` ( `ContentID` , `ContentGroup` , `ContentRefID` , `ContentValue` , `ContentDate` , `ContentUserID` , `ContentPageName` , `ContentPageSetParentID` , `ContentPageSetOrder` , `ContentType` , `ContentParentGroup` )
VALUES (

'78', 'Home Page', 'meta-keywords', 'home', '2010-09-27 11:21:10', '0', '', NULL , '1', 'WYG', NULL
);

MySQL said:

#1062 - Duplicate entry '78' for key 1

10/21/2010 11:48 am | #3 Jason ByrnesWebAssist

use this query to update the PowerStore 4 database:

INSERT INTO `ps4_contents` (`ContentGroup`,`ContentRefID`,`ContentValue`,`ContentDate`,`ContentUserID`,`ContentPageName`,`ContentPageSetParentID`,`ContentPageSetOrder`,`ContentType`,`ContentParentGroup`)
VALUES
	('Home Page','meta-keywords','home','2010-09-27 11:21:10',0,'',NULL,1,'WYG',NULL),
	('Home Page','meta-title','Home - [Site Name]','2010-09-27 11:21:10',0,'',NULL,1,'WYG',NULL),
	('Home Page','meta-description','test home','2010-09-27 11:21:10',0,'',NULL,1,'WYG',NULL),
	('Company Info','meta-keywords','Directions, [Site Name]','2010-09-27 11:21:23',0,'',NULL,2,'WYG',NULL),
	('Company Info','meta-title','About Us - [Site Name]','2010-09-27 11:21:23',0,'',NULL,2,'WYG',NULL),
	('Company Info','meta-description','This is the about us page','2010-09-27 11:21:23',0,'',NULL,2,'WYG',NULL),
	('Contact Us','meta-keywords','','2010-09-27 13:45:23',0,'',NULL,3,'WYG',NULL),
	('Contact Us','meta-title','Contact Us - [Site Name]','2010-09-27 13:45:23',0,'',NULL,3,'WYG',NULL),
	('Contact Us','meta-description','','2010-09-27 13:45:23',0,'',NULL,3,'WYG',NULL),
	('Product Results','meta-keywords','','2010-09-27 13:45:52',0,'',NULL,4,'WYG',NULL),
	('Product Results','meta-title','Products - [Site Name]','2010-09-27 13:45:52',0,'',NULL,4,'WYG',NULL),
	('Product Results','meta-description','','2010-09-27 13:45:52',0,'',NULL,4,'WYG',NULL),
	('News','meta-title','','2010-09-27 13:46:20',0,'',90,NULL,'WYG','0'),
	('Article 1','meta-title','Article 1','2010-09-27 13:46:20',0,'',90,1,'WYG',NULL),
	('Article 2','meta-title','Article 2','2010-09-27 13:46:20',0,'',90,2,'WYG',NULL),
	('News','meta-keywords','','2010-09-27 13:46:28',0,'',93,NULL,'WYG','0'),
	('Article 1','meta-keywords','','2010-09-27 13:46:28',0,'',93,1,'WYG',NULL),
	('Article 2','meta-keywords','','2010-09-27 13:46:28',0,'',93,2,'WYG',NULL),
	('News','meta-description','','2010-09-27 13:46:38',0,'',96,NULL,'WYG','0'),
	('Article 1','meta-description','','2010-09-27 13:46:38',0,'',96,1,'WYG',NULL),
	('Article 2','meta-description','','2010-09-27 13:46:38',0,'',96,2,'WYG',NULL),
	('Footer Pages','meta-title','Page Title','2010-09-27 13:47:03',0,'',99,NULL,'WYG',NULL),
	('Terms of Use','meta-title','Terms of Use - [Site Name]','2010-09-27 13:47:03',0,'',99,3,'WYG',NULL),
	('FAQ','meta-title','FAQ - [Site Name]','2010-09-27 13:47:03',0,'',99,1,'WYG',NULL),
	('Privacy Policy','meta-title','Privacy Policy - [Site Name]','2010-09-27 13:47:03',0,'',99,2,'WYG',NULL),
	('Footer Pages','meta-keywords','','2010-09-27 13:47:10',0,'',103,NULL,'WYG',NULL),
	('Terms of Use','meta-keywords','','2010-09-27 13:47:10',0,'',103,3,'WYG',NULL),
	('FAQ','meta-keywords','','2010-09-27 13:47:10',0,'',103,1,'WYG',NULL),
	('Privacy Policy','meta-keywords','','2010-09-27 13:47:10',0,'',103,2,'WYG',NULL),
	('Footer Pages','meta-description','','2010-09-27 13:47:17',0,'',107,NULL,'WYG',NULL),
	('Terms of Use','meta-description','','2010-09-27 13:47:17',0,'',107,3,'WYG',NULL),
	('FAQ','meta-description','','2010-09-27 13:47:17',0,'',107,1,'WYG',NULL),
	('Privacy Policy','meta-description','','2010-09-27 13:47:17',0,'',107,2,'WYG',NULL),
	('Custom Pages','meta-title','Page - [Site Name]','2010-09-27 13:47:34',0,'',111,NULL,'WYG','0'),
	('Shipping','meta-title','','2010-09-27 13:47:34',0,'',111,1,'WYG',NULL),
	('Return Policy','meta-title','Return Policy - [Site Name]','2010-09-27 13:47:34',0,'',111,4,'WYG',NULL),
	('Custom Pages','meta-keywords','','2010-09-27 13:47:43',0,'',114,NULL,'WYG','0'),
	('Shipping','meta-keywords','','2010-09-27 13:47:43',0,'',114,1,'WYG',NULL),
	('Return Policy','meta-keywords','','2010-09-27 13:47:43',0,'',114,4,'WYG',NULL),
	('Custom Pages','meta-description','','2010-09-27 13:47:50',0,'',117,NULL,'WYG','0'),
	('Shipping','meta-description','','2010-09-27 13:47:50',0,'',117,1,'WYG',NULL),
	('Return Policy','meta-description','','2010-09-27 13:47:50',0,'',117,4,'WYG',NULL),
	('Custom Menu','meta-title','Custom Menu - [Site Name]','2010-09-27 13:48:18',0,'',NULL,NULL,'WYG',NULL),
	('Custom Menu','meta-keywords','','2010-09-27 13:48:27',0,'',NULL,NULL,'WYG',NULL),
	('Custom Menu','meta-description','','2010-09-27 13:48:33',0,'',NULL,NULL,'WYG',NULL);

10/21/2010 7:25 pm | #4 Jason Kline

Hi Jason,

That SQL statement worked.

But now I have also just discovered I get errors when I click the add to cart button.

What could have possibly gone wrong when I did the update?

see the attachment

10/22/2010 7:10 am | #6 Jason ByrnesWebAssist

In the update instructions, you copy only the PHP files at the root of the "PowerStore Files" fodler to your existing site and the Admin and HTMLEditor folder.

The webassist/plugins/shopping_cart/cart_editable.php file should not be effected using this method.
Edit/Delete Message

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Update to PowerStore 4.01 from 4.00

10/20/2010 7:07 pm | #1 Jason Kline