nucalendar

nefar · Regular Joined: Sep 20, 2004 Posts: 79

Hi,
I'm running 7.5 and just installed nucalendar. I don't believe it's meant to run on 7.5 however it looks like it's functions are fine I just have one problem.
When I try and goto it's admin section via admin in nuke im getting.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/home/dread00/public_html/includes/sql_layer.php on line 286
Access Denied

i've been able to add events in etc with no problems so thought it may have something to do with how admin section is differant in 7.5.

Anyone have any ideas?
Thanks.

chatserv · Posted: Mon Sep 20, 2004 7:03 pm

Its admin files need to be converted but you can still use them as they are by modifying the starting lines that verify the admin's access, most likely right now they look for a field in the author's db table with something similar to:

Code:

$row = $db->sql_fetchrow($db->sql_query("SELECT radmincalendar, radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if (($row['radmincalendar'] == 1) OR ($row['radminsuper'] == 1)) {

you would need to remove the calendar reference like so:

Code:

$row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if ($row['radminsuper'] == 1) {

nefar · Regular Joined: Sep 20, 2004 Posts: 79

Thanks i'll give that a try

nefar · Regular Joined: Sep 20, 2004 Posts: 79

Going to take a guess here and say these are the lines I should be looking for.
I took out radminlink but I wasnt sure how to do the if (($radminlink==1) or line. When I remove the if (($radminlink--1) I get unexpected end errors, or I will get parse errors when I try to fix that.

if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }

$result = sql_query("select radminlink, radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminlink, $radminsuper) = sql_fetch_row($result, $dbi);
if (($radminlink==1) OR ($radminsuper==1)) {

require_once("modules/NuCalendar/dbaccess.inc.php");
require_once("modules/NuCalendar/datefuncs.php");
require_once("modules/NuCalendar/printevent.php");
get_lang("NuCalendar");

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

Quote:

if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }
$row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if ($row['radminsuper'] == 1) {
require_once("modules/NuCalendar/dbaccess.inc.php");
require_once("modules/NuCalendar/datefuncs.php");
require_once("modules/NuCalendar/printevent.php");
get_lang("NuCalendar");

nefar · Regular Joined: Sep 20, 2004 Posts: 79

Thanks, she seems to be working now.

bc_ · New Member Joined: Sep 30, 2004 Posts: 1

I have the same problem, but with the Event Calendar. Any ideas, how to fix that?

ehutton · New Member Joined: Oct 05, 2004 Posts: 1

bc_ wrote:

I have the same problem, but with the Event Calendar. Any ideas, how to fix that?

I found this link on phpnuke.org thought it might help

Only registered users can see links on this board!
Get registered or login to the forums!

chitoka · New Member Joined: Oct 26, 2004 Posts: 1

The above link is dead. I would like to install Event Calendar 2.13 on PHP-Nuke 7.5, but don't know how to update the admin.php and authors.php files. Anyone who knows where else I can find a walkthrough?

Noxious · New Member Joined: Feb 06, 2005 Posts: 2

hey wonder if anyone can help me, i've recently updated to PHPNuke 7.5 and the calendar works fine except when i go into the admin menu

i've tried doing whats been said but its not worked so far

when i click on NuCalendar i just get a white screen and nofin appears anyone know whats going on and how to fix it??

Thanks in advance
Noxious

Noxious · New Member Joined: Feb 06, 2005 Posts: 2

ah doesn't matter its fixed now

chi · New Member Joined: Feb 14, 2005 Posts: 1

I'm not sure if I am in the right place or not, but I am not a programmmer. By some miracle I was able to install some php stuff and that has gotten me interested in the forum. Currently I have some php Nukes set up as part of my hosting plan. I wanted to install NuCalendar, and I did do it correctly the first time.
The next time I tried to install it on the other six Nukes, i got a bunch of error messages about the includes/sql-layer. i gave up and trashed the Nukes since they were not used yet. I like the open source idea, but it seems to be hard to get things running. So bottom line: I'm willing to pay kind of installation fee if I can get someone to put the NuCalendar on my php Nukes. I also want to know if there are more problems with installing too many Nukes/Calendars in one directory (one site)?

onishi · New Member Joined: Feb 15, 2005 Posts: 1

I have tried doing what was said as well. Before it just says access denied. But after I have done the alterations, all i get now is a blank page. Please help.

makphisto · New Member Joined: Feb 25, 2005 Posts: 3

I'm having similar issues. Using the fixes here, I get the calendar block AND I get the main calendar module page. However, the main module page gives me this error:

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fathill/public_html/includes/sql_layer.php on line 342

Is there no calendar native to 7.* yet?

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

I have nucalendar working just fine on my nuke 7.5 site so I'm not sure why you are having these issues.

makphisto · New Member Joined: Feb 25, 2005 Posts: 3

And your above code was all you changed? Maybe I'll start over from the top. Thanks.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

I did not need to edit the files at all - perhaps you have an older version?

makphisto · New Member Joined: Feb 25, 2005 Posts: 3

Perhaps, the only version I can find is:
Version: .61 Filesize: 40 bytes
Added on: 23-Nov-2003

Know where I can get the most recent?

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

Looks like I'm running the same version as you;
Module's Name: NuCalendar
Module's Version: 0.61
Release Date: May 25th 2003
Module's Cost: Free
License: GNU/GPL
Author's Name: Bill Smith
Author's Email: xxxx
Module's Description: An event calendar for PHP-Nuke version 6 and 6.5
Author's HomePage:

Only registered users can see links on this board!
Get registered or login to the forums!

elephants1 · New Member Joined: May 07, 2005 Posts: 2

I am having this issue also.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/home/dread00/public_html/includes/sql_layer.php on line 286
Access Denied

Which admin.php file or which other file needs to be changed. I am new to this whop php stuff.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

Edit the admin.php file in NuCalendar folder (inside 'modules')

elephants1 · New Member Joined: May 07, 2005 Posts: 2

I edited the admin.php file to look like the one you posted on this forum earlier and now everything works great. Thanks for the support.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

Glad to help

sabastina · Hangin' Around Joined: May 12, 2005 Posts: 36

I've fixed this and win zipped it...does anyone know where I could put it for download for those who want a patched" version for 7+ ???
Also, do I need to alter the version or anything?
I will hold off on doing anything with it until I know what is allowed.

Thanks for reading!

Sabastina

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

No you don't need to alter the version number, this would normally be done by the script writer but you could edit the readme to explain the fix that was made and which version of nuke you have used/tested it on for anyone else who might want to use it.
Upload the zipped file to your website and then all you have to do is submit it to which ever nuke site you would like to have the link to it.