Wondering if anyone knows the proper steps for doing an
upgrade of MySQL and PHP for use with the new UBBT 7.01?

I have UBBT 6.5.1.1 MySQL 3.23.58 and PHP 4.4.1

I updated MySQL to 5.0.27 but now I get errors on UBBT 6.5.1.1





What is the appropriate way to upgrade to the latest versions
of MySQL and PHP in order to use with UBBT 7.01 on Windows Server 2003 and then run the import scripts to bring over my older posts.
 

 

Simply put, the way that MySQL stores user passwords changed in version 4.0; you have a couple of choices:
1. Reset your password, all is well.
2. Set MySQL to run passwords how it used to; its again fairly easy and an edit in the my.cnf, although I'm not sure of the exact steps, just google it for a full answer.

As for the PHP error, I'm not entirely sure off hand, but I'm guessing its due to the double // before tbopen.tmpl

Some quick googling on the password format returns:
1. Edit /etc/my.cnf (in *nix), or C:\my.cnf (in Win)
2. Under [mysqld] add: old-passwords

Note that I would more recommend you reset your password than change the password type; but its your choice how to repair the issue.

Thanks.

Option 1 sounds fine.

Not sure exactly though what you mean.

The config.inc.php file has the password already.
I dropped my user and recreated and gave a password with Grant
in MySQL and gave all permissions to the local database
after upgrading to 5.027

Thanks
 

Your config.inc.php doesn't need updating unless you change what it is, the password in MySQL has to be updated as they changed the format of how passwords are stored in MySQL4.

If you really want to read about the password changes you should take a gander at the following two links:
http://dev.mysql.com/doc/refman/5.0/en/set-password.html
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

Thanks for the links.

I read the first link before, will read up on the 2nd link.

Thanks again.

Update:

worked a treat thanks. 2nd link also has other PHP issues that may affect some users.


 
Thanks again Gizmo.
 

Lol not a problem