I just updated from mysql 5.5 to mysql 5.7. Now I get the following error on date fields in wpdatatables:
"There was an error trying to insert a new row! Error: Incorrect date value: 'NULL' for column 'RMARequestDate' at row 1"
The mysql column I want to add is a date column with NULL value possible. Adding a new row with the specified column as NULL in mysql directly or in phpmyadmin is possible. But wpdatatables seems to not allow adding NULL values to date fields.
All other fields except date fields seem to work.
Is there any possibility to get a sql output from wpdatatables, so that I can see what's going wrong?
I just updated from mysql 5.5 to mysql 5.7. Now I get the following error on date fields in wpdatatables:
"There was an error trying to insert a new row! Error: Incorrect date value: 'NULL' for column 'RMARequestDate' at row 1"
The mysql column I want to add is a date column with NULL value possible. Adding a new row with the specified column as NULL in mysql directly or in phpmyadmin is possible. But wpdatatables seems to not allow adding NULL values to date fields.
All other fields except date fields seem to work.
Is there any possibility to get a sql output from wpdatatables, so that I can see what's going wrong?
Hi kbartl,
Thank you for your purchase.
Can you please tell me which version of our plugin do you use?
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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