Same problem here: when trying to update 2.0.33 to 2.0.34 we're getting the error:
"Cannot find XML setup file"

Please upload a working package asap.

Thx in advance!

Thanks!

Looks like everything is back again.
The installation ran without an error and the templates are back.

Same problem here. Using Joomla 2.5.14 and VM 2.0.26d

Neither the install from the Artio server nor manual upgrade of the previous version worked. We´re getting a bunch of errors, somehow related to the template:

Cannot create #__vminvoice_templates: Specified key was too long; max key length is 1000 bytes SQL=CREATE TABLE IF NOT EXISTS `j25_vminvoice_templates` ( `config_id` int(11) NOT NULL, `document` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `name` varchar(255) NOT NULL COMMENT 'custom name', `template` text NULL, `params` text NOT NULL, `last_template_change` INT NOT NULL, PRIMARY KEY (`config_id`,`document`,`type`), KEY `last_template_change` (`last_template_change`) )
Unable to execute SQL query: CREATE TABLE IF NOT EXISTS `#__vminvoice_templates` ( `config_id` int(11) NOT NULL, `document` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `name` varchar(255) NOT NULL COMMENT 'custom name', `template` text NULL, `params` text NOT NULL, `last_template_change` INT NOT NULL, PRIMARY KEY (`config_id`,`document`,`type`), KEY `last_template_change` (`last_template_change`) ) ;. Specified key was too long; max key length is 1000 bytes SQL=CREATE TABLE IF NOT EXISTS `j25_vminvoice_templates` ( `config_id` int(11) NOT NULL, `document` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `name` varchar(255) NOT NULL COMMENT 'custom name', `template` text NULL, `params` text NOT NULL, `last_template_change` INT NOT NULL, PRIMARY KEY (`config_id`,`document`,`type`), KEY `last_template_change` (`last_template_change`) ) ;
Unable to execute SQL query: /* first insert empty rows into templates (1) and backups (-1) /* invoice */ INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=/* first insert empty rows into templates (1) and backups (-1) /* invoice */ INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'tax_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'tax_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'tax_row') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'invoice', 'tax_row') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'tax_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'tax_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'tax_row') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'invoice', 'tax_row') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: /* delivery note */ INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=/* delivery note */ INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'delivery_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'delivery_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: /* credit note */ INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=/* credit note */ INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (1,'credit_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'footer') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'items_header') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: INSERT INTO `#__vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=INSERT INTO `j25_vminvoice_templates` (`config_id`, `document`, `type`) VALUES (-1,'credit_note', 'items_body') ON DUPLICATE KEY UPDATE `config_id`=`config_id`;
Unable to execute SQL query: /* then insert default values into -1 backups. this is done always, even in reinstall. */ /* invoice */ UPDATE `#__vminvoice_templates` SET `template` = '\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{contact} {logo}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='header';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=/* then insert default values into -1 backups. this is done always, even in reinstall. */ /* invoice */ UPDATE `j25_vminvoice_templates` SET `template` = '\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{contact} {logo}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='header';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '

{start_note}
{billing_address}
{shipping_address}

{invoice_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='body';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '

{start_note}
{billing_address}
{shipping_address}

{invoice_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='body';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{extra_fields}

\r\n
{pagination}
\r\n
{signature}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='footer';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{extra_fields}

\r\n
{pagination}
\r\n
{signature}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='footer';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{qty_cpt} {sku_cpt} {name_cpt} {price_cpt} {base_total_cpt} {tax_rate_cpt} {tax_cpt} {discount_cpt} {subtotal_cpt}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='items_header';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{qty_cpt} {sku_cpt} {name_cpt} {price_cpt} {base_total_cpt} {tax_rate_cpt} {tax_cpt} {discount_cpt} {subtotal_cpt}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='items_header';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{qty}{qty_unit} {item_image} {sku} {name}
{attributes}
{price} {price_notax} {tax_rate} {tax_price} {discount} {subtotal}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='items_body';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{qty}{qty_unit} {item_image} {sku} {name}
{attributes}
{price} {price_notax} {tax_rate} {tax_price} {discount} {subtotal}
' WHERE `config_id` = -1 AND `document`='invoice' AND `type`='items_body';
Unable to execute SQL query: /* delivery note */ UPDATE `#__vminvoice_templates` SET `template` = '\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{contact} {logo}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='header';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=/* delivery note */ UPDATE `j25_vminvoice_templates` SET `template` = '\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{contact} {logo}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='header';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '

{start_note}
{shipping_address}
{billing_address}

{dn_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='body';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '

{start_note}
{shipping_address}
{billing_address}

{dn_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='body';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{extra_fields}

\r\n
{pagination}
\r\n
{signature}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='footer';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{extra_fields}

\r\n
{pagination}
\r\n
{signature}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='footer';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{qty_cpt} {sku_cpt} {name_cpt}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='items_header';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{qty_cpt} {sku_cpt} {name_cpt}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='items_header';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{qty}{qty_unit} {sku} {name}
{attributes}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='items_body';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{qty}{qty_unit} {sku} {name}
{attributes}
' WHERE `config_id` = -1 AND `document`='delivery_note' AND `type`='items_body';
Unable to execute SQL query: /* credit note */ UPDATE `#__vminvoice_templates` SET `template` = '\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{contact} {logo}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='header';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=/* credit note */ UPDATE `j25_vminvoice_templates` SET `template` = '\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{contact} {logo}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='header';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '

{start_note}
{billing_address}
{shipping_address}

{credit_note_cpt} {invoice_number}
{orig_invoice_no_cpt}: {orig_invoice_no}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='body';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '

{start_note}
{billing_address}
{shipping_address}

{credit_note_cpt} {invoice_number}
{orig_invoice_no_cpt}: {orig_invoice_no}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='body';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{extra_fields}

\r\n
{pagination}
\r\n
{signature}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='footer';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{extra_fields}

\r\n
{pagination}
\r\n
{signature}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='footer';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{qty_cpt} {sku_cpt} {name_cpt} {price_cpt} {base_total_cpt} {tax_rate_cpt} {tax_cpt} {discount_cpt} {subtotal_cpt}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='items_header';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{qty_cpt} {sku_cpt} {name_cpt} {price_cpt} {base_total_cpt} {tax_rate_cpt} {tax_cpt} {discount_cpt} {subtotal_cpt}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='items_header';
Unable to execute SQL query: UPDATE `#__vminvoice_templates` SET `template` = '
{qty}{qty_unit} {item_image} {sku} {name}
{attributes}
{price} {price_notax} {tax_rate} {tax_price} {discount} {subtotal}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='items_body';. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=UPDATE `j25_vminvoice_templates` SET `template` = '
{qty}{qty_unit} {item_image} {sku} {name}
{attributes}
{price} {price_notax} {tax_rate} {tax_price} {discount} {subtotal}
' WHERE `config_id` = -1 AND `document`='credit_note' AND `type`='items_body';
Unable to execute SQL query: /* now copy all templates for new installation (IF statement - `template` is null) from template backups (config id -1) */ UPDATE `#__vminvoice_templates` AS `t1` JOIN `#__vminvoice_templates` AS `t2` ON (`t2`.`config_id` = -1 AND `t1`.`document` = `t2`.`document` AND `t1`.`type` = `t2`.`type`) SET `t1`.`template` = IF(`t1`.`template` IS NULL, `t2`.`template`, `t1`.`template`) WHERE `t1`.`config_id` = 1;. Table 'usr_web646_2.j25_vminvoice_templates' doesn't exist SQL=/* now copy all templates for new installation (IF statement - `template` is null) from template backups (config id -1) */ UPDATE `j25_vminvoice_templates` AS `t1` JOIN `j25_vminvoice_templates` AS `t2` ON (`t2`.`config_id` = -1 AND `t1`.`document` = `t2`.`document` AND `t1`.`type` = `t2`.`type`) SET `t1`.`template` = IF(`t1`.`template` IS NULL, `t2`.`template`, `t1`.`template`) WHERE `t1`.`config_id` = 1;

Same problem here. Using Joomla 2.5.14 and VM 2.0.26d

Neither the install from the Artio server nor manual upgrade of the previous version worked. We´re getting a bunch of errors, somehow related to the template:

Hi,

after updating to 2.0.27 the system attaches the wrong invoices to the confirmation emails when we set the operation mode in "general config" to automatic.

Customers get invoices from other customers which is really bad. There seams to be a glitch in the database or the way the invoices get parsed for attaching them to the mail. Didn't happen in previous versions...

Please help!

Very interested in this as a feature, in fact I am was surprised to find that its not a standard feature in WM-Invoice.

A company that issues invoices should also be able to issue credit notes. Otherwise you wont be able to track and bookkepp returns or other credits issued to customers without having to resort to writng manual credit-notes.

Since a credit note is basically a negative invoice with its own numbering sequence, it should be a pretty simple thing to add but I wouldnt mind paying a reasonable fee for it, if it came to that.

I really enjoy working with WM-invoice and it solved a lot of the inherent problems in VM2 order handling for me, but its simply not a full invoicing solution if a credit note cant be issued from the backend, so you can keep track of credits issued in the cashflow.

Looking forward to seeing a patch. Keep up the good work!

Thanks!

Yep, if we de-activate the VAT ID checker the error message is gone.
Unfortunately we need the checker...

Hello,
same problem here: when trying to create a custom order we get "Model order not found."

Upgrading the component didn't help.
We're using Joomla 2.5.11, VirtueMart 2.0.20b and Artio VM Invoice 2.0.25 - also the VAT ID Checker v2.0.10_1.3 by iStraxx. We would have purchased yours but it's not available for J2.5/VM2 ;-)

Thx for the VM Invoice, a great component which saves us many brain cells unlike other solutions on the market.

Thx in advance,
Jussi