1. Robert Morrison
  2. Feedback and ideas
  3. woensdag, februari 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<br />Error No: 1064<br />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
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. Feedback and ideas
  3. # 1
Robert Morrison 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. Feedback and ideas
  3. # 2
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. Feedback and ideas
  3. # 3
Robert Morrison Accepted Answer
0
Votes
Undo
Now fixed.

Thanks
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Feedback and ideas
  3. # 4
Emeka Okwusi 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. Feedback and ideas
  3. # 5
Emeka Okwusi Accepted Answer
0
Votes
Undo
Thanks it worked
Comment
Very good!
  1. Dennis Buijs
  2. 10 months ago
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Feedback and ideas
  3. # 6
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. Feedback and ideas
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar
• Remove Upload Files (Maximum File Size: 2 MB)
You may insert polls into your post. The poll would then appear in the post.
Vote Options
In this section you can provide your site details at here and it visible to the moderators only.
Share Location

Sharing your current location while posting a new question allow viewers to identify the location you are located.

Latitude:
Longitude:

Welcome

Categories

OpenCart Free Extension
  1. 0 posts
  2. 2 subcategories
OpenCart Commercial Extension
  1. 12 posts
  2. 17 subcategories
Sales & Billing
  1. 0 posts
  2. 2 subcategories
Welcome
  1. 7 posts
  2. 2 subcategories

Recent Discussions

Undefined variable on install
Installed this module to a fresh Opencart 3.0.2 and got the following errors. ...
100 Hits
0 Votes
Posted on dinsdag, oktober 09 2018, 09:43 PM
Cost and profit module issue
Need help with Cost and profit module issue, after its installed and everything ...
210 Hits
0 Votes
Posted on zondag, juni 10 2018, 12:17 AM
  • Resolved
  • OWC Replace Anywhere fail
    Dear Support Team. I bought a your module "OWC Replace Anywhere", V...
    1494 Hits
    0 Votes
    Posted on vrijdag, juli 07 2017, 01:25 PM
  • Resolved
  • Not appearing on extension list
    I've installed the extension by transferring all of the "Upload" folde...
    1884 Hits
    0 Votes
    Posted on woensdag, mei 10 2017, 10:47 AM
  • Resolved
  • OWC cost price field in import module Hostjars
    I have owc cost price installed but in Hostjars total import i can't see the cos...
    2661 Hits
    0 Votes
    Posted on donderdag, maart 30 2017, 11:25 AM
  • Resolved