VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Wibah on August 16, 2019, 12:13:20 PM

Title: 1054 Unknown column 'inv_hash' in 'field list' [SOLVED]
Post by: Wibah on August 16, 2019, 12:13:20 PM
Hi,

After updating from version VM: 3.4.5.10063 to VM: 3.5.0.10098
My PDF invoice doesnt work anymore, i get the following error:

1054 Unknown column 'inv_hash' in 'field list'

Updating the tables by Virtumart function doesn't seem to solve the issue.
Any ideas how to solve it?
Title: Re: 1054 Unknown column 'inv_hash' in 'field list'
Post by: GJC Web Design on August 16, 2019, 12:52:18 PM
it does appear the column inv_hash has been missed from the #__virtuemart_invoices table

is called in  administrator\components\com_virtuemart\tables\invoices.php

$this->setHashable('inv_hash');

what if u manually add  inv_hash varchar(33)  ?
Title: Re: 1054 Unknown column 'inv_hash' in 'field list'
Post by: GJC Web Design on August 16, 2019, 13:03:39 PM
ah --  inv_hash is there in VM3.4.2

in 3.5.x it is o_hash

try adding the field back  inv_hash so both are present
Title: Re: 1054 Unknown column 'inv_hash' in 'field list'
Post by: Wibah on August 16, 2019, 13:20:12 PM
That totally was the fix. I shouldnt be worried for the two columns to exist?

I created the column inv_hash varchar(33) in the virtuemart_invoices table. which resolved the issue.

Many thanks for the quick response!
Title: Re: 1054 Unknown column 'inv_hash' in 'field list' [SOLVED]
Post by: GJC Web Design on August 16, 2019, 14:24:58 PM
will be fixed for the next release and both columns should be there