Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

errors from specials.php


rains

Recommended Posts

Hello,

 

I have recently noticed that the specials page, here; is generating the following error:

____________________________________________________________

1054 - Unknown column 'p.products_sort_order' in 'order clause'

 

select pd.products_name 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 s.status = '1' order by p.products_sort_order ASC

 

[TEP STOP]

_____________________________________________________________

This all has been working fine, up until a few days back. I recognise that it seems to be something to do with the products sort order clashing, but I can't seem to find where I can change or adjust these settings.

 

I have had a couple of people working on the site in the background and can't really be sure, if one of their work may have casued this.

 

The recent work has been in adding and setting-up some ParcelForce Worldwide shipping modules and cDynamic_Meta_Tags.

 

Thanks for any assiastance you can offer,

 

rains

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...