Step 3: Upgrading your database 6.0.0003 to 6.0.0004

baggypants posted 7th of February 2008 in Community Voice. 6 comments.

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?

Comments

Newest

·Oldest

·Top

Please login to post a comment.

baggypants•7th of February 2008

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?

Permalink•Reply•Plus•0 pluses

VictorT•8th of February 2008

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) see more

Permalink•Reply•Plus•0 pluses

baggypants•8th of February 2008

Thanks Victor.

Permalink•Reply•Plus•0 pluses