MODx could not detect your MySQL server version via mysql_get_server_info()

Hi!

I’m having some fresh installation problems.

My environment:

iis7
php 5.3.2
mysql server 5.5.3-m3-community
mysql client 5.0.7-091210-$Revision:294543$
pdo_mysql - enabled
windows vista prof x32
Permissions - OK
FF 3.0
IE8
Revo Version 2.0.0-rc2


All configurations up to the point of installation are fine.
1) I selected ’New Installation’;
2) Entered the connection information and "Connecting to mysql server: Success!" and I get thess messages:
Installation Summary

Pre-installation tests were successful. Click Install below to continue.

*Checking PHP for zlib dependency: OK!
*Checking for SimpleXML: OK!
*Checking PHP version: OK! Running: 5.3.2
*Checking MySQL server version: OK! Running: 5.5.3-m3-community
*Checking MySQL client version: OK! Running: 5.0.7-091210-$Revision:294543$
*Checking if memory limit is set to at least 24M: OK! Set to 128M
*Checking if sessions are properly configured: OK!
*Checking if core/cache directory exists: OK!
*Checking if core/cache directory is writable: OK!
*Checking if core/export directory exists: OK!
*Checking if core/export directory is writable: OK!
*Checking if core/packages directory exists: OK!
*Checking if core/packages directory is writable: OK!
*Checking if core/config/config.inc.php exists and is writable: OK!
*Creating connection to the database: OK!

However I then get this message when I click ’Install’:

Installation Summary

Errors were encountered during core installation. Please review the installation results below, correct the problems and proceed as directed.

I click back and I get

Installation Summary

Pre-installation tests were successful. Click Install below to continue.

*Checking PHP for zlib dependency: OK!
*Checking for SimpleXML: OK!
*Checking PHP version: OK! Running: 5.3.2
* OK! Could not detect MySQL server version!
MODx could not detect your MySQL server version via mysql_get_server_info(). Please manually make sure that your MySQL server version is at least 4.1.20 before proceeding.
*Checking MySQL client version: OK! Running: 5.0.7-091210-$Revision:294543$
*Checking if memory limit is set to at least 24M: OK! Set to 128M
*Checking if sessions are properly configured: OK!
*Checking if core/cache directory exists: OK!
*Checking if core/cache directory is writable: OK!
*Checking if core/export directory exists: OK!
*Checking if core/export directory is writable: OK!
*Checking if core/packages directory exists: OK!
*Checking if core/packages directory is writable: OK!
*Checking if core/config/config.inc.php exists and is writable: OK!
*Creating connection to the database: Database connection failed!

Setup will attempt to create the database.

This is the same on a different PC running the same OS and same iis setup.

Help!!!

There "should" be a file in core/cache/logs/ named install.{timestamp} that contains any PHP errors that occurred. See if that exists...

Thank you for the tip OpenGeek.
There are a series of install.{timestamp} logs in this directory. All of them contain just one line, which reads:

"[2010-06-21 17:10:01] (FATAL) Could not load core MODx configuration!"

Then there’s the ’error.log’ file which contains predominantly SQL syntax errors.

Can i create the tables manually?

Where do I find the database creation script?

Cheers!

Quote from: olabs at Jun 23, 2010, 04:57 PM

Then there’s the ’error.log’ file which contains predominantly SQL syntax errors.

Can you attach your error.log or post a few examples here?

Quote from: olabs at Jun 23, 2010, 04:57 PM

Can i create the tables manually?

Where do I find the database creation script?

No; the tables are created from a schema definition by the xPDO O/R code. There are currently no manual SQL scripts available for this purpose.

Sure, here’s a sample of the error.log file.

’[2010-06-21 15:28:42] (ERROR @ /modx/setup/index.php) Could not create table `access_actiondom`
SQL: CREATE TABLE `access_actiondom` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`target` VARCHAR(100) NOT NULL DEFAULT ’’,`principal_class` VARCHAR(100) NOT NULL DEFAULT ’modPrincipal’,`principal` INT(10) unsigned NOT NULL DEFAULT ’0’,`authority` INT(10) unsigned NOT NULL DEFAULT ’9999’,`policy` INT(10) unsigned NOT NULL DEFAULT ’0’, PRIMARY KEY (`id`), INDEX `target` (`target`), INDEX `principal_class` (`principal_class`), INDEX `principal` (`principal`), INDEX `authority` (`authority`), INDEX `policy` (`policy`)) TYPE=MyISAM
ERROR: Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’TYPE=MyISAM’ at line 1
)

[2010-06-21 15:28:42] (ERROR @ /modx/setup/index.php) Could not create table `access_context`
SQL: CREATE TABLE `access_context` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`target` VARCHAR(100) NOT NULL DEFAULT ’’,`principal_class` VARCHAR(100) NOT NULL DEFAULT ’modPrincipal’,`principal` INT(10) unsigned NOT NULL DEFAULT ’0’,`authority` INT(10) unsigned NOT NULL DEFAULT ’9999’,`policy` INT(10) unsigned NOT NULL DEFAULT ’0’, PRIMARY KEY (`id`), INDEX `target` (`target`), INDEX `principal_class` (`principal_class`), INDEX `principal` (`principal`), INDEX `authority` (`authority`), INDEX `policy` (`policy`)) TYPE=MyISAM
ERROR: Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’TYPE=MyISAM’ at line 1
)

[2010-06-21 15:28:42] (ERROR @ /modx/setup/index.php) Could not create table `access_elements`
SQL: CREATE TABLE `access_elements` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`target` VARCHAR(100) NOT NULL DEFAULT ’’,`principal_class` VARCHAR(100) NOT NULL DEFAULT ’modPrincipal’,`principal` INT(10) unsigned NOT NULL DEFAULT ’0’,`authority` INT(10) unsigned NOT NULL DEFAULT ’9999’,`policy` INT(10) unsigned NOT NULL DEFAULT ’0’,`context_key` VARCHAR(100) NOT NULL DEFAULT ’’, PRIMARY KEY (`id`), INDEX `target` (`target`), INDEX `principal_class` (`principal_class`), INDEX `principal` (`principal`), INDEX `authority` (`authority`), INDEX `policy` (`policy`), INDEX `context_key` (`context_key`)) TYPE=MyISAM
ERROR: Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’TYPE=MyISAM’ at line 1
)’


Every little help I can get is appreciated.
May I say that I’m a newbie with Modx, but I read such good things about it that I just had to check it out.

Thank you for your time.

I have no idea. That syntax is perfectly valid in MySQL 5.0.x and 5.1.x. I know nothing about the more recent MySQL releases TBH, and I don’t think they are very commonly used yet. We will eventually support them, but it’s not on the priority list atm if it doesn’t just work as is.

If anyone can identify what the incompatibility is in the SQL syntax, please enter a bug in our JIRA application and we’ll get it fixed.

More questions:

So should I therefore down-grade my MySQL server version?
Which has been the most ideal version for Revo 2.0.0 rc2?
Is MSSQL Server an option at all?

Don’t know the extent of this, but as I launched the install I also noticed that CGI/FastCGI stops working as well.

Sounds like you have other environment issues then, and this may not be related to MySQL at all. I’m not versed at all in IIS, so I’ll have to defer to those knowledgeable to diagnose what would cause the PHP CGI to stop working.