View Full Version : Margin Report v1.00

07-16-2007, 10:12 AM
The /admin/margin_report.php file had some SQL queries which were incompatible with PHP 5 and caused the infamous 1054 - Unknown column 'p.products_id' in 'on clause' error

Attached is the PHP5 compatible file.

More... (http://www.oscommerce.com/community/contributions,1594)

07-27-2007, 12:42 PM
Hi Mike,

I'm adding this contribution to my site today. Have you encountered any compatibility problems with it and osCMax?

07-28-2007, 04:24 PM
Installed 2.56 and updated the report file pretty easily. If anyone is installing this though you can't just follow the instructions on find and replacing bits of code because Max has an additional field in some of the queries and inserts. In most cases it was just "products_cost" that needed to be added to the query or insert.