Can't log in as regular user

Nuke Cadet Joined: Aug 08, 2008 Posts: 8

I have to tell ya, phpnuke is a pain in the rear. I have tried for a month to get it running. Luckily I still have my forum running on phpbb. I have managed to correct the db issues and mail issues. But I still can't log in as normal user. I can sign in through the admin.php but not through the "Your Account" from main page or forum. I registered a test account named "test" with a short password, recieved the confirmation email, followed the link and received "Your account has been activated.....click here to sing in....". After doing so, I get an error "Login Incorrect! Please Try Again...". So I go and look in db and no user is there. Again I create test account, check in db and the account is in nuke_users_temp table. Then proceed to check mail, follow link and try to log in. Still get an error "Login Incorrect! Please Try Again...". I go back and check db, the nuke_users_temp table is empty and the account "test" is nowhere in db. I've spent days, weeks searching to find a solution for this. I have to tell ya, I am not impressed with phpnuke. I had my phpbb forum up in less than 30 minutes.

Captain Joined: Sep 13, 2003 Posts: 313

Check the PHP-Nuke Administration Panel, if the Your_Account Module is available for all visitors and not only registered members.

Nuke Cadet Joined: Aug 08, 2008 Posts: 8

As of right now, everything is set to "All Visitors" for testing purposes. This forum has not been made to the public yet. The thing is, no users are being created in db except for the "God" account. When I try to register a test account, it shows up in db in the temp table, but then gets deleted and never creates user account. I've tried to manually create user in admin, but comes up blank page and nothing happens. I have error checking turned on but no errors show.

Site Admin Joined: Aug 17, 2003 Posts: 12388

What version are you using? Please post the structure of your users table

Nuke Cadet Joined: Aug 08, 2008 Posts: 8

Version is 7.5 downloaded from this site. Can't see how to do attachments, you can get it here:

http://74.193.52.91:81/files/nuke_users.sql

Nuke Cadet Joined: Aug 08, 2008 Posts: 8

Also, when I import the nuke.sql, I get this error and only get 33 tables:

Code:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 457
STR: </
SQL:
INSERT INTO nuke_blocks VALUES (2, 'admin', 'Administration', '<big>�</big> <a href="admin.php">Administration</a> \r\n<big>�</big> <a href="admin.php?op=adminStory">NEW Story</a> \r\n<big>�</big> <a href="admin.php?op=create">Change Survey</a> \r\n<big>�</big> <a href="admin.php?op=content">Content</a> \r\n<big>�</big> <a href="admin.php?op=logout">Logout</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2, '0', 'd', 0);

SQL query:

INSERT INTO nuke_blocks VALUES (2, 'admin', 'Administration', '� Administration
\r\n� NEW Story
\r\n� Change Survey
\r\n� Content
\r\n� Logout', '', 'l', 2, 1, 0, '985591188', '', '', 2, '0', 'd', 0);

MySQL said: Documentation
#1366 - Incorrect string value: '\xB7</big...' for column 'content' at row 1

If I cut and paste the content of nuke.sql into "SQL" section of phpmyadmin and hit "go", all tables get created (I assume). It lists 88 tables.

Nuke Cadet Joined: Aug 08, 2008 Posts: 8

I finally figured out what the problem was, I had MySQL 5.0 installed. There is a bug in that version that does not write to tables when creating user. I downgraded to 4.1.15 and my Nuke portal is now fully operational.

Site Admin Joined: Aug 17, 2003 Posts: 12388

MySQL version would help next time
http://evaders.swrebellion.com/forums/postt60.html