Saving to a MySQL database - Page 4 -...

User 187934 Photo


Senior Advisor
20,239 posts

Hi GG,
Make sure you don't have any inputs names starting with a number.
In the Form Builder you may have inputs named 01.
Change it to something like a01 or what ever you prefer.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2947074 Photo


Registered User
27 posts

Eric Rohloff,

Thank you for responding, I did put the letters up front and a single number at the end, if need. My application is pretty long. Most of it will look like this. This what was on my error Page.

<?php echo 'Access denied.'; exit(); ?>
Mon, 18 May 2020 05:53:42 +0000: Failed to execute query on table: Application(CREATE TABLE `Application`(_rowid_ int(11) NOT NULL AUTO_INCREMENT,
`firstname1` varchar(255) NOT NULL DEFAULT '',
`lastname2` varchar(255) NOT NULL DEFAULT '',
`middelname3` varchar(255) NOT NULL DEFAULT '',
`suffix4` varchar(255) NOT NULL DEFAULT '',
`homephonenumber` varchar(255) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
_transactid_ (varchar, 255) NOT NULL DEFAULT '',
_fromaddress_ (varchar, 255) NOT NULL DEFAULT '0.0.0',
_flags_ (int, 225) NOT NULL DEFAULT '0',
_submitted_ (VARCHAR, 255)
_rowid_ (int, 40) 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. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
User 187934 Photo


Senior Advisor
20,239 posts

This user had the same error.
https://www.coffeecup.com/forums/web-fo … post287872
Did you delete the original table or change its name?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2947074 Photo


Registered User
27 posts

Eric Rohloff,

I read the link. I did the same thing I change all my Questions to Q1 thought out my questions. I have about 400 question Most of them are repeats. I still get the same Error.

I was thinking to split in different departments by using the redirect to another URL, but Im not to sure if I can with this form, because If a customer fills the forms out I would think they have to re enter their information because it another form?

My form is a Job Application its Pretty long and It would have to have the same person information. So I wont get confuse when they fill out the form with another form though the emails, because multi people will fill out this form.
User 187934 Photo


Senior Advisor
20,239 posts

Did you delete the table and start over?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2947074 Photo


Registered User
27 posts

Eric Rohloff
Iv done it all. It still not working. Might have to find a new form builder.
User 187934 Photo


Senior Advisor
20,239 posts

Can you share your form project?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2947074 Photo


Registered User
27 posts

Sorry I took everything off my website. right now

I just talk to my host and I need to change varchar to text any way on doing this.

User 187934 Photo


Senior Advisor
20,239 posts

Keep us posted.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.