Re: Opencart 2.1.x supports Mysql 8
16) By default MySQL 8 has NO_ZERO_DATE set in sql_mode. You need to set a value for sql_mode that doesn't have NO_ZERO_DATE. thanks for answering, can you share how this can be done ? As i already set this - mysqli.php mentioned this - $this->link->query("SET SQL_MODE = 'NO_ZERO_IN_DATE,NO_EN...
Jump to post- Thu Jan 27, 2022 8:57 pm
- Replies 6
- Views 1582
Re: Opencart 2.1.x supports Mysql 8
May be that i don't have that's why i posted here.
Jump to post
- Thu Jan 27, 2022 8:54 pm
- Replies 6
- Views 1582
Re: Opencart 2.1.x supports Mysql 8
I tried to upgrade to mysql 8, and got these three issues. Anyone can help me in fixing this, if not this still thanks for reading. 3) Usage of utf8mb3 charset Warning: The following objects use the utf8mb3 character set. It is recommended to convert them to use utf8mb4 instead, for improved Unicode...
Jump to post- Thu Jan 27, 2022 2:09 am
- Replies 6
- Views 1582
Opencart 2.1.x supports Mysql 8
Hello All, I want to know Opencart 2.1x supports the Mysql 8 without any issue. Pls. don't confuse with PHP 8, I am running PHP 7.3. My config.php already using a mysqli driver. New servers don't have the option to installed Mysql 5.7, so looking for your expertise if you have tried. Those have upgr...
Jump to post- Sat Jan 22, 2022 1:10 am
- Replies 6
- Views 1582
Push Notification Service
I am looking for a push notification service extension, which is hosted on our server, and not a third-party extension that charge some monthly fees. I searched the marketplace and was not able to find out anything like this, Sorry if I missed something, then let me know. Or If not exist, then anyon...
Jump to post- Tue Jan 11, 2022 3:45 am
- Replies 4
- Views 563
Looking for Share button for Opencart 2.1.0.2
Hello, Lots of share buttons are available in the marketplace, but we need a share button with some applications and other options. Here's the link from another marketplace, this we are looking for a share button - https://www.dropbox.com/s/n0x35gpw69ses96/Screen_Recording_20211128-115340_Chrome.mp4...
Jump to post- Sun Nov 28, 2021 2:32 pm
- Replies 4
- Views 526
Re: Cookie Info when adding product to the cart
there is no problem, using that cookie we can serve the differentiate between in new and repeat visitor and serve the content faster from the cache.
Jump to post- Sat Apr 17, 2021 4:28 am
- Replies 3
- Views 436
Cookie Info when adding product to the cart
Hello, I am using opencart 2.1.0.2. We want to know when we add the product in the cart then info is added in the phpsessionid and no separate cookie is created. Is that possible, when product is added in the cart by the Guest, then one cookie is created either empty or simple value 1, so we can use...
Jump to post- Thu Apr 15, 2021 3:39 am
- Replies 3
- Views 436
Maximum version of Mysql supported by Opencart 2.1.0.2
Hello Everyone, can you share which is the last version of mysql is supported by opencart 2.1.0.2 without breaking anything ?
Mysql5.6 is now deprecated, so will opencart supports 5.7 or 5.8 etc???
- Mon Nov 30, 2020 4:39 am
- Replies 1
- Views 435
Re: Opencart and PHPbb integration
You won't be able to sync existing account passwords, that's for sure. Because most likely OpenCart and PHPbb have different encryption algorithms. But it is possible to add modifications to BOTH OpenCart and PHPbb to create accounts and update passwords in the future. You can't avoid adding a modi...
Jump to post- Thu May 28, 2020 3:23 pm
- Replies 8
- Views 1020
Opencart and PHPbb integration
Hllo, this question is asked several times but no solution posted regarding this, maybe required lot of work in database connectivity. So, we are looking for a developer which have experience in doing this... In detail, We are looking for opencart 2.1.0.2 and phpbb 3.3 forum integration. Opencart ha...
Jump to post- Thu May 28, 2020 1:22 am
- Replies 8
- Views 1020
Re: Custom field in admin order view
Hello, is this the last modification also valid in opencart 2.1.0.2 ?
But we don't see any custom field in Additional tab before this modification.
- Thu May 28, 2020 12:42 am
- Replies 6
- Views 3063
Shipping Report as per Couriers Extension Request
We are looking for an Extension that allows creating a printable report as the shipments shipped on a particular date through a particular courier with all data. Like Shipper name, address, pincode, product name, AWB with barcode to scan, weight (blank column), dimension (blank column). We are using...
Jump to post- Tue May 12, 2020 8:35 pm
- Replies 5
- Views 627
Coupon history recording twice
In opencart 2.1.0.2, I am experiencing when anyone apply a coupon then database table record in the history twice.
There is no issue because of this, but hope this is not a general behavior and let me know how to fix it?
- Fri Apr 24, 2020 5:36 pm
- Replies 0
- Views 358
Mobile Menu Like Opencart
Are you guys aware of any menu system for mobile (vertical), similar to open cart mobile menu for opencart 2.1.0.2?
Only find out one in the marketplace but that's not available for this version.
- Fri Apr 24, 2020 2:40 pm
- Replies 3
- Views 369
Re: Opencart v2.1.0.2 supports the mysql 5.7
No issue but you know the answer, compatible with MySQL 5.7 ?
Jump to post- Wed Apr 08, 2020 1:08 am
- Replies 5
- Views 694
Re: Opencart v2.1.0.2 supports the mysql 5.7
Thanks for response. But you read it wrong.... upgrade to mysql 5.7 and not php 5.7
Jump to post- Wed Apr 08, 2020 1:01 am
- Replies 5
- Views 694
Opencart v2.1.0.2 supports the mysql 5.7
Currently I am using mysql 5.6 using mysqli driver. And want to know If I upgrade to MySQL 5.7, then i have to make any changes, is this opencart version 2.1.0.2 is compatible or break everything? Because opencart 2.1.0.2 launched in Jan 2016 and mysql 5.7 is launched in oct 2015. Will I get any per...
Jump to post- Tue Apr 07, 2020 4:39 am
- Replies 5
- Views 694
Re: Coding visible in the Store Credit mails
You are absolutely right, no need of them stupid mod, but font used on the site changed the symbol design because not available in each font.
That's why we have to use this.
- Sat Jun 24, 2017 2:54 am
- Replies 8
- Views 2653
Re: Coding visible in the Store Credit mails
this is not the solution. We are talking about the editing in the php code, to avoid html in mails.
Jump to post- Sat Jun 24, 2017 2:03 am
- Replies 8
- Views 2653
