OXPUS.de

Could not obtain topic information

DEBUG MODE

SQL Error : 1054 Unknown column 't.forum_id' in 'on clause'

SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 LEFT JOIN phpbb_forums f ON t.forum_id=f.forum_id WHERE t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND f.auth_view < 2 ORDER BY t.topic_last_post_id DESC LIMIT 10

Line : 203
File : actualstats.php

set_filenames(array( 'body' => 'admin/admin_recent_logins_body.tpl') ); $template->assign_vars(array( 'L_RECENT_LOGINS' => $lang['Recent_Logins'], 'L_RECENT_LOGIN_EXPLAIN' => $lang['Recent_Login_Explain'], 'L_NUMBER' => $lang['Number'], 'L_USERNAME' => $lang['Username'], 'L_DAYS_SINCE_LOGIN' => $lang['Days_since_login'] )); $today = time(); $week = $today - 604800; $sql = 'SELECT username, user_lastlogon FROM ' . USERS_TABLE . ' WHERE user_lastlogon > ' . $week . ' && user_id > 1 ORDER BY user_lastlogon DESC'; //check if query was successful, if not, output error message if ( ! ($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query users table', '', __LINE__, __FILE__, $sql); } $count = 1; while( $row = $db->sql_fetchrow($result) ) { $template->assign_block_vars('user_row', array( 'COUNT' => $count++, 'USERNAME' => $row['username'], 'DAYS_SINCE_LOGIN' => number_format((($row['user_lastlogon'] - $today) / 86400) * -1, 2) )); } // // Generate the page // $template->pparse('body'); include('./page_footer_admin.'.$phpEx); ?>

warum ging das eigendlich immer und nu nimmer?

Fatal error: Maximum execution time of 30 seconds exceeded in D:\wamp\www\2\db\mysql4.php on line 118

ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title);

CREATE TABLE phpbb_pa_comments (
  comments_id int(10) NOT NULL auto_increment,
  file_id int(10) NOT NULL default '0',
  comments_text text NOT NULL,
  comments_title text NOT NULL,
  comments_time int(50) NOT NULL default '0',
  comment_bbcode_uid varchar(10) default NULL,
  poster_id mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (comments_id),
  FULLTEXT KEY comment_bbcode_uid (comment_bbcode_uid)
);

Beim Update der Datenbank trat ein Fehler auf
The used table type doesn't support FULLTEXT indexes

Could not get main information for similar topics

DEBUG MODE

SQL Error : 1214 The used table type doesn't support FULLTEXT indexes

SELECT topic_id FROM phpbb_topics WHERE topic_id != 1 AND MATCH (topic_title) AGAINST ('Welcome to Dimension of phpBB 0.2.4') ORDER BY topic_time DESC LIMIT 0,5

Line : 577
File : viewtopic.php

could not obtain main information.

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_first_post_id' in 'on clause'

SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_posts p2 ON p2.post_id = t.topic_first_post_id LEFT OUTER JOIN phpbb_forums f ON p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u ON p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 ON u2.user_id = t.topic_poster WHERE t.forum_id NOT IN ('start') AND p.post_id = t.topic_last_post_id AND FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10

Line : 127
File : recent.php

FROM (TOPICS_TABLE t, POSTS_TABLE p)