I get this error
"AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',11 GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,' at line 64<br />Error No: 1064<br />\n\t\t\tSELECT \n\t\t\t\tp.product_id, \n\t\t\t\t(\n\t\t\t\t\tSELECT AVG(rating) total \n\t\t\t\t\tFROM `ocs8_review` r1 \n\t\t\t\t\tWHERE \n\t\t\t\t\t\tr1.product_id = p.product_id \n\t\t\t\t\t\tAND r1.status = '1' \n\t\t\t\t\tGROUP BY r1.product_id\n\t\t\t\t) rating, \n\t\t\t\t(\n\t\t\t\t\tSELECT price \n\t\t\t\t\tFROM `ocs8_product_discount` pd2 \n\t\t\t\t\tWHERE \n\t\t\t\t\t\tpd2.product_id = p.product_id \n\t\t\t\t\t\tAND pd2.customer_group_id = '1' \n\t\t\t\t\t\tAND pd2.quantity = '1' \n\t\t\t\t\t\tAND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) \n\t\t\t\t\t\tAND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) \n\t\t\t\t\tORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1\n\t\t\t\t) discount, \n\t\t\t\t(\n\t\t\t\t\tSELECT price \n\t\t\t\t\tFROM `ocs8_product_special` ps \n\t\t\t\t\tWHERE \n\t\t\t\t\t\tps.product_id = p....'"
can any body explain
what could be?
kind regards
Sal
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Full OC version?
What extensions do you have installed?
When does this happen?
That \n\t\t\t\t\t is newline and tabs. SOMETHNG is really mucking up that query. So it might be just something that is messed up with an extension or there is a major flaw with an extension and it is allowing people to add stuff to get to a sql query and attempting an attach. I would guess the first but overall you need to give us a lot more details.
Mike
cue4cheap not cheap quality
- total order with taxes
- plugin for seo
- multiupload images
- admin filter on products
- stripe paypent
- free shipping
- payment fee/ discounts
- mass update for products
- ebay / google merchant connection
- insert product prices tax included
- abandoned carts
thanks for support!
You'll have to either disable or uninstall each extension until noticing which extension is causing this error until this error message is gone. Afterwards, contact the extension developer of the related extension to resolve this issue.May85 wrote: ↑Sun Apr 25, 2021 8:50 pmI have few extension
- total order with taxes
- plugin for seo
- multiupload images
- admin filter on products
- stripe paypent
- free shipping
- payment fee/ discounts
- mass update for products
- ebay / google merchant connection
- insert product prices tax included
- abandoned carts
thanks for support!
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
about some I'm sure that they arent becouse all start with a strange issue: when I save a product / change a status order , the front end stop working for about ten seconds. Some I put after this issue so they couldn't imho
for remove an extension i go in extension manager and I unistall ? I have to do only this?
If you want to uninstall extensions: OC Admin > Extensions > Installer . Then, see this FAQ post: viewtopic.php?f=134&t=215776#p718325 .May85 wrote: ↑Sun Apr 25, 2021 9:02 pmHello
about some I'm sure that they arent becouse all start with a strange issue: when I save a product / change a status order , the front end stop working for about ten seconds. Some I put after this issue so they couldn't imho
for remove an extension i go in extension manager and I unistall ? I have to do only this?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Some extensions require this for removal:
Extensions > Extensions > Modules > uninstall
before doing the
Extensions > Installer > Uninstall
The latter only removes the files.
Then it's always a good idea to also refresh the OCmod:
Extensions > Modifications > Refresh
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
The error is in the query itself near ",11 GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,"
A query can not have ",11 GROUP BY" but we cannot see the entire query so you have to print and post
Go to file catalog/model/catalog/product.php
find function:
Code: Select all
getProducts
Code: Select all
$query = $this->db->query($sql);
Code: Select all
$this->log->write($sql);
When you found it, post it and remove the code above.
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Users browsing this forum: Bing [Bot] and 516 guests