corrupt database after install
Posted: 31. March 2009 12:04
Your Portal Version: 1.0.2
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Advanced Knowledge
What have you done before the problem was there?
I installrd phpbb3 and converted my phpbb2 site. The board seemed to work ok and all the users and posts were there.
What have you already tryed to solve the problem?
Description and Message
I ran the board3 install and had no errors. When portal.php is run I get the following error.
how can
i correct this?[/i]
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Advanced Knowledge
What have you done before the problem was there?
I installrd phpbb3 and converted my phpbb2 site. The board seemed to work ok and all the users and posts were there.
What have you already tryed to solve the problem?
Description and Message
I ran the board3 install and had no errors. When portal.php is run I get the following error.
Code: Select all
General Error
SQL ERROR [ mysqli ]
Table 'p' is marked as crashed and should be repaired [1194]
SQL
SELECT t.poll_title, t.poll_start, t.topic_id, t.topic_first_post_id, t.forum_id, t.poll_length, t.poll_vote_change, t.poll_max_options, t.topic_status, f.forum_status, p.bbcode_bitfield, p.bbcode_uid FROM phpbb_topics t, phpbb_posts p, phpbb_forums f WHERE t.forum_id = f.forum_id AND t.topic_approved = 1 AND t.poll_start > 0 AND (t.forum_id = '1' OR t.forum_id = '2' OR t.forum_id = '3' OR t.forum_id = '7' OR t.forum_id = '9' OR t.forum_id = '13' OR t.forum_id = '17' OR t.forum_id = '18' OR t.forum_id = '19' OR t.forum_id = '22' OR t.forum_id = '23' OR t.forum_id = '26' OR t.forum_id = '27' OR t.forum_id = '28' OR t.forum_id = '29' OR t.forum_id = '31' OR t.forum_id = '32' OR t.forum_id = '33' OR t.forum_id = '34' OR t.forum_id = '35' OR t.forum_id = '36' OR t.forum_id = '37' OR t.forum_id = '38') AND t.topic_moved_id = 0 AND p.post_id = t.topic_first_post_id ORDER BY t.poll_start DESC LIMIT 3
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()
FILE: portal/block/poll.php
LINE: 211
CALL: dbal->sql_query_limit()
FILE: portal.php
LINE: 90
CALL: include('portal/block/poll.php')i correct this?[/i]