Problems after last upgrade (to 2.0.32)

Welcome, Guest

TOPIC: Problems after last upgrade (to 2.0.32)

Problems after last upgrade (to 2.0.32) 10 years, 7 months ago #43594

fossa OFFLINE Posts: 3	Unlike earlier upgrades, the last one resulted in a lot of error messages - but although control panel reports I'm using last version. In top of Invoice / Order Management panel, I get the following message: JUser: :_load: Kan ikke laste bruker med id: 121 (Translated: Can't load user with id:121) JUser: :_load: Kan ikke laste bruker med id: 108 Any suggestions what to do?
	Last Edit: 10 years, 7 months ago by fossa. Reason: Found mistake! The topic has been locked.

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

pama
OFFLINE
Posts: 489

Hello. Do you remember what were the error messages?
Also, can you please post your Joomla and VirtueMart versions?
As for user JUser errors, they are not harmful. It just says that some Joomla user does not exist any more. We will supress that in next release. We are sorry about that. You can fix it if you can edit code on server if you go to administrator/components/com_vminvoice/helpers/getter.php, find function getOrderUserId and delete condition starting:

if (is_object($order)){ ...
...
}

ARTIO Support Team

Last Edit: 10 years, 7 months ago by pama.

The topic has been locked.

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

roaststar OFFLINE Posts: 2	Hello, we have the same problems. Additionally there is an error message: Warning: Invalid argument supplied for foreach() in administrator/components/com_vminvoice/helpers/invoicehelper.php on line 1144 And our invoice template is gone. Seems we have to restore from backup. Regards, Bernd
	The topic has been locked.

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

fossa
OFFLINE
Posts: 3

My Joomla version: 2.5.16
Virtuemart: 2.0.26a

Now I also get the following error message:

Warning: Invalid argument supplied for foreach() in /home/dittdoys/public_html/administrator/components/com_vminvoice/helpers/invoicehelper.php on line 1144

Warning: Invalid argument supplied for foreach() in /home/dittdoys/public_html/administrator/components/com_vminvoice/helpers/invoicehelper.php on line 1144

Warning: Invalid argument supplied for foreach() in /home/dittdoys/public_html/administrator/components/com_vminvoice/helpers/invoicehelper.php on line 1144

The invoice template is empty!

Regards, Olav

The topic has been locked.

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

mrinks OFFLINE Posts: 12	When I try to email an invoice I get the following error message. Config: parameter pdf_library not found for config Id 1 called in invoicehtml.php on line 2210 I get the same message when I try to view an invoice. How do I fix this? Regards Dave
	The topic has been locked.

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

JussiH
OFFLINE
Posts: 8

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.

Page:
1
2

ARTIO Forums

Podpora

TOPIC: Problems after last upgrade (to 2.0.32)