1054 Unknown column 'inv_hash' in 'field list' [SOLVED]

[Wibah]

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?

[GJC Web Design]

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)  ?

[GJC Web Design]

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

[Wibah]

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!

[GJC Web Design]

will be fixed for the next release and both columns should be there