Fatal Error: I cannot log in anymore [message #38195] |
Tue, 24 July 2007 19:21 |
ron4
Messages: 17 Registered: July 2007
Karma: 0
|
Junior Member |
|
|
Hello,
A couple of months ago I downloaded FUDforum and installed it on my website.
I (as well as the other registered members) am now experiencing a critical problem; namely I cannot log in anymore from the homepage of the forum.
The issue is apparently related to an SQL Error, as the following message comes up when I click 'Login':
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log...on line 188
I have looked at the core.inc file - at line 188 - as suggested in the error message, but I cannot make sense of where it goes wrong.
Could you please help me out on what to do to solve this issue?
Thanks in advance!
kind regards
Ron
|
|
|
Re: Fatal Error: I cannot log in anymore [message #38198 is a reply to message #38195] |
Tue, 24 July 2007 22:28 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
You can find the error log inside the errors/ directory inside data/ dir. It'll have the text file containing the query error. I suspect your sessions table may have become corrupted.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Fatal Error: I cannot log in anymore [message #39126 is a reply to message #38195] |
Mon, 01 October 2007 15:36 |
nectar2
Messages: 26 Registered: April 2005
Karma: 0
|
Junior Member |
|
|
I have just a admin account. Can't login to admin control panel to rebuild the theme. And don't know how to change to default theme using phpMyAdmin.
I checked my sql_errors again, there are some logs:
?1016 ?1190815305?(/bbs.anqun.cn/index.php:76<br />
/bbs.anqun.cn/index.php:176<br />
/bbs.anqun.cn/index.php:275<br />
/bbs.anqun.cn/index.php:947<br />
/bbs.anqun.cn/index.php:1142<br />
) 1030: Got error 134 from storage engine<br />
Query: SELECT
s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id,
t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt,
u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.topics_per_page,
u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc
FROM fud26_ses s
INNER JOIN fud26_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END)
INNER JOIN fud26_themes t ON t.id=u.theme
WHERE s.ses_id='38b75f0c8272d5cef733ac122ff61a7b'<br />
Server Version: 4.1.22-standard-log<br />
?703 ?1190815315?(/bbs.anqun.cn/index.php:76<br />
/bbs.anqun.cn/theme/anqunpi/login.php:286<br />
/bbs.anqun.cn/theme/anqunpi/login.php:611<br />
/bbs.anqun.cn/index.php:1188<br />
) 1062: Duplicate entry '2' for key 3<br />
Query: UPDATE fud26_ses SET user_id=2, sys_id='0f3694db960fdc2476760054e7979590' WHERE ses_id='fed47b919efcb9dc07abfb569505acd3'<br />
_GET: array (
't' => 'login',
)<br />
_POST: array (
'login' => 'LiuJia',
'password' => '88888888,
'SQ' => '0',
'adm' => '',
)<br />
Server Version: 4.1.22-standard-log<br />
[Referring Page] http://bbs.anqun.cn/index.php/l/<br />
|
|
|
|
|
|
Re: Fatal Error: I cannot log in anymore [message #39400 is a reply to message #39383] |
Sun, 21 October 2007 15:52 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
If it happens again, could you please send me the contents of your session records (relating to the user who cannot login) from the sessions table.
FUDforum Core Developer
|
|
|
|
|
Re: Fatal Error: I cannot log in anymore [message #39448 is a reply to message #39442] |
Tue, 23 October 2007 04:52 |
nectar2
Messages: 26 Registered: April 2005
Karma: 0
|
Junior Member |
|
|
I just tried, not sure. Here it is.
Relating session table:
INSERT INTO `fud26_ses` (`id`, `ses_id`, `sys_id`, `user_id`, `action`, `forum_id`, `time_sec`, `data`, `returnto`) VALUES
(47763, '1b6b8cc54fd45900adc3cb641933b21a', '0f3694db960fdc2476760054e7979590', 2077447306, '浏览论坛<a href="index.php/f/2">HostMonster</a>', 2, 1192167442, NULL, '/f/2/?');
Error at sql_errors:
1.
Quote: |
?559 ?1192717791?(/home/enchorg/public_html/bbs.anqun.cn/index.php:76<br />
/home/enchorg/public_html/bbs.anqun.cn/index.php:315<br />
/home/enchorg/public_html/bbs.anqun.cn/theme/anqunpi2/index.php:41<br />
/home/enchorg/public_html/bbs.anqun.cn/index.php:1199<br />
) 1030: Got error 127 from storage engine<br />
Query: UPDATE fud26_ses SET sys_id='0f3694db960fdc2476760054e7979590', forum_id=0, time_sec=1192717791, action='浏览<a href=\"index.php/i/\">论坛列表</a>', returnto='' WHERE id=62236<br />
Server Version: 4.1.22-standard-log<br />
|
2.
Quote: |
?622 ?1192718894?(/home/enchorg/FUDforum/include/theme/default/db.inc:73<br />
/home/enchorg/FUDforum/include/theme/default/users_reg.inc:266<br />
/home/enchorg/public_html/bbs.anqun.cn/adm/admloginuser.php:22<br />
) 1062: Duplicate entry '2' for key 3<br />
Query: UPDATE fud26_ses SET user_id=2, sys_id='0f3694db960fdc2476760054e7979590' WHERE ses_id='50ef4a07fc0b56ade27e8e6f55e88f62'<br />
_POST: array (
'SQ' => '0',
'login' => 'LiuJia',
'passwd' => 'mypassword',
'btn_login' => 'Login',
)<br />
Server Version: 4.1.22-standard-log<br />
[Referring Page] http://bbs.anqun.cn/adm/admloginuser.php?&SQ=0<br />
|
3.
Quote: |
?705 ?1192730346?(/home/enchorg/public_html/bbs.anqun.cn/index.php:76<br />
/home/enchorg/public_html/bbs.anqun.cn/theme/anqunpi2/login.php:286<br />
/home/enchorg/public_html/bbs.anqun.cn/theme/anqunpi2/login.php:618<br />
/home/enchorg/public_html/bbs.anqun.cn/index.php:1199<br />
) 1062: Duplicate entry '2' for key 3<br />
Query: UPDATE fud26_ses SET user_id=2, sys_id='0f3694db960fdc2476760054e7979590' WHERE ses_id='50ef4a07fc0b56ade27e8e6f55e88f62'<br />
_GET: array (
't' => 'login',
)<br />
_POST: array (
'login' => 'LiuJia',
'password' => 'mypassword',
'SQ' => '0',
'adm' => '',
)<br />
Server Version: 4.1.22-standard-log<br />
[Referring Page] http://bbs.anqun.cn/index.php/l/<br />
|
|
|
|
Re: Fatal Error: I cannot log in anymore [message #39455 is a reply to message #39448] |
Tue, 23 October 2007 15:24 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Got error 127 from storage engine implies some error on MySQL end. It may cause subsequent errors to happen. After the error have you tried running REPAIR TABLE?
FUDforum Core Developer
|
|
|
|
|
|