Mysql In Stevie Brings Up Deprecated Error.

[paladox2014]

Hi I am getting this error when visting routines in MySQL on stevie

 

You are using PHP's deprecated 'mysql' extension, which is not capable of handling multi queries. <b>The execution of some stored routines may fail!</b> Please use the improved 'mysqli' extension to avoid any problems.

 

please remove mysql and install mysqli

 

Please install new extension.

[Tjoene]

I haven't checked, but the MySQLi extension should be installed.

You will have to change your php code from mysql_* to mysqli_* functions to use that extension, and not the depricated one.

[paladox2014]

Hi the administrator has to do it because it is installed for everyone.

 

It is an extension for php for MySQL and MySQL extension is deprecated and mysqli is the new extension to use.

 

http://php.net/manual/en/mysqli.installation.php

 

http://stackoverflow.com/questions/7250356/how-to-install-mysqli

 

https://www.udemy.com/blog/mysql-vs-mysqli/

[wolstech]

Both extensions are already installed. It's up to you to develop or deploy code that uses the new one (tjoene explained what you need to do).

 

We cannot and will not remove the old extension because many users run legacy applications that depend upon it.

[paladox2014]

Ok but could you make MySQLi default because a user cannot choose to use the new extension it is up to the person who own the server and with admin.

 

If we can use how can I change to use that.

[Tjoene]

It is up to the coder to use the MySQLi functions.

You use google on how to migrate to the newer extension:

 

https://wikis.oracle.com/display/mysql/Converting+to+MySQLi

http://www.dummies.com/how-to/content/how-to-convert-mysqli-functions-to-mysql-functions.html

[wolstech]

There is no default. Php uses whatever your software is coded to use. If your software is coded with the old MySQL functions in it, that's what it will use regardless of what we have available, and if what it wants is not available, the program dies with undefined function errors instead.

 

TL;DR: Your program must be rewritten if you want to use the newer library.

[paladox2014]

Hi this is an extension used in MySQL In phpmyadmin it says the extension being used is MySQL but needs upgraded to mysqli.

[wolstech]

That's because phpmyadmin (or the version we have anyway) is running on the old library. All that message is saying is that phpmyadmin itself is using the legacy library and isn't happy about it. It does not mean that mysqli is not available.

 

The message can be safely ignored since we still run an older php version where the legacy MySQL library is not deprecated. If we had php 5.5, it would be accurate.

[paladox2014]

Ok.