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;