login problem

Posted: Mon May 05, 2003 2:05 am

i am having a problem logging into my site as well as logging into nukecops (thats why i'm in the guest forum)

i was trying to import some forum topics and posts from a regular phpbb 2.0.4 site into my nukebb site using phpmyadmin, and somehow messed up the user table. now my site has no users, and when i login as admin to create one, after submitting the form, admin.php hangs.

i started to think it was a cookie related problem, as i couldn't even login to nukecops, so i deleted all my cookies from three different computers with still no success.

my site is www.tulsamusicpulse.com
please help.

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

From time to time the NC server gets a little bit cranky (unlike the moderators Laughing

) and doth protest a bit too much and it's hard to get logged in. But, now that the Master ZH has returned, things should be getting back to normal!

Having said that, the 2 are most likely unrelated - problems with your site and problems here, unless your ISP is having problems. What kind of login problems are you having?

Posted: Mon May 05, 2003 3:28 pm

well, i tried to migrate a forum over from another site by copying the contents of some mysql tables thru phpmyadmin:
php_forums, php_posts, php_posts_text, php_users, etc and then renamed them to the appropriate bb names.
this of course caused a few problems with my users, becuase this new site had only a few and the phpbb forums had more, so i had to try to recreate some users on my nuke site, but then when i tried to create them thru the admin panel, i'd fill out the form, then submit and admin.php would freeze as it posted the info to the db. then i'd look and nothing had been inserted.

i'm only assuming that this problem is related to the mysql tables cuz that is the last thing that i tried to mess with. at this point, i just want my orig tables back and will recreate the users that i had by hand. is there any way someone can send me a .sql file with the necessary structure to reinstall the forums only cuz i have alot of info added to the rest of my site....but no users Rolling Eyes

so i guess, really this is a 'user creation' problem and not really a 'logging in' problem cuz i have no users to log in. when i did have users and would try to login, it would continuously refresh the login page saying 'login incorrect!'

Posted: Mon May 05, 2003 3:58 pm

You need to use the same MD5 key as the old site, otherwise it won't work.

Posted: Mon May 05, 2003 4:12 pm

ok cool....um can you explain that a little better tho?

(note that i finally got logged into NC) Razz

Posted: Mon May 05, 2003 4:38 pm

in the config file, you see a long string of alphanumeric charachters (numbers and letters) make sure that the new config file has the same numbers as the old config file

Posted: Mon May 05, 2003 5:40 pm

at this point, i would just like to start from scratch on my forums and users. the sitekey's (is this the number you're referring to?) appear to be the same.

i emptied all the mysql tables and just want to start adding forums and users from scratch, but the admin page freezes and only echoes the header info, and it won't log ppl in as if they were just joining the site.

i somehow had someone manage to join now but i can only see the entry thru phpmyadmin, when i go to the members list i get:

Code:

phpBB : Critical Error

Could not query database for theme info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '' at line 3

in phpmyadmin, the user was inserted into the nuke_users_temp table and the nuke_users table is empty. then, after account activation, they go to login and it says login incorrect.