• Registered: 2009-07-03
  • Posts: 3

Topic: First time installation - MySQL Strict mode

I am using current release version, that is not a beta. Cannot get past the "MySQL Strict Mode is not supported" message. I have ready all the sketchy threads - Sorry I don't speak geek and have never read between the lines well.

I have, to the best of my understanding, tried all suggested fixes, without luck.

I hope that someone that has solved this problem can publish a solution for me. I am very eager to try Mia.

I am on WAMP 2.0h using Apache 2.2.11, MySQL 5.1.33 & PHP 5.2.9-2.

  • Registered: 2009-07-03
  • Posts: 3

Re: First time installation - MySQL Strict mode

This morning, I dug deeper into the MySQL reference link in one of the earlier threads. I ran the query:

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

The return was:

MYSQL40,HIGH_NOT_PRECEDENCE

I assume that is two results separated by a comma.

So if PHP reports version 4, shouldn't I be able to run the installation beyond the check phase.?

  • Registered: 2009-07-03
  • Posts: 3

Re: First time installation - MySQL Strict mode

Too late. I've moved on. Mia looked so promising. Maybe I'll see you down the road.

BTW, I thought the screen shot at the docs site was laughable.

http://docs.miacms.org/wikka.php?wakka=InstallingMia

Shows the Strict mode error with no mention as to resolution.

Bye