ArticleTrader Forums - Viewing Topic: Error: Field 'user

master-willy Newbie Group: Members Posts: 1 Joined: Today	Email PM Quote
	Hi there Trying to install articlems i got this errors: Field 'user_bio' doesn't have a default value Field'settings_settings' doesn't have a default value Field'section_settings' doesn't have a default value Field'group_perms' doesn't have a default value can someone please help me ? I have PHP Version: 5.2.6 Operating System: WINNT windows homeserver installed mysql
	Posted Oct 22, 2009, 8:26 pm

mandolinrick Newbie Group: Members Posts: 1 Joined: Today	Email PM Quote
	I'm getting the same message: Field 'section_settings' doesn't have a default valueField 'settings_settings' doesn't have a default valueField 'group_perms' doesn't have a default valueField 'group_perms' doesn't have a default valueField 'group_perms' doesn't have a default valueField 'group_perms' doesn't have a default valueField 'group_perms' doesn't have a default valueField 'group_perms' doesn't have a default valueField 'group_perms' doesn't have a default valueField 'user_bio' doesn't have a default value Stats PHP Version: 5.2.9-1 Operating System: WINNT Safe mode: off Register globals: off Magic Quotes: off, runtime off Installation Error: Field 'user_bio' doesn't have a default value Any help with this? Rick
	Posted Nov 9, 2009, 9:47 pm

Dejavu Administrator Group: Administrators Posts: 706 Joined: Jan 5, 2006	Email WWW PM Quote
	This is rather strange.. it complains that some TEXT fields (like user_bio) does not have a default value, but strictly mysql does not even allow default values for those types of fields.. anyhow here is a workaround to get it installed: open install/db_tables.php in notepad then replace text not null with text not null default '' and save. then run the installation again
	......................... Directory Tracker Article Distribution Posted Nov 9, 2009, 11:49 pm