Hello, I've tried a lot of things, but I can't find a solution. I have added my own table from which I read and display the data. The goal is that the users have to add missing information here. In the frontend I can open the cell via inline-editing and enter a value. But when saving, I get the error message "Error! There was an error trying to insert a new row".
Only one table is queried, the setting is "Users see and edit only own data". Do you have another idea for me? Oh yes, I am currently developing the site locally in a development environment, I can't put it online very well, there are still some features missing.
Hello, I have found a workaround for me. There are two Datetime fields in the table which are currently empty. I plan to fill them with an action as soon as they are changed by the user. wpdatatables will fail with the error in debug.log when saving the empty datetime:
PHP Fatal error: Uncaught Error: Call to a member function format() on boolean in /home/vagrant/agtraum/agt-website/public/wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php:322
Stack trace:
I have excluded the columns from my wpdatatables and now I can save :D Maybe it will help someone else who has the same mistakes.
Thank you for your purchase, and for your feedback.
If you don't have a row with your ID in it, and you've enabled "Users see and edit only own data", that's the reason why you're getting the error.
Simply put, you're trying to save a table that (from the plugin's point of view) is empty, and it's throwing an error. If you had one row with your ID associated to the selected "User ID" column, then I suppose there would be no issue.
Hello, I've tried a lot of things, but I can't find a solution. I have added my own table from which I read and display the data. The goal is that the users have to add missing information here. In the frontend I can open the cell via inline-editing and enter a value. But when saving, I get the error message "Error! There was an error trying to insert a new row".
Only one table is queried, the setting is "Users see and edit only own data". Do you have another idea for me?
Oh yes, I am currently developing the site locally in a development environment, I can't put it online very well, there are still some features missing.
Hello, I have found a workaround for me. There are two Datetime fields in the table which are currently empty. I plan to fill them with an action as soon as they are changed by the user. wpdatatables will fail with the error in debug.log when saving the empty datetime:
I have excluded the columns from my wpdatatables and now I can save :D Maybe it will help someone else who has the same mistakes.
The ticket can be closed. Thanks a lot
Hi MonaH
Thank you for your purchase, and for your feedback.
If you don't have a row with your ID in it, and you've enabled "Users see and edit only own data", that's the reason why you're getting the error.
Simply put, you're trying to save a table that (from the plugin's point of view) is empty, and it's throwing an error. If you had one row with your ID associated to the selected "User ID" column, then I suppose there would be no issue.
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