Favourite Host

Interserver

Install Service

Premium Support

Development

Order Custom Development Services

View Categories

MySQL error: Field ‘Aboutme’ doesn’t have a default value

< 1 min read

This article is outdated

Symptom:

When registering a new account, the following error appears:

Insert Into users(IP, SignupDate, FirstName, LastName, CompName, Username, Password, Email, Newsletter, Notification1, Notification2, Validated) values('IP was Here, I removed', '2006-06-24 09:37:00', 'Jonny', 'T', '', 'Jonny', 'password', '

em***@em***.com











', '', '', '', '1')Field 'Aboutme' doesn't have a default value

Solution

It looks like you are running MySQL version 5 with the default configuration. To ensure that the script will work with MySQL 5, you can try any of the following:

1. Find your my.ini file and replace the sql-mode line with:

sql-mode="MYSQL40"

Please remember to restart MySQL after editing the my.ini file. The my.ini file is MySQL's configuration file and should be located where MySQL was installed.

2. Or, configure your system so that MySQL start with the –sql-mode="MYSQL40" command line parameter.

The script is compatible for MySQL 3, and 4, but requires the configuration change for MySQL 5.

Powered by BetterDocs

Submit a Comment

Your email address will not be published. Required fields are marked *