Geeklog Forums

Suddenly, it seems that I cannot create a new user as anoymous or even create a new user account as admin in my GL 1.3.5sr2 installation. It seems to work for others, as I see one or two new users in my listings, but it's not working for me and I have no idea why??? Is it because of the cookies on my browser?

Every time I try to create a user with login/pass that I *KNOW* doesn't exist in mySQL database, it still tells me that "The username or email address provided already exists." This happens when I do it as anoymous or as admin.

The URL is http://thane.finiserv.com.

Please help!

---

L. Whitworth

Looking at the code (in users.php, function createuser), I can't see how this function can be wrong. Please note that both the user name AND the email address must be unique - i.e. you can not create a new user that uses the same email address as someone else. bye, Dirk

I don't think the function is wrong, either. I believe it could have been caused by my deleting an user within mySQL from the gl_users table without deleting subsequent entries from the other user-related tables in mySQL. Currently I have UIDs of 1, 2, 13, 14, 15, 20, 17, 18, 19, and 3 (I deleted all Admin users except root). This is in gl_users. In the other related tables, I show extra UIDs of 0 and 4 which do not exist in gl_users. I'm assuming that deleting all rows that correspond to 0 and 4 UIDs would solve my problem, but would like to clear this with you, Dirk, or anyone knowledgable, in case the UIDs 0 and 4 are special ones that should be left alone?

---

L. Whitworth

You really shouldn't delete users in MySQL directly unless you know what you're doing ... But I guess you know that by now ;-) I'm not sure about uid 0 (I have entries with a uid 0 in some of the tables on my sites and they don't seem to cause any problems), but uid 4 has no special meaning at all. So if you don't have a user with a uid of 4 any more, you can safely delete those entries. I must admit I'm not convinced that those stray entries really are the cause of your problems, but give it a try ... bye, Dirk

Yes, I know I shouldn't be dipping my fat and grubby fingers into mySQL but I know I had a good reason for doing so... I'll dip again tomorrow and let you know what happens.

Ok... I have wiped my user database so it only has 1 (anoymous), 2 (Admin), 3 (myself), and this mythical 0 which only appears in gl_userprefs, gl_userinfo, gl_userindex, and gl_usercomment. Now, when I try to create an account, it is sucessfully saved as UID 4 *but* the username always changes to "fst_warn," no matter what I put in originally. After this, trying to create other users keep giving me "This user already exists" stuff. It looks like something to do with mySQL, but there's nothing wrong with the entries, and the users I'm trying to create DO NOT exist anywhere, no matter what GL says... Any ideas, Dirk?

---

L. Whitworth

When I go into mySQL and rename "fst_warn" to another name (test, if you must know), I can go into Users admin and create another user, but it still keeps renaming that new user "fst_warn" and I'm once again unable to create any more users. This is weird, I cannot make head nor heels of it!!! Help!!!

---

L. Whitworth

It gets weirder... I had an UID of 4, which is fst_warn, and deleted it using GeekLog user admin. mySQL shows that it is deleted, and there is NO UID 4 anymore. BUT when I type in the specific URL: http://thane.finiserv.com/public_html/admin/user.php?mode=edit&uid=4 What happens??? Yep, you guessed it... UID 4's info shows up, fst_warn and all. Where the heck is GL getting this info from if it's not in mySQL? Same thing happens with UID 5, but UID 6 shows empty as it should be. Even though UID 4 and 5 doesn't exist (doesn't show up in either GL user listing or mySQL, I can still delete them normally but it still won't let me create any new users because every time I click new user it is assigned UID 4, which for some reason GL believes still exists, though it should not. When I go ahead and make the UID 4 user, it is still being assigned the name fst_warn and I cannot even make an UID 5 or beyond. Help, please!!! This is a rabbit hole I don't really want to muck around in anymore!

---

L. Whitworth

It basically comes down to this: /admin/user.php keeps renaming any user as fst_warn upon save, which is why I cannot create any new users beyond the first fst_warn because it already exists. (deeper and deeper into the rabbit hole)

---

L. Whitworth

Err, are you using Mozilla (or possibly Netscape 6/7) as your browser? I've fallen for a similar problem before, where Mozilla saved the content of a form (the user form in Geeklog) for me and overwrote whatever Geeklog put into that form with the contents it had stored earlier. Could this have something to do with what you're experiencing? bye, Dirk

Boy do I feel silly!!! I was using a redirect script outside of /public_html which was as follows: <? $name = 'fst_warn'; setcookie("username",$name,time()+500000000); if($HTTP_COOKIE_VARS["username"] == "fst_warn" { header("location: /public_html"; } else { header("location: warn.html"; } ?> Notice the "username" variable? That's what was putting in fst_warn into the username variable upon new user save. Replaced the code with the following: <? $name = 'fst_warn'; setcookie("tvisitor",$name,time()+500000000); if($HTTP_COOKIE_VARS["tvisitor"] == "fst_warn" { header("location: /public_html"; } else { header("location: warn.html"; } ?> Everything works like a dream now!!! Thanks, Dirk, for your attempts to help this blundering Creator!

---

L. Whitworth

Something like that! See next comment in the next thread.

---

L. Whitworth