Return to Question

Improved Formatting

Source Link

edit approved Feb 11, 2022 at 8:36

Klarna module log clean cron to clean the log throws the error and cron job failed, Table: cron_schedule jobe_code : klarna_core_clean_logs Error: 'SQLSTATE[42S22]: Column not found: 1054 Unknown column ''store_id'' in ''where clause'', query was

Table: SELECT COUNT(*) FROM klarna_logscron_schedule AS

job_code main_table WHERE: (store_idklarna_core_clean_logs = ''0'') AND

Error: (created_at'SQLSTATE[42S22]: Column not found: 1054 Unknown column ''store_id'' in ''where clause'', query was: SELECT COUNT(*) FROM `klarna_logs` AS `main_table` WHERE (`store_id` = ''0'') AND (`created_at` <= ''2021-07-14'')' <= ''2021-07-14'')'

Klarna module log clean cron throws the error and cron job failed, Table: cron_schedule jobe_code : klarna_core_clean_logs Error: 'SQLSTATE[42S22]: Column not found: 1054 Unknown column ''store_id'' in ''where clause'', query was: SELECT COUNT(*) FROM klarna_logs AS main_table WHERE (store_id = ''0'') AND (created_at <= ''2021-07-14'')'

Klarna cron to clean the log throws the error and cron job failed:

Table: cron_schedule

job_code : klarna_core_clean_logs

Error: 'SQLSTATE[42S22]: Column not found: 1054 Unknown column ''store_id'' in ''where clause'', query was: SELECT COUNT(*) FROM `klarna_logs` AS `main_table` WHERE (`store_id` = ''0'') AND (`created_at` <= ''2021-07-14'')'