Fatal Error: I cannot log in anymore [message #38195] |
Tue, 24 July 2007 15:21 |
ron4
Messages: 17 Registered: July 2007
Karma: 0
|
Junior Member |
add to buddy list ignore all messages by this user
|
|
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 #39126 is a reply to message #38195] |
Mon, 01 October 2007 11:36 |
nectar2
Messages: 26 Registered: April 2005
Karma: 0
|
Junior Member |
add to buddy list ignore all messages by this user
|
|
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 #39448 is a reply to message #39442] |
Tue, 23 October 2007 00:52 |
nectar2
Messages: 26 Registered: April 2005
Karma: 0
|
Junior Member |
add to buddy list ignore all messages by this user
|
|
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 />
|
|
|
|
|
|
|
|