paladox2014 Posted October 28, 2014 Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
Tjoene Posted October 28, 2014 Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
paladox2014 Posted October 28, 2014 Author Share Posted October 28, 2014 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/ Quote Link to comment Share on other sites More sharing options...
wolstech Posted October 28, 2014 Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
paladox2014 Posted October 28, 2014 Author Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
Tjoene Posted October 28, 2014 Share Posted October 28, 2014 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+MySQLihttp://www.dummies.com/how-to/content/how-to-convert-mysqli-functions-to-mysql-functions.html Quote Link to comment Share on other sites More sharing options...
wolstech Posted October 28, 2014 Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
paladox2014 Posted October 29, 2014 Author Share Posted October 29, 2014 Hi this is an extension used in MySQL In phpmyadmin it says the extension being used is MySQL but needs upgraded to mysqli. Quote Link to comment Share on other sites More sharing options...
wolstech Posted October 29, 2014 Share Posted October 29, 2014 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. Quote Link to comment Share on other sites More sharing options...
paladox2014 Posted November 3, 2014 Author Share Posted November 3, 2014 Ok. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.