Forums

Problems creating a table

petermazzi 02 Mar, 2011
Hi there,

I tried to create a table for a multipage form, and I get the following error:

Error while creating table :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 `jos_chronoforms_DCI_mothera` (`cf_id` INT(11) NOT NULL auto_increment, `uid` VARCHAR(255) NOT NULL, `recordtime` VARCHAR(255) NOT NULL, `ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` VARCHAR(255) NOT NULL, `text_1` VARCHAR(255) NOT NULL, `text_2` VARCHAR(255) NOT NULL, `text_3` VARCHAR(255) NOT NULL, `text_4` VARCHAR(255) NOT NULL, `text_5` VARCHAR(255) NOT NULL, `text_6` VARCHAR(255) NOT NULL, `text_7` VARCHAR(255) NOT NULL, `text_8` VARCHAR(255) NOT NULL, `text_9` VARCHAR(255) NOT NULL, `text_10` VARCHAR(255) NOT NULL, `text_11` VARCHAR(255) NOT NULL, `text_12` VARCHAR(255) NOT NULL, `text_13` VARCHAR(255) NOT NULL, `text_15` VARCHAR(255) NOT NULL, `text_16` VARCHAR(255) NOT NULL, `text_17` VARCHAR(255) NOT NULL, `text_18` VARCHAR(255) NOT NULL, `text_19` VARCHAR(255) NOT NULL, `text_20` VARCHAR(255) NOT NULL, `text_21` VARCHAR(255) NOT NULL, `text_22` VARCHAR(255) NOT NULL, `text_23` VARCHAR(255) NOT NULL, `text_24` VARCHAR(255) NOT NULL, `text_25` VARCHAR(255) NOT NULL, `text_26` VARCHAR(255) NOT NULL, `text_27` VARCHAR(255) NOT NULL, `text_28` VARCHAR(255) NOT NULL, `text_29` VARCHAR(255) NOT NULL, `text_30` VARCHAR(255) NOT NULL, `text_31` VARCHAR(255) NOT NULL, `text_32` VARCHAR(255) NOT NULL, `text_33` VARCHAR(255) NOT NULL, `text_34` VARCHAR(255) NOT NULL, `text_35` VARCHAR(255) NOT NULL, `text_36` VARCHAR(255) NOT NULL, `text_37` VARCHAR(255) NOT NULL, `text_38` VARCHAR(255) NOT NULL, `text_39` VARCHAR(255) NOT NULL, `radio0` VARCHAR(255) NOT NULL, `text_40` VARCHAR(255) NOT NULL, `radio1` VARCHAR(255) NOT NULL, `text_41` VARCHAR(255) NOT NULL, `text_42` VARCHAR(255) NOT NULL, `text_43` VARCHAR(255) NOT NULL, `text_44` VARCHAR(255) NOT NULL, `text_45` VARCHAR(255) NOT NULL, `text_46` VARCHAR(255) NOT NULL, `text_47` VARCHAR(255) NOT NULL, `text_48` VARCHAR(255) NOT NULL, `select_1` VARCHAR(255) NOT NULL, `radio2` VARCHAR(255) NOT NULL, `text_49` VARCHAR(255) NOT NULL, `text_50` VARCHAR(255) NOT NULL, `text_51` VARCHAR(255) NOT NULL, `text_52` VARCHAR(255) NOT NULL, `text_53` VARCHAR(255) NOT NULL, `text_54` VARCHAR(255) NOT NULL, `text_55` VARCHAR(255) NOT NULL, `text_56` VARCHAR(255) NOT NULL, `text_57` VARCHAR(255) NOT NULL, `text_58` VARCHAR(255) NOT NULL, `text_59` VARCHAR(255) NOT NULL, `text_60` VARCHAR(255) NOT NULL, `text_61` VARCHAR(255) NOT NULL, `text_62` VARCHAR(255) NOT NULL, `text_63` VARCHAR(255) NOT NULL, `text_64` VARCHAR(255) NOT NULL, `text_65` VARCHAR(255) NOT NULL, `text_66` VARCHAR(255) NOT NULL, `text_67` VARCHAR(255) NOT NULL, `text_68` VARCHAR(255) NOT NULL, `radio3` VARCHAR(255) NOT NULL, `text_69` VARCHAR(255) NOT NULL, `text_70` VARCHAR(255) NOT NULL, `text_71` VARCHAR(255) NOT NULL, `text_72` VARCHAR(255) NOT NULL, `text_73` VARCHAR(255) NOT NULL, `text_74` VARCHAR(255) NOT NULL, `text_75` VARCHAR(255) NOT NULL, `text_76` VARCHAR(255) NOT NULL, `text_77` VARCHAR(255) NOT NULL, `text_78` VARCHAR(255) NOT NULL, `text_79` VARCHAR(255) NOT NULL, `text_80` VARCHAR(255) NOT NULL, `text_81` VARCHAR(255) NOT NULL, `text_82` VARCHAR(255) NOT NULL, `text_83` VARCHAR(255) NOT NULL, `text_84` VARCHAR(255) NOT NULL, `text_85` VARCHAR(255) NOT NULL, `text_86` VARCHAR(255) NOT NULL, `text_87` VARCHAR(255) NOT NULL, `radio4` VARCHAR(255) NOT NULL, `text_88` VARCHAR(255) NOT NULL, `text_89` VARCHAR(255) NOT NULL, `text_90` VARCHAR(255) NOT NULL, `text_91` VARCHAR(255) NOT NULL, `text_92` VARCHAR(255) NOT NULL, `text_110` VARCHAR(255) NOT NULL, `text_93` VARCHAR(255) NOT NULL, `text_94` VARCHAR(255) NOT NULL, `text_95` VARCHAR(255) NOT NULL, `text_96` VARCHAR(255) NOT NULL, `text_97` VARCHAR(255) NOT NULL, `text_98` VARCHAR(255) NOT NULL, `text_99` VARCHAR(255) NOT NULL, `text_100` VARCHAR(255) NOT NULL, `text_101` VARCHAR(255) NOT NULL, `text_102` VARCHAR(255) NOT NULL, `text_103` VARCHAR(255) NOT NULL, `text_104` VARCHAR(255) NOT NULL, `text_105` VARCHAR(255) NOT NULL, `text_106` VARCHAR(255) NOT NULL, `text_107` VARCHAR(255) NOT NULL, `select_2` VARCHAR(255) NOT NULL, `select_3` VARCHAR(255) NOT NULL, `select_4` VARCHAR(255) NOT NULL, `select_5` VARCHAR(255) NOT NULL, `select_6` VARCHAR(255) NOT NULL, `select_7` VARCHAR(255) NOT NULL, `select_8` VARCHAR(255) NOT NULL, `select_9` VARCHAR(255) NOT NULL, `select_10` VARCHAR(255) NOT NULL, `select_11` VARCHAR(255) NOT NULL, `select_12` VARCHAR(255) NOT NULL, `select_13` VARCHAR(255) NOT NULL, `check0` VARCHAR(255) NOT NULL, `text_108` VARCHAR(255) NOT NULL, `check1` VARCHAR(255) NOT NULL, `check2` VARCHAR(255) NOT NULL, `radio5` VARCHAR(255) NOT NULL, `radio6` VARCHAR(255) NOT NULL, `text_109` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;
GreyHead 02 Mar, 2011
Hi petermazzi,

I think that it is self-explanatory, you need to set some of the columns to use smaller data formats than VARCHAR(255), or if they are really big entries to TEXT or BLOB but this is unlikely.

Bob
This topic is locked and no more replies can be posted.