Question2Answer query failed: UPDATE qa_users SET sessioncode=NULL WHERE userid=_utf8 '1' Error 1048: Column 'sessioncode' cannot be null

Question

I get this error when logging out as admin. I'm using beta 3. Did work with Beta 2.

Answer 1

Thanks for this. It seems you have MySQL on some kind of stricter mode than usual, since in most cases this should just generate a silent warning. But it is a bug, which you can fix by changing line 193 of qa-app-users.php from:

qa_db_user_set($db, $_SESSION['qa_session_userid'], 'sessioncode', NULL);

... to ...

qa_db_user_set($db, $_SESSION['qa_session_userid'], 'sessioncode', '');

Of course I'll also fix this for the final 1.0 release.