phpBB.de

Code: Alles auswählen

Could not obtain calendar config data

DEBUG MODE

SQL Error : 1146 Table 'klth.CALENDAR_CONFIG_TABLE' doesn't exist

SELECT name, value FROM CALENDAR_CONFIG_TABLE
Line : 17
File : calendar.php

Code: Alles auswählen

Table 'klth_CALENDAR_CONFIG_TABLE'

Schau Dir nochmal das Original an.

Code: Alles auswählen

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_calendar_cats` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(255) NOT NULL default '',
  `read_user_level` int(11) NOT NULL default '0',
  `read_user_ids` varchar(50) NOT NULL default '',
  `read_group_ids` varchar(50) NOT NULL default '',
  `read_black_uids` varchar(50) NOT NULL default '',
  `edit_user_level` int(11) NOT NULL default '0',
  `edit_user_ids` varchar(50) NOT NULL default '',
  `edit_group_ids` varchar(50) NOT NULL default '',
  `edit_black_uids` varchar(50) NOT NULL default '',
  `auto_notify` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `phpbb_calendar_auth` (
  `action` varchar(32) NOT NULL default '',
  `user_level` int(11) NOT NULL default '0',
  `group_ids` varchar(50) NOT NULL default '',
  `user_ids` varchar(50) NOT NULL default '',
  `black_uids` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`action`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `phpbb_calendar_auth` VALUES ('read', 0, '', '', '');
INSERT INTO `phpbb_calendar_auth` VALUES ('add', 1, '', '', '');
INSERT INTO `phpbb_calendar_auth` VALUES ('edit', 1, '', '', '');


CREATE TABLE `phpbb_calendar_config` (
  `name` varchar(30) NOT NULL,
  `value` varchar(50) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `phpbb_calendar_config` VALUES ('date_format', 'D, j.n.Y');
INSERT INTO `phpbb_calendar_config` VALUES ('days_before_today', '7');
INSERT INTO `phpbb_calendar_config` VALUES ('days_after_today', '21');
INSERT INTO `phpbb_calendar_config` VALUES ('next_days', '10');
INSERT INTO `phpbb_calendar_config` VALUES ('notify_mode', '');

CREATE TABLE `phpbb_calendar_events` (
  `event_id` int(11) NOT NULL auto_increment,
  `event_name` varchar(70) NOT NULL default '',
  `event_desc` text NOT NULL,
  `author` int(11) NOT NULL default '0',
  `times` varchar(255) NOT NULL default '',
  `j` varchar(255) NOT NULL default '',
  `n` varchar(255) NOT NULL default '',
  `Y` varchar(255) NOT NULL default '',
  `w` varchar(255) NOT NULL default '',
  `cats` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


ALTER TABLE `phpbb_users` ADD `cal_notify_mode` VARCHAR(5) DEFAULT '' NOT NULL, ADD `cal_notify_days` INT DEFAULT '3' NOT NULL, ADD `cal_notify_cats` VARCHAR(100) DEFAULT '' NOT NULL;

Code: Alles auswählen

## Author Notes:
##
##  This MOD adds a simple calendar to your board.
##  Please change "phpbb_" to your own table prefix in the SQL-Statements!
##  You should run "calender.php?cronjob" every day to send notifications.