I had to change my db table prefix. (on a staging website, to be on par with production website).
But .. your am_wpdatacharts is containing table name including prefix !
(which is a bad idea, since prefix is supposed to be set by wp-config.php : so you should store only tablename without prefix, and grab prefix from wp-config.php)
Now that I understood that, I changed mysql_table_name column in am_wpdatatable table, but I still have error message
Error in WordPress database : [Table 'wordpress_r.bC5OLCt86_wpdatatable_1' doesn't exist] SELECT * FROM bC5OLCt86_wpdatatable_1
Hi,
I had to change my db table prefix. (on a staging website, to be on par with production website).
But .. your am_wpdatacharts is containing table name including prefix !
(which is a bad idea, since prefix is supposed to be set by wp-config.php : so you should store only tablename without prefix, and grab prefix from wp-config.php)
Now that I understood that, I changed mysql_table_name column in am_wpdatatable table, but I still have error message
Error in WordPress database : [Table 'wordpress_r.bC5OLCt86_wpdatatable_1' doesn't exist]
SELECT * FROM bC5OLCt86_wpdatatable_1
bC5OLCt86 being the OLD prefix.
Is there a cache somewhere that I can reset ?
thanks !
- Arnaud
Hi Arnaud,
Thank you for your purchase.
Can you please tell me did you try to crate a table without that old prefix
Just
SELECT * FROM wp_wpdatatable_1
Best regards.
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