Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
steve_lemaster
Worker
Worker



Joined: Dec 26, 2006
Posts: 178

PostPosted: Fri Jun 20, 2008 6:30 pm Reply with quote

You're probably wondering how I installed RN, set it up and maintain it, when I don't have the slightest idea how to fix these intricate issues.

Installing it and setting it up is easy, you need to know php code and MySQL to fix these errors, which I don't.

That's why I have no clue about these things.

_________________
The urge to save humanity is often a false front for the urge to rule.

- H.L. Mencken 
View user's profile Send private message Send e-mail
dad7732
RavenNuke(tm) Development Team



Joined: Mar 18, 2007
Posts: 1242

PostPosted: Fri Jun 20, 2008 8:43 pm Reply with quote

Open up your config.php file in the root directory of where your Nuke is located on your server and look for these lines, your info will differ:

Code:
$dbhost = 'localhost';

$dbuname = 'root';  <------ DB Username - default is usually 'root'
$dbpass = 'password';  <------ your MySQL password
$dbname = 'database_name'; <------ your DB name
$prefix = 'nuke';  <------ default prefix
$user_prefix = 'nuke';


The $dbuname and the $dbpass should be the same in phpMyAdmin.

If you're still confused then one of the moderators/admins here will volunteer to carry this further via PM maybe as you may need to divulge your private info, not here of course. They helped me out the same way quite a bit and very successfully I might add.

Cheers
 
View user's profile Send private message
steve_lemaster







PostPosted: Fri Jun 20, 2008 8:53 pm Reply with quote

[quote]If you're still confused[\quote]

I am.
 
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Sat Jun 21, 2008 6:42 am Reply with quote

steve_lemaster wrote:
Now I get the same thing when I started.

Probably best to leave it alone. I most likely wouldn't use it anyway.;


Steve, you didn't change the prefix like I told you to do. If your prefix is "nuke", use the following SQL just as you tried above:

Code:


DROP TABLE IF EXISTS `nuke_gcal_category`;
CREATE TABLE `nuke_gcal_category` (`id` int(11) NOT NULL auto_increment,`name` varchar(128) NOT NULL default '',PRIMARY KEY  (`id`));
INSERT INTO `nuke_gcal_category` VALUES (1, 'Unfiled');
INSERT INTO `nuke_gcal_category` VALUES (2, 'Show');
INSERT INTO `nuke_gcal_category` VALUES (3, 'Birthday');
INSERT INTO `nuke_gcal_category` VALUES (4, 'Release Date');
INSERT INTO `nuke_gcal_category` VALUES (5, 'Anniversary');
INSERT INTO `nuke_gcal_category` VALUES (6, 'Site Event');

DROP TABLE IF EXISTS `nuke_gcal_config`;
CREATE TABLE `nuke_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`));
INSERT INTO `nuke_gcal_config` VALUES (1, 'Calendar of Events', 'images/admin/gcalendar.gif', 2006, 2037,'members', 1, 'a,b,i,img','href,src,border,alt,title', '1.7.0', 0, '%m/%d', '%B %d, %Y', '%A, %B %d, %Y', 0, 1, 0,0, 0, 'admin@yoursite.com', 'New GCalendar Event', 'A new GCalendar event was submitted.', 'admin@yoursite.com', 1, 1, 1, '0,6', 'off', 'Event RSVP Notification', '', '' );

DROP TABLE IF EXISTS `nuke_gcal_event`;
CREATE TABLE `nuke_gcal_event` (`id` int(11) NOT NULL auto_increment,`title` varchar(255) NOT NULL default '',`no_time` tinyint(1) NOT NULL default '1',`start_time` time NOT NULL default '00:00:00',`end_time` time NOT NULL default '00:00:00',`location` text NOT NULL,`category` int(11) NOT NULL default '0',`repeat_type` enum('none','daily','weekly','monthly','yearly') NOT NULL default 'none',`details` text NOT NULL,`interval_val` int(11) NOT NULL default '0',`no_end_date` tinyint(1) NOT NULL default '1',`start_date` date NOT NULL default '0000-00-00',`end_date` date NOT NULL default '0000-00-00',`weekly_days` set('0','1','2','3','4','5','6') NOT NULL default '',`monthly_by_day` tinyint(1) NOT NULL default '0',`submitted_by` varchar(25) NOT NULL default '',`approved` tinyint(1) NOT NULL default '0',`rsvp` ENUM( 'off', 'on', 'email' ) NOT NULL DEFAULT 'off',PRIMARY KEY  (`id`),KEY `approved` (`approved`),KEY `start_date` (`start_date`),KEY `repeat_type` (`repeat_type`));
DROP TABLE IF EXISTS `nuke_gcal_rsvp`;
CREATE TABLE `nuke_gcal_rsvp` (`id` int(11) NOT NULL auto_increment,`event_id` int(11) NOT NULL,`user_id` int(11) NOT NULL,PRIMARY KEY  (`id`), KEY `event_id` (`event_id`,`user_id`));

DROP TABLE IF EXISTS `nuke_gcal_exception`;
CREATE TABLE `nuke_gcal_exception` (`id` int(11) NOT NULL auto_increment, `event_id` int(11) NOT NULL, `date` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`), KEY `event_id` (`event_id`), KEY `date` (`date`));

DROP TABLE IF EXISTS `nuke_gcal_cat_group`;
CREATE TABLE `nuke_gcal_cat_group` (`id` int(11) NOT NULL auto_increment, `cat_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `cat_id` (`cat_id`), KEY `group_id` (`group_id`));

INSERT INTO `nuke_gcal_cat_group` VALUES (NULL, 1, -1);
INSERT INTO `nuke_gcal_cat_group` VALUES (NULL, 2, -1);
INSERT INTO `nuke_gcal_cat_group` VALUES (NULL, 3, -1);
INSERT INTO `nuke_gcal_cat_group` VALUES (NULL, 4, -1);
INSERT INTO `nuke_gcal_cat_group` VALUES (NULL, 5, -1);
INSERT INTO `nuke_gcal_cat_group` VALUES (NULL, 6, -1);

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
steve_lemaster







PostPosted: Sat Jun 21, 2008 10:07 am Reply with quote

I went back and changed it and got errors.
 
montego







PostPosted: Sun Jun 22, 2008 10:26 am Reply with quote

You should not get an error on the SQL that I posted one post above. If you do, please post the full error text!
 
steve_lemaster







PostPosted: Sun Jun 22, 2008 11:50 am Reply with quote

Error
SQL query:

DROP TABLE IF EXISTS $prefix.`global_gcal_category` ;



MySQL said:

#1142 - DROP command denied to user 'global'@'localhost' for table 'global_gcal_category'
 
Guardian2003
Site Admin



Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam

PostPosted: Sun Jun 22, 2008 11:56 am Reply with quote

You need to change $prefix to 'nuke' if you are using that as your prefix as Montego stated. mySQL doesn't know what $prefix is supposed to be so it will give you an error.

Something else isn't right though; nowhere is Montegos code is the table "global_gcal_category" mentioned.
 
View user's profile Send private message Send e-mail
steve_lemaster







PostPosted: Sun Jun 22, 2008 1:24 pm Reply with quote

global is the prefix I use.

It's all Greek to me, guys. Seems to be more trouble than it's worth anyway, as I doubt I'll ever use the calendar.

Now, it would seem, that I cannot get a simple module to work. I think I botched the entire upgrade.
 
Guardian2003







PostPosted: Sun Jun 22, 2008 1:55 pm Reply with quote

Code:


DROP TABLE IF EXISTS `global_gcal_category`;
CREATE TABLE `global_gcal_category` (`id` int(11) NOT NULL auto_increment,`name` varchar(128) NOT NULL default '',PRIMARY KEY  (`id`));
INSERT INTO `global_gcal_category` VALUES (1, 'Unfiled');
INSERT INTO `global_gcal_category` VALUES (2, 'Show');
INSERT INTO `global_gcal_category` VALUES (3, 'Birthday');
INSERT INTO `global_gcal_category` VALUES (4, 'Release Date');
INSERT INTO `global_gcal_category` VALUES (5, 'Anniversary');
INSERT INTO `global_gcal_category` VALUES (6, 'Site Event');

DROP TABLE IF EXISTS `global_gcal_config`;
CREATE TABLE `global_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`));
INSERT INTO `global_gcal_config` VALUES (1, 'Calendar of Events', 'images/admin/gcalendar.gif', 2006, 2037,'members', 1, 'a,b,i,img','href,src,border,alt,title', '1.7.0', 0, '%m/%d', '%B %d, %Y', '%A, %B %d, %Y', 0, 1, 0,0, 0, 'admin@yoursite.com', 'New GCalendar Event', 'A new GCalendar event was submitted.', 'admin@yoursite.com', 1, 1, 1, '0,6', 'off', 'Event RSVP Notification', '', '' );

DROP TABLE IF EXISTS `global_gcal_event`;
CREATE TABLE `global_gcal_event` (`id` int(11) NOT NULL auto_increment,`title` varchar(255) NOT NULL default '',`no_time` tinyint(1) NOT NULL default '1',`start_time` time NOT NULL default '00:00:00',`end_time` time NOT NULL default '00:00:00',`location` text NOT NULL,`category` int(11) NOT NULL default '0',`repeat_type` enum('none','daily','weekly','monthly','yearly') NOT NULL default 'none',`details` text NOT NULL,`interval_val` int(11) NOT NULL default '0',`no_end_date` tinyint(1) NOT NULL default '1',`start_date` date NOT NULL default '0000-00-00',`end_date` date NOT NULL default '0000-00-00',`weekly_days` set('0','1','2','3','4','5','6') NOT NULL default '',`monthly_by_day` tinyint(1) NOT NULL default '0',`submitted_by` varchar(25) NOT NULL default '',`approved` tinyint(1) NOT NULL default '0',`rsvp` ENUM( 'off', 'on', 'email' ) NOT NULL DEFAULT 'off',PRIMARY KEY  (`id`),KEY `approved` (`approved`),KEY `start_date` (`start_date`),KEY `repeat_type` (`repeat_type`));
DROP TABLE IF EXISTS `global_gcal_rsvp`;
CREATE TABLE `global_gcal_rsvp` (`id` int(11) NOT NULL auto_increment,`event_id` int(11) NOT NULL,`user_id` int(11) NOT NULL,PRIMARY KEY  (`id`), KEY `event_id` (`event_id`,`user_id`));

DROP TABLE IF EXISTS `global_gcal_exception`;
CREATE TABLE `global_gcal_exception` (`id` int(11) NOT NULL auto_increment, `event_id` int(11) NOT NULL, `date` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`), KEY `event_id` (`event_id`), KEY `date` (`date`));

DROP TABLE IF EXISTS `global_gcal_cat_group`;
CREATE TABLE `global_gcal_cat_group` (`id` int(11) NOT NULL auto_increment, `cat_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `cat_id` (`cat_id`), KEY `group_id` (`group_id`));

INSERT INTO `global_gcal_cat_group` VALUES (NULL, 1, -1);
INSERT INTO `global_gcal_cat_group` VALUES (NULL, 2, -1);
INSERT INTO `global_gcal_cat_group` VALUES (NULL, 3, -1);
INSERT INTO `global_gcal_cat_group` VALUES (NULL, 4, -1);
INSERT INTO `global_gcal_cat_group` VALUES (NULL, 5, -1);
INSERT INTO `global_gcal_cat_group` VALUES (NULL, 6, -1);
 
steve_lemaster







PostPosted: Sun Jun 22, 2008 2:05 pm Reply with quote

Ok. That was successful (don't know what I was doing wrong), however, when I go to the calendar configuration in the admin page and click on the icon, I get this:

database problem, no config table
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©