I've set up two forms, both are writing to a mySQL DB. One form works, the other fails. Both are using the same DB. Both are using reCaptcha. The working form is pretty straightforward. No conditional statements. It writes to all the fields, sends the emails.
The other form has conditionals in it. No information is sent to the DB. But if you choose to upload an image it will write those fields.
This is the error on screen:
"Failed to execute query associated to this form."

This is what is in the fb_error.log.php:

<?php echo 'Access denied.'; exit(); ?>
Thu, 09 May 2013 23:03:28 +0000: DataSaveMySQL hit upon an unhandled field type: captcha
Thu, 09 May 2013 23:03:28 +0000: Failed to execute query on table: not_working(CREATE TABLE `not_working`(_rowid_ int(11) NOT NULL AUTO_INCREMENT,`first_name` varchar(255) NOT NULL DEFAULT '',`last_name` varchar(255) NOT NULL DEFAULT '',`user_email` varchar(255) NOT NULL DEFAULT '',`product_select` varchar(255) NOT NULL DEFAULT '',`option_select` varchar(255) NOT NULL DEFAULT '',`uploaded_file` varchar(255) NOT NULL DEFAULT '',`more_info` varchar(10000) NOT NULL DEFAULT '',`image_location` varchar(10000) NOT NULL DEFAULT '',`design_request` varchar(10000) NOT NULL DEFAULT '',`_submitted_` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',`_fromaddress_` varchar(128) NOT NULL DEFAULT '0.0.0',`_flags_` int(11) NOT NULL DEFAULT '0',`_transactid_` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY ( _rowid_ ) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 [0] 42000 [1] 1118 [2] 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

If I set this form to save as a CSV it works fine.

Did you enter a different table for each form to write to?

My understanding of WFB is that you start with a blank database and the first time you run the form then WFB creates the tables. It may simply be that you cannot have 2 forms using the same DB because WFB will see that it's not empty when the second form executes. And it will have different tables than the first.

I could be wrong, my horse is giving me that funny look again...

Yes each form has a different table name.
These are not the forms currently on my website, they are both using CSV at the moment.
I would attach the .fb files but they are above the 100k limit.

You can have two forms write to the same table.
I would dbl check you mysql connection settings in each form.

I went ahead and opened a support ticket on this.

Well, I got an answer on just what was causing this.

This is what Scott said:
"This is an issue that will be fixed in the next update. The issue is with the Text Area elements on your form. You either have a single one or multiple ones with a max character count of over 65535 which is the max MySQL can handle for a BLOB. To fix that, just make the total character count for all Text Area elements to around 50,000."

Yippie!! Scott and everyone at CoffeeCup and on these forums are the best!

This is not working for me.. issues.. same error message.. not one field is over the 634000 the three text areas I have at max size of 400.. still getting error.

I'll assume you have, but I have to ask the obvious question first to be sure since the last post was 1 1/2 years ago. Have you upgraded to the latest version? Not sure if a version has fixed this or not, but again I'll assume it has and that maybe you need to just upgrade your program to get it working correctly. If you have already let us know, and I would then put a support ticket in to CoffeeCup rather than posting here on the forums.

apologies for resurrecting this old thread but i was banging my head against the wall on this problem for a couple days and was an easy fix but would have been nice to find it here...

Apparently, when WFB writes a varchar() it always creates it as varchar(255) instead of what we insert as character limits. So, once the sum of all varchar() fields in that table reach 65535, the add fails. i had to go into the table and manually change about 60 varchar() values and then my updated form worked.

Is there a way an easy update could be made to fix this problem?? My version is 2.4 (5318)

does this sound like a correct assumption?