Changelog
Below is the changelog for WP Business Intelligence Free and Pro. This information is provided to help developers make better decisions when using our plugin. Actions taken on only the Free version or Pro version are noted. If there is no note then the action taken likely impacts both versions of our plugin.
Version 3.2 (Lite) – 12/31/2022
– Fixed a bug that produced an error when upgrading to WordPress v6.1
– Added chart.js library
– Added chart.js line charts
– Added chart.js vertical bar charts
– Added chart.js doughnut charts
– Added chart.js radar charts
– Added ‘Connections’ section
– Added pre-built WordPress charts (in beta)
– Added a plugin homepage
PHP: 8.0, 8.1
WordPress: v6.0, v6.01, v6.1, v 6.1.1
Version 3.2.5 (Pro) – 12/22/2022
– Fixed a bug that produced an error when upgrading to WordPress v6.1
– Added a new chart type “Counter”
– Added the first Counter chart (a numerical counter with animation)
– Updated the data label settings for Chart.js Bubble Charts
PHP: 8.0, 8.1
WordPress: v6.0, v6.01, v6.1, v 6.1.1
Version 3.2.4 (Pro) – 1/10/2022
– Fixed a bug in the plugin updating code that was incompatible with PHP 8.0.
Instructions to fix updating issues caused by this bug: Deactivate WP Business Intelligence plugin, Downgrade server to PHP 7.4, Click “Check for Updates” next to WP Business Intelligence on Plugins page (you may need to do this several times), Upgrade WP Business Intelligence to v3.2.4 from v3.2.3, upgrade server to PHP 8.0, Reactivate WP Business Intelligence plugin
Version 3.2.3 (Pro) – 1/6/2022
Note: This version REQUIRES PHP 8.0 and has not been tested with PHP 7.1 to 7.4. Do not upgrade to WPBI Pro v3.2.3 until you are ready to upgrade your system to PHP 8.0
– Fixed a bug that caused the Admin to crash in PHP 8.0
– Fixed a bug with our datatables and PHP 8.0
– Renamed “Database Connections” section to “Connections” to provide more types of data and content connections for dashboards
– Added embedded content connections type
– Added pre-built WordPress data queries connections type
– Added a feature to put charts on the admin dashboards
– Added a WordPress navigation icon
– Fixed Chart.js color scheme options to show only one color per data series
– Added Scatter Charts for the Google Charts Library
– Added Candlestick Charts for the Google Charts Library
– Added Histogram Charts for the Google Charts Library
– Added Timeline Charts for the Google Charts Library
PHP versions tested: v8.0, v8.0 + PHP-FPM
Minimum required PHP version: v8.0
Minimum required WordPress version: v5.0
Everything below this text to version 3.1.3 worked on a version of PHP 7 ranging from PHP 7.1 to 7.4 + PHP-FPM. During this time we did not notate in our changelog what PHP versions a release was tested with or known to work with. Starting with our January 2022 Pro release we have begun adding this data to the bottom of our release notes in order to help developers make better decisions about ugprades.
Version 3.2.2 (Pro) – 6/30/2021
– Fixed a bug that may have caused deactivation issues and led to two Critical Issues in WordPress Site Health. This might have caused the plugin to deactivate randomly though we were never able to replicate this issue.
– Fixed a bug with “session_start” in our PHP code wrapping it in a proper condition. This was not known to cause any issues.
– Added Google Charts
– Added Line Charts for the Google Charts Library
– Added Stepped Area Charts for the Google Charts Library
– Added Gauge Charts for the Google Charts Library
– Added Vertical Bar Charts for the Chart.js library
– Added Horizontal Bar Charts for the Chart.js library
– Added Stacked Bar Charts for the Chart.js library
– Added Stacked and Grouped Bar Charts for the Chart.js library
– Added Multi-axis Line Charts for the Chart.js library
– Added Stepped Line Charts for the Chart.js library
– Added Doughnut Charts for the Chart.js library
– Added Multi-series Pie Charts for the Chart.js library
– Added Stacked Bar Line Combo Charts for the Chart.js library
– Added Stacked Line Charts for the Chart.js library
– Added Stacked Radar Charts for the Chart.js library
Version 3.1.9 (Lite) – 6/17/2021
– Fixed a bug that may have caused deactivation issues and led to two Critical Issues in WordPress Site Health. This might have caused the plugin to deactivate randomly.
Version 3.2.1 (Pro) – 6/9/2021
– Fixed data inputs for the Britecharts Grouped Bar Charts to use correct values, this also fixed a bug that would prevent editing of a Britecharts Grouped Bar Chart that did not use the correct data types for each column. This would appear in tooltips as “0NaN”
– Added Legend feature for several charts in Britecharts library including: Line Charts, Stacked Area Charts, Stacked Bar Charts, Donut Charts, and Grouped Bar Charts
– Added IBM Informix database connector (PDO)
– Added Firebird database connector (PDO)
– Added SQLite database connector (PDO)
– Added Pie Charts for the Chart.js library
– Added Polar Area Charts for the Chart.js library
– Added Scatter Charts for the Chart.js library
– Added Radar Charts for the Chart.js library
– Added Combo Bar & Line Charts for the Chart.js library
– Added Floating Bar Charts for the Chart.js library
Version 3.1.8 (Lite) – 6/2/2021
– Fixed a bug that caused install issues in some situations where the plugin would try and overwrite existing db data and fail. Error appearing would be similar to: “WordPress database error: [Duplicate column name ‘example-column-name’]”
Version 3.2.0 (Pro) – 5/19/2021
– Fixed a bug that prevented Britecharts Step Charts from loading correctly
Version 3.1.9 (Pro) – 5/18/2021
– Added Oracle database connector (PDO)
– Added ability to give tooltips a title on Line Charts, Grouped Bar Charts, Stacked Area Charts, and Stacked Bar Charts for the Britecharts library
– Added a color palette option selector to select different preset color palettes to give your charts more color
– Added chart library label to differentiate between charting libraries
– Added Chart.js
– Added Line Charts for the Chart.js library
– Added Bubble Charts for the Chart.js library
Version 3.1.8 (Pro) – 4/22/2021
– Fixed a bug that impacted how the Y-axis labels displayed in the horizontal line charts
Version 3.1.7 (Pro) – 4/22/2021
– Added Horizontal Bar Charts to Pro version
– Added test of Brush Chart capability to Pro version
Version 3.1.7 (Lite) – 3/27/2021
– Fixed a bug that caused an error with the wp_wpbi_grouped_bar_charts table in the database of the Free version only
Version 3.1.6 – 3/24/2021
– Fixed a bug that crashed plugin on install/activation if a chart already existed in Free and Pro versions
Version 3.1.5 – 3/24/2021
– Added chart names to Free and Pro versions
– Added chart captions to Free and Pro versions
– Fixed tooltip display on charts in Free version
– Fixed tooltip display on charts in Pro version
Version 3.1.4 – 3/4/2021
– Added Britecharts Line charts to Free version
– Added Britecharts Grouped Bar charts to Free version
Version 3.1.3 – 1/24/2021
– Fixed miscellaneous bugs
– Added in new animation to charts
– Added compatibility with WordPress 5.6
– Upgraded Britecharts version
– Updated licensing integration in Pro version
Everything below this text was completed by a different development team and is listed here for your records. Most of this was pulled from the WordPress logs, some of it was pulled from internal developer logs. It should not be considered perfectly accurate.
Version 3.1.2 -> Date Unknown (approximately December of 2018)
– Increase length of queries
– WordPress 5.0 compliant
Version 3.1.1
– PostgreSQL support in pro version
– Test on latest WordPress (5.1.1)
– Improve loading of scripts when jQuery is not yet loaded
Version 3.1.0
– Microsoft SQL Server support in pro version
– Minor changes that should make things more robust
– Added testing for PHP 7.2, 7.0
– Added testing for MyISAM (InnoDB was already tested)
– Added testing for MySQL 5.5, 5.7, 8.0
– Added testing for MariaDB 5.5, 10.3
Version 3.0.10
– Minor bug fix: initial order of datatable defaulted to ordering by first row
– tested up to WordPress 4.9.8
Version 3.0.9
– Remove automatically calculated timestamps because of db version inconsistencies (and because they were not used)
Version 3.0.8
– Add more info for debugging initial installation
– Minor fixes to this file
– Minor improvements to tests
Version 3.0.7
– fix issue with php 5.6 compatibility
Version 3.0.6
– do not use with php 5.6
– test on WordPress 4.9.6
– update dependencies to work better with old versions of php
– improve similarity of tables created with default wp tables (collation and charset)
– fix startup failing on MySQL 5.6 if using mb4 by default
– fix bug if InnoDB does not exist
Version 3.0.5
– php 5.6.0 support
Version 3.0.4
– More verbose error logging if plugin cannot be activated
– Disable plugin if there are issues connecting to database
Version 3.0.3
– Prevent old versions of PHP and WordPress from using this plugin
Version 3.0.2
– Bug fix for users who upgraded with legacy table
Version 3.0.1
– Workaround bug where britecharts chooses the wrong colors for grouped bar charts
Version 3.0.0 -> Date Unknown (approximately January of 2018)
– Complete rewrite. Backward incompatible with previous version.
– Use Britecharts instead of directly using d3
– Free version: Pie(donut) and Bar charts only
– Pro version: Bar charts, Stacked Bar charts, Grouped Bar charts, Step charts, Line charts, Stacked Area charts, Pie(donut) charts, and Sparkline charts
– Update to Datatables 1.10
Version 2 to 2.2 -> Dates Unknown (approximately 2017)
– unknown
Version 1.6.7
– rollback table.tpl for compatibility issues
Version 1.6.6
– bug fix in table pagination
Version 1.6.4
– color class renamed to wpbi_color
– add_query_arg escaped to fix vulnerability
Version 1.6.3
– SQL injection vulnerability fix enhanced
Version 1.6.2
– SQL injection vulnerability fixed
Version 1.6.1
– Validated on WP 4.1.1
– Error message added in case of no data
Version 1.6
– Bug on iframe fixed
– X and Y labels added
– Validated on WP 4.0
Version 1.5 -> Date Unknown (approximately September 6th of 2014)
– Added possibility to download charts and tables data
– Charts and table download as PDF or image
– Additional controls on charts
Version 1.4
– Charts and tables IDs are shown in the dashboard
Version 1.3
– Removed file with potential vulnerability
Version 1.2.1
– Missing include added to includes.php
Version 1.2
– Some major bug fixes and support of click event on bar chart (example for developers to be extended to other charts)
Version 1.1
– Security vulnerability fixed and control over bar charts color added.
Version 1.0.7
– Added support for text labels to line charts
Version 1.0.6
– Renamed button registration function to avoid conflicts with other themes
Version 1.0.5
– TinyMCE button registration warning fixed.
– Donut chart added
– Version 1.1.13 of NVD3 integrated
Version 1.0.4 – 6/29/2013
– Bug fix with queries pagination
Version 1.0.3 – 6/19/2013
– Code was cleaned up to remove some warnings
Version 1.0.2 – 5/21/2013
– First integration of “DataTables” tables
Version 1.0.1
– Fixes on JS inclusion and icon chart
Version 1.0 -> Date unknown (approximately January of 2013)
– First beta release