Parse Error when logging in as a Web User

I’ve created a web user on a fresh installation and I get a parse error when logging in.

The SQL is trying to insert a NULL value for the active_users.id field, but it’s added single quotes around.

Should this value be null? The table is set to allow nulls in that field. I can add some conditional around that line of the code, but I wondered if there was a reason for the error before I start hacking around.

I believe this is a problem with MySQL strict sql_mode settings; I believe this is addressed in SVN already, though I’d have to look up the bug report. Go ahead and make the change, and the next release should include the fix anyway.

Cheers OG.

Any idea on how to hack the code to fix this or a timetable on a posted fix?

This happens for me when logging in as a web user and attempting to access the site’s homepage http://site.com/modx either by typing it in or by clicking on the Home button.

However, there is no error if I click on the logo which is linked to http://site.com/index.php?id=1.