Basically, what happened is, during an update, we've included new features ,
which was also added to the database as new columns ( in this case 'file_location') in the 'wp_wpdatatables' table.
( wp_ prefix is the default WordPress table prefix,
but on your database, the table prefix might be different)
For some reason, the plugin couldn't create these columns, which resulted in the error - the plugin tried pulling the data, while the columns were never created.
To prevent this from happening again in the future, you can reach out to your hosting provider and have them check if the plugins have the necessary permissions to create/update database tables.
-
There are two ways we can fix this for you right now.
1. The easy way :
Please deactivate wpDataTables plugin,
purge cache on your site;
reactivate the plugin;
purge cache again,
and see if the issue goes away
2.
If the issue persists, i can easily add this column in your database, if you could grant me access to your WP-Admin and the database.
-
Please provide me a temporary WP-admin (administrator) user for your site where this happens,
and database access ( URL with credentials for PHPMyAdmin or cPanel access),
so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
When I try to save changes to any of my datatables in the backend it just creates an error message:
Unknown column 'file_location' in 'field list'
I can't make any changes to the tables nor create new ones. Please help!
Hi, Tomi
Sorry for the delay
-
Basically, what happened is, during an update, we've included new features ,
which was also added to the database as new columns ( in this case 'file_location') in the 'wp_wpdatatables' table.
( wp_ prefix is the default WordPress table prefix,
but on your database, the table prefix might be different)
For some reason, the plugin couldn't create these columns, which resulted in the error - the plugin tried pulling the data, while the columns were never created.
To prevent this from happening again in the future, you can reach out to your hosting provider and have them check if the plugins have the necessary permissions to create/update database tables.
-
There are two ways we can fix this for you right now.
1. The easy way :
Please deactivate wpDataTables plugin,
purge cache on your site;
reactivate the plugin;
purge cache again,
and see if the issue goes away
2.
If the issue persists, i can easily add this column in your database, if you could grant me access to your WP-Admin and the database.
-
Please provide me a temporary WP-admin (administrator) user for your site where this happens,
and database access ( URL with credentials for PHPMyAdmin or cPanel access),
so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
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
Hi!
Thanks for the fast and thorough answer! Deactivating and activating worked, but thanks for the recording anyway.
Have a great week!
-Tomi