I deleted a column in the MySQL table (thinking that's how I would remove it from WpDataTables) and ended up breaking my table. I think it's due to the IDs changing since the column I deleted was not the last column? Please see attachment.
Hello! I was able to solve this issue by restoring the column in MySQL and re-creating the table. However - this is what's happening...I've attached 4 screen shots.
1-"FileUpload" field is not mandatory.
2-When trying to submit the front end edit form, I get the message in the top/right that FileUpload cannot be null. (if I enter something in there, it works)
3-It is not set to "Cannot be empty"
4-It is not the ID column for editing, and I do not have any table relations setup.
Overall - what can be causing FileUpload to require input in order to save the row?
This could be related to the column's setup in the database.
Can you please check the database structure of the table, and see if it's set to "NOT NULL". If that's how the column is configured, the entry for this column would be mandatory in the database, and the plugin is relying on that as well.
I deleted a column in the MySQL table (thinking that's how I would remove it from WpDataTables) and ended up breaking my table. I think it's due to the IDs changing since the column I deleted was not the last column? Please see attachment.
Hello! I was able to solve this issue by restoring the column in MySQL and re-creating the table. However - this is what's happening...I've attached 4 screen shots.
1-"FileUpload" field is not mandatory.
2-When trying to submit the front end edit form, I get the message in the top/right that FileUpload cannot be null. (if I enter something in there, it works)
3-It is not set to "Cannot be empty"
4-It is not the ID column for editing, and I do not have any table relations setup.
Overall - what can be causing FileUpload to require input in order to save the row?
Thanks so much.
Hello Andrew
This could be related to the column's setup in the database.
Can you please check the database structure of the table, and see if it's set to "NOT NULL". If that's how the column is configured, the entry for this column would be mandatory in the database, and the plugin is relying on that as well.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables