Em Andamento

osCommerce - fix bug #1054

I have noticed a small bug in my osCommerce shop after having moved a site to a new server which appears to have mysql 5 installed.

I get the following error when clicking on menu category links:

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

select distinct p.products_id, p.products_image, p.products_tax_class_id, [url removed, login to view] as specstat, s.specials_new_products_price, 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 = '73' and p.products_status = '1' and [url removed, login to view] = '1' order by rand() DESC limit 6

I believe this is something to do with the Ultimate SEO url contribution though I have applied the fixes noted in forums without success - I have now removed the fixes ( I am using Ultimate SEO Url's package: Ultimate_SEO_URLsv21da )

In apache error log I can see:

[Sat Jul 7 18:47:02 2007] [error] PHP Warning: Cannot modify header information - headers already sent by (output started at /path/to/includes/[url removed, login to view]) in /path/to/includes/classes/[url removed, login to view] on line 1995

Habilidades: PHP

Ver mais: oscommerce 1054, 1054 oscommerce, oscommerce warning modify header information headers already sent, modify header information oscommerce, products_status ultimate seo, 1054 php, my fix, get my fix, modify header information headers already sent oscommerce, 1054 oscommerce fix, categories 1054 oscommerce, oscommerce 1054 desc, 1054 osc fix, osc warning modify header information headers already sent, commerce mysql bug left join, oscommerc warning modify header information headers already sent, fix oscommerce 1054, oscommerce modify categories, mysql bug 1054, oscommerce warning modify header information, modify header information oscommerce login, oscommerce 1054 problem, oscommerce files left join fix, oscommerce 1054 featured, oscommerce 1054 fix

Acerca do Empregador:
( 17 comentários ) Bristol, United Kingdom

ID do Projeto: #157723