LinkBack URL
About LinkBacksThe /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...
This is a discussion on Margin Report v1.00 within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; The /admin/margin_report.php file had some SQL queries which were incompatible with PHP 5 and caused the infamous 1054 - Unknown ...
Margin Report v1.00 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...
Michael Sasek
osCMax Developer
osCmax installation service - Have our professionals install osCmax on your server - same day service!
osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0
Stay Up To Date with everything osCMax:
Free osCMax Newsletters - Security notices, New Releases, osCMax News
osCMax on Twitter - Up to the minute info as it happens. Know it first.
osCmax Documentation
Re: Margin Report v1.00 Hi Mike,
I'm adding this contribution to my site today. Have you encountered any compatibility problems with it and osCMax?
Re: Margin Report v1.00 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.
Posting Permissions
Bookmarks