Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

errors from specials.php


Recommended Posts



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




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,



Link to comment
Share on other sites


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

  • Create New...