Changeset 3342631

Timestamp:

08/11/2025 05:06:05 AM (3 months ago)

Author:

matteoenna

Message:

Release 1.4.3

Location:

cloud-s3-storage

Files:

• tags/1.4.3 (copied) (copied from cloud-s3-storage/trunk)
• tags/1.4.3/class/base/cloud-s3-storage_db.php (modified) (3 diffs)
• tags/1.4.3/class/base/cloud-s3-storage_image_function.php (modified) (2 diffs)
• tags/1.4.3/cloud-s3-storage.php (modified) (1 diff)
• tags/1.4.3/readme.txt (modified) (1 diff)
• trunk/class/base/cloud-s3-storage_db.php (modified) (3 diffs)
• trunk/class/base/cloud-s3-storage_image_function.php (modified) (2 diffs)
• trunk/cloud-s3-storage.php (modified) (1 diff)
• trunk/readme.txt (modified) (1 diff)

cloud-s3-storage/tags/1.4.3/class/base/cloud-s3-storage_db.php

@@ -7 +7 @@
 
         public function __construct() {
-
             global $wpdb;
 
@@ -27 +26 @@
             require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
             dbDelta( $sql );
-            
+
+            $column_exists = $wpdb->get_var( "SHOW COLUMNS FROM $table_name LIKE 'last_update'" );
+            if ( ! $column_exists ) {
+                $wpdb->query( "ALTER TABLE $table_name ADD last_update DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL" );
+                error_log("[cloud-s3-storage] Colonna 'last_update' aggiunta automaticamente alla tabella.");
+            }
+
+            $image_id_unique = $wpdb->get_var(
+                $wpdb->prepare(
+                    "SHOW INDEX FROM $table_name WHERE Column_name = %s AND Non_unique = 0",
+                    'image_id'
+                )
+            );
+
+            if (  $image_id_unique  ) {
+                // 🔧 Rimuove l'indice UNIQUE su image_id
+                $wpdb->query( "ALTER TABLE $table_name DROP INDEX image_id" );
+                error_log("[cloud-s3-storage] Indice UNIQUE su 'image_id' rimosso.");
+            }
+
             $this->check_and_insert_all_images();
         }
@@ -84 +102 @@
 
                 foreach ($missing_images as $image) {
+                    if (!isset($image['image_id'])) {
+                        error_log("[cloud-s3-storage] image_id mancante per URL: " . $image['url']);
+                        continue;
+                    }
                     $image_id = isset($image["image_id"]) ? $image["image_id"] : null;
                     $image_url = $image["url"];

cloud-s3-storage/tags/1.4.3/class/base/cloud-s3-storage_image_function.php

@@ -16 +16 @@
         static function getFileAttachFullVersion() {   
             $file_list = [];
+
             $cached_file_list = get_transient('cloud_s3_storage_cached_file_attach_list');
         
@@ -52 +53 @@
         
                             $file_list[$file['file']] = [
+                                'image_id' => $attachment->ID,
                                 'url' => self::sanitize_key_static($relative_path),
                                 'complete_path' => $full_path,

cloud-s3-storage/tags/1.4.3/cloud-s3-storage.php

@@ -3 +3 @@
 Plugin Name: Cloud S3 Storage
 Description: The plugin allows you to manage WordPress media on S3 compatible object storage services.
-Version: 1.4.2
+Version: 1.4.3
 Author: VHosting & Matteo Enna
 Text Domain: cloud-s3-storage

cloud-s3-storage/tags/1.4.3/readme.txt

@@ -6 +6 @@
 Requires PHP: 7.2.5
 Tested up to: 6.8.1
-Stable tag: 1.4.2
+Stable tag: 1.4.3
 License: GPLv2 or later
 

cloud-s3-storage/trunk/class/base/cloud-s3-storage_db.php

@@ -7 +7 @@
 
         public function __construct() {
-
             global $wpdb;
 
@@ -27 +26 @@
             require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
             dbDelta( $sql );
-            
+
+            $column_exists = $wpdb->get_var( "SHOW COLUMNS FROM $table_name LIKE 'last_update'" );
+            if ( ! $column_exists ) {
+                $wpdb->query( "ALTER TABLE $table_name ADD last_update DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL" );
+                error_log("[cloud-s3-storage] Colonna 'last_update' aggiunta automaticamente alla tabella.");
+            }
+
+            $image_id_unique = $wpdb->get_var(
+                $wpdb->prepare(
+                    "SHOW INDEX FROM $table_name WHERE Column_name = %s AND Non_unique = 0",
+                    'image_id'
+                )
+            );
+
+            if (  $image_id_unique  ) {
+                // 🔧 Rimuove l'indice UNIQUE su image_id
+                $wpdb->query( "ALTER TABLE $table_name DROP INDEX image_id" );
+                error_log("[cloud-s3-storage] Indice UNIQUE su 'image_id' rimosso.");
+            }
+
             $this->check_and_insert_all_images();
         }
@@ -84 +102 @@
 
                 foreach ($missing_images as $image) {
+                    if (!isset($image['image_id'])) {
+                        error_log("[cloud-s3-storage] image_id mancante per URL: " . $image['url']);
+                        continue;
+                    }
                     $image_id = isset($image["image_id"]) ? $image["image_id"] : null;
                     $image_url = $image["url"];

cloud-s3-storage/trunk/class/base/cloud-s3-storage_image_function.php

@@ -16 +16 @@
         static function getFileAttachFullVersion() {   
             $file_list = [];
+
             $cached_file_list = get_transient('cloud_s3_storage_cached_file_attach_list');
         
@@ -52 +53 @@
         
                             $file_list[$file['file']] = [
+                                'image_id' => $attachment->ID,
                                 'url' => self::sanitize_key_static($relative_path),
                                 'complete_path' => $full_path,

cloud-s3-storage/trunk/cloud-s3-storage.php

@@ -3 +3 @@
 Plugin Name: Cloud S3 Storage
 Description: The plugin allows you to manage WordPress media on S3 compatible object storage services.
-Version: 1.4.2
+Version: 1.4.3
 Author: VHosting & Matteo Enna
 Text Domain: cloud-s3-storage

cloud-s3-storage/trunk/readme.txt

@@ -6 +6 @@
 Requires PHP: 7.2.5
 Tested up to: 6.8.1
-Stable tag: 1.4.2
+Stable tag: 1.4.3
 License: GPLv2 or later