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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
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. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.