PDA

View Full Version : Using the MySQLi Extension

Shamil.
09-27-2008, 11:09 PM
Hi, I'm trying to improve one of my forums, and I am wanting to use the MySQLi extension as opposed to the common/normal mysql extension, however when setting this, I recieve these errors:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 171

Warning: implode() [function.implode (http://www.theflickzone.com/function.implode)]: Argument must be an array in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 172

What should I do?
Amenadiel
09-28-2008, 12:41 AM
uh... what mysql version are you running?
nexialys
09-28-2008, 01:27 AM
That just mean that your MySQL is not set to use that extension... this is not related to vBulletin, but your host...
JamesAB
09-28-2008, 01:53 AM
Perhaps your version of PHP wasn't compiled with mySQLi support?

Check your phpinfo to see if mySQLi is listed there.

If not, you will need to recompile PHP and add --with-mysqli=/path/to/mysql_config to your configure command. Just specify the correct path to where mysql_config is on your system.
Dismounted
09-28-2008, 04:32 AM
It looks like MySQLi is compiled with PHP and it is working correctly (otherwise, you would get connection errors). The issue here is that a modification author has decided to use the raw PHP functions, not the vBulletin wrapper database class (and has chosen to use the MySQL (not i functions). Therefore it does not work correctly.
Amenadiel
09-28-2008, 02:43 PM
Hmm yes it makes perfect sense that he has a tampered functions_forumlist.php, because I can't find any implode() in mine.