Forums

I have a form that I tried to save in create table and and received the attached database response error. If anyone has a solution it would be greatly appreciated. Everything was configured properly in events. I contacted my hosting company and they didn't have any idea what the issue was.

RyAbO

Hi eryabo,

Probably the total size of the column is too long:

There is a limit on the maximum size of a row. This is around 80 VARCHAR(255) columns, if you find that you can't create your table consider reducing the size of some of the VARCHAR columns.

from this FAQ

Bob

It worked like a charm! Thanks for the quick response. This may be a stupid question... attached documents is there a VARCHAR default or can I change it a minimum value?

Hi eryabo,

By an attached document you mean an uploaded file? I think that ChronoForms normally only saves the file name so VARCHAR(64) should be more than enough for any normal name.

Bob