I enjoy your plugin for over a year now. I already made 50 tables and charts. Always with a seperate mysql connection to query an external database.
I'm running into a small problem now. Except for 2 extra tables I don't want to make use of the external datasource but I need the Wordpress database. So I went to 'Create a table' and chose 'Generate a query to WordPress database'. I assumed it automaticly would establish a connection with my wordpress database and not with the external database.
My assumption was wrong. I couldn't query the wordpress database. I had to switch off the external connection to let the 2 extra reports work. But after switching off the external connection my other 50 tables (not surprisingly) weren't working anymore.
Could you tell me how I can make the 2 extra tables work without switching off the external database connection?
HI Scholto Bos, Thank your purchase and your trust in our product.
Glad to hear that you are enjoying it.
For next update of our plugin we implemented and increased a separate my sql connection feature and you will be able to choose separate mysql connection per table which in this case will solve your issue.
Hi Guys,
I enjoy your plugin for over a year now. I already made 50 tables and charts. Always with a seperate mysql connection to query an external database.
I'm running into a small problem now. Except for 2 extra tables I don't want to make use of the external datasource but I need the Wordpress database. So I went to 'Create a table' and chose 'Generate a query to WordPress database'. I assumed it automaticly would establish a connection with my wordpress database and not with the external database.
My assumption was wrong. I couldn't query the wordpress database. I had to switch off the external connection to let the 2 extra reports work. But after switching off the external connection my other 50 tables (not surprisingly) weren't working anymore.
Could you tell me how I can make the 2 extra tables work without switching off the external database connection?
Thanks in avance.
HI Scholto Bos,
Thank your purchase and your trust in our product.
Glad to hear that you are enjoying it.
For next update of our plugin we implemented and increased a separate my sql connection feature and you will be able to choose separate mysql connection per table which in this case will solve your issue.
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
Great mate!