phpBB.de

Code: Alles auswählen

Could not save meeting data

DEBUG MODE

SQL Error : 1054 Unknown column 'meeting_guest_names' in 'field list'

INSERT INTO phpbb_meeting_data (meeting_id, meeting_time, meeting_until, meeting_location, meeting_subject, meeting_desc, meeting_link, meeting_places, meeting_by_user, meeting_edit_by_user, meeting_start_value, meeting_recure_value, meeting_notify, meeting_guest_overall, meeting_guest_single, meeting_guest_names, bbcode_uid) VALUES (1, 1191412800, 1191326400, 'Schwarzenfels', 'SK07: Voraussuche', 'Ausbilder und Gruppenleiter bitte melden!', '', 33, 2, 2, 0, 5, 0, 0, 0, 0, '1968565b50')

Line : 370
File : meeting_manage.php

Code: Alles auswählen

Could not query announcements information

DEBUG MODE

SQL Error : 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 ') AND t.topic_time <= 1189644797 AND t.topic_poster =

SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1189644797 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC

Line : 86
File : portal_poll.php

Code: Alles auswählen

...
...

CREATE TABLE phpbb_meeting_config (
	config_name VARCHAR(255) NOT NULL DEFAULT '',
	config_value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (config_name)
);
CREATE TABLE phpbb_meeting_guestnames (
	meeting_id MEDIUMINT(8) NOT NULL DEFAULT '0',
	user_id MEDIUMINT(8) NOT NULL DEFAULT '0',
	guest_prename VARCHAR(255) NOT NULL DEFAULT '',
	guest_name VARCHAR(255) NOT NULL DEFAULT ''
);

INSERT INTO phpbb_meeting_config (config_name, config_value) VALUES ('allow_user_enter_meeting', '0');
...
...

Code: Alles auswählen

...
...
$sql = array();
$sql[] = "CREATE TABLE " . $table_prefix . "meeting_comment (
       comment_id MEDIUMINT(8) AUTO_INCREMENT,
       meeting_id MEDIUMINT(8) unsigned NOT NULL,
       user_id MEDIUMINT(8) DEFAULT '0' NOT NULL,
       meeting_comment TEXT NOT NULL,
       meeting_edit_time INT(11) DEFAULT '0' NOT NULL,
       bbcode_uid varchar(10) NOT NULL DEFAULT '',
       PRIMARY KEY (comment_id))";
$sql[] = "CREATE TABLE " . $table_prefix . "meeting_data (
       meeting_id MEDIUMINT(8) unsigned NOT NULL,
       meeting_time INT(11) DEFAULT '0' NOT NULL,
       meeting_until INT(11) DEFAULT '0' NOT NULL,
       meeting_location VARCHAR(255) NOT NULL,
       meeting_subject VARCHAR(255) NOT NULL,
       meeting_desc TEXT NOT NULL,
       meeting_link VARCHAR(255) NOT NULL,
       meeting_places MEDIUMINT(8) DEFAULT '0' NOT NULL,
       meeting_by_user MEDIUMINT(8) DEFAULT '0' NOT NULL,
       meeting_edit_by_user MEDIUMINT(8) DEFAULT '0' NOT NULL,
       meeting_start_value MEDIUMINT(8) DEFAULT '0' NOT NULL,
       meeting_recure_value MEDIUMINT(8) DEFAULT '5' NOT NULL,
       meeting_notify TINYINT(1) NOT NULL DEFAULT '0',
       meeting_guest_overall MEDIUMINT(8) NOT NULL DEFAULT '0',
       meeting_guest_single MEDIUMINT(8) NOT NULL DEFAULT '0',
       bbcode_uid varchar(10) NOT NULL DEFAULT '',
       PRIMARY KEY (meeting_id))";
$sql[] = "CREATE TABLE " . $table_prefix . "meeting_user (
       meeting_id MEDIUMINT(8) unsigned NOT NULL,
       user_id MEDIUMINT(8) DEFAULT '0' NOT NULL,
       meeting_sure TINYINT(4) DEFAULT '0' NOT NULL,
       meeting_guests MEDIUMINT(8) NOT NULL DEFAULT '0')";
$sql[] = "CREATE TABLE " . $table_prefix . "meeting_usergroup (
       meeting_id MEDIUMINT(8) unsigned NOT NULL,
       meeting_group MEDIUMINT(8) NOT NULL)";
$sql[] = "CREATE TABLE " . $table_prefix . "meeting_config (
	config_name VARCHAR(255) NOT NULL DEFAULT '',
	config_value VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (config_name)
)";
$sql[] = "INSERT INTO " . $table_prefix . "meeting_config (config_name, config_value) VALUES ('allow_user_enter_meeting', '0')";

...
...