MySQL

[iPrestege]

Hey guys!

I was importing some of mySQL tables i got this error :

Error at the line 127131: ) ENGINE=MyISAM AUTO_INCREMENT=1155 DEFAULT CHARSET=latin1; 
Query: 
MySQL: Invalid default value for 'field_mym_c' 
  

My Code :

DROP TABLE IF EXISTS user; 
CREATE TABLE `user` ( 
  `userid` int(10) unsigned NOT NULL AUTO_INCREMENT, 
  `gxcss_mzag` mediumtext NOT NULL, 
  `gxcss_users` mediumtext NOT NULL, 
  `gxcss_user` mediumtext NOT NULL, 
  `gxcss_news` mediumtext NOT NULL, 
  `gxcss_sms` mediumtext NOT NULL, 
  `gxcss_mms` mediumtext NOT NULL, 
  `gxcss_down` mediumtext NOT NULL, 
  `gxcss_up` mediumtext NOT NULL, 
  `gxcss_underline` mediumtext NOT NULL, 
  `gxcss_italic` mediumtext NOT NULL, 
  `gxcss_blod` mediumtext NOT NULL, 
  `gxcss_size` mediumtext NOT NULL, 
  `gxcss_font` mediumtext NOT NULL, 
  `gxcss_color` mediumtext NOT NULL, 
  `usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `membergroupids` char(250) NOT NULL DEFAULT '', 
  `displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `username` varchar(100) NOT NULL DEFAULT '', 
  `password` char(32) NOT NULL DEFAULT '', 
  `passworddate` date NOT NULL DEFAULT '0000-00-00', 
  `email` char(100) NOT NULL DEFAULT '', 
  `styleid` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `parentemail` char(50) NOT NULL DEFAULT '', 
  `homepage` char(100) NOT NULL DEFAULT '', 
  `icq` char(20) NOT NULL DEFAULT '', 
  `aim` char(20) NOT NULL DEFAULT '', 
  `yahoo` char(32) NOT NULL DEFAULT '', 
  `msn` char(100) NOT NULL DEFAULT '', 
  `skype` char(32) NOT NULL DEFAULT '', 
  `showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2', 
  `usertitle` char(250) NOT NULL DEFAULT '', 
  `customtitle` smallint(6) NOT NULL DEFAULT '0', 
  `joindate` int(10) unsigned NOT NULL DEFAULT '0', 
  `daysprune` smallint(6) NOT NULL DEFAULT '0', 
  `lastvisit` int(10) unsigned NOT NULL DEFAULT '0', 
  `lastactivity` int(10) unsigned NOT NULL DEFAULT '0', 
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0', 
  `lastpostid` int(10) unsigned NOT NULL DEFAULT '0', 
  `posts` int(10) unsigned NOT NULL DEFAULT '0', 
  `reputation` int(11) NOT NULL DEFAULT '10', 
  `reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1', 
  `timezoneoffset` char(4) NOT NULL DEFAULT '', 
  `pmpopup` smallint(6) NOT NULL DEFAULT '0', 
  `avatarid` smallint(6) NOT NULL DEFAULT '0', 
  `avatarrevision` int(10) unsigned NOT NULL DEFAULT '0', 
  `profilepicrevision` int(10) unsigned NOT NULL DEFAULT '0', 
  `sigpicrevision` int(10) unsigned NOT NULL DEFAULT '0', 
  `options` int(10) unsigned NOT NULL DEFAULT '33554447', 
  `birthday` char(10) NOT NULL DEFAULT '', 
  `birthday_search` date NOT NULL DEFAULT '0000-00-00', 
  `maxposts` smallint(6) NOT NULL DEFAULT '-1', 
  `startofweek` smallint(6) NOT NULL DEFAULT '1', 
  `ipaddress` char(15) NOT NULL DEFAULT '', 
  `referrerid` int(10) unsigned NOT NULL DEFAULT '0', 
  `languageid` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `emailstamp` int(10) unsigned NOT NULL DEFAULT '0', 
  `threadedmode` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `autosubscribe` smallint(6) NOT NULL DEFAULT '-1', 
  `pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `pmunread` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `salt` char(30) NOT NULL DEFAULT '', 
  `ipoints` int(10) unsigned NOT NULL DEFAULT '0', 
  `infractions` int(10) unsigned NOT NULL DEFAULT '0', 
  `warnings` int(10) unsigned NOT NULL DEFAULT '0', 
  `infractiongroupids` varchar(255) NOT NULL DEFAULT '', 
  `infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT '0', 
  `adminoptions` int(10) unsigned NOT NULL DEFAULT '0', 
  `profilevisits` int(10) unsigned NOT NULL DEFAULT '0', 
  `friendcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `friendreqcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `vmunreadcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `vmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `socgroupinvitecount` int(10) unsigned NOT NULL DEFAULT '0', 
  `socgroupreqcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `pcunreadcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `pcmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `gmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0', 
  `ncode_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') DEFAULT NULL, 
  `ncode_imageresizer_maxwidth` smallint(5) unsigned DEFAULT NULL, 
  `ncode_imageresizer_maxheight` smallint(5) unsigned DEFAULT NULL, 
  `showcybstats` tinyint(1) NOT NULL DEFAULT '1', 
  `dbtech_thanks_likes` int(10) unsigned NOT NULL DEFAULT '0', 
  `dbtech_thanks_liked` int(10) unsigned NOT NULL DEFAULT '0', 
  `dbtech_thanks_thanks` int(10) unsigned NOT NULL DEFAULT '0', 
  `dbtech_thanks_thanked` int(10) unsigned NOT NULL DEFAULT '0', 
  `dbtech_thanks_dislikes` int(10) unsigned NOT NULL DEFAULT '0', 
  `dbtech_thanks_disliked` int(10) unsigned NOT NULL DEFAULT '0', 
  `likes_by_ali` int(10) unsigned NOT NULL DEFAULT '0', 
  `likes_receive_by_ali` int(10) unsigned NOT NULL DEFAULT '0', 
  `likes_send_by_ali` int(10) unsigned NOT NULL DEFAULT '0', 
  `field_mycl_1` varchar(255) NOT NULL, 
  `field_myhl` varchar(255) NOT NULL DEFAULT 'center', 
  `field_myfol` varchar(255) NOT NULL DEFAULT 'center', 
  `field_mymsh_1` varchar(255) NOT NULL, 
  `field_mymsh_2` varchar(255) NOT NULL, 
  `field_mymsh_3` varchar(255) NOT NULL, 
  `field_mymsh_1_n` varchar(255) NOT NULL, 
  `field_mymsh_2_n` varchar(255) NOT NULL, 
  `field_mymsh_3_n` varchar(255) NOT NULL, 
  `field_mym_test` varchar(255) NOT NULL, 
  `field_mym_test2` varchar(255) NOT NULL, 
  `field_mym_test3` varchar(255) NOT NULL, 
  `field_mypost` varchar(100) NOT NULL DEFAULT 'helm_legacy', 
  `field_mys` text NOT NULL, 
  `field_mym` varchar(255) NOT NULL, 
  `field_mynb` varchar(255) NOT NULL, 
  `field_myne` varchar(255) NOT NULL, 
  `field_mync` varchar(255) NOT NULL, 
  `field_mynf` varchar(255) NOT NULL, 
  `field_myns` varchar(255) NOT NULL, 
  `field_mynst` varchar(255) NOT NULL, 
  `field_mycl` text NOT NULL, 
  `field_myfo` varchar(255) NOT NULL, 
  `field_myh` varchar(255) NOT NULL, 
  `field_myso` varchar(255) NOT NULL, 
  `field_myy` varchar(255) NOT NULL, 
  `field_mych` varchar(255) NOT NULL DEFAULT '0', 
  `field_mym_d` varchar(255) NOT NULL, 
  `field_mym_c` varchar(255) NOT NULL DEFAULT 'އқ', 
  `field_mym_j` varchar(255) NOT NULL, 
  `field_mym_sk` varchar(255) NOT NULL, 
  `field_myl` text NOT NULL, 
  `sc_thumbs_notifcnt` int(4) unsigned NOT NULL DEFAULT '0', 
  `sc_thumbs_notifact` tinyint(1) NOT NULL DEFAULT '1', 
  `sc_thumbs_up_received` int(10) unsigned NOT NULL DEFAULT '0', 
  `sc_thumbs_down_received` int(10) unsigned NOT NULL DEFAULT '0', 
  `sc_thumbs_up_gave` int(10) unsigned NOT NULL DEFAULT '0', 
  `sc_thumbs_down_gave` int(10) unsigned NOT NULL DEFAULT '0', 
  `dbtech_thanks_points` int(10) NOT NULL DEFAULT '0', 
  `dbtech_thanks_settings` int(10) unsigned NOT NULL DEFAULT '0', 
  `dbtech_thanks_alertcount` int(10) unsigned NOT NULL DEFAULT '0', 
  PRIMARY KEY (`userid`), 
  KEY `usergroupid` (`usergroupid`), 
  KEY `username` (`username`), 
  KEY `birthday` (`birthday`,`showbirthday`), 
  KEY `birthday_search` (`birthday_search`), 
  KEY `referrerid` (`referrerid`) 
) ENGINE=MyISAM AUTO_INCREMENT=1155 DEFAULT CHARSET=latin1; 

What does this mean? And how i can fix it.

[Jaysds1]

Does the user have permission to do all of that?

[iPrestege]

Yes.

[Jaysds1]

What's the default?

  `field_mym_c` varchar(255) NOT NULL DEFAULT 'އқ', 
  

[AeroXbird]

Change your charset to something that supports the characters you intend to put in the database.

[iPrestege]

Thanks guys this was useful!