Hi, I have the site running 3.02
I upgraded the php version to 7.2 and the error logs are full of this error:
PHP Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /var/sites/f/website/public_html/system/library/db/mysqli.php on line 10
I contacted the host and they said to lower the version number as mysqli is version 7 and above.
The only issue there is that the next available version down is 5.6 and the site does not work if I select that.
I upgraded the php version to 7.2 and the error logs are full of this error:
PHP Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /var/sites/f/website/public_html/system/library/db/mysqli.php on line 10
I contacted the host and they said to lower the version number as mysqli is version 7 and above.
The only issue there is that the next available version down is 5.6 and the site does not work if I select that.
But you have an issue related exactly to mysqli. Looks like it simply isn't enabled on your server.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
From php info page
mysqli.allow_local_infile On
mysqli.allow_persistent On
mysqli.default_host value no mysqli.default_port33063306
mysqli.default_pw no value no mysqli.default_socket/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sockmysqli.default_user no value no
mysqli.max_links Unlimited mysqli.max_persistent Unlimited
mysqli.reconnect On
mysqli.rollback_on_cached_plink Off
mysqlndmysqlnd enabled
Versionmysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $Compressionsupportedcore SSLsupportedextended SSLsupportedCommand buffer size4096
Read buffer size32768
timeout31536000
Collecting statistics Yes
Collecting memory statistics No
Tracingn/aLoaded pluginsmysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_passwordAPI Extensionsmysqli,pdo_mysql
mysqli.allow_local_infile On
mysqli.allow_persistent On
mysqli.default_host value no mysqli.default_port33063306
mysqli.default_pw no value no mysqli.default_socket/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sockmysqli.default_user no value no
mysqli.max_links Unlimited mysqli.max_persistent Unlimited
mysqli.reconnect On
mysqli.rollback_on_cached_plink Off
mysqlndmysqlnd enabled
Versionmysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $Compressionsupportedcore SSLsupportedextended SSLsupportedCommand buffer size4096
Read buffer size32768
timeout31536000
Collecting statistics Yes
Collecting memory statistics No
Tracingn/aLoaded pluginsmysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_passwordAPI Extensionsmysqli,pdo_mysql
Mysqli is enabled.
The host has told me it's an opencart issue and likely wrong config... any ideas?
php
// HTTP
define('HTTP_SERVER', 'https://*****/');
// HTTPS
define('HTTPS_SERVER', 'https://*****/');
// DIR
define('DIR_APPLICATION', '/var/sites/f/*****/public_html/catalog/');
define('DIR_SYSTEM', '/var/sites/f/*****/public_html/system/');
define('DIR_IMAGE','/var/sites/f/*****/public_html/image/');
define('DIR_STORAGE', '/var/sites/f/*****/storage/');
define('DIR_LANGUAGE', DIR_APPLICATION . 'language/');
define('DIR_TEMPLATE', DIR_APPLICATION . 'view/theme/');
define('DIR_CONFIG', DIR_SYSTEM . 'config/');
define('DIR_CACHE', DIR_STORAGE . 'cache/');
define('DIR_DOWNLOAD', DIR_STORAGE . 'download/');
define('DIR_LOGS', DIR_STORAGE . 'logs/');
define('DIR_MODIFICATION', DIR_STORAGE . 'modification/');
define('DIR_SESSION', DIR_STORAGE . 'session/');
define('DIR_UPLOAD', DIR_STORAGE . 'upload/');
// DB
define('DB_DRIVER', 'mysqli');
define('DB_HOSTNAME', '*****');
define('DB_USERNAME', '*****');
define('DB_PASSWORD', '*****');
define('DB_DATABASE', '*****');
define('DB_PORT', '3306');
define('DB_PREFIX', 'oc_');
The host has told me it's an opencart issue and likely wrong config... any ideas?
php
// HTTP
define('HTTP_SERVER', 'https://*****/');
// HTTPS
define('HTTPS_SERVER', 'https://*****/');
// DIR
define('DIR_APPLICATION', '/var/sites/f/*****/public_html/catalog/');
define('DIR_SYSTEM', '/var/sites/f/*****/public_html/system/');
define('DIR_IMAGE','/var/sites/f/*****/public_html/image/');
define('DIR_STORAGE', '/var/sites/f/*****/storage/');
define('DIR_LANGUAGE', DIR_APPLICATION . 'language/');
define('DIR_TEMPLATE', DIR_APPLICATION . 'view/theme/');
define('DIR_CONFIG', DIR_SYSTEM . 'config/');
define('DIR_CACHE', DIR_STORAGE . 'cache/');
define('DIR_DOWNLOAD', DIR_STORAGE . 'download/');
define('DIR_LOGS', DIR_STORAGE . 'logs/');
define('DIR_MODIFICATION', DIR_STORAGE . 'modification/');
define('DIR_SESSION', DIR_STORAGE . 'session/');
define('DIR_UPLOAD', DIR_STORAGE . 'upload/');
// DB
define('DB_DRIVER', 'mysqli');
define('DB_HOSTNAME', '*****');
define('DB_USERNAME', '*****');
define('DB_PASSWORD', '*****');
define('DB_DATABASE', '*****');
define('DB_PORT', '3306');
define('DB_PREFIX', 'oc_');
Either use PHP 5.6 - not recommended as it may not be secure.
Or install mysqli, your host should do that for you or at least tell you how.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
No, it is NOT an OpenCart issue and mysqli is not functioning properly on your server. Contact your hosting support on the matter.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Ok thankyou for replying
I have contacted the host and even though mysqli is enabled they have made a new php.ini file and enabled mysqli there.
This seems to have resolved the issue but I wont know for an hour or so when I check error logs again.
I have contacted the host and even though mysqli is enabled they have made a new php.ini file and enabled mysqli there.
This seems to have resolved the issue but I wont know for an hour or so when I check error logs again.
Surely nothing would work if that wasn't correctly installed, so if it seems to be working, it probably is.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Ok so since the php.ini file was created I'm getting lots of this error repeating:
PHP Warning: mysqli::query(): MySQL server has gone away in /var/sites/f/****.co.uk/public_html/system/library/db/mysqli.php on line 18
PHP Warning: mysqli::query(): Error reading result set's header in /var/sites/f/****.co.uk/public_html/system/library/db/mysqli.php on line 18
PHP Warning: mysqli::query(): MySQL server has gone away in /var/sites/f/****.co.uk/public_html/system/library/db/mysqli.php on line 18
PHP Warning: mysqli::query(): Error reading result set's header in /var/sites/f/****.co.uk/public_html/system/library/db/mysqli.php on line 18
This sounds like your server connection is timing out
It is still a hosting issue ...
(it could possibly be that your site is being backed-up, but that should have cleared already)
It is still a hosting issue ...
(it could possibly be that your site is being backed-up, but that should have cleared already)
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Usually means your host doesn't have enough resources for your site.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Who is online
Users browsing this forum: No registered users and 308 guests