Thread

I am trying to install EE on a Windows 2003 Server (IIS 6.0, PHP 4, MySQL 5).

I was able to use forum suggestions and Google to get the Wizard to show both required items as supported. Then I kept getting errors saying that I don’t have INSERT permissions. I checked to see that we have PHP and MySQL set up properly—we do. I turned off strict mode. Now I keep getting alternating errors in the Wizard’s MySQL check of:

“Your MySQL user does not have INSERT permissions - MySQL error:Incorrect integer value: ‘’ for column ‘ee_id’ at row 1”

... or ...

“PHP has encountered an Access Violation at XXXXXXX”

I’ve searched everywhere for some sort of solution, but the only thing I can find is to disable strict mode in MySQL, and I have already done that:

# Set the SQL mode to strict
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql-mode = "NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

Any suggestions?

It looks like a strict mode issue to me.  But server setup is beyond standard support- and I’m not dead sure how to do it.  Did you restart mysql after making the change?  And I wonder if you should put in ‘TRADITIONAL’ as the mode instead?

But I’m going to shift to ‘How to’ for the moment.  Getting the server setup for the wizard to pass is a bit beyond what we do.  I’ll keep an eye on it, though- shift it back if it needs poking once the wizard is passing it.  Seriously looks like it’s still in strict mode to me.

Thanks, Robin.

I think that I may not have restarted MySQL properly. I’ll give that a shot this afternoon—I have to wait until my client closes for the day so as not to interrupt their MySQL connections for Moodle.

Are you seriously testing this on a live database? You should getting a testbed of sorts, I think.

It’s been tested in-office. It just won’t seem to translate over to the actual setup, which is exactly the same. I think we may have missed a step though, meaning that MySQL may not have been restarted when it should have been.

Anyway, backups are run nightly, so we’ll be fine in any event ...