OpenCart Community

Search found 9984 matches

Re: Max User Connections Error in OpenCart 3.0.4.0 with PHP 8.3 - Seeking Help

We have an article about preventing Bing etc. from spamming your site, using all the bandwidth, and potentially taking it down: https://www.antropy.co.uk/blog/how-to-r ... ary-links/

Jump to post

Fri Jul 11, 2025 7:00 pm
Replies 19
Views 588

paulfeakins

Re: How to display customers names in the review list in Admin?

I'm not SQL savvy enough. This really is such a simple thing that if it doesn't make sense, you probably shouldn't be poking around with any code at all on a live ecommerce shop. You should probably find a freelancer from the Commercial Support Forum. However, it does seem to already output the Aut...

Jump to post

Fri Jul 11, 2025 6:45 pm
Replies 4
Views 515

paulfeakins

Re: How to display customers names in the review list in Admin?

paola_84 wrote: ↑
Thu Jul 10, 2025 3:20 am
I saw that the "oc_review" table in the database contains the customer ID so how can I display the customer's name in the review list?

Try:

Code: Select all

SELECT * FROM `oc_review` r
JOIN `oc_customer` c 
ON r.customer_id = c.customer_id;

Jump to post

Thu Jul 10, 2025 7:44 pm
Replies 4
Views 515

paulfeakins

Re: Max User Connections Error in OpenCart 3.0.4.0 with PHP 8.3 - Seeking Help

mandom wrote: ↑
Wed Jul 09, 2025 5:27 pm
**max\_user\_connections** limit on my MySQL database.

...

* **Hosting**: Shared hosting with a 20 DB connection limit.

You need hosting with higher limits.

Jump to post

Wed Jul 09, 2025 6:04 pm
Replies 19
Views 588

paulfeakins

Re: Error "Could not load file localisation/*.json" on checkout page

Considering the "server" is the Docker container (there's no WAF there), and the Apache web server within that container is responding to the browser (meaning nothing on my laptop is interfering with the request), I find it very unlikely to be a security/firewall issue. Are you sure the s...

Jump to post

Wed Jul 09, 2025 5:59 pm
Replies 9
Views 849

paulfeakins

Re: Error "Could not load file localisation/*.json" on checkout page

When looking at the server response for the respective requests in the Network tab, I can see that the 404 was generated by Apache in the Docker container, indicating the request didn't even make it into OpenCart. Probably security/firewall software blocking the request. OpenCart won't work if its ...

Jump to post

Tue Jul 08, 2025 6:41 pm
Replies 9
Views 849

paulfeakins

Re: Category dropdown list

Hi Dan, I think give us a link to your site so we can see what's going on.

Jump to post

Tue Jul 08, 2025 6:35 pm
Replies 7
Views 2054

paulfeakins

Re: Category dropdown list

gunownergear wrote: ↑
Fri Jul 04, 2025 10:57 pm
How do I prevent the drop down list from starting a new column and keep all the sub-categories all lined up vertically ?

Are you talking about on the front-end or in the admin?

Perhaps give us a link to your site?

Jump to post

Mon Jul 07, 2025 7:03 pm
Replies 7
Views 2054

paulfeakins

Re: How to check if current page is the homepage in twig?

paola_84 wrote: ↑
Thu Jul 03, 2025 2:06 am
How can I do it?

There are many ways, but I would create 2 new templates:
column_left_home.twig
column_right_home.twig

Modify those as you wish and include them on the home template.

Jump to post

Thu Jul 03, 2025 7:53 pm
Replies 5
Views 2177

paulfeakins

Re: How to properly restrict Bingbot from crawling unnecessary links?

You could give the Bingbot a crawl delay as described here: https://www.antropy.co.uk/blog/how-to-r ... ary-links/

Jump to post

Wed Jul 02, 2025 7:03 pm
Replies 11
Views 6377

paulfeakins

Re: Need for Mailblue integration in checkout: field mail

Feel free to drop us an email for a quick estimate: info@antropy.co.uk

Jump to post

Tue Jul 01, 2025 10:05 pm
Replies 7
Views 1494

paulfeakins

Re: mini cart in header not updating to show option price

JNeuhoff wrote: ↑
Mon Jun 30, 2025 9:00 pm
And there are extensions (such as our Instant Option Price Calculator) which instantly update the product price on the product page depending on the chosen option values.

We like JNeuhoff and his extensions

Jump to post

Tue Jul 01, 2025 8:02 pm
Replies 5
Views 2692

paulfeakins

Re: Inactive hamburger menu/Non-resizing logo image

phpconsult wrote: ↑
Mon Jun 30, 2025 6:53 pm
One more question.

Usually it's one question per topic.

Jump to post

Tue Jul 01, 2025 8:01 pm
Replies 4
Views 2412

paulfeakins

Re: How can I speed up my OpenCart site? It's very slow on shared hosting.

kamalhinduja wrote: ↑
Tue Jul 01, 2025 2:15 pm
Can anyone share tips on how to speed up my OpenCart site?

Sure, read this: https://www.antropy.co.uk/blog/speed-up ... ed-issues/

Jump to post

Tue Jul 01, 2025 7:58 pm
Replies 4
Views 3497

paulfeakins

Re: mini cart in header not updating to show option price

Well if a client is paying you to develop this you'd better learn to code it

Jump to post

Mon Jun 30, 2025 8:04 pm
Replies 5
Views 2692

paulfeakins

Re: mini cart in header not updating to show option price

ianhaney50 wrote: ↑
Mon Jun 30, 2025 6:57 pm
I'll be honest and I asked chatgpt to do the code for me

Yeah luckily us web developers still have jobs at this point.

Anyway, why not just make the product price the price of the lowest option and make the other options the differences? That's how it's supposed to work.

Jump to post

Mon Jun 30, 2025 7:46 pm
Replies 5
Views 2692

paulfeakins

Re: Upgrading to 4.1 from 4.0.2.3, Error line 9

knigisan wrote: ↑
Sun Jun 29, 2025 5:34 am
For me, the update stops at step 9 too. Is there any solution yet?

Switch back to 3.0.4.1.

Jump to post

Mon Jun 30, 2025 7:35 pm
Replies 33
Views 14874

paulfeakins

Re: What happened to OpenCart 4.1.0.3 "Payment Methods"?

Firstly, if you're talking about a specific file, you should give its path e.g.:

/admin/language/en-gb/extension/payment.php

Secondly, you can see the history of that file here:

https://github.com/opencart/opencart/co ... ayment.php

Jump to post