Generated: 2026-08-28 12:58:01 AWST
Latest detected log timestamp: 2026-08-28 03:49:43
Latest detected log timestamp: 2026-08-28 03:49:43
=== JFM BILLING LATEST ERROR LOG TAIL ===
Generated: 2026-08-28 12:58:01 AWST
Latest detected log timestamp: 2026-08-28 03:49:43
[2026-08-02 11:30:56] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'end_customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select exists(select * from `reseller_customer_links` where `end_customer_id` = 3) as `exists`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'end_customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select exists(select * from `reseller_customer_links` where `end_customer_id` = 3) as `exists`) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'end_customer_id' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-02 11:32:47] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT COUNT(*) as cnt, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS size_mb FROM information_schema.TABLES WHERE table_schema = 'jfmbilling' AND table_name = 'audit_logs') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT COUNT(*) as cnt, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS size_mb FROM information_schema.TABLES WHERE table_schema = 'jfmbilling' AND table_name = 'audit_logs') at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-02 12:12:40] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company_name' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customers` where (`billing_name` like %Healthy% or `pbx_tenant_name` like %Healthy% or `company_name` like %Healthy% or `display_name` like %Healthy%)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company_name' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customers` where (`billing_name` like %Healthy% or `pbx_tenant_name` like %Healthy% or `company_name` like %Healthy% or `display_name` like %Healthy%)) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company_name' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-02 12:12:58] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'billing_customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `reseller_invoice_templates` where `billing_customer_id` = 16 or `reseller_customer_id` = 16 limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'billing_customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `reseller_invoice_templates` where `billing_customer_id` = 16 or `reseller_customer_id` = 16 limit 1) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'billing_customer_id' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-02 12:13:15] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `reseller_invoice_templates` where `customer_id` = 16 or `reseller_id` = 16) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `reseller_invoice_templates` where `customer_id` = 16 or `reseller_id` = 16) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customer_id' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-02 12:35:57] production.ERROR: Undefined property: stdClass::$period_start {"exception":"[object] (ErrorException(code: 0): Undefined property: stdClass::$period_start at /tmp/jfm-agent-run.php:15)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-agent-run.php(15): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-02 12:38:57] production.ERROR: Undefined property: stdClass::$to {"exception":"[object] (ErrorException(code: 0): Undefined property: stdClass::$to at /tmp/jfm-agent-run.php:11)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-agent-run.php(11): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-03 23:54:57] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'qty' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, code, description, qty, unit_price, next_invoice_date, is_active, start_date FROM recurring_charges WHERE customer_id=3 ORDER BY id) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'qty' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, code, description, qty, unit_price, next_invoice_date, is_active, start_date FROM recurring_charges WHERE customer_id=3 ORDER BY id) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'qty' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-03 23:55:11] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'period_start' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, invoice_number, invoice_date, due_date, status, sent_at, created_at, period_start, period_end FROM invoices WHERE customer_id=3 AND created_at >= '2026-08-01' ORDER BY id DESC) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'period_start' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, invoice_number, invoice_date, due_date, status, sent_at, created_at, period_start, period_end FROM invoices WHERE customer_id=3 AND created_at >= '2026-08-01' ORDER BY id DESC) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'period_start' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-03 23:55:30] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'il.total' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT il.invoice_id, il.recurring_charge_id, il.description, il.quantity, il.unit_price, il.total FROM invoice_lines il JOIN invoices i ON il.invoice_id=i.id WHERE i.customer_id=3 ORDER BY il.id DESC LIMIT 15) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'il.total' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT il.invoice_id, il.recurring_charge_id, il.description, il.quantity, il.unit_price, il.total FROM invoice_lines il JOIN invoices i ON il.invoice_id=i.id WHERE i.customer_id=3 ORDER BY il.id DESC LIMIT 15) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'il.total' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-04 00:00:04] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recipient_email' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, recipient_email, subject, status, sent_at, created_at FROM email_delivery_logs WHERE created_at >= '2026-08-01' ORDER BY id) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recipient_email' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, recipient_email, subject, status, sent_at, created_at FROM email_delivery_logs WHERE created_at >= '2026-08-01' ORDER BY id) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recipient_email' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-04 00:00:21] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sent_at' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, invoice_id, recipient_email, subject, status, sent_at FROM invoice_send_logs WHERE created_at >= '2026-08-01' ORDER BY id) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sent_at' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: SELECT id, invoice_id, recipient_email, subject, status, sent_at FROM invoice_send_logs WHERE created_at >= '2026-08-01' ORDER BY id) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sent_at' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-04 05:26:19] production.ERROR: Call to private method App\Support\QuickBooks\QuickBooksAgentClient::getJson() from global scope {"exception":"[object] (Error(code: 0): Call to private method App\\Support\\QuickBooks\\QuickBooksAgentClient::getJson() from global scope at /tmp/fogartys-qb-lookup.php:67)
[2026-08-04 07:35:55] production.ERROR: syntax error, unexpected token "use" (View: /opt/jfmbilling/app/resources/views/pdf/invoice.blade.php) {"exception":"[object] (Illuminate\\View\\ViewException(code: 0): syntax error, unexpected token \"use\" (View: /opt/jfmbilling/app/resources/views/pdf/invoice.blade.php) at /opt/jfmbilling/app/storage/framework/views/ea11fda88ff7ff0294a6eb1a0edae0df.php:180)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(59): Illuminate\\View\\Engines\\CompilerEngine->handleViewException()
[previous exception] [object] (ParseError(code: 0): syntax error, unexpected token \"use\" at /opt/jfmbilling/app/storage/framework/views/ea11fda88ff7ff0294a6eb1a0edae0df.php:180)
[2026-08-04 08:01:05] production.ERROR: Undefined property: stdClass::$name {"exception":"[object] (ErrorException(code: 0): Undefined property: stdClass::$name at /tmp/jfm-fogartys-list.php:9)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-fogartys-list.php(9): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-04 08:02:32] production.WARNING: QbLodge push failed {"queue_id":15,"invoice_id":549,"error":"Exception calling \"ProcessRequest\" with \"2\" argument(s): \"Reckon Accounts found an error when parsing the provided XML text stream.\" [jfm]","retryable":true}
[2026-08-04 08:02:34] production.WARNING: QbLodge push failed {"queue_id":16,"invoice_id":550,"error":"InvoiceAdd statusCode=3060: There was an error when converting the quantity \"1\" in the field \"item quantity\". Reckon Accounts error message: You cannot set the quantity for items of this type. [jfm]","retryable":true}
[2026-08-04 08:02:36] production.WARNING: QbLodge push failed {"queue_id":17,"invoice_id":551,"error":"InvoiceAdd statusCode=3060: There was an error when converting the quantity \"1\" in the field \"item quantity\". Reckon Accounts error message: You cannot set the quantity for items of this type. [jfm]","retryable":true}
[2026-08-04 08:02:38] production.WARNING: QbLodge push failed {"queue_id":18,"invoice_id":552,"error":"InvoiceAdd statusCode=3060: There was an error when converting the quantity \"1\" in the field \"item quantity\". Reckon Accounts error message: You cannot set the quantity for items of this type. [jfm]","retryable":true}
[2026-08-04 08:02:40] production.WARNING: QbLodge push failed {"queue_id":19,"invoice_id":553,"error":"InvoiceAdd statusCode=3060: There was an error when converting the quantity \"1\" in the field \"item quantity\". Reckon Accounts error message: You cannot set the quantity for items of this type. [jfm]","retryable":true}
[2026-08-04 08:02:42] production.WARNING: QbLodge push failed {"queue_id":20,"invoice_id":554,"error":"InvoiceAdd statusCode=3060: There was an error when converting the quantity \"1\" in the field \"item quantity\". Reckon Accounts error message: You cannot set the quantity for items of this type. [jfm]","retryable":true}
[2026-08-04 08:02:44] production.WARNING: QbLodge push failed {"queue_id":21,"invoice_id":555,"error":"InvoiceAdd statusCode=3060: There was an error when converting the quantity \"1\" in the field \"item quantity\". Reckon Accounts error message: You cannot set the quantity for items of this type. [jfm]","retryable":true}
[2026-08-04 08:04:35] production.WARNING: QbLodge push failed {"queue_id":16,"invoice_id":550,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"-100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:04:37] production.WARNING: QbLodge push failed {"queue_id":17,"invoice_id":551,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"-100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:04:39] production.WARNING: QbLodge push failed {"queue_id":18,"invoice_id":552,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"-100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:04:41] production.WARNING: QbLodge push failed {"queue_id":19,"invoice_id":553,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"-100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:04:43] production.WARNING: QbLodge push failed {"queue_id":20,"invoice_id":554,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"-100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:04:45] production.WARNING: QbLodge push failed {"queue_id":21,"invoice_id":555,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"-100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:06:13] production.WARNING: QbLodge push failed {"queue_id":16,"invoice_id":550,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:06:15] production.WARNING: QbLodge push failed {"queue_id":17,"invoice_id":551,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:06:17] production.WARNING: QbLodge push failed {"queue_id":18,"invoice_id":552,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:06:19] production.WARNING: QbLodge push failed {"queue_id":19,"invoice_id":553,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:06:21] production.WARNING: QbLodge push failed {"queue_id":20,"invoice_id":554,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:06:23] production.WARNING: QbLodge push failed {"queue_id":21,"invoice_id":555,"error":"InvoiceAdd statusCode=3040: There was an error when converting the amount \"100\" in the field \"Amount\". [jfm]","retryable":true}
[2026-08-04 08:12:14] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `app_settings` where `key` like invoice_email% or `key` like %email%mode%) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `app_settings` where `key` like invoice_email% or `key` like %email%mode%) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-04 08:21:44] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jfmbilling.customer_recurring_charges' doesn't exist (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customer_recurring_charges` where `id` = 685 limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jfmbilling.customer_recurring_charges' doesn't exist (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customer_recurring_charges` where `id` = 685 limit 1) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jfmbilling.customer_recurring_charges' doesn't exist at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-04 10:43:16] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `account_code`, `billing_name`, `name`, `pbx_tenant_name`, `is_active` from `customers` where `account_code` = 12 or `billing_name` like %Hardware% or `name` like %Hardware% or `pbx_tenant_name` like %Hardware% limit 15) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `account_code`, `billing_name`, `name`, `pbx_tenant_name`, `is_active` from `customers` where `account_code` = 12 or `billing_name` like %Hardware% or `name` like %Hardware% or `pbx_tenant_name` like %Hardware% limit 15) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-06 00:47:07] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ex_tenant_id' in 'where clause' (Connection: mirta, Host: 127.0.0.1, Port: 3307, Database: asterisk, SQL: select count(*) as aggregate from `ex_extensions` where `ex_tenant_id` = 11) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ex_tenant_id' in 'where clause' (Connection: mirta, Host: 127.0.0.1, Port: 3307, Database: asterisk, SQL: select count(*) as aggregate from `ex_extensions` where `ex_tenant_id` = 11) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ex_tenant_id' in 'where clause' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-06 00:47:35] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'issue_date' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `customer_id`, `invoice_number`, `status`, `total`, `issue_date`, `due_date`, `sent_at` from `invoices` where `customer_id` in (27, 28, 63) order by `id` desc limit 20) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'issue_date' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `customer_id`, `invoice_number`, `status`, `total`, `issue_date`, `due_date`, `sent_at` from `invoices` where `customer_id` in (27, 28, 63) order by `id` desc limit 20) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'issue_date' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-06 01:02:36] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customer_rate_packages` where `customer_id` = 27) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customer_id' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customer_rate_packages` where `customer_id` = 27) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customer_id' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-06 04:09:30] production.ERROR: Call to undefined method Illuminate\Mail\Message::withSymfonyMessage() {"exception":"[object] (BadMethodCallException(code: 0): Call to undefined method Illuminate\\Mail\\Message::withSymfonyMessage() at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:67)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(36): Illuminate\\Mail\\Message::throwBadMethodCallException()
[2026-08-06 04:29:30] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: update `customers` set `billing_name` = Lane Buck & Higgins, `billing_name_manually_set` = 1, `address_line_1` = PO Box 182, `address_line_1_manually_set` = 1, `address_line_2` = Narrogin, WA 6312, `address_line_2_manually_set` = 1, `billing_email` = busselton@lbh.net.au, narrogin@lbh.net.au, `billing_email_manually_set` = 1, `structured_billing_metadata` = Organisation: Lane Buck & Higgins (Barristers & Solicitors)
Updated: 2026-08-06 from lanebuckhiggins.com.au + DID confirm, `structured_billing_metadata_manually_set` = 1, `updated_at` = 2026-08-06 04:29:30, `qb_sync_enabled` = 1, `qb_customer_fullname` = Lane Buck & Higgins, `qb_company_key` = jfm where `id` = 27) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: update `customers` set `billing_name` = Lane Buck & Higgins, `billing_name_manually_set` = 1, `address_line_1` = PO Box 182, `address_line_1_manually_set` = 1, `address_line_2` = Narrogin, WA 6312, `address_line_2_manually_set` = 1, `billing_email` = busselton@lbh.net.au, narrogin@lbh.net.au, `billing_email_manually_set` = 1, `structured_billing_metadata` = Organisation: Lane Buck & Higgins (Barristers & Solicitors)
[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:612)
[2026-08-06 04:33:53] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: update `customers` set `billing_name` = Lane Buck & Higgins, `billing_name_manually_set` = 1, `address_line_1` = PO Box 182, `address_line_1_manually_set` = 1, `address_line_2` = Narrogin, WA 6312, `address_line_2_manually_set` = 1, `billing_email` = simon@jfmcommunications.com.au, `billing_email_manually_set` = 1, `structured_billing_metadata` = Organisation: Lane Buck & Higgins (Barristers & Solicitors)
Updated: 2026-08-06 from lanebuckhiggins.com.au + DID confirm, `structured_billing_metadata_manually_set` = 1, `updated_at` = 2026-08-06 04:33:53, `qb_sync_enabled` = 1, `qb_customer_fullname` = Lane Buck & Higgins, `qb_company_key` = jfm where `id` = 27) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: update `customers` set `billing_name` = Lane Buck & Higgins, `billing_name_manually_set` = 1, `address_line_1` = PO Box 182, `address_line_1_manually_set` = 1, `address_line_2` = Narrogin, WA 6312, `address_line_2_manually_set` = 1, `billing_email` = simon@jfmcommunications.com.au, `billing_email_manually_set` = 1, `structured_billing_metadata` = Organisation: Lane Buck & Higgins (Barristers & Solicitors)
[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:612)
[2026-08-06 04:37:38] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'amount' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `customer_id`, `description`, `amount`, `code`, `is_active` from `recurring_charges` where `customer_id` in (33, 41) and `is_active` = 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'amount' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `customer_id`, `description`, `amount`, `code`, `is_active` from `recurring_charges` where `customer_id` in (33, 41) and `is_active` = 1) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'amount' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-06 04:38:28] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: update `customers` set `billing_name` = Candlewood Medical Centre, `billing_name_manually_set` = 1, `address_line_1` = Shop 5, 45 Candlewood Boulevard, `address_line_1_manually_set` = 1, `address_line_2` = Joondalup, WA 6027, `address_line_2_manually_set` = 1, `billing_email` = simon@jfmcommunications.com.au, `billing_email_manually_set` = 1, `structured_billing_metadata` = Organisation: Candlewood Medical Centre (GP / general practice)
Role: primary bill-to (acct 308 / te 13) · QB sync on, `structured_billing_metadata_manually_set` = 1, `qb_company_key` = jfm, `updated_at` = 2026-08-06 04:38:28, `qb_sync_enabled` = 1, `qb_customer_fullname` = Candlewood Medical Centre where `id` = 33) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: update `customers` set `billing_name` = Candlewood Medical Centre, `billing_name_manually_set` = 1, `address_line_1` = Shop 5, 45 Candlewood Boulevard, `address_line_1_manually_set` = 1, `address_line_2` = Joondalup, WA 6027, `address_line_2_manually_set` = 1, `billing_email` = simon@jfmcommunications.com.au, `billing_email_manually_set` = 1, `structured_billing_metadata` = Organisation: Candlewood Medical Centre (GP / general practice)
[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `customers.structured_billing_metadata` failed for `jfmbilling`.`customers` at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:612)
[2026-08-11 03:03:54] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bi_periodstart' in 'order clause' (Connection: mirta, Host: 127.0.0.1, Port: 3307, Database: asterisk, SQL: select * from `bi_billings` where `bi_te_id` = 13 order by `bi_periodstart` desc limit 24) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bi_periodstart' in 'order clause' (Connection: mirta, Host: 127.0.0.1, Port: 3307, Database: asterisk, SQL: select * from `bi_billings` where `bi_te_id` = 13 order by `bi_periodstart` desc limit 24) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bi_periodstart' in 'order clause' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-11 03:05:52] production.ERROR: Undefined variable $dst {"exception":"[object] (ErrorException(code: 0): Undefined variable $dst at /tmp/jfm-recon10.php:15)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-recon10.php(15): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-11 03:39:29] production.ERROR: Undefined variable $periodStart→ {"exception":"[object] (ErrorException(code: 0): Undefined variable $periodStart→ at /tmp/candlewood_fax_invoice.php:242)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/candlewood_fax_invoice.php(242): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-11 05:14:17] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.fa_id' in 'IN/ALL/ANY subquery' (Connection: mirta, Host: 127.0.0.1, Port: 3307, Database: asterisk, SQL: SELECT a.* FROM ft_faxattempts a WHERE a.fa_id IN (SELECT fa_id FROM fa_faxes WHERE fa_date >= 2026-08-06 00:00:00 AND fa_date <= 2026-08-11 23:59:59) ORDER BY a.fa_id, a.ft_id) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.fa_id' in 'IN/ALL/ANY subquery' (Connection: mirta, Host: 127.0.0.1, Port: 3307, Database: asterisk, SQL: SELECT a.* FROM ft_faxattempts a WHERE a.fa_id IN (SELECT fa_id FROM fa_faxes WHERE fa_date >= 2026-08-06 00:00:00 AND fa_date <= 2026-08-11 23:59:59) ORDER BY a.fa_id, a.ft_id) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.fa_id' in 'IN/ALL/ANY subquery' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-11 05:39:30] production.ERROR: Undefined variable $pStart→ {"exception":"[object] (ErrorException(code: 0): Undefined variable $pStart→ at /tmp/jfm-agent-run.php:233)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-agent-run.php(233): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-11 05:40:45] production.ERROR: Property [count] does not exist on this collection instance. {"exception":"[object] (Exception(code: 0): Property [count] does not exist on this collection instance. at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php:1078)
[2026-08-11 10:18:57] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'asterisk.tenants' doesn't exist {"exception":"[object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'asterisk.tenants' doesn't exist at /tmp/jfm-agent-run.php:16)
[2026-08-11 10:19:30] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cc_date_start' in 'field list' {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cc_date_start' in 'field list' at /tmp/jfm-agent-run.php:15)
[2026-08-11 10:19:45] production.ERROR: Attempt to read property "COLUMN_NAME" on array {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"COLUMN_NAME\" on array at /tmp/jfm-agent-run.php:7)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-agent-run.php(7): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-11 10:19:54] production.ERROR: Undefined array key "COLUMN_NAME" {"exception":"[object] (ErrorException(code: 0): Undefined array key \"COLUMN_NAME\" at /tmp/jfm-agent-run.php:7)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-agent-run.php(7): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-11 10:20:57] production.ERROR: Attempt to read property "cc_type" on array {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"cc_type\" on array at /tmp/jfm-agent-run.php:32)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /tmp/jfm-agent-run.php(32): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-12 03:44:43] production.ERROR: Exception calling "BeginSession" with "2" argument(s): "Recent changes to your configuration require you (the Reckon Accounts Administrator) to go into the Integrated Applications preferences and re-authorize your integrated application to login automatically." [jfm] {"exception":"[object] (RuntimeException(code: 0): Exception calling \"BeginSession\" with \"2\" argument(s): \"Recent changes to your configuration require you (the Reckon Accounts Administrator) to go into the Integrated Applications preferences and re-authorize your integrated application to login automatically.\" [jfm] at /opt/jfmbilling/app/app/Support/QuickBooks/QuickBooksAgentClient.php:185)
[2026-08-12 11:53:29] production.ERROR: file_put_contents(/opt/jfmbilling/backups/qb-paid-reconcile-/before.json): Failed to open stream: No such file or directory {"exception":"[object] (ErrorException(code: 0): file_put_contents(/opt/jfmbilling/backups/qb-paid-reconcile-/before.json): Failed to open stream: No such file or directory at /tmp/qb-paid-bak.php:15)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-17 09:13:27] production.ERROR: file_get_contents(/tmp/.xai-plain.tmp): Failed to open stream: Permission denied {"exception":"[object] (ErrorException(code: 0): file_get_contents(/tmp/.xai-plain.tmp): Failed to open stream: Permission denied at /opt/jfmbilling/app/app/Console/Commands/EncryptXaiKey.php:23)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-27 23:47:09] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.period_start' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `i`.`id`, `i`.`invoice_number`, `i`.`invoice_date`, `i`.`due_date`, `i`.`total`, `i`.`period_start`, `i`.`period_end`, `c`.`id` as `customer_id`, `c`.`billing_name`, `c`.`account_code`, `c`.`billing_email` from `invoices` as `i` left join `customers` as `c` on `c`.`id` = `i`.`customer_id` where `i`.`status` = draft order by `i`.`id` asc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.period_start' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `i`.`id`, `i`.`invoice_number`, `i`.`invoice_date`, `i`.`due_date`, `i`.`total`, `i`.`period_start`, `i`.`period_end`, `c`.`id` as `customer_id`, `c`.`billing_name`, `c`.`account_code`, `c`.`billing_email` from `invoices` as `i` left join `customers` as `c` on `c`.`id` = `i`.`customer_id` where `i`.`status` = draft order by `i`.`id` asc) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.period_start' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-28 00:47:36] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'legal_name' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customers` where (`billing_name` like %fresh% or `pbx_tenant_name` like %fresh% or `account_code` like %111% or `billing_email` like %freshstart% or `legal_name` like %fresh% or `qb_customer_fullname` like %fresh%)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'legal_name' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select * from `customers` where (`billing_name` like %fresh% or `pbx_tenant_name` like %fresh% or `account_code` like %111% or `billing_email` like %freshstart% or `legal_name` like %fresh% or `qb_customer_fullname` like %fresh%)) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'legal_name' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-28 01:33:01] production.ERROR: file_get_contents(/tmp/_freshstart-portal-password.txt): Failed to open stream: Permission denied {"exception":"[object] (ErrorException(code: 0): file_get_contents(/tmp/_freshstart-portal-password.txt): Failed to open stream: Permission denied at /tmp/_freshstart-portal-login-to-simon.php:20)
#0 /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(258): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
[2026-08-28 03:48:47] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account_number' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `is_active`, `qb_customer_fullname` from `customers` where `id` in (6, 43) or `account_number` = 111 or `name` like %Fresh Start%) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account_number' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `is_active`, `qb_customer_fullname` from `customers` where `id` in (6, 43) or `account_number` = 111 or `name` like %Fresh Start%) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account_number' in 'WHERE' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[2026-08-28 03:49:43] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'active' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `customer_id`, `code`, `description`, `quantity`, `unit_price`, `active`, `next_invoice_date` from `recurring_charges` where `customer_id` = 6) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'active' in 'SELECT' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: jfmbilling, SQL: select `id`, `customer_id`, `code`, `description`, `quantity`, `unit_price`, `active`, `next_invoice_date` from `recurring_charges` where `customer_id` = 6) at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:841)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'active' in 'SELECT' at /opt/jfmbilling/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
=== END ===