Column not found: 1054 Unknown column ‘invoice_task_lock’

Self-Hosted | v5
1

Hey Guys,

I moved my installation to a different server and updated the installation.
Every time when saving somethings in the settings I get this error:

500: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘invoice_task_lock’ in ‘field list’ (SQL: update companies set convert_products = 0, fill_products = 1, update_products = 1, show_product_details = 0, client_can_register = 0, custom_surcharge_taxes1 = 0, custom_surcharge_taxes2 = 0, custom_surcharge_taxes3 = 0, custom_surcharge_taxes4 = 0, enable_product_cost = 0, enable_product_quantity = 1, default_quantity = 1, portal_domain = https://tester.DOMAIN`settings` = {“auto_archive_invoice”:true,“qr_iban”:“”,“besr_id”:“”,“lock_invoices”:“off”,“enable_client_portal_tasks”:false,“show_all_tasks_client_portal”:“invoiced”,“enable_client_portal_password”:false,“enable_client_portal”:true,“enable_client_portal_dashboard”:true,“signature_on_pdf”:false,“document_email_attachment”:true,“portal_design_id”:“1”,“timezone_id”:“36”,“date_format_id”:“11”,“military_time”:true,“language_id”:“3”,“show_currency_code”:false,“company_gateway_ids”:“”,“currency_id”:“3”,“custom_value1”:“”,“custom_value2”:“”,“custom_value3”:“”,“custom_value4”:“”,“default_task_rate”:65,“payment_terms”:“7”,“send_reminders”:true,“custom_message_dashboard”:“”,“custom_message_unpaid_invoice”:“”,“custom_message_paid_invoice”:“”,“custom_message_unapproved_quote”:“”,“auto_archive_quote”:false,“auto_convert_quote”:true,“auto_email_invoice”:true,“entity_send_time”:6,“inclusive_taxes”:false,“quote_footer”:“”,“translations”:[],“counter_number_applied”:“when_saved”,“quote_number_applied”:“when_saved”,“invoice_number_pattern”:“{$date:Ymd}-{$counter}”,“invoice_number_counter”:186,“recurring_invoice_number_pattern”:“”,“recurring_invoice_number_counter”:1,“quote_number_pattern”:“”,“quote_number_counter”:1,“client_number_pattern”:“”,“client_number_counter”:15,“credit_number_pattern”:“”,“credit_number_counter”:0,“task_number_pattern”:“”,“task_number_counter”:15,“expense_number_pattern”:“”,“expense_number_counter”:1,“recurring_expense_number_pattern”:“”,“recurring_expense_number_counter”:1,“recurring_quote_number_pattern”:“”,“recurring_quote_number_counter”:1,“vendor_number_pattern”:“”,“vendor_number_counter”:1,“ticket_number_pattern”:“”,“ticket_number_counter”:1,“payment_number_pattern”:“”,“payment_number_counter”:20,“project_number_pattern”:“”,“project_number_counter”:2,“purchase_order_number_pattern”:“”,“purchase_order_number_counter”:1,“shared_invoice_quote_counter”:true,“shared_invoice_credit_counter”:false,“recurring_number_prefix”:“R”,“reset_counter_frequency_id”:“0”,“reset_counter_date”:

I did the /update?secret= and php artisan migrate but nothing changed.

user@tattoine:/var/www/invoiceninja$ sudo php artisan migrate
                                                                                                                                                                                                                                            
APPLICATION IN PRODUCTION.                                                                                                          
                                                                                                                                                                                                                                              
  Do you really wish to run this command? (yes/no) [no]
❯ yes

   INFO  Nothing to migrate

Any idea what might be wrong?

2

Hi,

@david do you have any suggestions?

3

Do you have an exact backup of the database you migrated from? The migrations table looks to have been skipped here and the system needs to create some columns which are missing.

4

I took a sql dump and copied all files from storage and moved/imported everything to the new server. There is no “invoice_task_lock” in the sql dump i took from the old server. Any chance to recreate it?

5

Is there nothing i can do?