1. Dennis Buijs
  2. Product Sale and Cost Price
  3. Wednesday, February 08 2017, 05:50 PM
  4.  Subscribe via email
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
Comment
There are no comments made yet.
Add Comment
dfn Accepted Answer
0
Votes
Undo
clip-on ponytail for black hair balmain hair extensions review hair extensions sale kids hairstyles for girls tape in hair extensions before and after hair extensions uk how to make your own hair tracks dark blonde real hair extensions human hair small hair clips hair extensions sydney cbd lace wigs uk
Comment
https://www.google.com
google.com/
[url=https://www.google.com]google.com/[/url]
  1. Guest
  2. 5 years ago
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 1
irvin Accepted Answer
0
Votes
Undo
When i enable the plugin it goes to a white screen. Also, after installing this plugin i can no longer modify store settings.
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 2
Dennis Buijs Accepted Answer
0
Votes
Undo
Thanks it worked
Comment
Very good!
  1. Dennis Buijs
  2. 7 years ago
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 3
Dennis Buijs Accepted Answer
0
Votes
Undo
I just purchased the extension as well, using the 2.3.x but when am trying to install it it giving me error
Fatal error: Class 'VQMod' not found in /home/girlrtng/public_html/admin/controller/extension/module/owc_productsalecostprice.php on line 2

Also I can't find it in the User Group Access section, Pls what could be issue ? Kindly Help ASAP. If you need my FTP and Admin access kindly let me knw so you can assist me ASAP
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 4
Dennis Buijs Accepted Answer
0
Votes
Undo
Now fixed.

Thanks
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 5
Dennis Buijs Accepted Answer
0
Votes
Undo
Hi Robert

GR, sorry, I forgot a ' character!

Please try download again, also version 1.1!

Sorry for the discomfort!

Best regards
Dennis
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 6
Dennis Buijs Accepted Answer
0
Votes
Undo
Downloaded and installed. Problem still there.
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 7
Dennis Buijs Accepted Answer
0
Votes
Undo
Hi Robert

Please download new version from the OpenCart website, verion 1.1.

1.1 - 08-02-2017
# -> Bug Fix, database table prefix solved.

Best regards
Dennis
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Product Sale and Cost Price
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Welcome

Categories

OpenCart Free Extension
  1. 1 post
  2. 2 subcategories
OpenCart Commercial Extension
  1. 73 posts
  2. 17 subcategories
Sales & Billing
  1. 0 posts
  2. 2 subcategories
Welcome
  1. 6 posts
  2. 2 subcategories

Recent Discussions

EU VAT Compliant issue
Hello, we use the EU VAT Compliant plugin. It is working correctly in opencar...
130 Hits
0 Votes
Posted on Wednesday, December 11 2024, 09:26 AM
Error log issues for version 3.21
Hi Get this info in error log: 2024-10-08 23:45:32 - PHP Warning: Undefin...
368 Hits
0 Votes
Posted on Tuesday, October 08 2024, 09:53 PM
OWC EU VAT Compliant v3.15 - ocmod bug
When I edit user data and try to save, I get an error: Fatal error: Uncaught ...
527 Hits
0 Votes
Posted on Wednesday, August 28 2024, 09:22 AM
Very Critical BUG: Swiss VAT IDs are accepted as V
Hello, the Extensions incorrectly accepts Swiss Tax numbers as valid VAT numb...
528 Hits
0 Votes
Posted on Tuesday, August 27 2024, 12:55 PM
The buyer does not see second address and postal c
The buyer does not see the Administrator's modified second address and postal co...
611 Hits
0 Votes
Posted on Tuesday, August 20 2024, 11:06 AM