"mysql_fetch_array" errors

Nuke Cadet Joined: Mar 03, 2004 Posts: 6

This is a complete nightmare and the host won't help.

The website is www.stoneyslounge.com if anyone can take a look.

The top error is...

Warning:

These type of errors are everywhere. Can anyone please help? It's version 7.6

Posted: Thu Oct 06, 2005 6:54 am

You are supposed to find and replace mysql_ dependent queires to $db->mysql_ class object call. Some of PHP-Nukes with new patches do not allow such mysql dependent queries. In that case change the followings:

global $dbi ---> global $db

mysql_query( ........ , $dbi); ---> $db->sql_query ( ........ );

mysql_fetch_row ( .... , $dbi); ---> $db->sql_fetchrow( .... );

mysql_num_rows ( ....., $dbi); ----> $db->sql_numrows (...... );

mysql_fetch_assoc ( ....., $dbi); ---> $db->sql_getrow( ...... );

Site Admin Joined: Aug 17, 2003 Posts: 12482

That is a generic error, meaning something is wrong when accessing your tables.

You need to figure out exactly where the problem occurs. Start by disabling all addons, modules, blocks, etc. Change themes too. If you can pinpoint the problem, it will give you a direction for a solution