Database error "unknown columns" when upgrading to 1.2.1

I’m trying to upgrade an existing v1.1.0 installation to v1.2.1 and I get the following error when going to

A Database Error Occured

Error Number: 1054

Unknown column 'ip_invoice_amounts.invoice_sign' in 'field list'

SELECT SQL_CALC_FOUND_ROWS ip_invoice_custom.*, ip_client_custom.*, ip_user_custom.*, ip_users.user_name, ip_users.user_company, ip_users.user_address_1, ip_users.user_address_2, ip_users.user_city, ip_users.user_state, ip_users.user_zip, ip_users.user_country, ip_users.user_phone, ip_users.user_fax, ip_users.user_mobile, ip_users.user_email, ip_users.user_web, ip_users.user_vat_id, ip_users.user_tax_code, ip_clients.*, ip_invoice_amounts.invoice_amount_id, IFNULL(ip_invoice_amounts.invoice_item_subtotal, '0.00') AS invoice_item_subtotal, IFNULL(ip_invoice_amounts.invoice_item_tax_total, '0.00') AS invoice_item_tax_total, IFNULL(ip_invoice_amounts.invoice_tax_total, '0.00') AS invoice_tax_total, IFNULL(ip_invoice_amounts.invoice_total, '0.00') AS invoice_total, IFNULL(ip_invoice_amounts.invoice_paid, '0.00') AS invoice_paid, IFNULL(ip_invoice_amounts.invoice_balance, '0.00') AS invoice_balance, ip_invoice_amounts.invoice_sign AS invoice_sign, (CASE WHEN ip_invoices.invoice_status_id NOT IN (1, 4) AND DATEDIFF(NOW(), invoice_date_due) > 0 THEN 1 ELSE 0 END) is_overdue, DATEDIFF(NOW(), invoice_date_due) AS days_overdue, (CASE (SELECT COUNT(*) FROM ip_invoices_recurring WHERE ip_invoices_recurring.invoice_id = ip_invoices.invoice_id and ip_invoices_recurring.recur_next_date <> '0000-00-00') WHEN 0 THEN 0 ELSE 1 END) AS invoice_is_recurring, ip_invoices.* FROM (`ip_invoices`) JOIN `ip_clients` ON `ip_clients`.`client_id` = `ip_invoices`.`client_id` JOIN `ip_users` ON `ip_users`.`user_id` = `ip_invoices`.`user_id` LEFT JOIN `ip_invoice_amounts` ON `ip_invoice_amounts`.`invoice_id` = `ip_invoices`.`invoice_id` LEFT JOIN `ip_client_custom` ON `ip_client_custom`.`client_id` = `ip_clients`.`client_id` LEFT JOIN `ip_user_custom` ON `ip_user_custom`.`user_id` = `ip_users`.`user_id` LEFT JOIN `ip_invoice_custom` ON `ip_invoice_custom`.`invoice_id` = `ip_invoices`.`invoice_id` ORDER BY `ip_invoices`.`invoice_id` DESC LIMIT 10

Filename: /home/vhosting/client1/domains/

Line Number: 91

I have copied the database.php from the old directory and also added the following line to the .htaccess file in the main directory (just like I did for v1.1.0):

Redirect /setup

Did I miss something? Is upgrading from v1.1.0 to v1.2.1 in one go not possible?

It should be possible.
At which step do you get this error? Directly after opening the setup or at the database update?

Directly when opening the URL. The URL in the browser than changes to and displays the error.

Sorry, I should read everything before answering.

Redirect /setup

must be removed for updating.

Ah, of course! I should have interpreted what the line is doing instead of copying it from the old setup.
Thanks! :smiley:

This topic was automatically closed after 24 hours. New replies are no longer allowed.