Beim einfügen der sql daten:
Code: Alles auswählen
/* WARNING: do NOT execute the SQL commands on the phpbb3_acl_options table more
than once if you're upgrading or trying to repair a previous installation of the calendar mod.
Executing this command more than once will add duplicate entries to the table
breaking your current permissions and causing the calendar to malfunction */
INSERT INTO phpbb3_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('a_calendar', 1, 0, 0),
('m_calendar_edit_other_users_events', 1, 0, 0),
('m_calendar_delete_other_users_events', 1, 0, 0),
('u_calendar_view_events', 1, 0, 0),
('u_calendar_create_events', 1, 0, 0),
('u_calendar_edit_events', 1, 0, 0),
('u_calendar_delete_events', 1, 0, 0);
DROP TABLE IF EXISTS `phpbb3_calendar_config`;
CREATE TABLE IF NOT EXISTS `phpbb3_calendar_config` (
`config_name` varchar(255) NOT NULL,
`config_value` varchar(255) NOT NULL
);
INSERT INTO `phpbb3_calendar_config` (`config_name`, `config_value`) VALUES
('first_day_of_week', '0'),
('index_display_week', '0'),
('index_display_next_events', '5'),
('hour_mode', '12'),
('display_truncated_name', '0'),
('prune_frequency', '0'),
('last_prune', '0'),
('prune_limit', '2592000'),
('display_hidden_groups', '0');
DROP TABLE IF EXISTS `phpbb3_calendar_event_types`;
CREATE TABLE IF NOT EXISTS `phpbb3_calendar_event_types` (
`etype_id` tinyint(3) unsigned NOT NULL auto_increment,
`etype_index` tinyint(3) unsigned NOT NULL default '0',
`etype_full_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`etype_display_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`etype_color` varchar(6) character set utf8 collate utf8_bin NOT NULL default '',
`etype_image` varchar(255) NOT NULL,
PRIMARY KEY (`etype_id`)
);
INSERT INTO `phpbb3_calendar_event_types` (`etype_id`,`etype_index`,`etype_full_name`,`etype_display_name`,`etype_color`,`etype_image`) VALUES
(1,1,'Generic Event','','','');
DROP TABLE IF EXISTS `phpbb3_calendar_events`;
CREATE TABLE IF NOT EXISTS `phpbb3_calendar_events` (
`event_id` int(10) unsigned NOT NULL auto_increment,
`etype_id` tinyint(4) NOT NULL,
`sort_timestamp` bigint(20) unsigned NOT NULL,
`event_start_time` bigint(20) unsigned NOT NULL,
`event_end_time` bigint(20) unsigned NOT NULL,
`event_all_day` tinyint(2) NOT NULL default '0',
`event_day` varchar(10) character set utf8 collate utf8_bin NOT NULL default '',
`event_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`event_body` longblob NOT NULL,
`poster_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
`event_access_level` tinyint(1) NOT NULL default '0',
`group_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
`enable_bbcode` tinyint(1) unsigned NOT NULL default '1',
`enable_smilies` tinyint(1) unsigned NOT NULL default '1',
`enable_magic_url` tinyint(1) unsigned NOT NULL default '1',
`bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
`bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL,
PRIMARY KEY (`event_id`)
);Code: Alles auswählen
Fehler
SQL-Befehl:
CREATE TABLE IF NOT EXISTS `phpbb3_calendar_event_types` (
`etype_id` tinyint( 3 ) unsigned NOT NULL AUTO_INCREMENT ,
`etype_index` tinyint( 3 ) unsigned NOT NULL default '0',
`etype_full_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default '',
`etype_display_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default '',
`etype_color` varchar( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
`etype_image` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `etype_id` )
);
MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_unicode_ci NOT NULL default '',
`etype_display_ 