MySQL problems : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL

Portal Home > Knowledgebase > Articles Database > MySQL problems : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL

Posted by CrownS, 05-26-2008, 12:02 PM
Suddenly some of my users have the same problem... all using different scripts and different domains... Can someone help me with this??? Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Posted by RBBOT, 05-26-2008, 12:40 PM
It probably means you are running out of connections, but the code isn't checking for connection failures at the time it calls mysql_connect, so the problem isn't discovered until the code later tries to run a query on connection that failed to open.
Posted by gnusys, 05-26-2008, 01:21 PM
Any MySQL version changes of recent?
Posted by CrownS, 05-26-2008, 02:10 PM
If it is running out of connections, should it not be solved my a restart of mysql? cause that did nothing... No changes in MySQL... it just.. "happened" very strange issue. Also, MySQL is slow as h*ll... also ssh is very slow... But this has somehow always been the case for this server...
Posted by CrownS, 05-26-2008, 04:32 PM
Anyone??
Posted by david510, 05-26-2008, 04:36 PM
You may try this. Search for the word mysql_fetch_array in the php script and modify it, so that it looks like below. Make sure you take backup of the file before editing. @mysql_fetch_array

Add to Favourites Print this Article