Quiz Mod noch ein Fehler...

[Andy120]

Hier ich hoffe kann jemand helfen...

Code: Alles auswählen

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '// ADDED , pt.quiz_answer AND , p.post_id ASC BY Quiz Hack LIMIT 0, 15' at line 7

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_birthday, u.user_next_birthday_greeting, u.user_birthday, u.user_next_birthday_greeting, u.user_points, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, pt.quiz_answer FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 195 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC, p.post_id ASC// ADDED , pt.quiz_answer AND , p.post_id ASC BY Quiz Hack LIMIT 0, 15

Line : 397
File : /var/www/web102/html/index/phpbb2.0.6/viewtopic.php

[Markus67]

Hi ...

suche:

Code: Alles auswählen

p.post_time ASC, p.post_id ASC// ADDED , pt.quiz_answer AND , p.post_id ASC BY

ersetze mit:

Code: Alles auswählen

p.post_time ASC, p.post_id ASC, pt.quiz_answer AND , p.post_id ASC BY

Markus

[saerdnaer]

naja das passt jetzt nicht ganz:

Code: Alles auswählen

AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC, p.post_id ASC// ADDED , pt.quiz_answer AND , p.post_id ASC BY Quiz Hack LIMIT 0, 15 

sollte so heißen:

Code: Alles auswählen

AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC, p.post_id ASC LIMIT 0, 15