+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Error on step 5 (/showthread.php?tid=533)
Pages:
1
2
Error on step 5 - Jorem - Feb 25th, 2010
Hullo,
Creating a multi page form with over 100 inputs via the API. At step 5 I get:
Code:
Error:
Failed query in ft_finalize_form, /home/xxx/xxxx/xxxx/formtools/global/code/forms.php, line 238:Code:
CREATE TABLE ft_form_2 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(255),
col_3 VARCHAR(255),
col_4 VARCHAR(255),
col_5 VARCHAR(255),
..etc until ...
col_169 VARCHAR(255),
submission_date DATETIME NOT NULL,
last_modified_date DATETIME NOT NULL,
ip_address VARCHAR(15),
is_finalized ENUM('yes','no') default 'yes')
TYPE=InnoDB DEFAULT CHARSET=utf8Code:
Debug:
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 BLOBsSo, is there a limit to the number of inputs?
Cheers,
Jorem
RE: Error on step 5 - Ben - Feb 25th, 2010
Hi Jorem,
What a pain. This is actually a limitation by your MySQL implementation - you'll need to either contact your hosting provider and ask them to increase the allowable row size for your database, or reduce the size of your form. Obviously the latter won't be possible, but you can try and reduce the total allocated space for each field - that may save enough space. Or, as the error message suggests: increase some field to "Large" for TEXT.
That said, I've seen this issue a few times now and Form Tools should handle the situation better. I've logged it as a bug here:
http://bugs.formtools.org/index.php?cmd=view&id=200
I won't be able to fix it within the script, but at least it could tell you up-front if the needed space is too large for your system.
- Ben
RE: Error on step 5 - Jorem - Feb 26th, 2010
(Feb 25th, 2010, 8:46 PM)Ben Wrote: Hi Jorem,Thanks a mill, Ben.
What a pain. This is actually a limitation by your MySQL implementation - you'll need to either contact your hosting provider and ask them to increase the allowable row size for your database, or reduce the size of your form. Obviously the latter won't be possible, but you can try and reduce the total allocated space for each field - that may save enough space. Or, as the error message suggests: increase some field to "Large" for TEXT.
That said, I've seen this issue a few times now and Form Tools should handle the situation better. I've logged it as a bug here:
http://bugs.formtools.org/index.php?cmd=view&id=200
I won't be able to fix it within the script, but at least it could tell you up-front if the needed space is too large for your system.
- Ben
I'll have a chat with my host.
Jorem
RE: Error on step 5 - aningbo - Sep 30th, 2013
how do i increase the field to LARGE?!!!
RE: Error on step 5 - Joe - Oct 4th, 2013
Form > Fields > go to the field you need to edit > Under Fields Size > Select "Large"
Cheers,
Joe
RE: Error on step 5 - aningbo - Oct 4th, 2013
now i see it. i had managed the form in another method and cutting the size. weird that i didn't notice this earlier. i was in that page!!
thank you.
RE: Error on step 5 - Joe - Oct 4th, 2013
No problem.
Cheers,
Joe
RE: Error on step 5 - Argen - Feb 28th, 2014
Hey chaps,
Which table is the one that needs to be changed to allow a larger row size?
Thanks
RE: Error on step 5 - HamStra - Mar 16th, 2020
When you start getting information to the code then you have the best option to get learning free in your home. And if you get any error during your oxbridge essays you have to right to put your question an make it easy for everyone if they also get the same problem.
RE: Error on step 5 - followersaustralia - Apr 12th, 2020
Hello, I am receiving an error on step 5: The table “{{inventory_source_item}}” for active record class “Mage2InventorySourceItem” cannot be . buy instagram followers cheap