Saturday, May 30, 2009

Field 'user_website' doesn't have a default value

I received a few complaints about not being able to register an account on my phpbb forum. To confirm, I tried creating a test account.

Here were the results:

General Error
SQL ERROR [ mysql4 ]

Field 'user_website' doesn't have a default value [1364]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: some one

In my case, here was the fix. Of course, make sure you backup your database.

I ran the commands via phpmyadmin. It works fine now.

No comments: