Menu Content

Support

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

Problem in orders management with Artio VM Invoice
(1 viewing) (1) Guest
If you have suggestion for a new feature you would need or that other may appreciate, or you have suggestion for improvemnt or change, you may post such ideas in this category.
  • Page:
  • 1

TOPIC: Problem in orders management with Artio VM Invoice

Problem in orders management with Artio VM Invoice 7 years, 11 months ago #48328

Hi,
when chanching an order status I always obtain this error:

1146 Table 'katuma39_katuma.#__virtuemart_paymentmethods_' doesn't exist SQL=SELECT `#__virtuemart_paymentmethods`.* ,`#__virtuemart_paymentmethods_`.* FROM `#__virtuemart_paymentmethods` INNER JOIN `#__virtuemart_paymentmethods_` using (`virtuemart_paymentmethod_id`) WHERE `#__virtuemart_paymentmethods`.`virtuemart_paymentmethod_id` = "1"

I think the problem is that language is not insert in query (it_it is omitted). Correct query should be:

SELECT `#__virtuemart_paymentmethods`.* ,`#__virtuemart_paymentmethods_it_it`.* FROM `#__virtuemart_paymentmethods` INNER JOIN `#__virtuemart_paymentmethods_it_it` using (`virtuemart_paymentmethod_id`) WHERE `#__virtuemart_paymentmethods`.`virtuemart_paymentmethod_id` = "1"

What can I do?
Many thanks
Best regards,
Maurizio
The topic has been locked.
  • Page:
  • 1
User Login Empty