Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

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)

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

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 ago by fossa. Reason: Found mistake!
The topic has been locked.

Re: Problems after last upgrade (to 2.0.32) 10 years 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 ago by pama.
The topic has been locked.

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

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 ago #43634

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 ago #43663

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 ago #43664

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
User Login Empty