support for mysql 5?

[akhi003]

Does OJS 2.x support MySql 5? Here is my setup:

OJS 2.0.2
IIS 6.0
PHP 5.0.5
MySQL 5.0

The install page shows and goes to a blank page after I click the "Install Open Journal Systems" button.

A similar issue is also posted under http://pkp.sfu.ca/support/forum/viewtopic.php?t=387

Any information would be appreciated. Thanks.

Nabeel

[asmecher]

Hello Nabeel,

Yes, OJS 2.x supports PHP 5.x. The blank page you see when you attempt to install almost always arises when the MySQL module has not been loaded in your php.ini configuration file -- from docs/FAQ:

7) The installation form loads successfully, but after clicking the button
to install, a blank page appears and the database was not created.

A: This may indicate that your server does not have the selected PHP database
module installed and enabled (this can be verified by looking at the output
of phpinfo() to see if the required database support exists -- see
http://php.net/phpinfo).

The OJS installer lists database drivers for which the required PHP
extension does not appear to be loaded in brackets (e.g., "[MySQL]").

Most Linux distributions offer a separate package that can be installed for
each supported PHP database module -- e.g., php4-mysql or php-mysql (for
MySQL support), or php4-pgsql or php-pgsql (for PostgreSQL support).

Note also that even with the module installed it may be necessary to modify
your php.ini configuration to load the module, by adding "extension=mysql.so" or "extension=pgsql.so", for example.

Note that PHP 5.0.5 has changed some of the reference rules, so you may see a few error messages; these will be corrected in the next release of OJS. Feel free to post here if you encounter them and I'll provide a patch.

There are
Regards,
Alec Smecher
Open Journal Systems Team

[akhi003]

Thanks Alec. That was the problem. I added the extension for php-mysql.dll in the php.ini file and it worked fine.

Nabeel