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.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