ModX 0.9.5 Beta (rev 1491) installation problems

I’ll bet that the w32 MySQL server is running in the new STRICT_MODE introduced in MySQL 5.0 while the Linux deployment is not. If that’s the problem, you can disable strict mode on the W32 deployment to get around the issue for now. This has been identified and we are working on a long term solution to overcome some problematic data structures in this regard.

You’ll win that bet, thanks for pointing out this setting. I didn’t do any my.ini changes when I installed in windows, I guess Fedora changes the default server configuration, or mysql distributes the w32 server with a different default configuration than for linux.

I experienced similar problems to this, with the 0.9.2 release on a Win32 box (MySQL=STRICT)
I say similar, mine were an inability to add templates, snippets, chunks etc as described in http://modxcms.com/forums/index.php/topic,4573.0.html
and in http://modxcms.com/forums/index.php/topic,4603.0.html
I did NOT stop MySQL running in strict mode, but modified the setup.sql file so that every field with NOT NULL specified has a default value (I used ’’ or 0 depending if char or numeric’.

Of course I then lost the sql file after the install when the manager deleted the install folder :’(, but could soon re-create it if necessary. Since then have had no problems yet with strict mode.

Quote from: wyn at Oct 04, 2006, 12:59 AM

I did NOT stop MySQL running in strict mode, but modified the setup.sql file so that every field with NOT NULL specified has a default value (I used ’’ or 0 depending if char or numeric’.

Ah, thanks for the reminder on this wyn...I’m going to change this right now.