close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


4.01 problems

Thread began 10/21/2010 12:57 pm by max363071 | Last modified 10/21/2010 3:20 pm by Jason Byrnes | 2092 views | 3 replies |


4.01 problems

Most important ->
1) I had 2 errors from my server when running the Database update script. We can not add new products after the update. Could you please help me with this.

2) in both 4.0 and 4.01 there is a formatting error on page 2 and up.

The error can be seen by->

click on products - show all
at the bottom of right menu click on Semi-mount
(There seem to be missing photos on the 1st page - I'm not sure what causes the blanks on this page)

more importantly -
then click next page.
All the formatting/frames are missing from all further pages

Max Arwood
Arwood's Jewelry

Sign in to reply to this post

Jason ByrnesWebAssist

use this script for updateing the databse:

INSERT INTO `ps4_contents` (`ContentGroup`,`ContentRefID`,`ContentValue`,`ContentDate`,`ContentUserID`,`ContentPageName`,`ContentPageSetParentID`,`ContentPageSetOrder`,`ContentType`,`ContentParentGroup`)
('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);

the link you provided goes to a server not found error, can you please post back a valid link so i can see the problem.

Sign in to reply to this post



I have run the script once. Is it okay to run it again?

I did not completely understand the server error, but I think it was saying the script was too long. Can I split it up into 2 parts?

Follow directions above for this link To see incorrectly formatted page:

(I spelled jewelry incorrectly - sorry.)


Max Arwood

Sign in to reply to this post

Jason ByrnesWebAssist

There should not be an issue with running the script again.

If you get an error, I will need to know the exact error text.

the issue with formatting disappearing when using the paging controls is one that is fixed in the 4.01 update.

make sure you have uploaded the 4.01 updated files to the remote host for the fix to take effect.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...