Changeset 3096067

Timestamp:

06/01/2024 01:37:30 PM (21 months ago)

Author:

dipakraval

Message:

issue solve

Location:

bulk-mail-sender

Files:

• tags/1.1.5/App/BMSIActivate.php (modified) (3 diffs)
• trunk/App/BMSIActivate.php (modified) (3 diffs)

bulk-mail-sender/tags/1.1.5/App/BMSIActivate.php

@@ -59 +59 @@
         )ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
 
-
-
         $create_tbl_history = "CREATE TABLE $tbl_history (
             `id` int(25) not null auto_increment,
@@ -81 +79 @@
 
 
-        $alter_tbl_history = "ALTER TABLE $tbl_history
-            ADD COLUMN `open_count` varchar(50) NOT NULL DEFAULT '0'";
-
         require_once (ABSPATH . '/wp-admin/includes/upgrade.php');
         maybe_create_table($tbl_mail_details, $create_tbl_mail_details);
@@ -92 +87 @@
         maybe_create_table($tbl_email_queue, $create_tbl_email_queue);
 
-
-        $wpdb->query($alter_tbl_history);
+        if ($wpdb->get_var("SHOW COLUMNS FROM $tbl_history LIKE 'open_count'") !== 'open_count') {
+           
+            $alter_tbl_history = "ALTER TABLE $tbl_history ADD COLUMN `open_count` varchar(50) NOT NULL DEFAULT '0'";
+            $wpdb->query($alter_tbl_history);
+        }
     }
 
 }
-?>

bulk-mail-sender/trunk/App/BMSIActivate.php

@@ -59 +59 @@
         )ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
 
-
-
         $create_tbl_history = "CREATE TABLE $tbl_history (
             `id` int(25) not null auto_increment,
@@ -81 +79 @@
 
 
-        $alter_tbl_history = "ALTER TABLE $tbl_history
-            ADD COLUMN `open_count` varchar(50) NOT NULL DEFAULT '0'";
-
         require_once (ABSPATH . '/wp-admin/includes/upgrade.php');
         maybe_create_table($tbl_mail_details, $create_tbl_mail_details);
@@ -92 +87 @@
         maybe_create_table($tbl_email_queue, $create_tbl_email_queue);
 
-
-        $wpdb->query($alter_tbl_history);
+        if ($wpdb->get_var("SHOW COLUMNS FROM $tbl_history LIKE 'open_count'") !== 'open_count') {
+           
+            $alter_tbl_history = "ALTER TABLE $tbl_history ADD COLUMN `open_count` varchar(50) NOT NULL DEFAULT '0'";
+            $wpdb->query($alter_tbl_history);
+        }
     }
 
 }
-?>