Forums / Templates, Stylesheets, Page Layout / Help,What's the matter of my site(localhost)

Help,What's the matter of my site(localhost)

Locked

Started by jim9 on 18 Jul 2010, 5:42 AM · Views: 902

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
18 Jul 2010, 5:42 AM
#1
jim9 avatar

jim9

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.

18 Jul 2010, 9:45 AM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Help,What's the matter of my site(localhost)

Zen Cart doesn't have a products_price_retail field, so it sounds as if you have been attempting to install a third party add-on, or are trying to use a template that assumes that you have it installed.

But you haven't told us very much about your cart, so it's not possible to be more specific. Please click the "Reply" button below, and answer all the questions asked in the "Posting Tips" section.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

24 Jul 2010, 9:56 AM
#3
jim9 avatar

jim9

New Zenner

Join Date:
May 2010
Posts:
9
Plugin Contributions:
0

Re: Help,What's the matter of my site(localhost)

kuroi:

Zen Cart doesn't have a products_price_retail field, so it sounds as if you have been attempting to install a third party add-on, or are trying to use a template that assumes that you have it installed.

But you haven't told us very much about your cart, so it's not possible to be more specific. Please click the "Reply" button below, and answer all the questions asked in the "Posting Tips" section.

I had just for a test on my PC.I used the templates which I download from the net,but there was the problem.I didn't know the problem,I'm a tiro. THS.

Maybe the problem what uper told.but I import the data,there was error.Bad luck.

Then I only to change a templates,could you give me a download url as lightinthebox's sample.

24 Jul 2010, 9:57 AM
#4
jim9 avatar

jim9

New Zenner

Join Date:
May 2010
Posts:
9
Plugin Contributions:
0

Re: Help,What's the matter of my site(localhost)

adulti:

I had the same problem. You are using lightinthebox's sample, but you need a lightinthebox's database!

Try to find one!

Maybe the problem.but I import the data in the zip there was a error.Could you give me a download url as lightinthebox's sample.

Thank you very much.