0

Anybody know how to fix this? Every time I save a form (creating forms) I get this error. System drops all of my changes. Started yesterday.

EE Version Installed: 2.10.0 Forms Version 3.5.2

A Database Error Occurred Error Number: 1117

Too many columns

ALTER TABLE exp_forms_entries ADD fid_3189 TEXT NULL

Filename: third_party/forms/models/forms_model.php

Line Number: 210

0

https://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html

Unfortunately, it's right there in the docs, my friend. And your error is self-explanatory. Hard limit is 4096 (for MyISAM), or 1000 (for InnoDB), but EE defaults to MyISAM. The functional limit is actually less:

https://www.percona.com/blog/2013/04/08/understanding-the-maximum-number-of-columns-in-a-mysql-table/

This is why FreeForm, upon going from 3.x to 4.x, switched from having one table with expanding columns when adding forms, to giving each form it's own table. If Devdemon Forms does it's job correctly, when you delete old forms, this should delete the field ids for those forms. I don't know, I haven't personally used Devdemon Forms. But try it; remove some old forms, or specifically (if Forms doesn't directly relate forms owning specific fields) remove fields from your Devdemon install. Check the docs for how to do this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.