MySQL 5.0 Support

Read me first before posting anywhere!
Subscribe to the feed, available in Image Atom or Image RSS format.
Ideas Centre
Post Reply
Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

MySQL 5.0 Support

Post by Graham » Tue Nov 29, 2005 7:59 pm

We have received a number of queries recently regarding whether phpBB 2.0.x will run on MySQL 5.0.x.

I'm glad to report that it will install and run, although there are some minor issues on some particular distributions of MySQL (primarily the Windows build) which may require a minor change to allow installation.

If you are already running phpBB and wish to migrate to MySQL 5, there should be no issues, providing that PHP on your server is configured to install it.

If you are performing a new install on MySQL 5, you should make the following change before you start the install.

OPEN

Code: Select all

install/schemas/mysql_schema.sql
FIND

Code: Select all

bbcode_uid char(10) NOT NULL,
REPLACE WITH

Code: Select all

bbcode_uid char(10) DEFAULT '' NOT NULL,
You should then install normally and select the MySQL 4 option from the installation script.

The phpBB Development Team
"So Long, and Thanks for All the Fish"

phpBB Useful Links: Knowledge Base | Userguide | Forum Search | MOD Database | Styles Database
My Links: Blog!

Post Reply

Return to “Announcements”

Who is online

Users browsing this forum: No registered users and 15 guests