Field currentquestid doesn’t have a default value

If you get getting the following message “Field ‘currentquestid’ doesn’t have a default value” here is a very simple fix.

Right click your users table in and choose design table

View post on imgur.com

Scroll down till you find the field “currentquestid”

Put a zero in the default box

View post on imgur.com

Then click the save icon at the top

View post on imgur.com

All fixed :)

How to disable Strict Mysql

You can disable strict mysql on your server in two different ways.

First method, Run the query below (this is reset after system restart)

SET @@global.sql_mode= ”;

Second Method

Locate your my.ini file, this is normally in :

C:\Program Files\MySQL\MySQL Server 5.5 (or the mysql version you are using)

Open the my.ini file

View post on imgur.com

Look for a line like this sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

View post on imgur.com

Place an # infont of this text so you have #sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

View post on imgur.com

Save this file*

*If you get the error “File in use” you will need to do the following,

Go back to your “C:\Program Files\MySQL\MySQL Server 5.5″ right click the my.ini file, then click properties click the security tab and then choose edit.

Then click the “add” button
Type the username you are logged in with (Normally Administrator or root)

View post on imgur.com


Then click Ok

Then tick the box giving that user full control

View post on imgur.com


Click ok
Then go back to your my.ini in your text editor and save.

Then you need to restart your mysql service for changes to be updated.

Click start, Administrative Tools and choose Services.

View post on imgur.com

Right click the Mysql service
and choose Restart

View post on imgur.com

You have now disabled strict mysql!strict