Re: Finding database NOW() offset
Look at the SQL time_zone variables. You can find in phpMyAdmin under the Variables tab or use a query. SELECT @@GLOBAL.time_zone, @@SESSION.time_zone, @@system_time_zone; Thank Add Creative. system_time_zone is set to BST. So is Opencart setting this or is this set by the server? Btw both GLOBAL.t...
Jump to post- Sun Apr 19, 2020 1:49 am
- Replies 4
- Views 233
[SOLVED] Finding database NOW() offset
Good afternoon everyone, I know questions regarding the timezone settings have been asked before but I can't seem to find the answer to my little question. My hosting server's default timezone is UTC and this is also set in the /system/startup.php in my store installation. However; when an order is ...
Jump to post- Sat Apr 18, 2020 10:28 pm
- Replies 4
- Views 233
Re: Increase in fake customer accounts
These are bots, not spammers themselves. Tons of bots all over the Web and they constantly try to register accounts, post some crap on forums etc. If you don't have too much customers, then you can simply remove fake accounts manually from time to time. Because adding a bunch of captchas to your st...
Jump to post- Wed Nov 13, 2019 12:30 am
- Replies 7
- Views 1183
Re: Increase in fake customer accounts
If you need a captcha, I have an Account Registration Captcha extension that can do that. It works with both the regular registration and the checkout registration (for the default checkout, not for quick checkouts, which would need their own captcha). Feel free to take a look at the screenshots an...
Jump to post- Thu Nov 07, 2019 6:21 pm
- Replies 7
- Views 1183
Re: Increase in fake customer accounts
I am used to getting spam emails but fake accounts is new, I just don't see what the spammer would get out of it?
Jump to post- Thu Nov 07, 2019 6:19 pm
- Replies 7
- Views 1183
[SOLVED] Increase in fake customer accounts
Has anyone else started to get a load of fake customer signups? In the last couple of days I've had a few accounts created with gobbledegook first and last names from locations in the far east.
I'm using Opencart 2.0.3.1, is there a security flaw I should know about that is being exploited here?
- Wed Nov 06, 2019 7:31 pm
- Replies 7
- Views 1183
Re: Admin Login Screen Suddenly Not Working
So it appears to be something to do with my 301 redirects in my .htaccess file: Options +FollowSymlinks RewriteEngine on RewriteBase / RewriteCond %{HTTPS} off # First rewrite to HTTPS: # Don't put www. here. If it is already there it will be included, if not # the subsequent rule will catch it. Rew...
Jump to post- Thu Sep 20, 2018 8:25 pm
- Replies 3
- Views 373
Admin Login Screen Suddenly Not Working
Hi guys,
My admin login screen has suddenly stopped working for no apparent reason. When I enter my username and password and click login, the screen just refreshes. I do not receive any errors. I am using using OC 2.0.3.1, it has been working fine up until today.
Any ideas?
- Thu Sep 20, 2018 7:44 pm
- Replies 3
- Views 373
Setting up multi store with alternate hfreflang tags
Is it possible to set the alternate URLs and hreflang tags when using the multi store feature? I've set up a test second store but as there's no dedicated header.tpl file for it I'm not able to set these tags up.
Jump to post- Mon Feb 19, 2018 2:14 am
- Replies 1
- Views 814
Re: Contact Page reCaptcha not working
Did you get this working?
Jump to post- Thu Feb 15, 2018 8:59 am
- Replies 4
- Views 558
Re: Search not looking up in filters
OK forced to do a work around. Luckily my friend is a bit of a php guru and has made me a script that adds the filter names to the product tags which the standard search includes in it's lookup.
Jump to post- Wed Feb 14, 2018 4:22 am
- Replies 5
- Views 387
Re: Search not looking up in filters
Give us an example, what sort of filters do you mean? By category or brand? Hi Paul, I have created numerous filter groups such as gender, theme, style, chain length etc. Each filter group contains filters for example the 'style' group contains filters such as ravens, unicorns, angel's & demons etc...
Jump to post- Tue Feb 13, 2018 12:15 am
- Replies 5
- Views 387
Re: Search not looking up in filters
Not sure why I would need to include a screenshot and URL for such an enquiry. In OC 2.0.3.1 'filters' are not looked up by the standard search. I'm merely asking if there's a way to enable this. Jump to post
- Mon Feb 12, 2018 4:33 am
- Replies 5
- Views 387
Search not looking up in filters
Is there a way to include filters when a user does a product search?
Jump to post- Mon Feb 12, 2018 2:27 am
- Replies 5
- Views 387
Re: Discussion on "Waiting for Proof of ID" -- Really, in 2018? On the OpenCart marketplace site of all places?
I am having the same problem. This is ridiculous, I need to get some urgent work done!
Jump to post- General Discussion
- Discussion on "Waiting for Proof of ID" -- Really, in 2018? On the OpenCart marketplace site of all places?
- Sun Feb 11, 2018 4:05 am
- Replies 17
- Views 8260
Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x / 3.x
I am having a problem when importing product filters. If a filer name has an & or a " it will not insert the filter for the product even though I am not given an error when importing the Excel file. Now fixed, thank you for posting this issue. Please try the latest V3.19 of the Export/Import tool. ...
Jump to post- Wed Oct 25, 2017 12:00 am
- Replies 1036
- Views 264135
Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x / 3.x
I am having a problem when importing product filters. If a filer name has an & or a " it will not insert the filter for the product even though I am not given an error when importing the Excel file.
Jump to post- Tue Oct 24, 2017 6:01 am
- Replies 1036
- Views 264135
Re: Single page redirects with Apache and .htaccess not working
It just goes to the old (missing) page.
Jump to post- Tue Oct 10, 2017 9:21 pm
- Replies 2
- Views 479
Single page redirects with Apache and .htaccess not working
I don't know anything about Apache so please bear with me. I'm trying to 301 redirect a single old page to a new one with the following line: Redirect 301 /index.php?route=information/information&information_id=6 /delivery-information However; that is not working. I have tested with two simple pages...
Jump to post- Tue Oct 10, 2017 3:40 am
- Replies 2
- Views 479
Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x / 3.x
Hi, There appears to be a slight bug concerning the 'description(en)' field when I download my product catalogue. On some of my items it will repeat what's in the description multiple times underneath each other. Rather annoying as this means I have to check out every item to see if it has been aff...
Jump to post- Sat Oct 07, 2017 12:45 am
- Replies 1036
- Views 264135