|
Welcome,
Guest
|
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.
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.
|
TOPIC: Problems after last upgrade (to 2.0.32)
Re: Problems after last upgrade (to 2.0.32) 10 years 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 ago #43690
|
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 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.
|
|
