Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
ARTIO Forums
Archive
VM Invoice
Customer Support

Problems after last upgrade (to 2.0.32)
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1
  • 2

TOPIC: Problems after last upgrade (to 2.0.32)

Re: Problems after last upgrade (to 2.0.32) 10 years, 7 months ago #43665

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;
The topic has been locked.

Re: Problems after last upgrade (to 2.0.32) 10 years, 7 months ago #43690

  • pama
  • OFFLINE
  • Posts: 489
Hello. We are deeply sorry fof these problems, it can happen on some MySQL configurations. We just released fixed version 2.0.33, which should fix these problems.
ARTIO Support Team
The topic has been locked.

Re: Problems after last upgrade (to 2.0.32) 10 years, 7 months ago #43695

Thanks!

Looks like everything is back again.
The installation ran without an error and the templates are back.
The topic has been locked.
  • Page:
  • 1
  • 2
ARTIO Forums
Archive
VM Invoice
Customer Support
User Login Empty
Create an account Forgot your password?
Copyright © 2024 ARTIO