Search found 19 matches

Page 1 of 1

Search found 19 matches

Re: Warning: mysqli::set_charset

Thank you letxobnav, it works very good. I used the PHP 7 version in the website. The problem happened again even with disabling SEO URL and category count and before usingt seo cache, I will see tomorrow what will happen. It seems I should move to another host. I asked byet.host about max_questions...

Jump to post
  • Wed Apr 08, 2020 2:05 am
  • Replies 24
  • Views 969
Re: Warning: mysqli::set_charset

There is no seo url cache add on I am aware of, I wrote it myself just to see if it would speed up the site, not so much. It does however reduce the amount of queries alot. ... ..... instead of executing a query for every seo query/keyword it fetches the seo keyword from the SEO_PAIRS constant in m...

Jump to post
  • Tue Apr 07, 2020 3:27 am
  • Replies 24
  • Views 969
Re: Warning: mysqli::set_charset

I would start by counting all the queries your site is performing per page or per hour. Then look at which particular queries are executed the most (seo url will probably be in there). If you want to stay with a limited hosting plan, reduce your query count by eliminating extensions or start cachin...

Jump to post
  • Mon Apr 06, 2020 7:34 pm
  • Replies 24
  • Views 969
Re: Warning: mysqli::set_charset

See this solution: https://stackoverflow.com/questions/33046494/how-to-solve-exceeded-the-max-questions-resource-in-mysql-which-is-in-shared-h . If that does not solve it, contact your host. Thank you for you support. Shared web hosting doesn't allow that. I tried to contact the host support via ch...

Jump to post
  • Sun Apr 05, 2020 7:18 pm
  • Replies 24
  • Views 969
Re: 3.0.3.x Issues and Bugs

straightlight wrote:
Fri Apr 03, 2020 7:08 pm
moshair wrote:
Fri Apr 03, 2020 5:39 pm
Thank you.
Note: You forget to mention adding

'shipping_custom_fields' => $shipping_custom_fields,
'payment_custom_fields' => $payment_custom_fields,
I have now also added the account_custom_fields in the $data['orders'] array in the mean time.
👍 Thank you.

Jump to post
  • Sat Apr 04, 2020 5:38 pm
  • Replies 99
  • Views 73561
Re: Warning: mysqli::set_charset

Not user.ini but .user.ini (dot at the beginning). If you cannot see php.ini or .user.ini file, then this is an issue already. Opencart already delivers this file out-of-the-box from the original installation (php.ini). Simply re-upload this file from the original ZIP file downloaded from opencart....

Jump to post
  • Fri Apr 03, 2020 5:45 pm
  • Replies 24
  • Views 969
Re: 3.0.3.x Issues and Bugs

Take note that adding custom fields into the invoice may result dealing with split invoice template between pages. Only use the following if considering to use split pages if you cannot configure your printer driver to a fit landscape. In admin/controller/sale/order.php file, in the invoice() metho...

Jump to post
  • Fri Apr 03, 2020 5:39 pm
  • Replies 99
  • Views 73561
Re: Warning: mysqli::set_charset

Not user.ini but .user.ini (dot at the beginning). If you cannot see php.ini or .user.ini file, then this is an issue already. Opencart already delivers this file out-of-the-box from the original installation (php.ini). Simply re-upload this file from the original ZIP file downloaded from opencart....

Jump to post
  • Fri Apr 03, 2020 7:21 am
  • Replies 24
  • Views 969
Re: 3.0.3.x Issues and Bugs

I noticed that the added custom fields doesn't exists on the order (invoice) print page. So I should write them on that printed page. It is important to include the custom fields I added like Building Number, Street, and Apartment No.) because I also give that printed invoice the delivery man. OC v...

Jump to post
  • Fri Apr 03, 2020 6:05 am
  • Replies 99
  • Views 73561
Re: Warning: mysqli::set_charset

Replace the code to its original code. In php.ini file of your root opencart folder (and perhaps in the admin/php.ini file if it does exist), ensure that no semi-colon are showing at the end of each lines. I replaced the code to its original, I didn't find any php.ini files. Since you cannot find p...

Jump to post
  • Fri Apr 03, 2020 6:03 am
  • Replies 24
  • Views 969
Re: 3.0.3.x Issues and Bugs

I noticed that the added custom fields doesn't exists on the order (invoice) print page. So I should write them on that printed page.
It is important to include the custom fields I added like Building Number, Street, and Apartment No.) because I also give that printed invoice the delivery man.

Jump to post
  • Fri Apr 03, 2020 5:58 am
  • Replies 99
  • Views 73561
Re: Warning: mysqli::set_charset

straightlight wrote:
Fri Apr 03, 2020 5:19 am
Replace the code to its original code. In php.ini file of your root opencart folder (and perhaps in the admin/php.ini file if it does exist), ensure that no semi-colon are showing at the end of each lines.
I replaced the code to its original, I didn't find any php.ini files.

Jump to post
  • Fri Apr 03, 2020 5:45 am
  • Replies 24
  • Views 969
Re: Warning: mysqli::set_charset

There was a recent post about it but can't seem to find it now. In system/library/db/mysqli.php file, find: $this->connection->set_charset("utf8"); replace with: $this->connection->set_charset(""); See if that solves the issue. Thank you, I made that replace, I have two languages installed in the c...

Jump to post
  • Fri Apr 03, 2020 5:14 am
  • Replies 24
  • Views 969
Re: Warning: mysqli::set_charset

Which mySQLi version are you using? If v8 or above, you need to remove the charset validation's parameter manually from the system/library/db/mysqli.php file. Thank you for your reply, I found these information in the hosting panel: Platform Type Debian MySQL Version 5.6.32 Perl Version 5.8.8 PHP V...

Jump to post
  • Fri Apr 03, 2020 4:53 am
  • Replies 24
  • Views 969
Warning: mysqli::set_charset

Hello, I have a website on ipage uses Open Cart 3, sometimes I see only a blank page with this text: Warning: mysqli::set_charset(): Error executing query in /***/shop/system/library/db/mysqli.php on line 13 The shop returns to work again after few minutes without doing anything, I contacted the sup...

Jump to post
  • Wed Apr 01, 2020 12:45 am
  • Replies 24
  • Views 969
Re: Google Sitemap

New cached images are only created if they do not yet exist or if the original is newer. So yes, if your entire image cache is empty or you define unique dimensions for your sitemap images and you start the sitemap script it will create those images and you might run out of script time and get a 50...

Jump to post
  • Mon Aug 12, 2019 11:08 pm
  • Replies 7
  • Views 819
Re: Google Sitemap

thekrotek wrote:
Mon Aug 12, 2019 3:07 pm
Default Sitemap extension is completely stupid, indeed. I can recommend you my Smart Sitemap extension instead. It was successfully tested on site with 100K+ products with images. Should work fine on any number of products.
Thank you.

Jump to post
  • Mon Aug 12, 2019 11:06 pm
  • Replies 7
  • Views 819
Re: Google Sitemap

Thanks for reply, but that didn't help. What if you have more than 10000 product and you run the sitemap for the first time even a vps server can't produce the new images there is max execution time. The module is in the script why searching for another module instead of facing the problems that mig...

Jump to post
  • Mon Aug 12, 2019 7:24 am
  • Replies 7
  • Views 819
Google Sitemap

Hello, I think the integrated Google Sitemap module in OC3 should be improved. I tried it on an open-cart store with more than a 1100 product I got: 'Internal Server Error '. The most reason for that is exceeding the server memory or cpu. I tried it on the local server first I got memory insufficien...

Jump to post
  • Mon Aug 12, 2019 5:39 am
  • Replies 7
  • Views 819

Page 1 of 1

Search found 19 matches