All-in-One WP Migration - Version 7.36

Version Description

Added

  • Support for case sensitive table names in MySQL 8
Download this release

Release Info

Developer bangelov
Plugin Icon 128x128 All-in-One WP Migration
Version 7.36
Comparing to
See all releases

Code changes from version 7.35 to 7.36

Files changed (4) hide show
  1. all-in-one-wp-migration.php +1 -1
  2. constants.php +1 -1
  3. lib/vendor/servmask/database/class-ai1wm-database.php +4 -4
  4. readme.txt +6 -1
all-in-one-wp-migration.php CHANGED
@@ -5,7 +5,7 @@
5
  * Description: Migration tool for all your blog data. Import or Export your blog content with a single click.
6
  * Author: ServMask
7
  * Author URI: https://servmask.com/
8
- * Version: 7.35
9
  * Text Domain: all-in-one-wp-migration
10
  * Domain Path: /languages
11
  * Network: True
5
  * Description: Migration tool for all your blog data. Import or Export your blog content with a single click.
6
  * Author: ServMask
7
  * Author URI: https://servmask.com/
8
+ * Version: 7.36
9
  * Text Domain: all-in-one-wp-migration
10
  * Domain Path: /languages
11
  * Network: True
constants.php CHANGED
@@ -35,7 +35,7 @@ define( 'AI1WM_DEBUG', false );
35
  // ==================
36
  // = Plugin Version =
37
  // ==================
38
- define( 'AI1WM_VERSION', '7.35' );
39
 
40
  // ===============
41
  // = Plugin Name =
35
  // ==================
36
  // = Plugin Version =
37
  // ==================
38
+ define( 'AI1WM_VERSION', '7.36' );
39
 
40
  // ===============
41
  // = Plugin Name =
lib/vendor/servmask/database/class-ai1wm-database.php CHANGED
@@ -599,13 +599,13 @@ abstract class Ai1wm_Database {
599
  if ( $lower_case_table_names ) {
600
  $where_query[] = sprintf( "(`Tables_in_%s` REGEXP '^%s' AND `Tables_in_%s` NOT REGEXP '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
601
  } else {
602
- $where_query[] = sprintf( "(`Tables_in_%s` REGEXP BINARY '^%s' AND `Tables_in_%s` NOT REGEXP BINARY '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
603
  }
604
  } else {
605
  if ( $lower_case_table_names ) {
606
  $where_query[] = sprintf( "`Tables_in_%s` REGEXP '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
607
  } else {
608
- $where_query[] = sprintf( "`Tables_in_%s` REGEXP BINARY '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
609
  }
610
  }
611
  }
@@ -649,13 +649,13 @@ abstract class Ai1wm_Database {
649
  if ( $lower_case_table_names ) {
650
  $where_query[] = sprintf( "(`Tables_in_%s` REGEXP '^%s' AND `Tables_in_%s` NOT REGEXP '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
651
  } else {
652
- $where_query[] = sprintf( "(`Tables_in_%s` REGEXP BINARY '^%s' AND `Tables_in_%s` NOT REGEXP BINARY '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
653
  }
654
  } else {
655
  if ( $lower_case_table_names ) {
656
  $where_query[] = sprintf( "`Tables_in_%s` REGEXP '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
657
  } else {
658
- $where_query[] = sprintf( "`Tables_in_%s` REGEXP BINARY '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
659
  }
660
  }
661
  }
599
  if ( $lower_case_table_names ) {
600
  $where_query[] = sprintf( "(`Tables_in_%s` REGEXP '^%s' AND `Tables_in_%s` NOT REGEXP '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
601
  } else {
602
+ $where_query[] = sprintf( "(CAST(`Tables_in_%s` AS BINARY) REGEXP BINARY '^%s' AND CAST(`Tables_in_%s` AS BINARY) NOT REGEXP BINARY '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
603
  }
604
  } else {
605
  if ( $lower_case_table_names ) {
606
  $where_query[] = sprintf( "`Tables_in_%s` REGEXP '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
607
  } else {
608
+ $where_query[] = sprintf( "CAST(`Tables_in_%s` AS BINARY) REGEXP BINARY '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
609
  }
610
  }
611
  }
649
  if ( $lower_case_table_names ) {
650
  $where_query[] = sprintf( "(`Tables_in_%s` REGEXP '^%s' AND `Tables_in_%s` NOT REGEXP '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
651
  } else {
652
+ $where_query[] = sprintf( "(CAST(`Tables_in_%s` AS BINARY) REGEXP BINARY '^%s' AND CAST(`Tables_in_%s` AS BINARY) NOT REGEXP BINARY '^%s')", $this->wpdb->dbname, $prefix_filter[0], $this->wpdb->dbname, $prefix_filter[1] );
653
  }
654
  } else {
655
  if ( $lower_case_table_names ) {
656
  $where_query[] = sprintf( "`Tables_in_%s` REGEXP '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
657
  } else {
658
+ $where_query[] = sprintf( "CAST(`Tables_in_%s` AS BINARY) REGEXP BINARY '^%s'", $this->wpdb->dbname, $prefix_filter[0] );
659
  }
660
  }
661
  }
readme.txt CHANGED
@@ -4,7 +4,7 @@ Tags: move, transfer, copy, migrate, backup, clone, restore, db migration, wordp
4
  Requires at least: 3.3
5
  Tested up to: 5.6
6
  Requires PHP: 5.2.17
7
- Stable tag: 7.35
8
  License: GPLv2 or later
9
 
10
  Move, transfer, copy, migrate, and backup a site with 1-click. Quick, easy, and reliable.
@@ -108,6 +108,11 @@ Alternatively you can download the plugin using the download button on this page
108
  All-in-One WP Migration **asks for your consent** to collect **requester's email address** when filling plugin's contact form. [GDPR Compliant Privacy Policy](https://www.iubenda.com/privacy-policy/946881)
109
 
110
  == Changelog ==
 
 
 
 
 
111
  = 7.35 =
112
  **Added**
113
 
4
  Requires at least: 3.3
5
  Tested up to: 5.6
6
  Requires PHP: 5.2.17
7
+ Stable tag: 7.36
8
  License: GPLv2 or later
9
 
10
  Move, transfer, copy, migrate, and backup a site with 1-click. Quick, easy, and reliable.
108
  All-in-One WP Migration **asks for your consent** to collect **requester's email address** when filling plugin's contact form. [GDPR Compliant Privacy Policy](https://www.iubenda.com/privacy-policy/946881)
109
 
110
  == Changelog ==
111
+ = 7.36 =
112
+ **Added**
113
+
114
+ * Support for case sensitive table names in MySQL 8
115
+
116
  = 7.35 =
117
  **Added**
118