SQL=SELECT category_id FROM xxxx_hikashop

Hello,

I got error 0????
SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC

by clicking/showing product details.
I have only 1 category and 1 product.

System: Joomla 3.02
Hikashop: Latest stable version : 2.0.0


Thanks Hubert

Hello I'm again.

I test the sql query direct over PHPadmin and I got the following result!!!

SQL-Befehl:

SELECT category_id
FROM nelkies101212_hikashop_product_category
WHERE product_id =4
OR product_parent_id =4
ORDER BY product_category_id ASC
LIMIT 0 , 30

MySQL meldet:

#1054 - Unknown column 'product_parent_id' in 'where clause'

I think there is something wrong in the Hikashop code! I touch no hika-file!!

Hubert

Hi,

I'am again.
I fixed it by alter the table (add field product_category_id / table xxx_product_category)!
I hope there are no dependencies to other querys or code??

But I wonder, that this happens with a "commercial" software!!

Regards Hubert

Hello,

thanks for the reply.
I do not understand exactly, what I have to do
But I think it is better to do not use hikashop 2.x with Joomla 3.x?
Do you or Hika recommend hikashop 2.x with Joomla 3.x??

Hubert