Nucalendar administration access issue

New Member Joined: Nov 24, 2005 Posts: 3

I am running Nuke version 7.5. I have installed NuCalendar with no problems and have dumped the squl file into my database to create the tables. I have followed all directions and the calendar shows up fine, submissions of events go well but when I click on the icon in my administration menue, this is what I get:

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/u2/pmilton/fssfbdclan.com/html/includes/sql_layer.php on line 286


Access Denied

According to line 286 of the sql_layer.php file, this is what I have:

Code:

$row = mysql_fetch_row($res);

I am not sure what is wrong. I have been through the readme file and there is nothing that suggests altering any lines in this file. Any help wold be greatly appreciated.

By the way, I also tried the version from the nuke korea site and I am still getting the same error.

Sells PC To Pay For Divorce Joined: Posts: 5661

Does it show more when you turn display error ON
In your config..
(set $display_errors = 0; in your config to 1)

Posted: Fri Nov 25, 2005 9:14 am

that line does not exist in my config file. where would i place it?

Posted: Fri Nov 25, 2005 9:21 am

eh oops..7.5

Eh...ok a litle bit of editing...
The following is a copy of phpnuke Howto explaining this error :

This is a very general error.
Most of the time it just means that you could not connect to the database (for whatever reason) and thus the result set you tried to fetch was not a "valid MySQL result resource".
You should try first to get a more descriptive error message.
For this purpose, you must edit the "case" lines in the sql_layer.php file.

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

Edit it like this:

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

Posted: Fri Nov 25, 2005 9:48 am

there was actually a line of code in the admin/moduals/nucalendar.php file that wasn't correct. I have since fixed it and now my nucalendar administration works. Thank you for your help.

Posted: Fri Nov 25, 2005 12:09 pm

ok

New Member Joined: Dec 27, 2005 Posts: 4

I'm hitting the same issue with a fresh install of phpNuke 7.9 and NuCalendar. I'm no code guru, would you mind posting what changes you made to fix it?