Menu Content

Support

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

Invoice / Order does not display a list of orders
(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.

TOPIC: Invoice / Order does not display a list of orders

Re: Invoice / Order does not display a list of orders 10 years, 2 months ago #42588

  • ShikhovS
В файле autiliti.js нужно заменить строку 80 на http_ask.overrideMimeType('text/xml; charset=UTF-8');

The file should be replaced autiliti.js on line 80 http_ask.overrideMimeType('text/xml; charset=UTF-8');
The topic has been locked.

Re: Invoice / Order does not display a list of orders 10 years, 2 months ago #42608

  • fale
Hi,

Comparison of coding MySQL connection : utf8_general_ci . Database comparison utf8_general_ci
Tables:
_virtuemart_order_items
_virtuemart_products
_virtuemart_products_en_gb
_virtuemart_products_ru_ru
The tables use utf8 character set. Not all lines of tables encoded utf-8
I have a question. Which table are " custom fields "?

For example table "virtuemart_order_items" has the structure:

1 delivery_date varchar(200) utf8_general_ci
2 product_discountedPriceWithoutTax decimal(15,5) Да NULL
3 product_priceWithoutTax decimal(15,5) Да NULL
4 virtuemart_order_item_id int(11) UNSIGNED
5 virtuemart_order_id int(11) Да NULL
6 virtuemart_vendor_id smallint(11) Нет 1
7 virtuemart_product_id int(11) Да NULL
8 order_item_sku char(64) utf8_general_ci Нет
9 order_item_name char(255) utf8_general_ci Нет
10 product_quantity int(11) Да NULL
11 product_item_price decimal(15,5) Да NULL
12 product_tax decimal(15,5) Да NULL
13 product_basePriceWithTax decimal(15,5) Да NULL
14 product_final_price decimal(15,5) Нет 0.00000
15 product_subtotal_discount decimal(15,5) Нет 0.00000
16 product_subtotal_with_tax decimal(15,5) Нет 0.00000
17 order_item_currency int(11) Да NULL
18 order_status char(1) utf8_general_ci Да NULL
19 product_attribute text utf8_general_ci Да NULL
20 created_on datetime Нет 0000-00-00 00:00:00
21 created_by int(11) Нет 0
22 modified_on datetime Нет 0000-00-00 00:00:00
23 modified_by int(11) Нет 0
24 locked_on datetime Нет 0000-00-00 00:00:00
25 locked_by int(11) Нет 0

Do I understand correctly, I need to put in each row utf8_general_ci ?

I checked. In the admin so:
<meta http-equiv="content-type" content="text/html; charset=utf-8" />

Thank you that you are helping me!
The topic has been locked.

Re: Invoice / Order does not display a list of orders 10 years, 2 months ago #42609

  • fale
ShikhovS wrote:
В файле autiliti.js нужно заменить строку 80 на http_ask.overrideMimeType('text/xml; charset=UTF-8');

The file should be replaced autiliti.js on line 80 http_ask.overrideMimeType('text/xml; charset=UTF-8');


Where exactly is this file? I have no such file.
Где находится этот файл? Искал-не нашёл. Может этот файл относится к твоему шаблону?
The topic has been locked.

Re: Invoice / Order does not display a list of orders 10 years, 2 months ago #42610

  • fale
Нашёл, попробую.
Found.
administrator\components\com_vminvoice\assets\js\autility.js
The topic has been locked.

Re: Invoice / Order does not display a list of orders 10 years, 2 months ago #42611

  • fale
ShikhovS wrote:
В файле autiliti.js нужно заменить строку 80 на http_ask.overrideMimeType('text/xml; charset=UTF-8');

The file should be replaced autiliti.js on line 80 http_ask.overrideMimeType('text/xml; charset=UTF-8');


I checked. does not work
The topic has been locked.

Re: Invoice / Order does not display a list of orders 10 years, 2 months ago #42615

  • dajo
  • OFFLINE
  • Posts: 5069
Hi,

The tables for custom fields are _virtuemart_customs and _virtuemart_product_customfields.

The utf8_general_ci is required only for the columns of type char, varchar or text, so you have it set up correctly.

What versions of Joomla and VM Invoice do you use?
ARTIO Support Team
The topic has been locked.
User Login Empty