Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, 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.
I am pleased to say that we have fixed all issues for you, and for Tomi on that site as well ( on a separate ticket).
Basically, what happened is, during an update, we've included new features ,
which was also added to the database as new columns 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.
-
I took the liberty to install WP PhPMyAdmin on your WordPress, and i have fixed all the missing data/added the columns,
now everything works without issues. ( i removed the said plugin afterwards)
-
Please check and let us know if everything is working as it should. Thank you
Since updating to 5.1 I get the same error when trying to edit any table.
Unknown column 'var5' in 'field list'
This is making it impossible to update any setting within my tables.
Hi, Bob
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, 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!
I have the same issue. Any updates on how to fix this?
Hi, Bob , and Tomi.
Firstly my sincere apology for the waiting time.
I am pleased to say that we have fixed all issues for you, and for Tomi on that site as well ( on a separate ticket).
Basically, what happened is, during an update, we've included new features ,
which was also added to the database as new columns 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.
-
I took the liberty to install WP PhPMyAdmin on your WordPress, and i have fixed all the missing data/added the columns,
now everything works without issues. ( i removed the said plugin afterwards)
-
Please check and let us know if everything is working as it should. 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