Cannot activate included Gcalendar

Hangin' Around Joined: Feb 08, 2010 Posts: 27

Hey guys! I'm trying to activate the Gcalendar that came with my Raven Nuke 2.4.0 package. For some reason, I can use all of the functions from my admin login, but I cannot get it to show up for my user login. Any ideas?

Posted: Mon Feb 15, 2010 2:09 pm

OK sorry to point out the obvious, but have to check. Is it set to Visible by all users?

Posted: Mon Feb 15, 2010 3:38 pm

No worries. I understand the need to ask the obvious first.

Yes, I set the calendar to be viewable to all visitors. I created the block for the "thumbnail" calendar, and it now shows up even when I'm logged out. If I click on the month title, then it shows me the 30 day view in HOME. I thought I had this all figured out, then when I tried to change from Feb 2010 to Mar 2010, I got a "database problem, no config table" message. Bang Head

Posted: Sun Apr 11, 2010 8:09 pm

It's been a while and still no resolution on this. /bump.

Posted: Sun Apr 11, 2010 9:24 pm

Sorry we must have missed this.. I can confirm there is an issue, which I have submitted to our bug tracker.. We'll get back to you when we make some headway Wink

Posted: Mon Apr 12, 2010 6:54 am

Thank you, sir!

Posted: Mon Apr 12, 2010 2:58 pm

This error is triggered by /modules/GCalendar/common.inc.php when the Gcalendar configuration table is not present. The table name should be nuke_gcal_config assuming that you go with the standard prefix. The table is created in the upgrade script in the INSTALLATION folder.

Here's the SQL copied from the script:

Code:

      $sql = "CREATE TABLE IF NOT EXISTS `".$prefix."_gcal_config` (`id` int(11) NOT NULL auto_increment,`title` varchar(128) NOT NULL default 'Calendar of Events',`image` varchar(255) NOT NULL default '',`min_year` int(10) unsigned NOT NULL default '2006',`max_year` int(10) unsigned NOT NULL default '2037',`user_submit` enum('off','members','anyone','groups') NOT NULL default 'off',`req_approval` tinyint(1) NOT NULL default '1',`allowed_tags` text NOT NULL,`allowed_attrs` text NOT NULL,`version` varchar(16) NOT NULL default '',`time_in_24` tinyint(1) NOT NULL default '0',`short_date_format` varchar(16) NOT NULL default '',`reg_date_format` varchar(16) NOT NULL default '',`long_date_format` varchar(16) NOT NULL default '', `first_day_of_week` tinyint(1) NOT NULL default '0',`auto_link` tinyint(1) NOT NULL default '0',`location_required` tinyint(1) NOT NULL default '0',`details_required` tinyint(1) NOT NULL default '0',`email_notify` tinyint(1) NOT NULL default '0',`email_to` varchar(255) NOT NULL default '',`email_subject` varchar(255) NOT NULL default '',`email_msg` varchar(255) NOT NULL default '',`email_from` varchar(255) NOT NULL default '',`show_cat_legend` tinyint(1) NOT NULL default '1',`wysiwyg` tinyint(1) NOT NULL default '0',`user_update` tinyint(1) NOT NULL default '0',`weekends` SET( '0', '1', '2', '3', '4', '5', '6' ) NOT NULL DEFAULT '0,6',`rsvp` ENUM( 'off', 'on', 'email' ) NOT NULL DEFAULT 'off',`rsvp_email_subject` VARCHAR( 255 ) NOT NULL DEFAULT 'Event RSVP Notification', `groups_submit` TEXT NOT NULL , `groups_no_approval` TEXT NOT NULL, PRIMARY KEY  (`id`)) TYPE=MyISAM";

I would check for this table through PHPmyadmin to avoid overwriting anything that may already exist. It appears the table may be missing from the Ravennuke.com site also.

Let us know if this resolves your problem.

Posted: Mon Apr 12, 2010 5:04 pm

fkelly, the table is present. The problem is that the config table is defined by a constant and that constant is not being defined. I updated the mantis issue with additional information.

mordbuster, the problem only seems to happen when a user without permission to view the gCalendar module tries to view it. I have narrowed down the problem and assigned it to the appropriate person.