| 1 |
### ChangeLog for WP Data Access |
| 2 |
|
| 3 |
#### 2.0.13 / 2019-05-17 |
| 4 |
|
| 5 |
* Fixed: Database name containing minus character leads to query errors (see support forum topic 11540179 - Prause) |
| 6 |
* Added: Export tables from Data Explorer to SQL (with(out) WP prefix), XML, json, Excel, csv files (support topic 11533487 - rswebmaster) |
| 7 |
|
| 8 |
#### 2.0.12 / 2019-05-14 |
| 9 |
|
| 10 |
* Updated: Plugin help pages |
| 11 |
* Added: Video tutorial to install the demo app |
| 12 |
* Fixed: Search on table with no search columns should show no rows |
| 13 |
* Fixed: Cannot search on lookup items |
| 14 |
* Fixed: Sorting on lookup columns is not possible (removed header link from table list) |
| 15 |
* Added: Check if file_uploads = On before upload (disable file upload if file_uploads = Off) |
| 16 |
* Fixed: Not correctly jumping back to list table source page after "Add Existing" > "search" |
| 17 |
* Fixed: Data Explorer main page shows all tables on show favourites only no favourites defined |
| 18 |
* Fixed: Export and Data Backup fail when memory_limit is too small |
| 19 |
* Added: Check file size against upload_max_filesize before uploading imnport file |
| 20 |
* Changed: Import now using streams to better support large files |
| 21 |
* Changed: Export and Data Backup now using streams to better support large files |
| 22 |
* Added: Log table to "Manage Repository" and "System Info" |
| 23 |
* Changed: Export procedure now writes seperate insert statement for every row |
| 24 |
* Fixed: Export/import procedures non WP schema performed on WP schema |
| 25 |
* Added: System info tab to improve and simplify plugin support and communication |
| 26 |
|
| 27 |
#### 2.0.11 / 2019-04-30 |
| 28 |
|
| 29 |
* Fixed: After editing a data record user always returns to page 1 (support topic 11476140 - Hannes - Decentris) |
| 30 |
* Fixed: Cannot add new page to project (support topic 11477423 - fendervr) |
| 31 |
* Added: Drop logging table on uninstall |
| 32 |
* Added: Possibility to save repository backup tables during a plugin update |
| 33 |
* Changed: Simplified repository (re)creation to decrease the possibility of failure |
| 34 |
* Fixed: Export files writes {wp_prefix}_ instead of {wp_prefix} |
| 35 |
* Fixed: View only list tables should not allow delete bulk actions |
| 36 |
* Fixed: Cannot search in list of values (search is performed on main list table) |
| 37 |
* Fixed: Site blocked after unattended plugin update (support topic 11472418 - tjgorman) (patched version 2.0.10) |
| 38 |
* Fixed: Class 'WPDataProjects\List_Table\WPDP_List_Columns_Cache' not found (patched version 2.0.10) |
| 39 |
* Fixed: Plugin table array removed from table cache (patched version 2.0.10) |
| 40 |
|
| 41 |
#### 2.0.10 / 2019-04-25 |
| 42 |
|
| 43 |
* Changed: Moved all security checks from menu preparation to page preparation |
| 44 |
* Added: Data Backup now supports unattended (background/no browser) adhoc backups (support topic 11466155 - stevekatasi) |
| 45 |
* Changed: Improved and simplified Data Backup procedure |
| 46 |
* Fixed: Added WordPress database schema and plugin tables to cache (support topic 11461930 - stevekatasi) |
| 47 |
* Fixed: Added cache to list column classes to increase database performance (support topic 11461930 - stevekatasi) |
| 48 |
* Fixed: Optimized class WPDP_List_Table_Lookup due to bad performance issue (support topic 11461930 - stevekatasi) |
| 49 |
* Fixed: Create table menu items fails for MySQL 5.6 and prior (support topic 11461174 - rswebmaster) |
| 50 |
* Added: Demo project (app) WPDA_SAS - School Administration System |
| 51 |
* Added: Code example how to use WP Data Access classes in PHP plugin code |
| 52 |
* Fixed: Default and list-values imported without single quotes on Reverse Engineering (support topic 11423815 - Hannes - Decentris) |
| 53 |
* Fixed: Data Projects export not working in FireFix (support topic 11429499 - Hannes - Decentris) |
| 54 |
* Fixed: Submenus of data apps not shown correctly for roles null or empty string |
| 55 |
* Changed: Export tables with variable wpdb prefix to support import into repository with different wpdb prefix |
| 56 |
* Fixed: Set data type not handled correctly in the Data Designer (support topic 11423815 - Hannes - Decentris) |
| 57 |
* Added: Explain how to define enum and list type in the Data Designer (support topic 11423815 - Hannes - Decentris) |
| 58 |
* Fixed: Added latest version of WP_List_Table to project to reclaim navigation buttons |
| 59 |
* Fixed: Submenus of data apps not shown correctly for roles other than administrator |
| 60 |
* Fixed: WP table prefix not taken into account (support topic 11411195 - Hannes - Decentris) |
| 61 |
* Fixed: Key column labels not displayed correctly in table list |
| 62 |
* Added: A listbox is generated for lookup items in data entry forms |
| 63 |
* Added: It is now possible to add a lookup column to a table list |
| 64 |
* Added: Disable relationship and data entry form config for views and tables without a primary key (Data Projects) |
| 65 |
* Added: Allow views and tables without a primary key to be used (Data Projects) |
| 66 |
* Added: Allow to create relationships between tables and views (Data Projects) |
| 67 |
* Added: Table type (TABLE,VIEW) to WPDA_Design_Table_Model (WPDP_Project_Design_Table_Model inherited) |
| 68 |
* Fixed: Import script containing multiple SQL statements failed on Windows (using \r\n) |
| 69 |
|
| 70 |
#### 2.0.8 / 2019-02-05 |
| 71 |
|
| 72 |
* Added: Video tutorial to explain how to create many to many relationships in Data Projects |
| 73 |
* Changed: Static content not correctly filtered |
| 74 |
* Added: Make username accessible in where clause of project list tables |
| 75 |
* Added: Where clause to project list tables to influence selection (parent only) |
| 76 |
* Added: Support for MySQL set data type (listbox handling multiple selections) |
| 77 |
* Added: Role (multiple) to data project pages to give non admin users access to data apps |
| 78 |
* Changed: Content in list table wrapped (request from Enterprise Branding) |
| 79 |
* Changed: What's new message now shown on all plugin pages |
| 80 |
* Changed: Dropbox path now updatable |
| 81 |
* Changed: Add / at the end of the backup folder name if not entered |
| 82 |
|
| 83 |
#### 2.0.7 / 2019-01-27 |
| 84 |
|
| 85 |
* Added: Data backup tool to automatically backup table data to a local folder or Dropbox folder |
| 86 |
|
| 87 |
#### 2.0.6 / 2018-12-16 |
| 88 |
|
| 89 |
* Added: Check number max size and precision in data entry forms |
| 90 |
* Added: "Add New" button for parent in parent-child pages |
| 91 |
* Added: Show list of available tables in data entry form for project>pages |
| 92 |
* Fixed: Data Explorer manage table tabs not working correctly with multiple windows |
| 93 |
* Changed: Allow to hide primary key columns in data entry forms |
| 94 |
* Changed: Allow to hide primary key columns in table list |
| 95 |
* Fixed: Hide columns not working in all data entry forms |
| 96 |
* Fixed: Data Project table page: mode, title and subtitle not taken into account |
| 97 |
|
| 98 |
#### 2.0.5 / 2018-12-14 |
| 99 |
|
| 100 |
* Removed /themes/smoothness/jquery-ui.css from plugin admin class (shortcode button not working) |
| 101 |
* Added: New screenshots to WordPress Plugin Directory |
| 102 |
* Fixed: Export not working when "ask for confirmation when starting export" in settings is checked |
| 103 |
* Changed: Tabs in list table (table actions) not working in Internet Explorer |
| 104 |
* Changed: Links in list table not working in Internet Explorer |
| 105 |
|
| 106 |
#### 2.0.4 / 2018-12-11 |
| 107 |
|
| 108 |
* Changed: Plugin description in WordPress Plugin Directory |
| 109 |
* Changed: Layout of the manage table window |
| 110 |
|
| 111 |
#### 2.0.3 / 2018-12-05 |
| 112 |
|
| 113 |
* Added: Optimize table from Data Explorer > manage table > actions tab |
| 114 |
* Added: Hint user if table optimization should be considered |
| 115 |
* Changed: Data menus was moved to Data Projects > Manage Dashboard Menus |
| 116 |
* Added: Columns data size, index size and overhead to Data Explorer main page |
| 117 |
* Added: Hide columns on Data Explorer mainpage |
| 118 |
* Changed: Changed to order of the tabs in the manage table/view window |
| 119 |
* Changed: Replaced icon to manage table of view with standard WordPress listtable link |
| 120 |
* Changed: Changed import button text and labels for better understanding of import functionality |
| 121 |
* Added: Video tutorial to explain how to create one to many relationships in Data Projects |
| 122 |
|
| 123 |
#### 2.0.2 / 2018-12-03 |
| 124 |
|
| 125 |
* Fixed: Removed subtitle from Data Designer and Data Menus list |
| 126 |
* Added: What's new page to inform users about new features |
| 127 |
* Added: First video tutorial to explain Data Projects tool |
| 128 |
|
| 129 |
#### 2.0.1 / 2018-11-27 |
| 130 |
|
| 131 |
* Fixed: Null values not exported correctly |
| 132 |
* Fixed: Do not allow to hide mandatory columns in data entry forms |
| 133 |
|
| 134 |
#### 2.0.0 / 2018-11-09 |
| 135 |
|
| 136 |
* Added: Data Projects to plugin |
| 137 |
* Create WordPress Data Apps |
| 138 |
* Add app to dashboard menu |
| 139 |
* Supports static pages |
| 140 |
* Supports CRUD pages |
| 141 |
* Supports parent/child pages |
| 142 |
* Added: Documentation to plugin menu |
| 143 |
* Fixed: Repository activation error |
| 144 |
* Stopped: Website redirected to WordPress Plugin Directory |
| 145 |
|
| 146 |
#### 1.6.9 / 2018-03-20 |
| 147 |
|
| 148 |
* Fixed: Bulk actions not executed due to fix in 1.6.7 on favourites change |
| 149 |
* Added: Show MySQL error when create table fails |
| 150 |
* Changed: Prepared WPDA_Design_Table_Model to support transparent structures |
| 151 |
|
| 152 |
#### 1.6.8 / 2018-03-17 |
| 153 |
|
| 154 |
* Changed: Added new screenshots |
| 155 |
* Fixed: Missing check unique column names and index names |
| 156 |
* Fixed: Delete index in Data Designer not working |
| 157 |
* Changed: Default mode Data Designer changed to advanced |
| 158 |
|
| 159 |
#### 1.6.7 / 2018-03-16 |
| 160 |
|
| 161 |
* Fixed: Switch to editing mode after create table/index in Data Designer |
| 162 |
* Fixed: Prevent bulk selections being executed on favourites change |
| 163 |
* Fixed: Multiple alerts on invalid bulk drop or truncate selection |
| 164 |
|
| 165 |
#### 1.6.6 / 2018-03-16 |
| 166 |
|
| 167 |
* Added: Copy table (including/excluding data) |
| 168 |
* Added: Rename table/view |
| 169 |
* Changed: Simplified usage of table/view/index actions from Data Explorer |
| 170 |
|
| 171 |
#### 1.6.5 / 2018-03-15 |
| 172 |
|
| 173 |
* Added: Drop index from Data Explorer |
| 174 |
|
| 175 |
#### 1.6.4 / 2018-03-14 |
| 176 |
|
| 177 |
* Fixed: Column 'Unique?' on 'Indexes' tab of Data Explorer always showing 'No' |
| 178 |
|
| 179 |
#### 1.6.3 / 2018-03-14 |
| 180 |
|
| 181 |
* Fixed: Create table not working |
| 182 |
|
| 183 |
#### 1.6.2 / 2018-03-01 |
| 184 |
|
| 185 |
* Fixed: Action button issues |
| 186 |
* Fixed: Ask for confirmation on bulk-drop and bulk-truncate |
| 187 |
* Fixed: Schema issues |
| 188 |
|
| 189 |
#### 1.6.1 / 2018-03-01 |
| 190 |
|
| 191 |
* Added: Allow ZIP file imports to support larger import files (uses ZipArchive) |
| 192 |
|
| 193 |
#### 1.6.0 / 2018-02-15 |
| 194 |
|
| 195 |
* Added: Create tables in basic or advanced mode (switch between modes) |
| 196 |
* Added: Allow data and database administration of other schemas |
| 197 |
* Added: Import table(s) button to Data Explorer (allows multiple imports) |
| 198 |
|
| 199 |
#### 1.5.2 / 2018-02-06 |
| 200 |
|
| 201 |
* Added: Check every request for plugin updates (compare db version with plugin version) |
| 202 |
|
| 203 |
#### 1.5.1 / 2018-02-03 |
| 204 |
|
| 205 |
* Added: Check #Rows ( perform count if #Rows < WPDA::OPTION_BE_INNODB_COUNT ) |
| 206 |
|
| 207 |
#### 1.5.0 / 2018-01-23 |
| 208 |
|
| 209 |
* Added: Engine field to Data Explorer |
| 210 |
* Added: Number of records field to Data Explorer |
| 211 |
* Added: Drop and bulk drop for views (accessible through icon in Data Explorer) |
| 212 |
* Added: Bulk drop and bulk truncate for tables (accessible through icon in Data Explorer) |
| 213 |
* Added: View table/view structure (accessible through icon in Data Explorer) |
| 214 |
* Added: Option to backend settings to get default search value functionality (forget search value) |
| 215 |
* Added: Support for parent detail navigation |
| 216 |
* Added: Added argument 'allow_import' to WPDA_List_Table to hide import button |
| 217 |
* Changed: Always show page 1 on new search |
| 218 |
* Changed: Improved layout Simple Form |
| 219 |
* Changed: Hide button 'Back To List' in view mode |
| 220 |
* Removed: Menu WP Data Tables (replaced by favourites menu) |
| 221 |
* Fixed: Current page selector not working |
| 222 |
* Fixed: Check max length for input (attribute maxlength) |
| 223 |
* Fixed: On expanding favourites table name not shown |
| 224 |
* Fixed: Remember search value after navigating to details |
| 225 |
* Fixed: WPDA_List_Table::construct_where_clause() not respecting values already in $this->where |
| 226 |
* Fixed: Searching in favourites not working |
| 227 |
* Fixed: Disable only form items in view mode |
| 228 |
* Fixed: Argument 'show_view_link' has no effect |
| 229 |
* Fixed: Argument 'allow_insert' has no effect |
| 230 |
* Fixed: Back button in list table when called from data explorer or favourites |
| 231 |
|
| 232 |
#### 1.2.1 / 2018-01-14 |
| 233 |
|
| 234 |
* Fixed: Skip empty index on create table |
| 235 |
* Fixed: Data entry form should showing CURRENT_TIMESTAMP as default value |
| 236 |
* Fixed: Bulk checkboxes shown without bulk actions (tables export disabled) |
| 237 |
* Fixed: List table favourites not showing labels when empty |
| 238 |
|
| 239 |
#### 1.2.0 / 2018-01-13 |
| 240 |
|
| 241 |
* Fixed: Recognize missing wp_wpda_table_design |
| 242 |
* Fixed: Single file for every alter table stetement (wp_wpda_table_design) |
| 243 |
* Added: Add tables to favourites (WP Data Tables still in menu but will be removed soon) |
| 244 |
|
| 245 |
#### 1.1.1 / 2018-01-13 |
| 246 |
|
| 247 |
* Fixed: Create table wp_wpda_table_design (older versions of mysql not supporting timestamp) |
| 248 |
* Fixed: Hidden columns array returns false |
| 249 |
|
| 250 |
#### 1.1.0 / 2018-01-09 |
| 251 |
|
| 252 |
* Added: Data Designer |
| 253 |
* Design tables and indexes |
| 254 |
* Create tables and indexes from design |
| 255 |
* Added: Drop table (from list table) |
| 256 |
* Added: Truncate table (from list table) |
| 257 |
* Fixed: Recognize all WordPress tables (single and multisite) |
| 258 |
* Fixed: Link 'export' not showing in Data Explorer |
| 259 |
|
| 260 |
#### 1.0.0 / 2017-12-04 |
| 261 |
|
| 262 |
* Fixed: I can’t add table to menu (2017-12-29) |
| 263 |
* Fixed: Activating the plugin affects styles on the front page (2017-12-29) |
| 264 |
* Fixed: Sanitization error (2017-12-29) |
| 265 |
* Initial commit |
| 266 |
|
