Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 TEP STOP


edodidi

Recommended Posts

Getting the same error over and over, can someone please advice?

 

Tnx

 

1146 - Table 'raceskinz.TABLE_SPECIALS2' doesn't exist

 

select count(*) as total from products p, products_description pd, TABLE_SPECIALS2 s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1'

Link to comment
Share on other sites

Yes i did,

So now your error changed to:

 1054 - Unknown column 's.specials2_new_products_price' in 'field list'

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials2_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials2_date_added DESC limit 0, 9

What do you expect from us?

Link to comment
Share on other sites

What do you expect from us?

 

Miracles?

 

I would recommend you go back and check every step of the contribution installation including anything tat mentions sql

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...