FUDforum: Bug Reports » Random forum lockouts...

Home » FUDforum Development » Bug Reports » Random forum lockouts...

Show: Today's Messages :: Polls :: Message Navigator

Re: Random forum lockouts... [message #41023 is a reply to message #41013]

Thu, 08 May 2008 16:23

krbvroc1

Messages: 31
Registered: February 2005

Karma:

Member

This happened from completely different computers.

We traced the problem down to the following:

We have external code that populates the fud26_users table from another database source (single sign on).

When I cleared out the fud26_users table to import that info, the special magical 'Anonymous Coward' user with id 1 is removed. If that id is removed, it is impossible to log into the forum even as admin because 'guests' are mapped to that id 1 when it comes to session management. FUDforum issue an invalid SQL command because it leaves off the id in the WHERE clause during ses_update_status().

You can reproduce this simply by removing id 1.

Now we know that we need to leave the special user with id 1 alone or fudforum is inoperable (even adm).

The lesson is that if you ever custom populate your users table be sure to keep/insert the id 1.

Report message to a moderator

[Message index]

		Random forum lockouts... By: krbvroc1 on Wed, 07 May 2008 04:03
		Re: Random forum lockouts... By: Ilia on Wed, 07 May 2008 23:48
		Re: Random forum lockouts... By: krbvroc1 on Thu, 08 May 2008 16:23

Previous Topic:	alias and brackets
Next Topic:	Problem with RSS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 07:45:14 GMT 2024

Total time taken to generate the page: 0.04015 seconds