Login!
Lost password?
 

MODx Bug/Feature Tracker and Feature Requests

Welcome to the MODx CMS Tracker. Please choose the appropriate project from the drop down menu and provide as much information as possible regarding your server environment and browser. Thanks!

FS#1018 — Add DB checks for MySQL versions to installer

Attached to Project — MODx
Opened by Ryan Thrash (rthrash) - Friday, 22 February 2008, 09:18AM
Task Type ToDo
Category Install and Server Issues
Status Closed
Assigned To No-one
Operating System All
Severity High
Priority Normal
Reported Version 0.9.6.1
Due in Version 0.9.6.2
Due Date Undecided
Percent Complete 100%

Details

http://us2.php.net/mysql_get_server_info

We should make sure that it's NOT running version 5.0.51 and also that it's NOT running in strict mode.
This task depends upon

This task blocks these from closing
Closed by  Brunaud (coroico)
Friday, 09 May 2008, 05:35AM
Reason for closing:  Duplicate
Additional comments about closing:  Created in JIRA as #MODX-141
The improvement proposed by Shane should be tested
Comment by Matthew Pietz (sirlancelot) - Friday, 22 February 2008, 10:23AM
I think checking for strict mode is a must, but what problem is there with running mysql 5? Or is it a problem specifically with 5.0.51?

I'm running 5.0.22 (haven't upgraded in a while :-/) without problem.

Comment by Ryan Thrash (rthrash) - Friday, 22 February 2008, 10:45AM
5.0.51 has all sorts of problems with sorting.

http://www.google.com/custom?domains=modxcms.com&q=5.0.51&sa=Google+Search&sitesearch=modxcms.com

Comment by Jason Coward (opengeek) - Friday, 22 February 2008, 11:57AM
Guys, please do not add more bugs to flyspray -- all new bugs shall go into JIRA from now on

Comment by Shane Sponagle (dev_cw) - Monday, 25 February 2008, 07:36AM
Did not see this one in JIRA so I will answer here. The check for MySQL 5.0.51 and strict mode are complete (could use some additional testing) and the modified files are attached to the forum post:
http://modxcms.com/forums/index.php/topic,23164.0.html

Files modified install files are action.connection.php and action.summary.php

Comment by Jason Coward (opengeek) - Monday, 25 February 2008, 09:01AM
Ok I'll clarify; can we please start actively migrating any tickets that are left open here to JIRA rather than continuing to add stuff here?

Comment by Andy Shellam (andyccn) - Saturday, 05 April 2008, 02:05PM
I'm hoping that the MySQL 5.0.51 check is only a warning and doesn't prevent a user from installing MODx on this server version - I'm thinking about webhosts that may only have this version available, you could be severely restricting your audience.

Also what's JIRA? The links on your website still point to Flyspray?

Comment by Jason Coward (opengeek) - Saturday, 05 April 2008, 02:34PM
It will present a warning about the problems you will encounter if deploying on MySQL 5.0.51, as it is severely broken. IMHO, web hosts should not be deploying this version of MySQL; 5.0.45 and 5.0.54 both work wonderfully and avoids the problem which is affecting many scripts and applications that use MySQL. MODx is not alone in this.

JIRA is a new bug tracking system that we will be migrating to with the release of 0.9.7; the message was intended for team members who already have access to this system. We will be announcing this publicly in the near future.