Support » Plugin: WP Business Intelligence Lite » New Version: 3.1.3, New Developer

  • Plugin Author joeyoungblood

    (@joeyoungblood)


    Hi everyone. I recently took over as the maintener and developer of this plugin. My team and I are actively fixing issues with this and working to upgrade the free and pro versions. I’ve read through all of the reviews and a lot of the forum posts already and am aware of past issues this plugin has had.

    This evening we released a new version, v3.1.3 which fixes several bugs and cleans up some of the code. Please report any bugs or issues you have with this version here in this thread and leave any general ideas for improvement you have.

Viewing 15 replies - 1 through 15 (of 21 total)
  • miquelpontes

    (@miquelpontesgmailcom)

    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 1 year, 3 months ago by miquelpontes.
    Plugin Author joeyoungblood

    (@joeyoungblood)

    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.

    miquelpontes

    (@miquelpontesgmailcom)

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

    Plugin Author joeyoungblood

    (@joeyoungblood)

    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.

    Plugin Author joeyoungblood

    (@joeyoungblood)

    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.

    miquelpontes

    (@miquelpontesgmailcom)

    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.

    Plugin Author joeyoungblood

    (@joeyoungblood)

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

    Plugin Author joeyoungblood

    (@joeyoungblood)

    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.

    miquelpontes

    (@miquelpontesgmailcom)

    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 1 year, 2 months ago by miquelpontes.
    • This reply was modified 1 year, 2 months ago by miquelpontes.
    Plugin Author joeyoungblood

    (@joeyoungblood)

    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.

    miquelpontes

    (@miquelpontesgmailcom)

    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.

    Plugin Author joeyoungblood

    (@joeyoungblood)

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

    Plugin Author joeyoungblood

    (@joeyoungblood)

    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/

    miquelpontes

    (@miquelpontesgmailcom)

    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.

    Plugin Author joeyoungblood

    (@joeyoungblood)

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

Viewing 15 replies - 1 through 15 (of 21 total)
  • The topic ‘New Version: 3.1.3, New Developer’ is closed to new replies.