News:

Looking for documentation? Take a look on our wiki

Main Menu

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

Started by Wibah, August 16, 2019, 12:13:20 PM

Previous topic - Next topic

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
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation