Installing on MacOS X
Permalink
Hello,
I just tried an install of Concrete5 here at work to check it out. We are currently investigating CMS software (mostly Java stuff but some PHP)
I'm running OSX 10.5.8 and using Apache2 with PHP 5.3 and MySQL 5.0.67.
The installer stops dead with this setup as soon as it tries to place a default value of '000-00-00 00:00:00' in any column of type DATETIME.
This is indeed illegal so not sure how this got past QA.
The earliest date allowed in these columns is 1970
Had to replace all instances of '000-00-00 00:00:00' with '1970-01-01 00:00:00'
http://dev.mysql.com/doc/refman/5.0/en/datetime.html...
"The TIMESTAMP data type has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC. It has varying properties, depending on the MySQL version and the SQL mode the server is running in. These properties are described later in this section. "
This allows the install to complete, but not sure if date stuff is now broken.
My question is: Is this a bug? I found one other person talking about this in your forums but he fixed it himself and no one responded to the post.
I just tried an install of Concrete5 here at work to check it out. We are currently investigating CMS software (mostly Java stuff but some PHP)
I'm running OSX 10.5.8 and using Apache2 with PHP 5.3 and MySQL 5.0.67.
The installer stops dead with this setup as soon as it tries to place a default value of '000-00-00 00:00:00' in any column of type DATETIME.
This is indeed illegal so not sure how this got past QA.
The earliest date allowed in these columns is 1970
Had to replace all instances of '000-00-00 00:00:00' with '1970-01-01 00:00:00'
http://dev.mysql.com/doc/refman/5.0/en/datetime.html...
"The TIMESTAMP data type has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC. It has varying properties, depending on the MySQL version and the SQL mode the server is running in. These properties are described later in this section. "
This allows the install to complete, but not sure if date stuff is now broken.
My question is: Is this a bug? I found one other person talking about this in your forums but he fixed it himself and no one responded to the post.