New Zenner
- Join Date:
- May 2010
- Posts:
- 9
- Plugin Contributions:
- 0
Help,What's the matter of my site(localhost)
Hello,
I download a templates from the network.Then I setup a ZC CMS all is ok.
But then I view the site:http://127.0.0.1/lightinthebox/.
The error details:
1054 Unknown column 'p.products_price_retail' in 'field list'
in:
[select p.products_id, p.products_type,p.products_status,p.products_price,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products_quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from light_products_description pd, light_products p left join light_manufacturers m on p.manufacturers_id = m.manufacturers_id, light_products_to_categories p2c left join light_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and ( p2c.categories_id =1 or p2c.categories_id =4 or p2c.categories_id =5 or p2c.categories_id =6 or p2c.categories_id =7 or p2c.categories_id =8 or p2c.categories_id =9 or p2c.categories_id =16 or p2c.categories_id =17 or p2c.categories_id =2 or p2c.categories_id =18 or p2c.categories_id =19 or p2c.categories_id =20 or p2c.categories_id =3 or p2c.categories_id =10 or p2c.categories_id =11 or p2c.categories_id =12 or p2c.categories_id =13 or p2c.categories_id =14 or p2c.categories_id =15 or p2c.categories_id =21 or p2c.categories_id =22 or p2c.categories_id =23 or p2c.categories_id =24 or p2c.categories_id =25 or p2c.categories_id =28 or p2c.categories_id =33 or p2c.categories_id =34 or p2c.categories_id =40 or p2c.categories_id =43 or p2c.categories_id =35 or p2c.categories_id =37 or p2c.categories_id =38 or p2c.categories_id =39 or p2c.categories_id =36 or p2c.categories_id =41 or p2c.categories_id =42 or p2c.categories_id =44 or p2c.categories_id =48 or p2c.categories_id =31 or p2c.categories_id =32 or p2c.categories_id =45 or p2c.categories_id =47 or p2c.categories_id =49 or p2c.categories_id =27 or p2c.categories_id =52 or p2c.categories_id =50 or p2c.categories_id =46 or p2c.categories_id =51 or p2c.categories_id =53 or p2c.categories_id =54 or p2c.categories_id =55 or p2c.categories_id =56 or p2c.categories_id =57 or p2c.categories_id =58 or p2c.categories_id =60 or p2c.categories_id =61 or p2c.categories_id =62 or p2c.categories_id =63 or p2c.categories_id =64)]
What can I do.:no: THS for you help.