Version ie <v5.10.30>
v5.11.48
Environment <Docker/Shared Hosting/Zip/Other>
SHared
Checklist
N/A
Describe the bug
The recurring invoices have stopped recurring
Steps To Reproduce
Wait for CRON job.
Expected Behavior
Recurring invoices get queued.
Additional context
[2025-03-06 18:00:03] production.INFO: Trying to send 00032
[2025-03-06 18:00:03] production.INFO: Recurring Invoice Date Set on Invoice = 2025-03-06 - 2025-03-06
[2025-03-06 18:00:03] production.INFO: Unable to sending recurring invoice 62 SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e_invoice’ in ‘INSERT INTO’ (Connection: mysql, SQL: insert into invoices
(status_id
, discount
, is_amount_discount
, po_number
, footer
, terms
, public_notes
, private_notes
, is_deleted
, line_items
, tax_name1
, tax_rate1
, tax_name2
, tax_rate2
, tax_name3
, tax_rate3
, total_taxes
, subscription_id
, custom_value1
, custom_value2
, custom_value3
, custom_value4
, amount
, uses_inclusive_taxes
, is_proforma
, custom_surcharge1
, custom_surcharge2
, custom_surcharge3
, custom_surcharge4
, custom_surcharge_tax1
, custom_surcharge_tax2
, custom_surcharge_tax3
, custom_surcharge_tax4
, user_id
, assigned_user_id
, company_id
, recurring_id
, client_id
, auto_bill_enabled
, paid_to_date
, design_id
, e_invoice
, date
, due_date
, updated_at
, created_at
) values (1, 0.000000, 0, Monthy Security/Updates/Backups, ?, ?, ?, ?, 0, [{“product_key”:“”,“notes”:“Monthy Security/Updates/Backups”,“cost”:100,“product_cost”:0,“quantity”:1,“tax_name1”:“”,“tax_rate1”:0,“tax_name2”:“”,“tax_rate2”:0,“tax_name3”:“”,“tax_rate3”:0,“custom_value1”:“”,“custom_value2”:“”,“custom_value3”:“”,“custom_value4”:“”,“discount”:0,“tax_id”:“1”,“type_id”:“1”,“task_id”:“”,“expense_id”:“”,“createdAt”:1684001760207000,“is_amount_discount”:false,“sort_id”:“0”,“line_total”:100,“gross_line_total”:100,“tax_amount”:0,“date”:“”,“unit_code”:“C62”}], ?, 0.000000, ?, 0.000000, ?, 0.000000, 0.000000, ?, ?, ?, ?, ?, 100.000000, 0, 0, 0.000000, 0.000000, 0.000000, 0.000000, 0, 0, 0, 0, 1, ?, 1, 62, 421, 0, 0, 4, ?, 2025-03-06, 2025-03-06 00:00:00, 2025-03-06 18:00:03.479349, 2025-03-06 18:00:03.479349))
[2025-03-06 18:00:03] production.INFO: Trying to send 00034
[2025-03-06 18:00:03] production.INFO: Recurring Invoice Date Set on Invoice = 2025-03-06 - 2025-03-06
[2025-03-06 18:00:03] production.INFO: Unable to sending recurring invoice 64 SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e_invoice’ in ‘INSERT INTO’ (Connection: mysql, SQL: insert into invoices
(status_id
, discount
, is_amount_discount
, po_number
, footer
, terms
, public_notes
, private_notes
, is_deleted
, line_items
, tax_name1
, tax_rate1
, tax_name2
, tax_rate2
, tax_name3
, tax_rate3
, total_taxes
, subscription_id
, custom_value1
, custom_value2
, custom_value3
, custom_value4
, amount
, uses_inclusive_taxes
, is_proforma
, custom_surcharge1
, custom_surcharge2
, custom_surcharge3
, custom_surcharge4
, custom_surcharge_tax1
, custom_surcharge_tax2
, custom_surcharge_tax3
, custom_surcharge_tax4
, user_id
, assigned_user_id
, company_id
, recurring_id
, client_id
, auto_bill_enabled
, paid_to_date
, design_id
, e_invoice
, date
, due_date
, updated_at
, created_at
) values (1, 0.000000, 0, Monthy Security/Updates/Backups, ?, ?, ?, ?, 0, [{“product_key”:“”,“notes”:“Monthy Security/Updates/Backups”,“cost”:100,“product_cost”:0,“quantity”:1,“tax_name1”:“”,“tax_rate1”:0,“tax_name2”:“”,“tax_rate2”:0,“tax_name3”:“”,“tax_rate3”:0,“custom_value1”:“”,“custom_value2”:“”,“custom_value3”:“”,“custom_value4”:“”,“discount”:0,“tax_id”:“1”,“type_id”:“1”,“task_id”:“”,“expense_id”:“”,“createdAt”:1684001760207000,“net_cost”:0,“is_amount_discount”:false,“sort_id”:“0”,“line_total”:100,“gross_line_total”:100,“tax_amount”:0,“date”:“”,“unit_code”:“C62”}], ?, 0.000000, ?, 0.000000, ?, 0.000000, 0.000000, ?, ?, ?, ?, ?, 100.000000, 0, 0, 0.000000, 0.000000, 0.000000, 0.000000, 0, 0, 0, 0, 1, ?, 1, 64, 579, 0, 0, 4, ?, 2025-03-06, 2025-03-06 00:00:00, 2025-03-06 18:00:03.486401, 2025-03-06 18:00:03.486401))
[2025-03-06 18:00:03] production.INFO: Recurring invoice send duration 2025-03-06 06:00:03 - 2025-03-06 06:00:03
[2025-03-06 18:00:18] production.INFO: Failed to export company: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘u737112827_YnEEx.e_invoicing_tokens’ doesn’t exist (Connection: mysql, SQL: select * from e_invoicing_tokens
)
[2025-03-06 18:01:01] production.INFO: Subscription Cron 2025-03-06 18:01:01
[2025-03-06 18:08:14] production.INFO: Using mailer => smtp 2025-03-06 18:08:14
[2025-03-06 18:08:15] production.INFO: Trying to send to [email protected] 2025-03-06 18:08:15
[2025-03-06 18:08:15] production.INFO: Using mailer => smtp