miquelpontes

Developer has produced a new version (1.21.2.1) of the Out-of-the-box plugin that solves the problem.

Solution provided was: “I think that I managed to resolve the issue by placing the 3rd party library in the ‘namespace’ of Out-of-the-Box”.

Good news from the Out-of-the-Box plugin developer:

I can indeed reproduce the issue. It is a bit technical to explain what exactly happens, but the two plugins basically share some script libraries which are in conflict with each other. This is one of the drawbacks of using WordPress, as each plugin will have to load their own 3rd party script libraries, which can easily cause situations like this. Just a small difference in script version can already cause this problem.
Nevertheless, I will try to update the plugin today so that the script library Out-of-the-Box loads can only strictly be used by Out-of-the-Box. I will keep you informed!

I have tried and alternative access and finally reached their support team, and they are already investigating the problem. Hope to have good news soon.

Developers of the WP Cloud Plugin Out-of-the-Box (Dropbox) ask for a lot of money to even begin talking to me. Is there a way to get a log of what is happening here? Obviously there’s a conflict among these two plugins. I’m considering the situation as a whole.

Hi @joeyoungblood , apologies for not answering earlier.
I have tried deactivating both Complianz and Jetpack but the problem persisted. Then I checked which other plugins have been updated in the time range the problem appeared, and I think I found it:
The plugin “WP Cloud Plugin Out-of-the-Box (Dropbox)” version 1.21.1 by “WP Cloud Plugins” seems to be the one causing the conflict. If I deactivate this plugin, WPBI works flawelessly, but reactivating it causes the website to break because of WPBI. Deactivating WPBI makes the website to work just fine (but the WPBI charts). Previous versions of that Dropbox plugin had no conflict with WPBI. Any ideas?

Thanks for the update Rogier, as the blocking worked, we decided to wait for the upcoming Complianz update. Cheers !

Issue is solved.

Adding a Blocking for Flexible Maps script worked just fine, thank you !

Done !!

Guess you fixed it. Now I can edit the charts. Thank you very much !!

I updated the plugin to version 3.1.6 and now I can see bar chart values when hovering the mouse pointer over them, that didn’t work previously. Thank you very much.

Regarding the error when accessing the CHARTS menu option in the Admin Panel, it’s still showing a Critical error when trying to access it. WordPress sent me a detail of the error:

′When seeking help with this issue, you may be asked for some of the following information:
WordPress version 5.7
Current theme: Tempera (version 1.7.2)
Current plugin: WP Business Intelligence (version 3.1.6)
PHP version 7.4.15

Error Details
=============
An error of type E_ERROR was caused in line 662 of the file /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php. Error message: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'opistobr_mUHqxI.wp_wpbi_grouped_bar_charts' doesn't exist in /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php:319
Stack trace:
#0 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php(319): PDO->prepare('select * from ′...')
#1 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php(655): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select * from ′...', Array)
#2 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php(618): Illuminate\Database\Connection->runQueryCallback('select * from ′...', Array, Object(Closure))
#3 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illumina

This error mentions a missing table in the database:

• wp_wpbi_grouped_bar_charts

The only existing tables are these:

• wp_wpbi_bar_charts
• wp_wpbi_database_connections
• wp_wpbi_datatables
• wp_wpbi_phinx_log
• wp_wpbi_pie_charts
• wp_wpbi_queries3

Hi, sorry about the delay. Provoking an error is easy “as is”, here’s the “loom” as requested:

After updating the site to WordPress 5.7 the error persists, but WordPress seems to contain the error effects and does not deactivate the plugin anymore, only that I can’t configure already made charts. However, these charts do work nicely across the site.

Thanks for your answer. Yes you understood it well, but I understand I’m not exceeding original plugin specifications as there is the possibility to include certain system variables in the queries. In the query page there’s this statement:

You may insert the following placeholders in your query to have them replaced with WordPress variables:

Variable	Description	Notes
:user_id	the current user ID	returns 0 if there is no user logged in
:user_login	the current user login	returns empty string if there is no user logged in
:user_email	the current user email address	returns empty string if there is no user logged in
:post_id	the current post/page id	only works in the loop, otherwise returns 0
:blog_id	the current site id	used for multisite. Always returns an Integer

Certainly it seems I used the plugin to the limit, but I didn’t modified the plugin at all. So far it only fails in the admin screen, because our website uses this chart on almost every post and runs admirably well.

This plugin’s ability to dinamically query a custom table in the database makes it unique and provided the exact solution I needed, I don’t know of any other plugin able to do this. In fact I’m still searching a map plugin with a similar approach to plot database stored GPS coordinates in Google Maps.

Thanks for your time.

Thank you very much for your reply. After updating I have investigated further, and WordPress sent me detailed error information when it encountered a problem (i.e. accessing the Chart dialog from Admin panel results now in a critical error. But accessing queries works fine.

Perhaps the problem is I use a “creative approach” using your plugin and that is the Query is parametrized by having the actual pageID as a parameter to create the chart; this is the actual query I use:

SELECT wp_opistoFecha.mes, wp_opistoFecha.descripCA, COUNT(wp_opistobase.ID) FROM wp_opistoFecha LEFT JOIN wp_opistobase ON (wp_opistoFecha.mes = wp_opistobase.month) and (wp_opistobase.ID=:post_id) group by wp_opistoFecha.mes ORDER BY wp_opistoFecha.mes

You see the clause (wp_opistobase.ID=:post_id) where :post_id is the code of the actual page the chart is showing in.

This “parametrized use” posed problems in previous versions of the plugin because I couldn’t dynamically “try” the charts before publishing, so I had to change this parameter for the number corresponding to an existing post, but after it worked as I wanted, I changed the number for the parameter and it worked just fine.

It still works fine, but I can’t edit the chart anymore.

When I click the chart in Admin Panel I get a critical error, WordPress kicks in Recovery mode, and I get an email with the error description.

Here is the error:

When seeking help with this issue, you may be asked for some of the following information:
WordPress version 5.6.2
Current theme: Tempera (version 1.7.2)
Current plugin: WP Business Intelligence (version 3.1.4)
PHP version 7.4.14

Error Details
=============
An error of type E_ERROR was caused in line 662 of the file /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php. Error message: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'opistobr_mUHqxI.wp_wpbi_grouped_bar_charts' doesn't exist in /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php:319
Stack trace:
#0 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php(319): PDO->prepare('select * from...')
#1 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php(655): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select * from ...', Array)
#2 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illuminate/database/Connection.php(618): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure))
#3 /home2/opistobr/public_html/wp-content/plugins/wp-business-intelligence-lite/vendor/illumina

Hope it helps to pinpoint the problem.
Thank you very much for keeping the plugin updated.
Cheers !

• This reply was modified 4 years ago by miquelpontes.
• This reply was modified 4 years ago by miquelpontes.

Animation does work, but as the graphics are low on the page, you won’t see it unless you reload the page in some point. I will try to get the logs from cPanel to try to reach the point where the plugin deactivates.