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 ;
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 ;