ULTRA DEBUG COPY START

Source: aicom_qmn
Target: aicom_qmn1

[DEBUG] Selecting source DB
[OK] Tables found: 103

TABLE: accounts

[DEBUG] SHOW CREATE TABLE `accounts`
[DEBUG] CREATE SQL:
[DEBUG] CREATE TABLE `accounts` (
  `id` int NOT NULL,
  `parent_id` int DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `level` int DEFAULT NULL,
  `col5` varchar(100) DEFAULT NULL,
  `col6` varchar(100) DEFAULT NULL,
  `col7` varchar(100) DEFAULT NULL,
  `col8` varchar(100) DEFAULT NULL,
  `col9` varchar(100) DEFAULT NULL,
  `col10` varchar(100) DEFAULT NULL,
  `col11` varchar(100) DEFAULT NULL,
  `col12` varchar(100) DEFAULT NULL,
  `col13` varchar(100) DEFAULT NULL,
  `col14` varchar(100) DEFAULT NULL,
  `col15` varchar(100) DEFAULT NULL,
  `col16` varchar(100) DEFAULT NULL,
  `col17` varchar(100) DEFAULT NULL,
  `col18` varchar(100) DEFAULT NULL,
  `col19` varchar(100) DEFAULT NULL,
  `col20` varchar(100) DEFAULT NULL,
  `opening_balance` decimal(12,2) DEFAULT NULL,
  `col22` varchar(100) DEFAULT NULL,
  `col23` varchar(100) DEFAULT NULL,
  `group_id` int DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `col27` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
[DEBUG] Switching to target DB
[OK] Table exists
[DEBUG] TRUNCATE TABLE `accounts`
[OK] Target table truncated
[DEBUG] Switching back to source DB
[DEBUG] Column: id | Type: int
[DEBUG] → Non-empty rows: 925
[DEBUG] Column: parent_id | Type: int
[DEBUG] → Non-empty rows: 925
[DEBUG] Column: title | Type: varchar(100)
[DEBUG] → Non-empty rows: 925
[DEBUG] Column: level | Type: int
[DEBUG] → Non-empty rows: 925
[DEBUG] Column: col5 | Type: varchar(100)
[DEBUG] → Non-empty rows: 899
[DEBUG] Column: col6 | Type: varchar(100)
[DEBUG] → Non-empty rows: 1
[DEBUG] Column: col7 | Type: varchar(100)
[DEBUG] → Non-empty rows: 3
[DEBUG] Column: col8 | Type: varchar(100)
[DEBUG] → Non-empty rows: 17
[DEBUG] Column: col9 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: col10 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: col11 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: col12 | Type: varchar(100)
[DEBUG] → Non-empty rows: 1
[DEBUG] Column: col13 | Type: varchar(100)
[DEBUG] → Non-empty rows: 7
[DEBUG] Column: col14 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: col15 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: col16 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: col17 | Type: varchar(100)
[DEBUG] → Non-empty rows: 5
[DEBUG] Column: col18 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: col19 | Type: varchar(100)
[DEBUG] → Non-empty rows: 5
[DEBUG] Column: col20 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: opening_balance | Type: decimal(12,2)
[DEBUG] → Non-empty rows: 5
[DEBUG] Column: col22 | Type: varchar(100)
[DEBUG] → Non-empty rows: 5
[DEBUG] Column: col23 | Type: varchar(100)
[DEBUG] → Non-empty rows: 0
[DEBUG] Column: group_id | Type: int
[DEBUG] → Non-empty rows: 241
[DEBUG] Column: remarks | Type: varchar(255)
[DEBUG] → Non-empty rows: 241
[DEBUG] Column: is_active | Type: tinyint(1)
[DEBUG] → Non-empty rows: 907
[DEBUG] Column: col27 | Type: varchar(100)
[DEBUG] → Non-empty rows: 223
[DEBUG] Column: created_at | Type: datetime
[ERROR] MYSQL EXCEPTION
[ERROR] Incorrect DATETIME value: ''
[ERROR] SQLSTATE: HY000
[ERROR] Error Code: 1525