Error in Displaying the Details of Products

15.11.2013 07:23
#1
skillfulken
Joomshopping forum user no avatar
Name: Ken
15.11.2013
Posts: 6
Quote
Error in Displaying the Details of Products

Hello!

I have encountered a problem after I deleted one attribute with ID#2. I get the following message when I click the product:

Quote "Unknown column 'PA.attr_2' in 'field list' SQL=SELECT distinct PA.attr_2 as val_id, V.`name_en-GB` as value_name, V.image FROM `vzv8w_jshopping_products_attr` as PA INNER JOIN vzv8w_jshopping_attr_values as V ON PA.attr_2=V.value_id WHERE PA.product_id = '12' and PA.attr_1='2' ORDER BY V.value_ordering"

Moreover, the ordering of attributes is missing number 2 in the backend!

Could anyone tell me how to fix it? It seems that I should manipulate the coding of JoomShopping instead of editing in the backend?
Error in Displaying the Details of Products


Joomla: 3.1.5
JoomShopping: Version 4.3.1 Pro
PHP: 5.3.26
MySQL: 5.5.32
 
15.11.2013 07:57
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16506
Quote
Aw: Error in Displaying the Details of Products

Add field manual (phpmyadmin)

 
15.11.2013 14:03
#3
skillfulken
Joomshopping forum user no avatar
Name: Ken
15.11.2013
Posts: 6
Quote
Aw: Error in Displaying the Details of Products

Thanks very much!

Solved it successfully!

 
Copyrights MAXXmarketing GmbH. All Rights Reserved