Hi all

Need a hand if I can ask,
URL of WebForm
http://www.ogs.on.ca/conference2014/mar … ration.php

getting this error:
Your form could not be submitted for the following reason(s):
Warning: [ err 2/line 84/utilities.inc.php] error_log(/home/ogs/public_html/conference2014/market/Marketplace Registration/storage/fb_error.log.php) [<a href='function.error-log'>function.error-log</a>]: failed to open stream: Permission denied
Failed to execute query associated to this form.

Copy of Error Log

Sat, 28 Sep 2013 02:58:24 +0000: Failed to execute query on table: marketplace(CREATE TABLE `marketplace`(_rowid_ int(11) NOT NULL AUTO_INCREMENT,`whoyouare` varchar(255) NOT NULL DEFAULT '',`select17` varchar(255) NOT NULL DEFAULT '',`select18` varchar(255) NOT NULL DEFAULT '',`select19` varchar(255) NOT NULL DEFAULT '',`text39` varchar(255) NOT NULL DEFAULT '',`text26` varchar(255) NOT NULL DEFAULT '',`text24` varchar(255) NOT NULL DEFAULT '',`text27` varchar(255) NOT NULL DEFAULT '',`text83` varchar(255) NOT NULL DEFAULT '',`prostat` varchar(255) NOT NULL DEFAULT '',`country` varchar(255) NOT NULL DEFAULT '',`poszip` varchar(255) NOT NULL DEFAULT '',`dayphonenum` varchar(255) NOT NULL DEFAULT '',`evephonenum` varchar(255) NOT NULL DEFAULT '',`email30` varchar(255) NOT NULL DEFAULT '',`textarea31` varchar(10000) NOT NULL DEFAULT '',`radio32` varchar(255) NOT NULL DEFAULT '',`radio33` varchar(255) NOT NULL DEFAULT '',`text34` varchar(255) NOT NULL DEFAULT '',`radio38` varchar(255) NOT NULL DEFAULT '',`radio36` varchar(255) NOT NULL DEFAULT '',`text37` varchar(255) NOT NULL DEFAULT '',`banquet` varchar(255) NOT NULL DEFAULT '',`banquetnumber` int(11),`allergy` varchar(255) NOT NULL DEFAULT '',`textarea117` varchar(10000) NOT NULL DEFAULT '',`meals` varchar(255) NOT NULL DEFAULT '',`mealsfriday` varchar(255) NOT NULL DEFAULT '',`mealssaturday` varchar(255) NOT NULL DEFAULT '',`mealssun` varchar(255) NOT NULL DEFAULT '',`allergy2` varchar(255) NOT NULL DEFAULT '',`textarea119` varchar(10000) NOT NULL DEFAULT '',`fridayamwork` varchar(255) NOT NULL DEFAULT '',`fridaypmwork` varchar(255) NOT NULL DEFAULT '',`radio63` varchar(255) NOT NULL DEFAULT '',`radio156` varchar(255) NOT NULL DEFAULT '',`sat1sess` varchar(255) NOT NULL DEFAULT '',`sat2sess` varchar(255) NOT NULL DEFAULT '',`sat3sess` varchar(255) NOT NULL DEFAULT '',`sat4sess` varchar(255) NOT NULL DEFAULT '',`sun1sess` varchar(255) NOT NULL DEFAULT '',`sun2sess` varchar(255) NOT NULL DEFAULT '',`sun3sess` varchar(255) 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

Did a search on the forum but having some issues understanding if this is the right solution.
Thanks

Steve Fulton

If your using mysql for holding data submissions you need to create the database on the server but not the table. Let the first submission of the form do that for you. Also if your using the csv option make sure that the storage directory actually exists on the server.

Thanks but the database has be created and I created a smaller form in the same capacity and it works with no issues. It created the table as well

url: http://www.ogs.on.ca/conference2014/web … ration.php

Thanks
Steve

Try deleting the table and submitting the form. Also did you check on the storage directory?

The table will not create on the first submission - Not sure what you mean storage folder as this is being written to a MYSQL Database and not a CSV file

Thanks

Steve

Sounds like you have one of your settings wrong for access to the database. I would dbl check to make sure there's no spaces or wrong entries.

Ok thanks, i will check

Steve

Also make sure the user has full permissions for writing to the database.