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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| 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
|
| Sponsored Links | ||
| ||
|
#2
| |||
| |||
| Hi Mike, I'm adding this contribution to my site today. Have you encountered any compatibility problems with it and osCMax?
__________________ John |
|
#3
| |||
| |||
| 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.
__________________ John |
| Sponsored Links | ||
| ||
| |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Margin Report v1.00 | michael_s | New osCommerce Contributions | 0 | 07-16-2007 01:17 AM |
| All Customers Report | michael_s | New osCommerce Contributions | 0 | 03-11-2007 03:22 AM |
| All Customers Report | michael_s | New osCommerce Contributions | 0 | 03-04-2007 01:50 PM |
| Report of all products | subtleinstrument | osCMax v2 Features Discussion | 1 | 02-28-2007 04:52 PM |
| Sales Report 2 | michael_s | New osCommerce Contributions | 0 | 01-31-2007 04:03 PM |