I have successfully created two forms tied into the database. I get the following error when I try to create a database for a rather large form.
1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=CREATE TABLE IF NOT EXISTS `s3gxw_employment` ( `id` INT(11) NOT NULL auto_increment, `uniq_id` VARCHAR(50) NOT NULL, `user_id` INT(11) NOT NULL, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME DEFAULT NULL, `firstname` VARCHAR(255) NOT NULL, `middlename` VARCHAR(255) NOT NULL, `lastname` VARCHAR(255) NOT NULL, `address` VARCHAR(255) NOT NULL, `city` VARCHAR(255) NOT NULL, `state` VARCHAR(255) NOT NULL, `zip` VARCHAR(255) NOT NULL, `phone` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `eligible` VARCHAR(255) NOT NULL, `age` VARCHAR(255) NOT NULL, `transport` VARCHAR(255) NOT NULL, `job` VARCHAR(255) NOT NULL, `pay` VARCHAR(255) NOT NULL, `fulltime` VARCHAR(255) NOT NULL, `hours` VARCHAR(255) NOT NULL, `previousemploy` VARCHAR(255) NOT NULL, `whenemployed` VARCHAR(255) NOT NULL, `available` VARCHAR(255) NOT NULL, `nameother` VARCHAR(255) NOT NULL, `lastyrother` VARCHAR(255) NOT NULL, `gradother` VARCHAR(255) NOT NULL, `otherdiploma` VARCHAR(255) NOT NULL, `namecollege` VARCHAR(255) NOT NULL, `lastyrcollege` VARCHAR(255) NOT NULL, `gradcollege` VARCHAR(255) NOT NULL, `collegediploma` VARCHAR(255) NOT NULL, `refname1` VARCHAR(255) NOT NULL, `refoccupation1` VARCHAR(255) NOT NULL, `refaddress1` VARCHAR(255) NOT NULL, `refcity1` VARCHAR(255) NOT NULL, `refstate1` VARCHAR(255) NOT NULL, `refzip1` VARCHAR(255) NOT NULL, `refphone1` VARCHAR(255) NOT NULL, `refrelationship1` VARCHAR(255) NOT NULL, `refname2` VARCHAR(255) NOT NULL, `refoccupation2` VARCHAR(255) NOT NULL, `refaddress2` VARCHAR(255) NOT NULL, `refcity2` VARCHAR(255) NOT NULL, `refstate2` VARCHAR(255) NOT NULL, `refzip2` VARCHAR(255) NOT NULL, `refphone2` VARCHAR(255) NOT NULL, `refrelationship2` VARCHAR(255) NOT NULL, `refname3` VARCHAR(255) NOT NULL, `refoccupation3` VARCHAR(255) NOT NULL, `refaddress3` VARCHAR(255) NOT NULL, `refcity3` VARCHAR(255) NOT NULL, `refstate3` VARCHAR(255) NOT NULL, `refzip3` VARCHAR(255) NOT NULL, `refphone3` VARCHAR(255) NOT NULL, `refrelationship3` VARCHAR(255) NOT NULL, `childbefore` VARCHAR(255) NOT NULL, `agegroup` VARCHAR(255) NOT NULL, `willingwork` VARCHAR(255) NOT NULL, `enjoy` VARCHAR(255) NOT NULL, `qualities` VARCHAR(255) NOT NULL, `firstaid` VARCHAR(255) NOT NULL, `aidscert` VARCHAR(255) NOT NULL, `cpr` VARCHAR(255) NOT NULL, `cprcert` VARCHAR(255) NOT NULL, `sids` VARCHAR(255) NOT NULL, `sidscert` VARCHAR(255) NOT NULL, `employ1` VARCHAR(255) NOT NULL, `bustype1` VARCHAR(255) NOT NULL, `from1` VARCHAR(255) NOT NULL, `employedto1` VARCHAR(255) NOT NULL, `startpay1` VARCHAR(255) NOT NULL, `endpay1` VARCHAR(255) NOT NULL, `supervisor1` VARCHAR(255) NOT NULL, `supphone1` VARCHAR(255) NOT NULL, `reasonleft1` VARCHAR(255) NOT NULL, `employ2` VARCHAR(255) NOT NULL, `bustype2` VARCHAR(255) NOT NULL, `from2` VARCHAR(255) NOT NULL, `employedto2` VARCHAR(255) NOT NULL, `startpay2` VARCHAR(255) NOT NULL, `endpay2` VARCHAR(255) NOT NULL, `supervisor2` VARCHAR(255) NOT NULL, `supphone2` VARCHAR(255) NOT NULL, `reasonleft2` VARCHAR(255) NOT NULL, `employ3` VARCHAR(255) NOT NULL, `bustype3` VARCHAR(255) NOT NULL, `from3` VARCHAR(255) NOT NULL, `employedto3` VARCHAR(255) NOT NULL, `startpay3` VARCHAR(255) NOT NULL, `endpay3` VARCHAR(255) NOT NULL, `supervisor3` VARCHAR(255) NOT NULL, `supphone3` VARCHAR(255) NOT NULL, `reasonleft3` VARCHAR(255) NOT NULL, `employ4` VARCHAR(255) NOT NULL, `bustype4` VARCHAR(255) NOT NULL, `from4` VARCHAR(255) NOT NULL, `employedto4` VARCHAR(255) NOT NULL, `startpay4` VARCHAR(255) NOT NULL, `endpay4` VARCHAR(255) NOT NULL, `supervisor4` VARCHAR(255) NOT NULL, `supphone4` VARCHAR(255) NOT NULL, `reasonleft4` VARCHAR(255) NOT NULL, `file202` VARCHAR(255) NOT NULL, `file203` VARCHAR(255) NOT NULL, `file204` VARCHAR(255) NOT NULL, `legalname` VARCHAR(255) NOT NULL, `datesubmitted` VARCHAR(255) NOT NULL, `captcha` VARCHAR(255) NOT NULL, `submitbutton` VARCHAR(255) NOT NULL, `input_recordtime` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8;
Admittedly I am weak on database's. Any help that can be provided is greatly appreciated.
Thanks
1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=CREATE TABLE IF NOT EXISTS `s3gxw_employment` ( `id` INT(11) NOT NULL auto_increment, `uniq_id` VARCHAR(50) NOT NULL, `user_id` INT(11) NOT NULL, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME DEFAULT NULL, `firstname` VARCHAR(255) NOT NULL, `middlename` VARCHAR(255) NOT NULL, `lastname` VARCHAR(255) NOT NULL, `address` VARCHAR(255) NOT NULL, `city` VARCHAR(255) NOT NULL, `state` VARCHAR(255) NOT NULL, `zip` VARCHAR(255) NOT NULL, `phone` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `eligible` VARCHAR(255) NOT NULL, `age` VARCHAR(255) NOT NULL, `transport` VARCHAR(255) NOT NULL, `job` VARCHAR(255) NOT NULL, `pay` VARCHAR(255) NOT NULL, `fulltime` VARCHAR(255) NOT NULL, `hours` VARCHAR(255) NOT NULL, `previousemploy` VARCHAR(255) NOT NULL, `whenemployed` VARCHAR(255) NOT NULL, `available` VARCHAR(255) NOT NULL, `nameother` VARCHAR(255) NOT NULL, `lastyrother` VARCHAR(255) NOT NULL, `gradother` VARCHAR(255) NOT NULL, `otherdiploma` VARCHAR(255) NOT NULL, `namecollege` VARCHAR(255) NOT NULL, `lastyrcollege` VARCHAR(255) NOT NULL, `gradcollege` VARCHAR(255) NOT NULL, `collegediploma` VARCHAR(255) NOT NULL, `refname1` VARCHAR(255) NOT NULL, `refoccupation1` VARCHAR(255) NOT NULL, `refaddress1` VARCHAR(255) NOT NULL, `refcity1` VARCHAR(255) NOT NULL, `refstate1` VARCHAR(255) NOT NULL, `refzip1` VARCHAR(255) NOT NULL, `refphone1` VARCHAR(255) NOT NULL, `refrelationship1` VARCHAR(255) NOT NULL, `refname2` VARCHAR(255) NOT NULL, `refoccupation2` VARCHAR(255) NOT NULL, `refaddress2` VARCHAR(255) NOT NULL, `refcity2` VARCHAR(255) NOT NULL, `refstate2` VARCHAR(255) NOT NULL, `refzip2` VARCHAR(255) NOT NULL, `refphone2` VARCHAR(255) NOT NULL, `refrelationship2` VARCHAR(255) NOT NULL, `refname3` VARCHAR(255) NOT NULL, `refoccupation3` VARCHAR(255) NOT NULL, `refaddress3` VARCHAR(255) NOT NULL, `refcity3` VARCHAR(255) NOT NULL, `refstate3` VARCHAR(255) NOT NULL, `refzip3` VARCHAR(255) NOT NULL, `refphone3` VARCHAR(255) NOT NULL, `refrelationship3` VARCHAR(255) NOT NULL, `childbefore` VARCHAR(255) NOT NULL, `agegroup` VARCHAR(255) NOT NULL, `willingwork` VARCHAR(255) NOT NULL, `enjoy` VARCHAR(255) NOT NULL, `qualities` VARCHAR(255) NOT NULL, `firstaid` VARCHAR(255) NOT NULL, `aidscert` VARCHAR(255) NOT NULL, `cpr` VARCHAR(255) NOT NULL, `cprcert` VARCHAR(255) NOT NULL, `sids` VARCHAR(255) NOT NULL, `sidscert` VARCHAR(255) NOT NULL, `employ1` VARCHAR(255) NOT NULL, `bustype1` VARCHAR(255) NOT NULL, `from1` VARCHAR(255) NOT NULL, `employedto1` VARCHAR(255) NOT NULL, `startpay1` VARCHAR(255) NOT NULL, `endpay1` VARCHAR(255) NOT NULL, `supervisor1` VARCHAR(255) NOT NULL, `supphone1` VARCHAR(255) NOT NULL, `reasonleft1` VARCHAR(255) NOT NULL, `employ2` VARCHAR(255) NOT NULL, `bustype2` VARCHAR(255) NOT NULL, `from2` VARCHAR(255) NOT NULL, `employedto2` VARCHAR(255) NOT NULL, `startpay2` VARCHAR(255) NOT NULL, `endpay2` VARCHAR(255) NOT NULL, `supervisor2` VARCHAR(255) NOT NULL, `supphone2` VARCHAR(255) NOT NULL, `reasonleft2` VARCHAR(255) NOT NULL, `employ3` VARCHAR(255) NOT NULL, `bustype3` VARCHAR(255) NOT NULL, `from3` VARCHAR(255) NOT NULL, `employedto3` VARCHAR(255) NOT NULL, `startpay3` VARCHAR(255) NOT NULL, `endpay3` VARCHAR(255) NOT NULL, `supervisor3` VARCHAR(255) NOT NULL, `supphone3` VARCHAR(255) NOT NULL, `reasonleft3` VARCHAR(255) NOT NULL, `employ4` VARCHAR(255) NOT NULL, `bustype4` VARCHAR(255) NOT NULL, `from4` VARCHAR(255) NOT NULL, `employedto4` VARCHAR(255) NOT NULL, `startpay4` VARCHAR(255) NOT NULL, `endpay4` VARCHAR(255) NOT NULL, `supervisor4` VARCHAR(255) NOT NULL, `supphone4` VARCHAR(255) NOT NULL, `reasonleft4` VARCHAR(255) NOT NULL, `file202` VARCHAR(255) NOT NULL, `file203` VARCHAR(255) NOT NULL, `file204` VARCHAR(255) NOT NULL, `legalname` VARCHAR(255) NOT NULL, `datesubmitted` VARCHAR(255) NOT NULL, `captcha` VARCHAR(255) NOT NULL, `submitbutton` VARCHAR(255) NOT NULL, `input_recordtime` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8;
Admittedly I am weak on database's. Any help that can be provided is greatly appreciated.
Thanks