Calendar Events 2.11 with nuke 6.5 and a My_Sql error

Sergeant Joined: May 09, 2003 Posts: 81

Ok with any luck you guys will know, and thank you in advance.

I loaded the module Calendar Events 2.11, and attempted to follow the intructions that came with it, with little or no issues. I log into my admin and click on Calendar I get the following message.

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/www/game-times/includes/sql_layer.php on line 286
Access Denied

Any ideas?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Enable debug mode as described in the Welcome Announcement in the Forum's Directory and find out which table has the problem. You're most likely missing a table or missing columns in a table.

Sergeant Joined: May 09, 2003 Posts: 81

Ok did that and now it comes up with this when you go to the page:

SQL query: select radminCalendarAdmin, radminsuper from nuke_authors where aid='Harlequin'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/www/game-times/includes/sql_layer.php on line 286
Access Denied

ideas?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Copy and paste that query

Code:

select radminCalendarAdmin, radminsuper from nuke_authors where aid='Harlequin'

into phpMyAdmin and see if it works there. My guess is that you haven't modified the nuke_authors table.

Sergeant Joined: May 09, 2003 Posts: 81

Wish I could, phpMyAdmin according to the site only works on 4.1.x, and I'm running 4.2.x so I haven't been able to install it yet.

I have installed the nukecops analyze program will it shed any light?

Sergeant Joined: May 09, 2003 Posts: 81

Is there anything similar to phpMyadmin that runs on 4.2.x?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

phpMyAdmin works on all versions. Just install it.

Sergeant Joined: May 09, 2003 Posts: 81

ok installed phpMyAdmin, and I think I've got it up and running. I went to a query box and put in

select radminCalendarAdmin, radminsuper from nuke_authors where aid='Harlequin'

And phpMyAdmin gave me this response back:

Error

SQL-query :

SELECT radminCalendarAdmin, radminsuper
FROM nuke_authors
WHERE aid = 'Harlequin'
LIMIT 0 , 30

MySQL said:

Unknown column 'radminCalendarAdmin' in 'field list'

So what does this mean, and what do I do?
Thanks for helping out the newbie in advance...

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Raven wrote:

Copy and paste that query

Code:

select radminCalendarAdmin, radminsuper from nuke_authors where aid='Harlequin'

into phpMyAdmin and see if it works there. My guess is that you haven't modified the nuke_authors table.

You are missing a column. Go back and read the installation instructions for the Calendar application. Looks like you missed 1 or more steps.

Sergeant Joined: May 09, 2003 Posts: 81

Thanks for the help, I'm up and running now, the event_calendar.sql didn't populate, I had to go into the phpmyadmin and and drop the script in a query.

Then it worked