I posted it here because i do not know weather it is bug or not.
uninstall the best sellers module. I will sort this.indigo wrote:Error: Invalid use of group function
Error No: 1111
Hi - Great work team! I just installed & I get this error when selecting a product from the home page ...It still happens after I try & add products myself ...Code: Select all
Error: Invalid use of group function Error No: 1111 SELECT op.product_id FROM opencart_order_product op LEFT JOIN `opencart_order` o ON (op.order_id = o.order_id) LEFT JOIN `opencart_product` p ON (op.product_id = p.product_id) LEFT JOIN opencart_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY op.product_id ORDER BY COUNT(op.product_id) DESC LIMIT 4
Thanks
PHP Version 5.2.17
OpenCart®
Project Owner & Developer.
Just downloaded the new version. Looks great and the admin side is fantastic.
However, there seems to be a problem with the loading speed of the site. I noticed this in the older versions too.
If I understand it correctly you have changed so that it should be faster but it is still slow. I have appr 10,000 articles and have not even uploaded all images yet.
What can be done to have the site load faster?
fixed thickbox-compressed.js
http://forum.opencart.com/viewtopic.php ... ox#p158978
it looks as if the OC does not know when a Gift Voucher has been activated. Is the idea that it should be managed manually? Under Voucher History you can see it has been activated BUT the status is still Enabled
It would be great if the system changed status to Used
Regarding returns, could the system flag up an incoming one ?
Yes, I have tried to refresh my brower.Daniel wrote:hj7610 wrote:I have tried to log in to the back-end of demo site (ver.1.5.0), then get the same issue(bug)...
which browser are you using? and have you tried to refresh your browser?
And I have tried in IE 8, Firefox 4 and Chrome 10......
No IP address
Attachments
IP adres.png (14.29 KiB) Viewed 8026 times
I have the same issue since the 1.4.9 releases. I fixed it with the same fix suggested in this topic.Daniel wrote:hj7610 wrote:I have tried to log in to the back-end of demo site (ver.1.5.0), then get the same issue(bug)...
which browser are you using? and have you tried to refresh your browser?
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
intreasting. it should not need the json extension.Ambottera wrote:Problem solved. There was json php extension disabled.Ambottera wrote:When I hit Add to cart, the cart doesn't refresh.
Shopping cart drop-down box is empty.
Checkout isn't working at all.
Checked in FF4, Chrome, IE9.
OpenCart®
Project Owner & Developer.
i2Paq wrote:I have the same issue since the 1.4.9 releases. I fixed it with the same fix suggested in this topic.Daniel wrote:hj7610 wrote:I have tried to log in to the back-end of demo site (ver.1.5.0), then get the same issue(bug)...
which browser are you using? and have you tried to refresh your browser?
which fix?
OpenCart®
Project Owner & Developer.
This oneDaniel wrote:which fix?
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
i2Paq wrote:This oneDaniel wrote:which fix?
that does not sound like a fix. its justs to make the image manager larger. the screenshot that was put up does not even show the image manager working properly.
is it a fix or or not?
OpenCart®
Project Owner & Developer.
jQuery?Daniel wrote:intreasting. it should not need the json extension.Ambottera wrote:Problem solved. There was json php extension disabled.Ambottera wrote:When I hit Add to cart, the cart doesn't refresh.
Shopping cart drop-down box is empty.
Checkout isn't working at all.
Checked in FF4, Chrome, IE9.
Ambottera wrote:jQuery?Daniel wrote:intreasting. it should not need the json extension.Ambottera wrote:
Problem solved. There was json php extension disabled.
no your right it was because of the json fallback function not working.
OpenCart®
Project Owner & Developer.
hj7610 wrote:Yes, I have tried to refresh my brower.Daniel wrote:hj7610 wrote:I have tried to log in to the back-end of demo site (ver.1.5.0), then get the same issue(bug)...
which browser are you using? and have you tried to refresh your browser?
And I have tried in IE 8, Firefox 4 and Chrome 10......
I have tried this with all the latest browsers. what operating system are you using?
OpenCart®
Project Owner & Developer.
no it needs fixing.Ambottera wrote:Is it necessary to include check for the extension in the installer? or it is a very rare case?Daniel wrote:no your right it was because of the json fallback function not working.
OpenCart®
Project Owner & Developer.
Users browsing this forum: No registered users and 43 guests