Step 3: Upgrading your database 6.0.0003 to 6.0.0004

Upgrade Instructions from 6.0.0003 to 6.0.0004

Step 3 says: You should run your upgrade.php only once. If you run the script for a second time, it will result in Database access error.

I installed all upgrade files then ran upgrade.php (step 3) but received an error message because the dolphin could not find the correct path. It appears the instructions are not in the correct order because it is step 5 that tells me how to change the path. That information should be given first before going to step 3.

I followed the instructions in step 5 and changed the path but it was too late because upgrade.php can only be run once. Now I receive a blank page when I go to mysite.com. How do I correct this problem and upgrade the database?

baggypants

336 days ago


	Update: I solved the blank page problem I made an error when entering the path. Now that the path is correct should I run the upgrade.php again. Perhaps it did not run the first time because it could not find the site because of the path error?

VictorT

335 days ago


	Yes, you can run upgrade.php again. In case it results to an error with "Database access error" then just simply run the following MySQL query: ------------------------------------------ CREATE TABLE `RayShoutboxMessages` ( `ID` int(11) NOT NULL auto_increment, `UserID` varchar(20) NOT NULL default '0', `Msg` text NOT NULL, `When` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `RayVideoStats` ( `Approved` int(20) NOT NULL default '0', `Pending` int(20) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `RayVideoStats` VALUES(0, 0); ------------------------------------------ That should do.