I purchased your Product Sale and Cost Price extension for Opencart and when reports are activated the page shows this php error
Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
Error No: 1064
SELECT op.name, op.model, SUM(op.quantity) AS quantity, SUM((op.price + op.tax) * op.quantity) AS total, SUM(op.price * op.quantity) AS total_ex, SUM(p.cost_price * op.quantity) AS cost_price FROM expo_order_product op LEFT JOIN `expo_order` o ON (op.order_id = o.order_id) LEFT JOIN expo_product` p ON (p.product_id = op.product_id) WHERE o.order_status_id > '0' GROUP BY op.product_id ORDER BY total DESC LIMIT 0,20 in /var/www/clients/client0/web2/web/system/storage/modification/system/library/db/mysqli.php:47 Stack trace: #0 /var/www/clients/client0/web2/web/system/storage/modification/system/library/db.php(16): DB\MySQLi->query('SELECT op.name,...', Array) #1 /var/www/clients/client0/web2/web/vqmod/vqcache/vq2-admin_model_report_product.php(78): DB->query('SELECT op.name,...') #2 /var/www/clients/client0/web2/w in /var/www/clients/client0/web2/web/system/storage/modification/system/library/db/mysqli.php on line 47
and can't access report page.
Please fix,
Robert