Most Popular in Unix
-
Server error: 501 #5.1.3 in UNIX
-
Replace pipe with Broken Pipe
-
HMC Commands
-
problem with awk script
-
UX: useradd: ERROR: Path must not start with '/home/'.
-
Calculate the Median, first quartile and third quartile using AWK
-
Proposed vBulletin Mobile App and Tapatalk
-
ssh debug1: Exit status 254 problem
-
phpBB Rivals 1.8.1 (Default branch)
-
Confused over results using "tee" in piped command
Field 'user_website' doesn't have a default value
Article posted from
My SysAd Blog (http://www.mysysad.com/2009/05/field-userwebsite-doesnt-have-default.html)
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 @gmail.com
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.
More Stories in My SysAd Blog
- How to Exclude a Directory for TAR
- Restore MySQL Database via Command Line
- Sun StorageTek 6140 Cache
- HTML Symbol Entities issue on Blogger
- Log an FTP Session with a Filter
- The Khan Academy is Teaching the Online World
- Use Redirect Symbol to Zero File
- Run the Windows Explorer GUI
- Retrieve Information on LDAP User
- $HOME/.TTauthority not writable, auth entry not added
Most Popular Stories
Blog sale!
A fix for those "Pairing Record Missing" errors
Server error: 501 #5.1.3 in UNIX
Anonymous Hacks Syrian President?s Email. The Password: 12345
Replace pipe with Broken Pipe
Twelve South HoverBar a unique way to marry iPad and iMac
VooMote Zapper universal remote for iOS: A first look and a rant
HMC Commands
Adobe confirms: no Flash for Chrome on Android
AMD processors take on tablets