FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Fatal Error: I cannot log in anymore
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Fatal Error: I cannot log in anymore [message #38195] Tue, 24 July 2007 15:21 Go to next message
ron4 is currently offline  ron4   Netherlands
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 #38198 is a reply to message #38195] Tue, 24 July 2007 18:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 #38206 is a reply to message #38198] Wed, 25 July 2007 10:10 Go to previous messageGo to next message
ron4 is currently offline  ron4   Netherlands
Messages: 17
Registered: July 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
This is the message I read repeatedly in the SQL Error log:

...
1100: Table 'fud26_mod' was not locked with LOCK TABLES
Query: DELETE FROM fud26_mod WHERE user_id IN(17)
_GET: array ( 't' => 'login', 'S' => 'd7bcb706a4fc655495ec511fcc056629', )

This is very strange because all the tables are locked. Moreover, I have never even unlocked them after installing FUDforum.
I looked in the MySQL database and searched for user_id 17 in fud26_mod, it was an empty value. I entered the query to delete the value.
This has not helped, the same problem persists.

What should I do to solve this problem?



Re: Fatal Error: I cannot log in anymore [message #38212 is a reply to message #38206] Wed, 25 July 2007 18:31 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The following patch will fix the problem:

http://cvs.prohost.org/c/index.cgi/FUDforum/filediff?f=install/forum_data/i nclude/users_adm.inc&v1=1.22&v2=1.23


FUDforum Core Developer
Re: Fatal Error: I cannot log in anymore [message #38443 is a reply to message #38212] Tue, 07 August 2007 05:12 Go to previous messageGo to next message
ron4 is currently offline  ron4   Netherlands
Messages: 17
Registered: July 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I've changed the users_adm.inc accordingly, based on the patch you gave me.
Unfortunately the problem still persists, and the exact same message appears when I click on 'Login' in my forum:

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log [...]/forum/include/core.inc on line 188


Is there something else I can now to get the Login page functioning again?

Thank you very much for your help!

kind regards
Ron
Re: Fatal Error: I cannot log in anymore [message #38455 is a reply to message #38443] Tue, 07 August 2007 22:26 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you tried logging as admin via the admin login page?

http://your.forum.url/adm/

Once you login try to rebuild the theme.


FUDforum Core Developer
Re: Fatal Error: I cannot log in anymore [message #38470 is a reply to message #38455] Wed, 08 August 2007 08:27 Go to previous messageGo to next message
ron4 is currently offline  ron4   Netherlands
Messages: 17
Registered: July 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Yes, I have tried that as well. And logging in via the admin login page does work. I have rebuild the theme too, but without result.

The Fatal Error message as mentioned above still persists when I try to log in the normal way by clicking on 'Login' in the forum.

Could you please advice me what to do now?


Re: Fatal Error: I cannot log in anymore [message #38480 is a reply to message #38443] Thu, 09 August 2007 15:12 Go to previous messageGo to next message
tmuka is currently offline  tmuka   United States
Messages: 9
Registered: July 2007
Location: Michigan
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Stange, i am having the same issue loggin in and out of the forums... if i login as admin into the adm section it works fine, i just cant logout from the forum frontend...

i have made sure i have the patch above applied, and i have clicked rebuild cache, although there is no visual feedback that that has worked...

anyone have any more tips? i am new to fudforum, so it is probably something i am doing wrong... is there any documentation as far as how to set directory permissions? that seems to be my biggest hurdle at this point...

thanks!
-tony
Re: Fatal Error: I cannot log in anymore [message #38481 is a reply to message #38480] Thu, 09 August 2007 16:16 Go to previous messageGo to next message
tmuka is currently offline  tmuka   United States
Messages: 9
Registered: July 2007
Location: Michigan
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
my issue turned out to be a problem with my theme headers... it has now been resolved be using the default theme. thanks!
Re: Fatal Error: I cannot log in anymore [message #38491 is a reply to message #38481] Fri, 10 August 2007 04:33 Go to previous messageGo to next message
ron4 is currently offline  ron4   Netherlands
Messages: 17
Registered: July 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I have the exact same problem, can log in via the admin page but cannot log out anymore.

I am already using the default theme, but have now also removed my personal alterations.
Unfortunately, this has no impact on the functioning of the forum. I still cannot log in or log out via the forum frontend..

I have no idea what is going on here...I have rebuilt the theme, search, applied forum consistency - and nothing seems to work!

Does anyone have tips on what to do now?

Thanks!
Re: Fatal Error: I cannot log in anymore [message #38524 is a reply to message #38491] Sun, 12 August 2007 13:20 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you tried replacing you users_adm.inc with the one in CVS?
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/forum_data/incl ude/users_adm.inc?v=1.23


FUDforum Core Developer
Re: Fatal Error: I cannot log in anymore [message #38531 is a reply to message #38524] Mon, 13 August 2007 05:32 Go to previous messageGo to next message
ron4 is currently offline  ron4   Netherlands
Messages: 17
Registered: July 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Yes, I have tried that and unfortunately I still get the same Fatal SQL error (line 188 in core.inc) as I have quoted earlier.

Are there other changes I can apply to the 2.7.7.RC2 version that might be the reason why my log in page does not work?



Re: Fatal Error: I cannot log in anymore [message #38556 is a reply to message #38531] Tue, 14 August 2007 19:30 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Can you try this version:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/forum_data/incl ude/users_adm.inc?v=1.24


FUDforum Core Developer
Re: Fatal Error: I cannot log in anymore [message #39093 is a reply to message #38556] Wed, 26 September 2007 11:29 Go to previous messageGo to next message
nectar2 is currently offline  nectar2   China
Messages: 26
Registered: April 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Wed, 15 August 2007 07:30

Can you try this version:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/forum_data/incl ude/users_adm.inc?v=1.24


I met the same problem, and used users_adm.inc(v1.24), not ok yet.
Re: Fatal Error: I cannot log in anymore [message #39123 is a reply to message #38212] Mon, 01 October 2007 00:02 Go to previous messageGo to next message
Astoria is currently offline  Astoria   United States
Messages: 225
Registered: April 2004
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Before I was getting the error with fud26_mod. After applying the patch I am getting the same error, but for a different table -- fud26_custom_tags.

Edit: Never mind, it works now that I applied the 2nd patch.

[Updated on: Mon, 01 October 2007 00:06]

Report message to a moderator

Re: Fatal Error: I cannot log in anymore [message #39124 is a reply to message #38195] Mon, 01 October 2007 08:17 Go to previous messageGo to next message
nectar2 is currently offline  nectar2   China
Messages: 26
Registered: April 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
It's a good news, Astoria.

I have to reinstall FUDforum to resolve the problem causing users_adm.inc(v=1.24) looks not works.
Re: Fatal Error: I cannot log in anymore [message #39125 is a reply to message #39124] Mon, 01 October 2007 11:21 Go to previous messageGo to next message
Astoria is currently offline  Astoria   United States
Messages: 225
Registered: April 2004
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Can you search through your forum directory and apply the patch in place without rebuilding?

I have a test account so I used that one to test the login process, while I stayed logged in to my admin account to rebuild the theme.

[Updated on: Mon, 01 October 2007 11:22]

Report message to a moderator

Re: Fatal Error: I cannot log in anymore [message #39126 is a reply to message #38195] Mon, 01 October 2007 11:36 Go to previous messageGo to next message
nectar2 is currently offline  nectar2   China
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&gt;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' =&gt; 'login',
)<br />
_POST: array (
  'login' =&gt; 'LiuJia',
  'password' =&gt; '88888888,
  'SQ' =&gt; '0',
  'adm' =&gt; '',
)<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 #39127 is a reply to message #39126] Mon, 01 October 2007 11:47 Go to previous messageGo to next message
Astoria is currently offline  Astoria   United States
Messages: 225
Registered: April 2004
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
You wouldn't use Phpmyadmin to fix the theme; you would need to edit the files on your server. I used Cpanel file manager to replace the source file in the data directory, but I was able to rebuild the theme. You would need to figure out where the source file was included and replace it there. Your forum/adm directory is the one that has the admin login process that Ilia mentioned above - that would be a smaller file and easier to edit in the patch.

Maybe you can get that one fixed first, and then you will be able to rebuild the theme to get your regular user login back up and running.

Another way to change your files would be to do it locally and then ftp them up to your server.
Re: Fatal Error: I cannot log in anymore [message #39128 is a reply to message #39127] Mon, 01 October 2007 11:53 Go to previous messageGo to next message
nectar2 is currently offline  nectar2   China
Messages: 26
Registered: April 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks for your idea, Astoria.

Yes, if I can't rebuild theme online(can't login as admin), can rebuild theme locally and then upload to replace old theme.
Re: Fatal Error: I cannot log in anymore [message #39383 is a reply to message #38195] Fri, 19 October 2007 07:04 Go to previous messageGo to next message
nectar2 is currently offline  nectar2   China
Messages: 26
Registered: April 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I met this problem again at 2.7.7.

1. can't login at index page
2. can't login at /adm

I tried to empty 'fud26_ses' table via phpMyAdmin, then login success.
Re: Fatal Error: I cannot log in anymore [message #39400 is a reply to message #39383] Sun, 21 October 2007 11:52 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 #39403 is a reply to message #38195] Sun, 21 October 2007 11:59 Go to previous messageGo to next message
nectar2 is currently offline  nectar2   China
Messages: 26
Registered: April 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Before I empty 'fud26_ses' table, I have backup FUDforum database, if you need 'fud26_ses', I would like to supply.
Re: Fatal Error: I cannot log in anymore [message #39442 is a reply to message #39403] Mon, 22 October 2007 18:45 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Unless you know the session id your computer had at a time the dump won't help I'm afraid.

FUDforum Core Developer
Re: Fatal Error: I cannot log in anymore [message #39448 is a reply to message #39442] Tue, 23 October 2007 00:52 Go to previous messageGo to next message
nectar2 is currently offline  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='浏览&lt;a href=\&quot;index.php/i/\&quot;&gt;论坛列表&lt;/a&gt;', 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' =&gt; '0',
'login' =&gt; 'LiuJia',
'passwd' =&gt; 'mypassword',
'btn_login' =&gt; 'Login',
)<br />
Server Version: 4.1.22-standard-log<br />
[Referring Page] http://bbs.anqun.cn/adm/admloginuser.php?&amp;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' =&gt; 'login',
)<br />
_POST: array (
'login' =&gt; 'LiuJia',
'password' =&gt; 'mypassword',
'SQ' =&gt; '0',
'adm' =&gt; '',
)<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 11:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Re: Fatal Error: I cannot log in anymore [message #39456 is a reply to message #39455] Tue, 23 October 2007 12:10 Go to previous messageGo to next message
nectar2 is currently offline  nectar2   
Messages: 26
Registered: April 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Sorry, I haven't REPAIR TABLE after I Got error 127 message. I will try to do if it happen again.

Thanks for your help, Ilia.
Re: Fatal Error: I cannot log in anymore [message #40932 is a reply to message #38195] Tue, 29 April 2008 04:47 Go to previous messageGo to next message
aabio is currently offline  aabio   China
Messages: 2
Registered: April 2008
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
i have the similar problem, and still don't know how to solve.
Re: Fatal Error: I cannot log in anymore [message #40940 is a reply to message #40932] Tue, 29 April 2008 19:42 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you tried clearing out the sessions table?

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Ban privelegy, how to add?
Next Topic: Setup question - Breaking up a forum
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Oct 17 07:40:32 EDT 2017

Total time taken to generate the page: 0.01334 seconds