Deprecated: mysql_connect() error in Opencart 1.5.6.1

In my new xampp 1.8.3 installation, I installed Opencart 1.5.6.1 and received a deprecated warning message such as:
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in ....\system\database\mysql.php on line 6

The quick way to resolve this issue is by making a small change to the config.php and admin/config.php files. In both these config.php files, look for the line
define('DB_DRIVER', 'mysql');

Modify the above line to
define('DB_DRIVER', 'mysqli');

The new line will simply connect to the database from system/database/mysqli.php file.

Comments

  1. AnonymousJune 2, 2014 at 7:43 PM

    but file config.php and admin/config.php empty, i cannot replace define('DB_DRIVER', 'mysql'); show me how to fix

    ReplyDelete
    Replies
    1. RWTJune 20, 2014 at 8:14 PM

      If you have installed Opencart, I believe these files especially admin/config.php should not be empty. It puts all your database credentials there. Did you create database in your host control panel prior to installing Opencart. Maybe you can also try doing a site-wide search for "define('DB_DRIVER', 'mysql')" to see where exactly it has placed it.

      Delete
  2. AnonymousOctober 12, 2014 at 6:41 PM

    thanks for your help

    ReplyDelete
  3. AnonymousMarch 27, 2015 at 8:46 AM

    thanks for your help

    ReplyDelete
  4. AnonymousMarch 31, 2015 at 3:20 PM

    thanks my friend.

    ReplyDelete
  5. UnknownJuly 13, 2015 at 12:43 PM

    Thanks!!

    ReplyDelete
  6. AnonymousOctober 13, 2015 at 6:03 AM

    It fixed the issue. Thanks.

    ReplyDelete
  7. AnonymousApril 7, 2016 at 1:12 PM

    Hi there,
    I know this is an old thread, but I now have the above issue with my site.
    The problem I'm having is, my config file directory is empty, and I don't appear to have an admin/config file at all. I'm a bit of a novice so not 100% sure where to start looking, or how to resolve the issue :(

    ReplyDelete
  8. AnonymousJune 16, 2016 at 6:23 PM

    Still getting the issue at the top of my page, and I can't login to the admin panel to put the site into maintenance mode because of it.

    I changed the config.php file for both public and admin to use mysqli as the DB driver, wat do?

    ReplyDelete

Post a Comment

Popular posts from this blog

How to resolve 'res://ieframe.dll/acr_error.htm#' error (Internet Explorer stopped working while viewing a website)

While testing a website I was developing, I got an error message saying "Internet Explorer has stopped working". This is followed by this line added before the URL: res://ieframe.dll/acr_error.htm# . I was using Internet Explorer 11 in Windows 7 64-bit machine. I tried disabling all add-ons in IE but that did not resolve the issue. I've found this solution to my problem: From Tools menu, open "Internet options". Go to the Advanced tab. Under "Accelerated graphics", tick the box that says "Use software rendering instead of GPU rendering". Click Apply and Ok. Test your website. You might need to restart your computer if it does not immediately show any effect. This worked for me.
Read more

htaccess: Redirecting multiple domains to the main domain

Let's say this is the main domain: mywebsite.com.au And you'd like to redirect several other domains that you have purchased to this main domain.The steps shown below redirects all www, non-www, http and https variations and also matches the internal pages. Step 1: Go to your DNS provider's website and point each of those purchased domains to the server that is hosting your main domain. In other words, add the IP address of your hosting server in the A record. Step 2: Log in to your WHM. Then park each domain on top of the main domain. You may be able to do this in cPanel > Aliases but I haven't tried. Step 3: If you have AutoSSL enabled, all the additional parked domains will automatically get SSL added. This may take some time. Alternatively, you can go to WHM > Manage AutoSSL and Run AutoSSL Check. Step 4: Add your parked domains to your .htaccess file as shown below. Note the "$" at the end of this line: ^www\.mywebsite\.com$ . This
Read more

MailChimp API V2.0 SSL error solution

I got this SSL error while trying to use MailChimp API V2.0 in my localhost. Fatal error: Uncaught exception 'Mailchimp_HttpError' with message 'API call to lists/list failed: SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed' in C:\Installation\xampp\htdocs\mailchimp-test\Mailchimp.php:192 Stack trace: #0 C:\Installation\xampp\htdocs\mailchimp-test\mailchimp-api.php(16): Mailchimp->call('lists/list', Array) #1 {main} thrown in C:\Installation\xampp\htdocs\mailchimp-test\Mailchimp.php on line 192 To resolve this, you can try any of the methods below. Method 1: Download cacert.pem file from here: http://curl.haxx.se/docs/caextract.html Save the file in your PHP installation folder. I am using xampp. So I saved it in C:\Installation\xampp\php\cacert.pem Open your php.ini file and add this line: curl.cainfo="C:\Installation\xampp\php\cacert.pem&quo
Read more