Getting Errors? Read This

Posted: Mon Feb 10, 2003 10:10 am

While most of this is covered in the welcome thread i decided to place them here to see if it helps users having these problems.
--------------------------------------------------------------------------------------
sql_layer.php errors

PHP-Nuke 5.6 and lower:

If getting errors that mention line 286 of sql_layer.php, open sql_layer.php and change lines 285-288 from:

Code:

case "MySQL":
$row = mysql_fetch_row($res);
return $row;
break;;

to:

Code:

case "MySQL":
if ($row = mysql_fetch_row($res)) {
return $row;
} else {
print (mysql_error());
}
break;;

PHP-Nuke 6.0 and up

If getting errors that mention line 301 of sql_layer.php open sql_layer.php and change lines 300-303 from:

Code:

case "MySQL":
$row = mysql_fetch_row($res);
return $row;
break;;

to:

Code:

case "MySQL":
if ($row = mysql_fetch_row($res)) {
return $row;
} else {
print (mysql_error());
}
break;;

Upload the modified sql_layer.php file and go back to your site, this modification will not fix the errors but will usually make the error more detailed, as an example the error may now contain another line that says:
table nuke_main does not exist.

This will help solve your problems as you now know what is causing it.
--------------------------------------------------------------------------------------
Users get a _ERROR message when they click finish on new registrations:

PHP-Nuke 5.6 and earlier:

Open modules/Your_Account/index.php and change line 154 from:

Code:

echo ""._ERROR."<br>";

to:

Code:

print (mysql_error());
echo ""._ERROR."<br>";

PHP-Nuke 6.0 and up:

Open modules/Your_Account/index.php and change line 114 from:

Code:

echo ""._ERROR."<br>";

to:

Code:

print (mysql_error());
echo ""._ERROR."<br>";

This will not fix the error but it will tell you what is wrong, usually a mismatch between the users table and the FinishNewUser function. Most of the time people that get this last error are those that have installed the phpBB port and they get it because they fail to upload all files that come with the port.

Posted: Fri Oct 24, 2003 10:25 pm

bumped from unanswered