Site Reviews - Version 5.1.1

Version Description

(2020-10-24) =

  • Add "ORDER BY" in migration SQL queries. This will make it a little slower, but hopefully fix the problem where the database migration notice is shown multiple times.
Download this release

Release Info

Developer geminilabs
Plugin Icon 128x128 Site Reviews
Version 5.1.1
Comparing to
See all releases

Code changes from version 5.1.0 to 5.1.1

Files changed (3) hide show
  1. plugin/Modules/Migrations/Migrate_5_0_0/MigrateReviews.php +4 -0
  2. readme.txt +5 -1
  3. site-reviews.php +1 -1
plugin/Modules/Migrations/Migrate_5_0_0/MigrateReviews.php CHANGED
@@ -85,6 +85,7 @@ class MigrateReviews
85
  INNER JOIN {$this->db->posts} AS p ON r.review_id = p.ID
86
  INNER JOIN {$this->db->postmeta} AS m ON r.review_id = m.post_id
87
  WHERE m.meta_key = '_assigned_to' AND m.meta_value > 0
 
88
  LIMIT %d, %d
89
  ", $offset, $this->limit), 'migrate-assigned-posts');
90
  $results = glsr(Database::class)->dbGetResults($sql, ARRAY_A);
@@ -118,6 +119,7 @@ class MigrateReviews
118
  AND p.post_type = '%s'
119
  AND m1.meta_value != '%s'
120
  AND m1.meta_key LIKE '_custom%%'
 
121
  LIMIT %d, %d
122
  ", glsr()->post_type, serialize([]), $offset, $this->limit), 'migrate-custom');
123
  $results = glsr(Database::class)->dbGetResults($sql, OBJECT);
@@ -153,6 +155,7 @@ class MigrateReviews
153
  SELECT ID
154
  FROM {$this->db->posts}
155
  WHERE post_type = '%s'
 
156
  LIMIT %d, %d
157
  ) AS post_ids
158
  )
@@ -184,6 +187,7 @@ class MigrateReviews
184
  FROM {$table} AS r
185
  INNER JOIN {$this->db->term_relationships} AS tr ON r.review_id = tr.object_id
186
  INNER JOIN {$this->db->term_taxonomy} AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
 
187
  LIMIT %d, %d
188
  ", $offset, $this->limit), 'migrate-assigned-terms');
189
  $results = glsr(Database::class)->dbGetResults($sql, ARRAY_A);
85
  INNER JOIN {$this->db->posts} AS p ON r.review_id = p.ID
86
  INNER JOIN {$this->db->postmeta} AS m ON r.review_id = m.post_id
87
  WHERE m.meta_key = '_assigned_to' AND m.meta_value > 0
88
+ ORDER BY r.ID
89
  LIMIT %d, %d
90
  ", $offset, $this->limit), 'migrate-assigned-posts');
91
  $results = glsr(Database::class)->dbGetResults($sql, ARRAY_A);
119
  AND p.post_type = '%s'
120
  AND m1.meta_value != '%s'
121
  AND m1.meta_key LIKE '_custom%%'
122
+ ORDER BY m1.meta_id
123
  LIMIT %d, %d
124
  ", glsr()->post_type, serialize([]), $offset, $this->limit), 'migrate-custom');
125
  $results = glsr(Database::class)->dbGetResults($sql, OBJECT);
155
  SELECT ID
156
  FROM {$this->db->posts}
157
  WHERE post_type = '%s'
158
+ ORDER BY ID
159
  LIMIT %d, %d
160
  ) AS post_ids
161
  )
187
  FROM {$table} AS r
188
  INNER JOIN {$this->db->term_relationships} AS tr ON r.review_id = tr.object_id
189
  INNER JOIN {$this->db->term_taxonomy} AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
190
+ ORDER BY r.ID
191
  LIMIT %d, %d
192
  ", $offset, $this->limit), 'migrate-assigned-terms');
193
  $results = glsr(Database::class)->dbGetResults($sql, ARRAY_A);
readme.txt CHANGED
@@ -5,7 +5,7 @@ Tags: reviews, ratings, testimonials, business reviews, product reviews, stars,
5
  Tested up to: 5.5
6
  Requires at least: 5.5
7
  Requires PHP: 5.6
8
- Stable tag: 5.1.0
9
  License: GPLv3
10
  License URI: https://www.gnu.org/licenses/gpl-2.0.html
11
 
@@ -113,6 +113,10 @@ All documentation can be found in the "Help" page of the plugin. If your questio
113
 
114
  == Changelog ==
115
 
 
 
 
 
116
  = 5.1.0 (2020-10-24) =
117
 
118
  - Fixed database integration with WordPress tables that still use the old MyISAM engine
5
  Tested up to: 5.5
6
  Requires at least: 5.5
7
  Requires PHP: 5.6
8
+ Stable tag: 5.1.1
9
  License: GPLv3
10
  License URI: https://www.gnu.org/licenses/gpl-2.0.html
11
 
113
 
114
  == Changelog ==
115
 
116
+ = 5.1.1 (2020-10-24) =
117
+
118
+ - Add "ORDER BY" in migration SQL queries. This will make it a little slower, but hopefully fix the problem where the database migration notice is shown multiple times.
119
+
120
  = 5.1.0 (2020-10-24) =
121
 
122
  - Fixed database integration with WordPress tables that still use the old MyISAM engine
site-reviews.php CHANGED
@@ -7,7 +7,7 @@
7
  * Plugin Name: Site Reviews
8
  * Plugin URI: https://wordpress.org/plugins/site-reviews
9
  * Description: Receive and display reviews on your website
10
- * Version: 5.1.0
11
  * Author: Paul Ryley
12
  * Author URI: https://geminilabs.io
13
  * License: GPL2
7
  * Plugin Name: Site Reviews
8
  * Plugin URI: https://wordpress.org/plugins/site-reviews
9
  * Description: Receive and display reviews on your website
10
+ * Version: 5.1.1
11
  * Author: Paul Ryley
12
  * Author URI: https://geminilabs.io
13
  * License: GPL2