2026-06-26 18:54:39.974 INFO - UPDATE SEQ DONE: 2 tariff
2026-06-26 18:54:39.974 INFO - findTariffSeq Complete
2026-06-26 18:54:40.193 INFO - UPDATE STAT AND UNIT QTY DONE: 2 tariff
2026-06-26 18:54:40.193 INFO - findStatCode Complete
2026-06-26 18:54:40.468 INFO - checkPermission Complete
2026-06-26 18:54:40.484 INFO - ROUND 2 SKIP : no pending tariff
2026-06-26 18:54:40.484 INFO - checkEmptyHscode Complete
2026-06-26 18:54:40.562 INFO - updateEcommerceNo Complete
2026-06-26 18:56:47.128 INFO - UPDATE SEQ DONE: 504 tariff
2026-06-26 18:56:47.128 INFO - findTariffSeq Complete
2026-06-26 18:56:55.077 INFO - UPDATE STAT AND UNIT QTY DONE: 510 tariff
2026-06-26 18:56:55.077 INFO - findStatCode Complete
2026-06-26 18:57:05.007 INFO - checkPermission Complete
2026-06-26 18:57:44.116 INFO - ROUND 2 ->> callSmartTariffAPI After checkPermission Complete
2026-06-26 18:57:47.711 INFO - UPDATE SEQ DONE: 117 tariff
2026-06-26 18:57:47.711 INFO - ROUND 2 ->> findTariffSeq Complete
2026-06-26 18:57:50.982 INFO - UPDATE STAT AND UNIT QTY DONE: 127 tariff
2026-06-26 18:57:50.982 INFO - ROUND 2 ->> findStatCode Complete
2026-06-26 18:57:51.841 INFO - ROUND 2 ->> checkPermission Complete
2026-06-26 18:57:52.129 INFO - checkEmptyHscode Complete
2026-06-26 18:57:55.078 INFO - updateEcommerceNo Complete
2026-06-26 19:09:10.793 INFO - UPDATE SEQ DONE: 504 tariff
2026-06-26 19:09:10.793 INFO - findTariffSeq Complete
2026-06-26 19:09:18.836 INFO - UPDATE STAT AND UNIT QTY DONE: 510 tariff
2026-06-26 19:09:18.836 INFO - findStatCode Complete
2026-06-26 19:09:28.532 INFO - checkPermission Complete
2026-06-26 19:10:07.353 INFO - ROUND 2 ->> callSmartTariffAPI After checkPermission Complete
2026-06-26 19:10:10.950 INFO - UPDATE SEQ DONE: 117 tariff
2026-06-26 19:10:10.950 INFO - ROUND 2 ->> findTariffSeq Complete
2026-06-26 19:10:14.094 INFO - UPDATE STAT AND UNIT QTY DONE: 127 tariff
2026-06-26 19:10:14.094 INFO - ROUND 2 ->> findStatCode Complete
2026-06-26 19:10:14.962 INFO - ROUND 2 ->> checkPermission Complete
2026-06-26 19:10:15.275 INFO - checkEmptyHscode Complete
2026-06-26 19:10:17.381 INFO - updateEcommerceNo Complete
2026-06-26 19:54:56.485 INFO - UPDATE SEQ DONE: 2 tariff
2026-06-26 19:54:56.485 INFO - findTariffSeq Complete
2026-06-26 19:54:56.704 INFO - UPDATE STAT AND UNIT QTY DONE: 2 tariff
2026-06-26 19:54:56.704 INFO - findStatCode Complete
2026-06-26 19:54:56.735 INFO - checkPermission Complete
2026-06-26 19:54:56.751 INFO - ROUND 2 SKIP : no pending tariff
2026-06-26 19:54:56.751 INFO -
| Error
2026-06-26 19:54:56.751 INFO - Message |
| SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(
2026-06-26 19:54:56.751 INFO - OR statistical_code = ''
2026-06-26 19:54:56.751 INFO - OR statistical_code' at line 4 |
|
2026-06-26 19:54:56.751 INFO - UPDATE temp_ecommerce_data
2026-06-26 19:54:56.751 INFO - SET tariff_code = '',statistical_code = '',english_description_of_good = original_endesc,tariff_sequence = '',quantity_unit_code = '',thai_description_of_good = ''
2026-06-26 19:54:56.751 INFO - WHERE e_id = '197' AND tariff_code <> ''
2026-06-26 19:54:56.751 INFO - (
2026-06-26 19:54:56.751 INFO - OR statistical_code = ''
2026-06-26 19:54:56.751 INFO - OR statistical_code IS NULL
2026-06-26 19:54:56.751 INFO - )
2026-06-26 19:54:56.767 INFO - |
2026-06-26 20:00:35.756 INFO - UPDATE SEQ DONE: 504 tariff
2026-06-26 20:00:35.756 INFO - findTariffSeq Complete
2026-06-26 20:00:43.820 INFO - UPDATE STAT AND UNIT QTY DONE: 510 tariff
2026-06-26 20:00:43.820 INFO - findStatCode Complete
2026-06-26 20:00:53.486 INFO - checkPermission Complete
2026-06-26 20:01:34.794 INFO - ROUND 2 ->> callSmartTariffAPI After checkPermission Complete
2026-06-26 20:01:38.563 INFO - UPDATE SEQ DONE: 117 tariff
2026-06-26 20:01:38.563 INFO - ROUND 2 ->> findTariffSeq Complete
2026-06-26 20:01:41.901 INFO - UPDATE STAT AND UNIT QTY DONE: 127 tariff
2026-06-26 20:01:41.901 INFO - ROUND 2 ->> findStatCode Complete
2026-06-26 20:01:42.885 INFO - ROUND 2 ->> checkPermission Complete
2026-06-26 20:01:42.885 INFO - | Error
2026-06-26 20:01:42.885 INFO - Message |
| SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR statistical_code = ''
2026-06-26 20:01:42.885 INFO - OR statistical_code IS NULL
2026-06-26 20:01:42.885 INFO - ' at line 5 |
|
2026-06-26 20:01:42.885 INFO - UPDATE temp_ecommerce_data
2026-06-26 20:01:42.885 INFO - SET tariff_code = '',statistical_code = '',english_description_of_good = original_endesc,tariff_sequence = '',quantity_unit_code = '',thai_description_of_good = ''
2026-06-26 20:01:42.885 INFO - WHERE e_id = '199' AND tariff_code <> '' AND
2026-06-26 20:01:42.885 INFO - (
2026-06-26 20:01:42.885 INFO - OR statistical_code = ''
2026-06-26 20:01:42.885 INFO - OR statistical_code IS NULL
2026-06-26 20:01:42.885 INFO - )
2026-06-26 20:01:42.995 INFO - |
2026-06-26 20:04:08.708 INFO - UPDATE SEQ DONE: 504 tariff
2026-06-26 20:04:08.708 INFO - findTariffSeq Complete
2026-06-26 20:04:17.088 INFO - UPDATE STAT AND UNIT QTY DONE: 510 tariff
2026-06-26 20:04:17.088 INFO - findStatCode Complete
2026-06-26 20:04:27.250 INFO - checkPermission Complete
2026-06-26 20:05:07.110 INFO - ROUND 2 ->> callSmartTariffAPI After checkPermission Complete
2026-06-26 20:05:11.203 INFO - UPDATE SEQ DONE: 117 tariff
2026-06-26 20:05:11.203 INFO - ROUND 2 ->> findTariffSeq Complete
2026-06-26 20:05:14.683 INFO - UPDATE STAT AND UNIT QTY DONE: 127 tariff
2026-06-26 20:05:14.683 INFO - ROUND 2 ->> findStatCode Complete
2026-06-26 20:05:15.461 INFO - ROUND 2 ->> checkPermission Complete
2026-06-26 20:05:15.683 INFO - checkEmptyStatcode Complete
2026-06-26 20:05:17.748 INFO - updateEcommerceNo Complete