Phpbb Calendar' Versie 0.1.0 probleem install

yomi · Bericht door **yomi** » 07 jun 2010, 19:07

Adres van je forum: http://www.witvisforum.nl
Event. modificaties op je forum:Portaal
Wanneer ontstond het probleem? na het installeren van de MOD 'phpbb Calendar' Versie 0.1.0
phpBB versie: 3.0.7-PL1
Wat is het probleem?

Hallo,
Ik ben bezig om de MOD 'phpbb Calendar' Versie 0.1.0 te intalleren op mijn forum.
In de manual staat dat ik een SQL query moet draaien.
Het gaat om de volgende SQL query.
Deze heb ik ook gedraaied alleen nu krijg ik de volgende error melding op mijn forum.
Hij zegt dat er een table ontbreekt.
Hoe kan ik die table er aan toevoegen.
Dit geeft hij aan in mijn SQL databasis.

Nieuwe tabel aanmaken in database p5014_E3FHqadvan
Naam: Number of fields:

Wat van naam moet ik de tabel geven en wat van number of field moet ik invullen
Ik kan nu niet meer naar het forum toe.

Wie wilt mijn even helpen.
Pascal

De fout error

Code: Selecteer alles

Algemene fout
SQL ERROR [ mysql4 ]

Table 'p5014_bLKsEphpbb.phpbb1calendar_config' doesn't exist [1146]

SQL

SELECT * FROM phpbb1calendar_config WHERE config_name ='prune_frequency'

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 4380
CALL: dbal_mysql->sql_query()

FILE: includes/functions.php
LINE: 4352
CALL: prune_calendar_required()

FILE: portal.php
LINE: 271
CALL: page_footer()

De SQL query.

Code: Selecteer alles

]/* WARNING: do NOT execute the SQL commands on the phpbb_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 phpbb_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_edit_events', 1, 0, 0),
('u_calendar_delete_events', 1, 0, 0),
('u_calendar_create_public_events', 1, 0, 0),
('u_calendar_create_group_events', 1, 0, 0),
('u_calendar_create_private_events', 1, 0, 0),
('u_calendar_nonmember_groups', 1, 0, 0),
('u_calendar_track_rsvps', 1, 0, 0),
('u_calendar_allow_guests', 1, 0, 0),
('u_calendar_view_headcount', 1, 0, 0),
('u_calendar_view_detailed_rsvps', 1, 0, 0),
('u_calendar_create_recurring_events', 1, 0, 0),
('m_calendar_edit_other_users_rsvps', 1, 0, 0);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_config` (
`config_name` varchar(255) NOT NULL,
`config_value` varchar(255) NOT NULL
);

INSERT INTO `phpbb_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'),
('time_format','h:i a'),
('date_format','M d, Y'),
('date_time_format','M d, Y h:i a'),
('disp_events_only_on_start','0'),
('populate_frequency','86400'),
('last_populate','0'),
('populate_limit','2592000');

CREATE TABLE IF NOT EXISTS `phpbb_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 `phpbb_calendar_event_types` (`etype_id`,`etype_index`,`etype_full_name`,`etype_display_name`,`etype_color`,`etype_image`) VALUES 
(1,1,'Generic Event','','','');

CREATE TABLE IF NOT EXISTS `phpbb_calendar_events` (
`event_id` mediumint(8) 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,
`group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
`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,
`track_rsvps` tinyint(1) unsigned NOT NULL default '0',
`allow_guests` tinyint(1) unsigned NOT NULL default '0',
`rsvp_yes` mediumint(8) unsigned NOT NULL default '0',
`rsvp_no` mediumint(8) unsigned NOT NULL default '0',
`rsvp_maybe` mediumint(8) unsigned NOT NULL default '0',
`recurr_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`event_id`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_recurring_events` (
`recurr_id` mediumint(8) unsigned NOT NULL auto_increment,
`etype_id` tinyint(4) NOT NULL,
`frequency` tinyint(4) NOT NULL default '1',
`frequency_type` tinyint(4) NOT NULL default '0',
`first_occ_time` bigint(20) unsigned NOT NULL,
`final_occ_time` bigint(20) unsigned NOT NULL,
`event_all_day` tinyint(2) NOT NULL default '0',
`event_duration` bigint(20) unsigned NOT NULL,
`week_index` tinyint(2) NOT NULL default '0',
`first_day_of_week` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`last_calc_time` bigint(20) unsigned NOT NULL,
`next_calc_time` bigint(20) unsigned NOT NULL,
`event_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`event_body` longblob NOT NULL,
`poster_id` mediumint(8) unsigned NOT NULL default '0',
`poster_timezone` decimal(5,2) NOT NULL default '0.00',
`poster_dst` tinyint(1) unsigned NOT NULL default '0',
`event_access_level` tinyint(1) NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
`group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
`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,
`track_rsvps` tinyint(1) unsigned NOT NULL default '0',
`allow_guests` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`recurr_id`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_rsvps` (
`rsvp_id` mediumint(8) unsigned NOT NULL auto_increment,
`event_id` mediumint(8) unsigned NOT NULL default '0',
`poster_id` mediumint(8) unsigned NOT NULL default '0',
`poster_name` varchar(255) collate utf8_bin NOT NULL default '',
`poster_colour` varchar(6) collate utf8_bin NOT NULL default '',
`poster_ip` varchar(40) collate utf8_bin NOT NULL default '',
`post_time` int(11) unsigned NOT NULL default '0',
`rsvp_val` tinyint(1) unsigned NOT NULL default '0',
`rsvp_count` smallint(4) unsigned NOT NULL default '1',
`rsvp_detail` mediumtext collate utf8_bin NOT NULL,
`bbcode_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
`bbcode_uid` varchar(8) collate utf8_bin NOT NULL,
`bbcode_options` tinyint(1) unsigned NOT NULL default '7',
PRIMARY KEY (`rsvp_id`),
KEY `event_id` (`event_id`),
KEY `poster_id` (`poster_id`),
KEY `eid_post_time` (`event_id`,`post_time`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_events_watch` (
`event_id` mediumint(8) unsigned NOT NULL default '0',
`user_id` mediumint(8) unsigned NOT NULL default '0',
`notify_status` tinyint(1) unsigned NOT NULL default '0',
`track_replies` tinyint(1) unsigned NOT NULL default '0',
KEY `event_id` (`event_id`),
KEY `user_id` (`user_id`),
KEY `notify_stat` (`notify_status`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_watch` (
`user_id` mediumint(8) unsigned NOT NULL default '0',
`notify_status` tinyint(1) unsigned NOT NULL default '0',
KEY `user_id` (`user_id`),
KEY `notify_stat` (`notify_status`)
);

Neo · Bericht door **Neo** » 07 jun 2010, 20:21

Zijn prefix was anders namelijk phpbb1 in plaats van phpbb_

Code: Selecteer alles

INSERT INTO phpbb1acl_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_edit_events', 1, 0, 0),
('u_calendar_delete_events', 1, 0, 0),
('u_calendar_create_public_events', 1, 0, 0),
('u_calendar_create_group_events', 1, 0, 0),
('u_calendar_create_private_events', 1, 0, 0),
('u_calendar_nonmember_groups', 1, 0, 0),
('u_calendar_track_rsvps', 1, 0, 0),
('u_calendar_allow_guests', 1, 0, 0),
('u_calendar_view_headcount', 1, 0, 0),
('u_calendar_view_detailed_rsvps', 1, 0, 0),
('u_calendar_create_recurring_events', 1, 0, 0),
('m_calendar_edit_other_users_rsvps', 1, 0, 0);

CREATE TABLE IF NOT EXISTS `phpbb1calendar_config` (
`config_name` varchar(255) NOT NULL,
`config_value` varchar(255) NOT NULL
);

INSERT INTO `phpbb1calendar_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'),
('time_format','h:i a'),
('date_format','M d, Y'),
('date_time_format','M d, Y h:i a'),
('disp_events_only_on_start','0'),
('populate_frequency','86400'),
('last_populate','0'),
('populate_limit','2592000');

CREATE TABLE IF NOT EXISTS `phpbb1calendar_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 `phpbb1calendar_event_types` (`etype_id`,`etype_index`,`etype_full_name`,`etype_display_name`,`etype_color`,`etype_image`) VALUES 
(1,1,'Generic Event','','','');

CREATE TABLE IF NOT EXISTS `phpbb1calendar_events` (
`event_id` mediumint(8) 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,
`group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
`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,
`track_rsvps` tinyint(1) unsigned NOT NULL default '0',
`allow_guests` tinyint(1) unsigned NOT NULL default '0',
`rsvp_yes` mediumint(8) unsigned NOT NULL default '0',
`rsvp_no` mediumint(8) unsigned NOT NULL default '0',
`rsvp_maybe` mediumint(8) unsigned NOT NULL default '0',
`recurr_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`event_id`)
);

CREATE TABLE IF NOT EXISTS `phpbb1calendar_recurring_events` (
`recurr_id` mediumint(8) unsigned NOT NULL auto_increment,
`etype_id` tinyint(4) NOT NULL,
`frequency` tinyint(4) NOT NULL default '1',
`frequency_type` tinyint(4) NOT NULL default '0',
`first_occ_time` bigint(20) unsigned NOT NULL,
`final_occ_time` bigint(20) unsigned NOT NULL,
`event_all_day` tinyint(2) NOT NULL default '0',
`event_duration` bigint(20) unsigned NOT NULL,
`week_index` tinyint(2) NOT NULL default '0',
`first_day_of_week` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`last_calc_time` bigint(20) unsigned NOT NULL,
`next_calc_time` bigint(20) unsigned NOT NULL,
`event_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`event_body` longblob NOT NULL,
`poster_id` mediumint(8) unsigned NOT NULL default '0',
`poster_timezone` decimal(5,2) NOT NULL default '0.00',
`poster_dst` tinyint(1) unsigned NOT NULL default '0',
`event_access_level` tinyint(1) NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
`group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
`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,
`track_rsvps` tinyint(1) unsigned NOT NULL default '0',
`allow_guests` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`recurr_id`)
);

CREATE TABLE IF NOT EXISTS `phpbb1calendar_rsvps` (
`rsvp_id` mediumint(8) unsigned NOT NULL auto_increment,
`event_id` mediumint(8) unsigned NOT NULL default '0',
`poster_id` mediumint(8) unsigned NOT NULL default '0',
`poster_name` varchar(255) collate utf8_bin NOT NULL default '',
`poster_colour` varchar(6) collate utf8_bin NOT NULL default '',
`poster_ip` varchar(40) collate utf8_bin NOT NULL default '',
`post_time` int(11) unsigned NOT NULL default '0',
`rsvp_val` tinyint(1) unsigned NOT NULL default '0',
`rsvp_count` smallint(4) unsigned NOT NULL default '1',
`rsvp_detail` mediumtext collate utf8_bin NOT NULL,
`bbcode_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
`bbcode_uid` varchar(8) collate utf8_bin NOT NULL,
`bbcode_options` tinyint(1) unsigned NOT NULL default '7',
PRIMARY KEY (`rsvp_id`),
KEY `event_id` (`event_id`),
KEY `poster_id` (`poster_id`),
KEY `eid_post_time` (`event_id`,`post_time`)
);

CREATE TABLE IF NOT EXISTS `phpbb1calendar_events_watch` (
`event_id` mediumint(8) unsigned NOT NULL default '0',
`user_id` mediumint(8) unsigned NOT NULL default '0',
`notify_status` tinyint(1) unsigned NOT NULL default '0',
`track_replies` tinyint(1) unsigned NOT NULL default '0',
KEY `event_id` (`event_id`),
KEY `user_id` (`user_id`),
KEY `notify_stat` (`notify_status`)
);

CREATE TABLE IF NOT EXISTS `phpbb1calendar_watch` (
`user_id` mediumint(8) unsigned NOT NULL default '0',
`notify_status` tinyint(1) unsigned NOT NULL default '0',
KEY `user_id` (`user_id`),
KEY `notify_stat` (`notify_status`)
);

Jeroen · Bericht door **Jeroen** » 07 jun 2010, 20:29

Verplaatst van 3.0 Support

- Pietje

yomi · Bericht door **yomi** » 08 jun 2010, 07:36

De mod is nu goed geinstalleeerd.
In mijn ACP kan ik ook de instelling invullen en aanpassen.
Alleen als ik dan naar de pagina wil gaan via mijn Portaal dan krijg ik de volgende melding

Je beschikt niet over de juiste permissies om deze procedure af te ronden.

In ACP heb ik de rechten al goed neergezet wat zou het probleem kunnen zijn.

yomi · Bericht door **yomi** » 08 jun 2010, 11:22

Oke dit probleem hierboven heb ik ook opgelost.
de calender is nu zichtbaar op het forum.

Ik heb de modules toegevoegd en mijn cache geleegd.
de twee groepen staan ook keurig in het gebruikerspaneel.
Alleen ik weet niet hoe ik een evenement er aan kan toevoegen.
de opsie die ik heb is in deze twee modules allebij het zelfde en kan alleen maar aangeven hoeveel dagen het evenement er in moet staan. als ik kijk naar de onwerper zijn demoboard te vinden op de volgende url dan zie ik niet hoe ik een evenement er aan kan toevoegen. alleen wat ik zie staan zijn al bestaande evenementen.

Demo Board: http://phpbbcalendarmod.com/305
Demo User: demo
Demo User Password: demouser
demo has permission to view, create, edit, and delete events.

yomi · Bericht door **yomi** » 17 jun 2010, 07:42

Besten mensen ik krijg zins vandaag bij mijn Calender een rare error melding.
Wat betekend deze melding

Algemene fout
template->set_filenames: Empty filename specified for body.

Wie heeft een idee want kan nu niet mijn calander open.
Mis ik een bestand of zoiets.

Phpbb Calendar' Versie 0.1.0 probleem install

Phpbb Calendar' Versie 0.1.0 probleem install

Re: Phpbb Calendar' Versie 0.1.0 probleem install

Re: Phpbb Calendar' Versie 0.1.0 probleem install

Re: Phpbb Calendar' Versie 0.1.0 probleem install

Re: Phpbb Calendar' Versie 0.1.0 probleem install

Re: Phpbb Calendar' Versie 0.1.0 probleem install