參考連結:http://phpbb-tw.net/phpbb/viewtopic.php ... es&start=0
使用版本:phpBB 2.0.3 、 4images 1.7.0
網站位置:已刪除\r
狀況描述:
請問各位大大,小弟在安裝了4images並按phpBB論壇架設寶典的說明下與小弟的論壇做了整合,起初一切正常,小弟在其強大的功能下使用的非常快樂,怎料,在小弟回到論壇將帳號登出想再登入時(後續也曾因要檢示會員資料而出現),論壇處竟出現下列訊息:
代碼: 選擇全部
Parse error: parse error, unexpected T_STRING in c:\appserv\www\phpbb2\language\lang_english\lang_main.php on line 898
phpBB :
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_users.MYD'. (errno: 145)
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '6708dd8c87f2daedc8cb55f72d5e6c05' AND u.user_id = s.session_user_id AND session_time > 1061748136
Line : 239
File : c:\appserv\www\phpbb2\includes\sessions.php
代碼: 選擇全部
DB Error: Bad SQL Query: SELECT u.*, l.* FROM phpBB_users u, 4images_lightboxes l WHERE u.user_id = 3 AND l.user_id = u.user_id
Can't open file: 'phpbb_users.MYD'. (errno: 145)
DB Error: Bad SQL Query: SELECT * FROM phpBB_users WHERE user_id = 3
Can't open file: 'phpbb_users.MYD'. (errno: 145)
Warning: Cannot add header information - headers already sent by (output started at c:\appserv\www\4images\includes\db_mysql.php:188) in c:\appserv\www\4images\includes\sessions.php on line 325
Warning: Cannot add header information - headers already sent by (output started at c:\appserv\www\4images\includes\db_mysql.php:188) in c:\appserv\www\4images\includes\sessions.php on line 326
DB Error: Bad SQL Query: SELECT u.user_id, u.user_level, u.username, u.user_allow_viewonline, s.session_user_id, s.session_time, s.session_ip FROM phpBB_users u, phpBB_sessions s WHERE u.user_id = s.session_user_id AND (s.session_time >= 1061784703 OR u.user_session_time >= 1061784703) ORDER BY u.user_id ASC, s.session_ip ASC
Can't open file: 'phpbb_users.MYD'. (errno: 145)
DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpBB_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 3, 14, 31, 24, 15, 22, 16, 10, 11, 17, 12, 18, 13, 19, 20, 21, 23, 25, 26, 27, 28, 29, 30, 32, 33) AND c.cat_id = i.cat_id ORDER BY RAND()
Can't open file: 'phpbb_users.MYD'. (errno: 145)
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpBB_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0) ORDER BY i.image_date DESC LIMIT 3
Can't open file: 'phpbb_users.MYD'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\appserv\www\4images\includes\db_mysql.php on line 116
代碼: 選擇全部
[color=black]phpbb_users 瀏覽 選擇[/color] [color=blue]新增 屬性 刪除[/color] [color=black] 清空 使用中[/color]
補充:
這個問題小弟初步的應對方式是利用phpmyadmin將備份的資料還原,雖然這麼做問題就消失了,但是該症狀無法完全根治!!嚴重時會一天出現個好幾次…\r
小弟的系統是:
Win2000、Apche1.3.26、PHP4.2.3