📄 Parser Logs

[Thu Apr 09 00:21:51.451314 2026] [proxy_fcgi:error] [pid 548083:tid 136856171701952] [client 128.76.227.200:0] AH01071: Got error 'PHP message: SQL Console Error by bmcadmin: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET @daily_http_job_id = LAST_INSERT_ID();\n\n-- Task 1: Daily catalog and pric...' at line 24; PHP message: Query: -- Setup DCS import jobs with task-level connections\n-- This script creates:\n-- 1. Daily catalog and pricelist import via HTTP pull\n\n-- Job 1: Daily full pricelist (HTTP pull) at 7:00\nINSERT INTO scheduled_jobs (\n    job_name,\n    job_type,\n    handler_class,\n    config,\n    schedule_minutes,\n    next_run_at,\n    is_active\n) VALUES (\n    'dcs_daily_http_import',\n    'supplier_import',\n    'App\\\\jobs\\\\SupplierImportJob',\n    '{"task_id": 1}',\n    1440,\n    CONCAT(CURDATE() + INTERVAL (CASE WHEN CURTIME() > '07:00:00' THEN 1 ELSE 0 END) DAY, ' 07:00:00'),\n    1\n) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id);\n\nSET @daily_http_job_id = LAST_INSERT_ID();\n\n-- Task 1: Daily catalog and pricelist via HTTP pull\nINSERT INTO supplier_import_tasks (\n    supplier_id,\n    scheduled_job_id,\n    task_name,\n    task_type,\n    filename_pattern,\n    parser_class,\n    import_options,\n    connection_type,\n    connection_details\n) VALUES (\n    1,\n    @daily_http_job_id,\n    'Daily Catalog & Prices via HTTP...', referer: https://apigateway.bmcnetworks.dk/admin/sql-console.html
[Sun Apr 12 15:43:43.174963 2026] [proxy_fcgi:error] [pid 842100:tid 136173456443072] [client 128.76.227.200:0] AH01071: Got error 'PHP message: SQL Console Error by bmcadmin: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET @daily_http_job_id = LAST_INSERT_ID();\n\n-- Task 1: Daily catalog and pric...' at line 24; PHP message: Query: -- Setup DCS import jobs with task-level connections\n-- This script creates:\n-- 1. Daily catalog and pricelist import via HTTP pull\n\n-- Job 1: Daily full pricelist (HTTP pull) at 7:00\nINSERT INTO scheduled_jobs (\n    job_name,\n    job_type,\n    handler_class,\n    config,\n    schedule_minutes,\n    next_run_at,\n    is_active\n) VALUES (\n    'dcs_daily_http_import',\n    'supplier_import',\n    'App\\\\jobs\\\\SupplierImportJob',\n    '{"task_id": 1}',\n    1440,\n    CONCAT(CURDATE() + INTERVAL (CASE WHEN CURTIME() > '07:00:00' THEN 1 ELSE 0 END) DAY, ' 07:00:00'),\n    1\n) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id);\n\nSET @daily_http_job_id = LAST_INSERT_ID();\n\n-- Task 1: Daily catalog and pricelist via HTTP pull\nINSERT INTO supplier_import_tasks (\n    supplier_id,\n    scheduled_job_id,\n    task_name,\n    task_type,\n    filename_pattern,\n    parser_class,\n    import_options,\n    connection_type,\n    connection_details\n) VALUES (\n    1,\n    @daily_http_job_id,\n    'Daily Catalog & Prices via HTTP...', referer: https://apigateway.bmcnetworks.dk/admin/sql-console.html
[Sun Apr 12 15:55:23.982960 2026] [proxy_fcgi:error] [pid 842100:tid 136174505006784] [client 128.76.227.200:0] AH01071: Got error 'PHP message: SQL Console Error by bmcadmin: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INSERT INTO scheduled_jobs (\n    job_name,\n    job_type,\n    handler_class,\n ...' at line 5; PHP message: Query: -- Disable existing DCS jobs\nUPDATE scheduled_jobs SET is_active = 0 WHERE job_name IN ('dcs_daily_pricelist', 'dcs_hourly_inventory');\n\n-- Create or update the Daily HTTP job\nINSERT INTO scheduled_jobs (\n    job_name,\n    job_type,\n    handler_class,\n    config,\n    schedule_minutes,\n    next_run_at,\n    is_active\n) VALUES (\n    'dcs_daily_http_import',\n    'supplier_import',\n    'App\\\\jobs\\\\SupplierImportJob',\n    '{}',\n    1440,\n    CONCAT(DATE_ADD(CURDATE(), INTERVAL 1 DAY), ' 07:00:00'),\n    1\n) ON DUPLICATE KEY UPDATE \n    schedule_minutes = 1440,\n    next_run_at = CONCAT(DATE_ADD(CURDATE(), INTERVAL 1 DAY), ' 07:00:00'),\n    is_active = 1,\n    id=LAST_INSERT_ID(id);\n\nSET @job_id = LAST_INSERT_ID();\n\nDELETE FROM supplier_import_tasks WHERE scheduled_job_id = @job_id;\n\nINSERT INTO supplier_import_tasks (\n    supplier_id,\n    scheduled_job_id,\n    task_name,\n    task_type,\n    filename_pattern,\n    parser_class,\n    import_options,\n    connection_type,\n    connection_details\n) VALU...', referer: https://apigateway.bmcnetworks.dk/admin/sql-console.html
[Fri Apr 17 18:51:27.158722 2026] [proxy_fcgi:error] [pid 1341127:tid 136174261749440] [client 128.76.227.200:0] AH01071: Got error 'PHP message: SQL Console Error by bmcadmin: SQLSTATE[42000]: Syntax error or access violation: 1250 Table 't' from one of the SELECTs cannot be used in ORDER BY; PHP message: Query: SELECT\n    section,\n    sort_order,\n    payload\nFROM (\n    SELECT\n        'supplier_task_job' AS section,\n        10 AS sort_order,\n        JSON_OBJECT(\n            'supplier_id', s.id,\n            'supplier_name', s.name,\n            'supplier_code', s.code,\n            'supplier_connection_type', s.connection_type,\n            'task_id', t.id,\n            'task_name', t.task_name,\n            'task_type', t.task_type,\n            'filename_pattern', t.filename_pattern,\n            'parser_class', t.parser_class,\n            'task_connection_type', t.connection_type,\n            'job_id', j.id,\n            'job_name', j.job_name,\n            'job_active', j.is_active,\n            'job_last_run_at', j.last_run_at,\n            'job_next_run_at', j.next_run_at,\n            'job_last_error', j.last_error\n        ) AS payload\n    FROM suppliers s\n    LEFT JOIN supplier_import_tasks t ON t.supplier_id = s.id\n    LEFT JOIN scheduled_jobs j ON j.id = t.scheduled_job_id\n    WHERE LOWER(s.code)...', referer: https://apigateway.bmcnetworks.dk/admin/sql-console.html
[Fri Apr 17 19:01:10.792845 2026] [proxy_fcgi:error] [pid 1341127:tid 136174664402624] [client 128.76.227.200:0] AH01071: Got error 'PHP message: SQL Console Error by bmcadmin: SQLSTATE[42000]: Syntax error or access violation: 1250 Table 't' from one of the SELECTs cannot be used in ORDER BY; PHP message: Query: SELECT\n    section,\n    sort_order,\n    payload\nFROM (\n    SELECT\n        'supplier_task_job' AS section,\n        10 AS sort_order,\n        JSON_OBJECT(\n            'supplier_id', s.id,\n            'supplier_name', s.name,\n            'supplier_code', s.code,\n            'supplier_connection_type', s.connection_type,\n            'task_id', t.id,\n            'task_name', t.task_name,\n            'task_type', t.task_type,\n            'filename_pattern', t.filename_pattern,\n            'parser_class', t.parser_class,\n            'task_connection_type', t.connection_type,\n            'job_id', j.id,\n            'job_name', j.job_name,\n            'job_active', j.is_active,\n            'job_last_run_at', j.last_run_at,\n            'job_next_run_at', j.next_run_at,\n            'job_last_error', j.last_error\n        ) AS payload\n    FROM suppliers s\n    LEFT JOIN supplier_import_tasks t ON t.supplier_id = s.id\n    LEFT JOIN scheduled_jobs j ON j.id = t.scheduled_job_id\n    WHERE LOWER(s.code)...', referer: https://apigateway.bmcnetworks.dk/admin/sql-console.html