Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL Error


Recommended Posts

Quick Run down of my problem, Maintaining a online show that was setup initially by someone else. I've updated to the latest milestone release and everything is working fine except on one page, the index.php page, and only with one seemingly one passed get var option.


plain old index.php works fine,


index.php?cPath=30_55 this sort of thing works perfectly too




index.php?cPath=30 Produces


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

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_weight, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '30' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 16


i though perhaps i'd missed updating a sql statement somewhere in the index.php file, but i cant for the life of me find where this statement is actually being produced.


I know the problem is that this sort of query wont work on mysql 5. So any help to locate where this statement is produced would be greatly appreciated.

Link to comment
Share on other sites


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

  • Create New...