Verfasst: 08.01.2007 14:49
Ich könnte den ganzen MOD ja wieder einbauen, könnte das vielleicht etwas bringen?
phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
SELECT f. * , p.post_time, p.post_username, u.username, u.user_id, t.topic_title, t.topic_last_post_id
FROM (
(
(
phpbb_forums f
LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id
)
LEFT JOIN phpbb_users u ON u.user_id = p.poster_id
)
LEFT JOIN phpbb_topics t ON t.topic_last_post_id = p.post_id
)
ORDER BY f.cat_id, f.forum_order
Bei allen aber kein Fehler gefunden.Check user and group tables This will check the user and the group tables for errors and will restore missing single user groups.
Check post and topic tables This will check the post and the topic tables for errors.
Check vote tables This will check the vote tables for errors.
Check private message tables This will check the private messages tables for errors.
Check configuration table This will check the configuration table for missing entries.
vollständige Textfelder
forum_id cat_id forum_name forum_desc forum_status forum_order forum_posts forum_topics forum_last_post_id prune_next prune_enable auth_view auth_read auth_post auth_reply auth_edit auth_delete auth_sticky auth_announce auth_vote auth_pollcreate auth_attachments iai_override iai_percentage iai_stop_words forum_parent disable_word_censor title_is_link weblink forum_link_icon forum_link_count post_time post_username username user_id topic_title topic_last_post_id
1 2 Akündigungen und Informationen Dieses Unterforum bitte immer lesen, da hier alle ... 0 10 7 5 86 NULL 0 0 0 1 1 1 1 3 3 1 1 0 0 0 0 0 0 0 0 1167047947