New Version: 3.1.3, New Developer

WordPress keeps deactivating WP Business Intelligence Lite after last upgrade. A sample page is https://opistobranquis.info/en/LQRxS in the “Abundance” section. You see a bar chart normally, but it disappears from time to time and the shortcode becomes visible, if I reactivate the plugin it works again for some time until the situation repeats.
I suppose there’s a fatal error that provokes automatic plugin deactivation. How can fix this?

• This reply was modified 3 years, 9 months ago by miquelpontes.

Thanks for that bug report. We’ll start investigating that on the Lite plugin here asap. Have you tried capturing any error data? If so could you please get that to me.

Hi, how can I capture the error? Is there a log somewhere?

You can try the methods discussed here: https://wordpress.stackexchange.com/questions/61057/why-my-plugin-keeps-deactivating-automatically

If you have something like cPanel you should have an error log there you can check. I’m not able to reproduce this error in Dev Tools so far.

I noticed the animation isn’t working on your chart, which might mean there’s some kind of conflict. (Each bar should grow from the bottom to the top like on our Demo page: https://www.wpbusinessintelligence.com/demos/). There’s also the chance that it’s a plugin conflict with another plugin or a server resource issue. Try and keep tabs of when you notice the failure and talk to your webhost to see if they can shed any light on it.

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.

Hmmm great catch. We’ll look into making it so the animation only starts loading when it’s in the viewport.

We just released a new version, the only real change is giving a few more chart types to the free version of the plugin. Please let me know if it deactivates on you again. We tested this in various configurations and haven’t been able to replicate the issue.

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 3 years, 8 months ago by miquelpontes.
• This reply was modified 3 years, 8 months ago by miquelpontes.

This looks like an SQL error. If I understand correctly you are trying to display tables by using the page id in a dynamic query to automatically display the correct chart instead of creating an SQL query for each chart and displaying via separate short codes is that accurate? If so, this may have worked until our v3.1.3 when we udpated our underlying architecture to latest stable releases.

I will pass it on to my dev team and we will try and troubleshoot, but if you’re using the plugin outside of how it was built to be used (i.e. not querying a live database to generate one chart from the tables) you may run into problems.

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.

Hmmm thanks. I believe I fully understand the issue now, that should help us troubleshoot it.

We have not been able to replicate this issue on WP Business Intelligence Lite inside of our test environment. Would you be able to take a quick screen recording video to better show me what is happening? You can use Loom or a similar service to record your screen and share a link to that recording: https://www.loom.com/

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.

Thank you Miquel for this video. We are looking in to this now and get a fix for it as soon as we can.