Tax rules listing - erroneous Tax Category
- jameswadsworth
-
Topic Author
- Offline
Less
More
15 years 8 months ago #4367
by jameswadsworth
Tax rules listing - erroneous Tax Category was created by jameswadsworth
If a tax rule is set up and the tax category is set to 'None', when the tax rule is viewed on the listings page a product category is shown. However the if the tax rule is edited and the tax category is set the tax category shows correctly. However reset the tax category back to 'None' a product category is shown. (In the database table hikashop taxation the category_namekey field is blank ).
Please Log in or Create an account to join the conversation.
15 years 8 months ago #4368
by nicolas
Replied by nicolas on topic Re: Tax rules listing - erroneous Tax Category
I cannot reproduce that on our end. When I create a tax rule without a tax category, nothing is displayed for that tax rule in the tax category column on the tax rules listing.
The only explanation I would see is that you have in the table hikashop_category a category with nothing in the column category_namekey which should not happen normally.
You could try to change the line
to
in the file administrator/components/com_hikashop/views/taxation/view.html.php
The only explanation I would see is that you have in the table hikashop_category a category with nothing in the column category_namekey which should not happen normally.
You could try to change the line
Code:
$query = ' FROM '.hikashop::table('taxation').' AS a LEFT JOIN '.hikashop::table('tax').' AS b ON a.tax_namekey=b.tax_namekey LEFT JOIN '.hikashop::table('category').' AS c ON a.category_namekey=c.category_namekey LEFT JOIN '.hikashop::table('zone').' AS d ON a.zone_namekey=d.zone_namekey'.$filters.$order;
Code:
$query = ' FROM '.hikashop::table('taxation').' AS a LEFT JOIN '.hikashop::table('tax').' AS b ON a.tax_namekey=b.tax_namekey LEFT JOIN '.hikashop::table('category').' AS c ON a.category_namekey=c.category_namekey AND a.category_namekey!=\'\' AND c.category_type=\'tax\' LEFT JOIN '.hikashop::table('zone').' AS d ON a.zone_namekey=d.zone_namekey AND a.zone_namekey!=\'\''.$filters.$order;
Please Log in or Create an account to join the conversation.
- jameswadsworth
-
Topic Author
- Offline
15 years 8 months ago #4397
by jameswadsworth
Replied by jameswadsworth on topic Re: Tax rules listing - erroneous Tax Category
Hi Nicolas,
you are right with your first hypothesis:
We had imported some categories from a CSV file and the first line had not been inserted correctly.
Thanks, James
you are right with your first hypothesis:
The only explanation I would see is that you have in the table hikashop_category a category with nothing in the column category_namekey which should not happen normally.
We had imported some categories from a CSV file and the first line had not been inserted correctly.
Thanks, James
Please Log in or Create an account to join the conversation.
Time to create page: 0.151 seconds