Search found 1909 matches

Search found 1909 matches

[SOLVED] OC 2.3.0.2 make order invoice products order by category

So ive noticed, that when you add products to the cart, they order by the categories, for example if i had a starters, mains, and desert category, and randomly add products they order in the order of the category sort order. However when i view an order invoice, the products are ordered in the order...

Jump to post
  • Mon Aug 28, 2017 2:36 am
  • Replies 6
  • Views 897
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

So what was this major change that everyone speaks about between 2.1.x and 2.2+? Because something has changed!

Jump to post
  • Sat Aug 05, 2017 4:48 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

I got curious too, and added 50 Products, by help of the Auto ProductsGenerator Extension, and those 50 products generated a 2182 line Log by use of my Version 1.5.6.5, just to mention this! Ernie I'm curious. Where can I get a copy of your version? I'm seriously considering reverting back. Ernie i...

Jump to post
  • Sat Aug 05, 2017 2:57 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Thanx. Linux tends to be a bit better at numbers of queries from what I know. You may have got lucky

Jump to post
  • Sat Aug 05, 2017 3:57 am
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Not quite. If you had the same issue as me. Then all customers will see the same error until the server resets or you manually reset permissions in cpanel if your host allows. Server reset time can be up to 2 hours. You will lose customers. Just be glad you don't have the same problem. What host do ...

Jump to post
  • Sat Aug 05, 2017 3:40 am
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

By default cart will remember orders. But if this error happens. It will display orders but you will get the error again when proceeding to checkout.

The error can happen at any time. Adding orders to cart or proceeding to checkout. It depends when the max questions limit is reached.

Jump to post
  • Sat Aug 05, 2017 3:30 am
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

You would need to ask your hosting provider. No one else can answer that question. My problem is with my Web host. And how many connections are allowed over an hour or minute.

So not everyone would have the same problem.

Jump to post
  • Sat Aug 05, 2017 3:24 am
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Seems abit complicated. I'd be installing on local host.

Doesn't matter. I'm going to install a 1.5.6.4 oc with bootstrap and a few other additions. See how I get on. Thanks anyway

Jump to post
  • Sat Aug 05, 2017 2:21 am
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

IP_CAM wrote:
Sat Aug 05, 2017 12:56 am
I got curious too, and added 50 Products, by help of the Auto
ProductsGenerator Extension, and those 50 products generated
a 2182 line Log by use of my Version 1.5.6.5, just to mention this!
Ernie
I'm curious. Where can I get a copy of your version? I'm seriously considering reverting back.

Jump to post
  • Sat Aug 05, 2017 1:13 am
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

There you go then. In oc2.3.0.2 when adding around 30 products it generated over 50k select queries.

Jump to post
  • Sat Aug 05, 2017 1:08 am
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

What if I manually add all products to the cart table with customer id as 0 first? Reducing the initial insert queries to 0. Then instead of just changing id and moving to order table it could just copy and change customer id before inserting to order table? Would that reduce the mumber of queries?

Jump to post
  • Fri Aug 04, 2017 11:53 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Well my friend has a product list much like a takeaway menu. So all he needs is categories and products. Maybe special price as well. But none of the other stuff like reoccurring profiles, model, sku etc etc. I had thought about pulling all product data and ordering by category I'd then running that...

Jump to post
  • Fri Aug 04, 2017 11:47 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Thanks for your input. Luckily for me it's my friend's problem as I designed the site for them. But it looks like they will be spending some money on a decent vps or semi dedicated server. It would have been only a matter of time before they needed to do it anyway I guess. My host is just set up as ...

Jump to post
  • Fri Aug 04, 2017 9:04 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Just an update. I indexed some of the tables that get used alot. I have added a cache extension and I've also ran memcache. Problem still persists. I've tried direct from a category page and problem still happens. What I've noticed is opencart calls the cart table for all products in a category ever...

Jump to post
  • Fri Aug 04, 2017 3:19 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Thank you. Ironically I was looking in to page caching. That maybe the answer. Unfortunately the site requires a menu style category product layout and so it uses a category product module to display all products on one page hence why you see multiple dB queries. There may be a better way to optimis...

Jump to post
  • Mon Jul 31, 2017 8:07 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Thank you, yes ive turned error logs off.

I will PM you the log file, 50512 SELECT queries to be exact when adding 34 products to the cart.

Jump to post
  • Mon Jul 31, 2017 6:16 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Ok so i ran the test, something clearly isnt right. After adding 34 products to the cart and clicking checkout the site crashed, i checked the error log for information. Bare in mind this is everything that got queried just on that page alone, i typed the exact url location of the page in to the bro...

Jump to post
  • Mon Jul 31, 2017 5:26 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Wow 100 per product? OK but even if I add 50 products that's still only 5000 queries. I'm 45000 queries short of the error lol ok so the page has a logo header 5 modules a banner an article etc etc. Can't see that adding up to 50000. But I'll use your logger code and check it out. Thank you!

Jump to post
  • Mon Jul 31, 2017 3:05 pm
  • Replies 34
  • Views 5810
Re: Oc 2.3.0.2 causing max questions database error when adding products to cart

Thanks for your reply, its unlikey to be a bot, since the error occours speficially when adding a lot of products to the cart, This isnt somthing which happens randomly, or at a timed event like a bot would cause. It could be an extension which is for some reason causing a database query loop, howev...

Jump to post
  • Mon Jul 31, 2017 4:58 am
  • Replies 34
  • Views 5810
Oc 2.3.0.2 causing max questions database error when adding products to cart

I appear to be getting a max questions database error when adding around 20 products to cart. Fatal error: Uncaught exception 'Exception' with message 'Error: User '173672_menu' has exceeded the 'max_questions' resource (current value: 50000)<br />Error No: 1226<br />SELECT * FROM oc_extension WHERE...

Jump to post
  • Mon Jul 31, 2017 2:09 am
  • Replies 34
  • Views 5810

Search found 1909 matches