Re: How to properly restrict Bingbot from crawling unnecessary links?
All I get is the statistics that Bingbot is wasting over 500G of traffic. I can't tell what type of links Bingbot is capturing, I would like to start by disabling Bingbot from crawling search links. RewriteEngine On RewriteCond %{HTTP_USER_AGENT} Bingbot [NC] RewriteCond %{REQUEST_URI} ^/search/?$ ...
Jump to post- Tue Jun 10, 2025 1:25 pm
- Replies 6
- Views 831
Re: How to properly restrict Bingbot from crawling unnecessary links?
In recent months, Our server has been consuming too much traffic from Bingbot. How can I make Bingbot crawl only product and category pages to avoid wasting traffic? This is the discussion I saw: https://www.reddit.com/r/bing/comments/1imihhk/why_is_bingbot_spamming_my_website_with_random/?tl=zh-ha...
Jump to post- Tue Jun 10, 2025 12:47 pm
- Replies 6
- Views 831
Re: Multiple stores with separate databases
Hi , I searched to find a way to do what I am going to explain now and I did not find any . Creating additional stores on the same server and with the same control panel as far as I know, they must all be in the same database created for OpenCart. Is there a way to separate each store with its own ...
Jump to post- Mon May 19, 2025 8:29 pm
- Replies 16
- Views 5742
Re: How to prevent duplicate products at checkout?
Or you could change this: // Remove all the expired carts with no customer ID $this->db->query("DELETE FROM " . DB_PREFIX . "cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)"); [code] to this: [code] // Remove all expired cart items...
Jump to post- Wed May 14, 2025 10:20 pm
- Replies 13
- Views 3534
Re: What PHP Mailer does OC v3.0.3.8 use?
maybe have a look at these:
Code: Select all
https://forum.directadmin.com/threads/host-impersonating-domain-name.66551/
https://forum.directadmin.com/threads/bad-helo-host-impersonating-domain-name-and-exim-conf.69454/
https://forum.directadmin.com/threads/bad-helo-host-impersonating-domain-name.57629/
- Thu May 01, 2025 10:51 am
- Replies 22
- Views 10154
Re: My incomplete attempt to add a "Confirm Email" field
Which would render the entire checkout process unusable. Jump to postpaulfeakins wrote: ↑Tue Apr 29, 2025 6:52 pmNot really, JavaScript can be turned off very easily.
- Wed Apr 30, 2025 12:45 pm
- Replies 9
- Views 3602
Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...
Thanks, looks good so far. Two questions, did you modify the original framework file, or do you have one in the modification folder? Any idea how to force a 1064 error specifically? We changed the original. A 1064 is an sql syntax error so you can just change a query to have such, add a quote, chan...
Jump to post- General Support
- PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...
- Sat Apr 19, 2025 7:48 am
- Replies 22
- Views 2846
Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...
On exception catching: We use this in system/framework.php function exit_nicely () { $headers = array_change_key_case(apache_request_headers(),CASE_LOWER); $json_req = ((array_key_exists("accept",$headers) && stristr($headers['accept'],'application/json')) ? true : false); $ajax_r...
Jump to post- General Support
- PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...
- Fri Apr 18, 2025 2:30 pm
- Replies 22
- Views 2846
Re: Semrush Warning alt attributes opencart defualt loading image.
Hi Guys! Why is this issue not resovled in latest version? Is there any way to fix this module? 155 images don't have alt attributes /catalog/view/theme/default/image/loading.gif This is default opencart.. using opencart 3.0.4.0 Journal 3 theme. adding alt attributes to 155 pages is not fun.. Using...
Jump to post- Thu Apr 17, 2025 11:48 am
- Replies 8
- Views 788
Re: OCMOD causing IP ban
Thanks by mona, i shall look into it if my host doesn't help. Shows how often i go on host, i can actually turn mod_security off (not that want to) in the cpanel. https://forum.opencart.com/viewtopic.php?p=878250#p878250 I had a quick look nonnedelectari but I'm still hoping the hosts will reply wi...
Jump to post- Wed Apr 16, 2025 6:43 pm
- Replies 25
- Views 1489
Re: Sitemap Invalid tag value: <lastmod>
Hello Everyone here My XML Sitemap when i try to submit on google seach console i got error Invalid tag value: <lastmod> below is my sitemap link Version 3.0.3.8 need urgently help https://www.gatesautomatic.com/sitemap.xml <lastmod>-0001-11-30T00:00:00+03:41</lastmod> yes, that is wrong.
Jump to post- Wed Apr 16, 2025 6:13 pm
- Replies 15
- Views 959
Re: OCMOD causing IP ban
I recommend Krystal in the UK. I have quite a few sites held with them and none of my customers have a bad word to say. They all have mod_security on and no issues with Opencart or the modification system besides with Krystal you have full control to turn it on and off anyway. I think you get a tri...
Jump to post- Wed Apr 16, 2025 6:07 pm
- Replies 25
- Views 1489
Re: OCMOD causing IP ban
So nonnedelectari, your saying if mod_security is used on host OC will not work? Or at least that OCMOD wont work? So i need to be looking for a host without security? No, OC works just fine with mod security but it does depend on which rules your host has enabled, sometimes they enable rules which...
Jump to post- Wed Apr 16, 2025 5:56 pm
- Replies 25
- Views 1489
Re: OCMOD causing IP ban
Well, if you put php code in a request, whether it is a post or get, whether it is in get parameters, post payload or json structures, you will get this result from mod security or any other firewall your host is using. You will get similar results when doing so with sql statements. I do not know w...
Jump to post- Wed Apr 16, 2025 5:03 pm
- Replies 25
- Views 1489
Re: What PHP Mailer does OC v3.0.3.8 use?
I also checked what my SERVER_NAME is, and it's mydomain.com Unfortunately I'm not able to check what SERVER_NAME is on my mail server. The mail server won't have SERVER_NAME as that's just for web servers. It will just be the mail server configuration. Have you asked whoever hosts you mail server?...
Jump to post- Wed Apr 16, 2025 4:11 pm
- Replies 22
- Views 10154
Re: OCMOD causing IP ban
Well, if you put php code in a request, whether it is a post or get, whether it is in get parameters, post payload or json structures, you will get this result from mod security or any other firewall your host is using. You will get similar results when doing so with sql statements. I do not know wh...
Jump to post- Wed Apr 16, 2025 4:01 pm
- Replies 25
- Views 1489
Re: What PHP Mailer does OC v3.0.3.8 use?
Sorry about the new thread, I wasn't getting any help there. I have the same issue still ( Original Thread ). I have a VPS and then also a separate mail server at the same host (I moved from Shared Hosting). They say my SMTP details are correct and that OC is the problem with sending emails, on the...
Jump to post- Fri Apr 11, 2025 7:57 pm
- Replies 22
- Views 10154
Re: How to prevent duplicate products at checkout?
I have added an extension that keeps the customer logged in for a longer period to hopefully prevent some of this...but now a customer just emailed me saying that he clicked on our store site and when he checked his account, he noticed that it was completely someone else's account! He logged out an...
Jump to post- Fri Apr 11, 2025 7:44 pm
- Replies 13
- Views 3534
Re: OC V3 PHP7.4 SMTP Issues: Error: EHLO not accepted from server!
you could change this code: throw new \Exception('Error: EHLO not accepted from server!'); in system/library/mail/smtp.php to: throw new \Exception('Error: EHLO not accepted from server'."\n".'['.$reply.']'); so you get some more info as to what is returned from the EHLO command, if anythi...
Jump to post- Installation, Upgrade, & Config Support
- OC V3 PHP7.4 SMTP Issues: Error: EHLO not accepted from server!
- Tue Apr 08, 2025 2:34 am
- Replies 4
- Views 1234
Re: How to add another option at header?
Be aware that with so many clickable icons in that header, on a mobile, you will need a needle to be able to select any of them.
Jump to post- Wed Apr 02, 2025 8:38 pm
- Replies 10
- Views 909
