Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ugly text error


Recommended Posts

hi all

 

got a big problem with some text error going on.

 

i have no idea how to fix it :'(

 

it is viewable at this address: http://alterstitch.com.au/shop/index.php

 

here is what it says:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.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 = '61' order by p.products_date_added DESC limit 2

 

also there is a problem with categories

 

if you choose caps (for example) you get the following error:

 

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.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 = '15'

 

[TEP STOP]

 

i would love any help, thanks

Edited by Cheezel_X
Link to comment
Share on other sites

ah dw ive given up

 

You should not give up so fast.

 

the problems you was having was due to your database, you was missing some tables and entries in your database

 

Also it helps if you post in the correct section as you posted in the templates and images when you should have posted in Installation and Configuration

Edited by Eighteen48

Powered By osC 2.2RC2a STS 4.5.8 - HTC 2.6.3 - FP 1.5.9 - BCH 1.0.0

Link to comment
Share on other sites

You should not give up so fast.

 

the problems you was having was due to your database, you was missing some tables and entries in your database

 

Also it helps if you post in the correct section as you posted in the templates and images when you should have posted in Installation and Configuration

 

gave up for the day hehe

 

but i put it in here cos i thought it was something with the template, soz :'(

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...