phpBB.de

Code: Alles auswählen

Error in posting

DEBUG MODE

SQL Error : 1062 Duplicate entry '0' for key 1

INSERT INTO wb_forum_posts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (0, 'test', 'aa1ede04fb', 'test')

Line : 279
File : /.../htdocs/forum/includes/functions_post.php

Code: Alles auswählen

#
# TABLE: wb_forum_posts_text
#
DROP TABLE IF EXISTS wb_forum_posts_text;
CREATE TABLE wb_forum_posts_text(
	post_id mediumint(8) unsigned NOT NULL,
	bbcode_uid varchar(10) NOT NULL,
	post_subject varchar(60),
	post_text text,
	PRIMARY KEY (post_id)
);

#
# Table Data for wb_forum_posts_text
#

INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('11', 'eb5c1a2885', 'Avatar / Benutzerbild', '?');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('10', '582a38e6d5', 'Ein Forum für ??', '?!');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('9', '34a0c12e5e', 'neue Benutzer - wie anmelden?', 'H?');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('12', '11be6dda35', 'neue ?L', '...');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('13', '939a37e1ca', 'Struktur des Forums', '...');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('14', 'ce4de43ef5', 'Layout', '...');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('15', 'e46382b202', 'Test-Feedback', '...');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('16', '0d84136b80', '', '...');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('17', '632b0822a7', '', '?');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('0', 'd6594e235c', '', 'HI!...');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('18', 'edad1e132e', 'test', 'test');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('20', '28e8f2f13e', 'test', 'test');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('22', 'fd2e6503cb', 'test', 'test');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('24', '749499c2e1', 'test', 'test');
INSERT INTO wb_forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('26', '4b674391a0', 'test2', 'test2');

Code: Alles auswählen

$sql = ($mode != "editpost") ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . " WHERE post_id = $post_id";