Thread

We’ve migrated a fully functioning EE site to a Windows server that meets all required specs (“URL Segment Support” = no, however), and nearly all forms in the control panel serve up 500 server errors. Logs aren’t showing anything besides simple GET requests and POST urls.

Edit:
Other details: PHP 5.3.6 and MySQL 5.5+ with Strict mode on.
Any ideas?

Did i not give enough information to get a response? Anything else i can do to help? This site is on hold in the middle of a launch and people are… not happy.

Hi Jack,

While EE should run with Strict Mode on can you test with it off please?

What version and build of EE are you using?

I have seen 2 issues regarding MySQL 5.5 but from what I see only refer to install time and a member area date.

Are you referring to just Publish forms? How about Admin forms?

I can try that (though i’ll need to figure out how to do it in Windows, bah). Using EE 2.1.3 Build 20101220.

Nearly all the CP forms, including Admin forms (General Config for example) are affected. A few of the channels don’t trigger errors on publish but most do. Really odd. Something with data types possibly?

Hi, Jack. What are the differences between field types in the channels that work and the ones that don’t?

I’d make a new channel with a new channel fields group, and put in the various fields one at a time until you can find out what it chokes on.

Does that help?

Looks like a file upload field. We switched the MySQL mode off of Strict and everything started behaving again. Probably something worth looking into or at least documenting! Thanks for the reply!

Hi, Jack. Was it one of ours? If so which one? We’ll be expanding our Windows testing as we get closer to EE 2.2..

If it wasn’t one of ours, which one was it?

Yes it was the File fieldtype. Also note that the General Configuration settings page had the same issue on submit, so it was probably a similar issue. I think i saw a thread around here somewhere (possibly by Steve Hambo) that said it might be an empty string type inserting into an int field in the DB. Haven’t confirmed, but maybe worth noting. Thanks!

Hi Jack,

Just to confirm, is everything still working here?

Yes, turning off Strict mode did the trick. Thanks for checking in.

Thanks Jack,

Strange as we haven’t seen this with strict mode on *NIX boxes, but glad you’re up and running! Don’t hesitate to post again if anything else crops up.