Topic Calendar: kleuren volgens verschillende forums
Geplaatst: 01 sep 2005, 22:10
Ik heb een mod (http://www.chathamkiwanis.com/phpBB/dlo ... ef4f76b246) gedownload om een onderscheid te maken van de events in mijn kalender, bv: events uit het forum "school" krijgen blauwe kleur, events uit forum "fuiven" krijgen rode kleur, en verjaardagen krijgen oranje kleur. Ik heb deze geïnstalleerd, maar krijg nu de volgende error op mijn index pagina:
Could not obtain topics information
DEBUG MODE
SQL Error : 1054 Unknown column 'f.forum_color' in 'field list'
SELECT t.*, p.poster_id, p.post_username, p.enable_bbcode, p.enable_html, p.enable_smilies, u.username, pt.post_text, pt.bbcode_uid, lp.poster_id AS lp_poster_id, lu.username AS lp_username, lp.post_username AS lp_post_username, lp.post_time AS lp_post_time , f.forum_name, f.forum_color FROM phpbb_topics AS t, phpbb_posts AS p, phpbb_posts_text AS pt, phpbb_users AS u, phpbb_posts AS lp, phpbb_users lu , phpbb_forums AS f WHERE t.forum_id IN (2, 3, 12, 5, 6, 7, 8, 9, 10, 11, 13, 14, 16, 17, 18, 19, 20, 21, 22, 23, 24) AND p.post_id = t.topic_first_post_id AND pt.post_id = t.topic_first_post_id AND u.user_id = p.poster_id AND lp.post_id = t.topic_last_post_id AND lu.user_id = lp.poster_id AND t.topic_calendar_time < 1126076400 AND (t.topic_calendar_time + t.topic_calendar_duration) >= 1125471600 AND t.topic_status <> 2 AND f.forum_id = t.forum_id ORDER BY t.topic_calendar_time, t.topic_calendar_duration DESC, t.topic_last_post_id DESC
Line : 375
File : functions_calendar.php
De mod is nogal verwarrend, er worden soms meerdere zoekresultaten gevonden bij een FIND-opdracht.. Wat zou ik verkeerd kunnen gedaan hebben?
Could not obtain topics information
DEBUG MODE
SQL Error : 1054 Unknown column 'f.forum_color' in 'field list'
SELECT t.*, p.poster_id, p.post_username, p.enable_bbcode, p.enable_html, p.enable_smilies, u.username, pt.post_text, pt.bbcode_uid, lp.poster_id AS lp_poster_id, lu.username AS lp_username, lp.post_username AS lp_post_username, lp.post_time AS lp_post_time , f.forum_name, f.forum_color FROM phpbb_topics AS t, phpbb_posts AS p, phpbb_posts_text AS pt, phpbb_users AS u, phpbb_posts AS lp, phpbb_users lu , phpbb_forums AS f WHERE t.forum_id IN (2, 3, 12, 5, 6, 7, 8, 9, 10, 11, 13, 14, 16, 17, 18, 19, 20, 21, 22, 23, 24) AND p.post_id = t.topic_first_post_id AND pt.post_id = t.topic_first_post_id AND u.user_id = p.poster_id AND lp.post_id = t.topic_last_post_id AND lu.user_id = lp.poster_id AND t.topic_calendar_time < 1126076400 AND (t.topic_calendar_time + t.topic_calendar_duration) >= 1125471600 AND t.topic_status <> 2 AND f.forum_id = t.forum_id ORDER BY t.topic_calendar_time, t.topic_calendar_duration DESC, t.topic_last_post_id DESC
Line : 375
File : functions_calendar.php
De mod is nogal verwarrend, er worden soms meerdere zoekresultaten gevonden bij een FIND-opdracht.. Wat zou ik verkeerd kunnen gedaan hebben?
toch bedankt