Database error with Your_Account 750_441 - help!

New Member Joined: Jul 19, 2005 Posts: 9

Hi folks,

I am brand-new to PHP-Nuke and know little PHP and even less SQL, so you'll have to bear with me.

My problem is this - I installed Your_Accoun 750_441 on my PHP-Nuke 7.3 installation according to the instructions in the archive. The scripts seem to run properly but:

1. I can't see any of my already-registered users.
2. When I try to register as a test new user the process bombs out at the end with a very unhelpful "ERROR: There was a problem with the database." No email is sent and no user info is registered.

I've seen some postings here that allude to the fact that there may be extra fields in the SQL database or that the install is missing some scripts. I have no clue and would really appreciate some guidance.

I did notice that when I ran the cnbya.php script to install the tables one field (I think it was a "ALTER users_temp" field or something like that) failed.

Anyway, thanks in advance for any help that can be provided.

Oh, and if you like Tempest, check out my site at http://www.chaosreins.com. Don't try to register as a new user though! Smile

-Rick

Posted: Tue Jul 19, 2005 11:07 am

Check that the _users_temp field was created in your database.

Posted: Tue Jul 19, 2005 11:55 am

Therein lies the problem, my friend. Not being a SQL person, I couldn't even begin to know how to do that. May I indulge you for an explanation?

Posted: Tue Jul 19, 2005 12:17 pm

Actually, I think was able to insert the field "_users_temp" into the database with the correct parameters (by reading the cbnya.php file) but I still get the same error when I try to sign up as a new user.

Posted: Tue Jul 19, 2005 2:59 pm

Ok lets back up a little what config settings are you using (the ones that control registrations).

Also check this thread for any of the old errors especially the missing field one mentioned. nuke_cnbya_config doublecheckemail
http://www.ravenphpscripts.com/postt3629.html

To check the fields you simply go to phpmyadmin (or what you have available) and select your nuke database and from there its pretty simple to examine the table names and fields that are in them.

Posted: Tue Jul 19, 2005 9:17 pm

I created an archive of three screenshots of the configuration settings within Nuke you can get it at http://homepage.mac.com/rickciervo/FileSharing13.html. I wasn't sure if you wanted the settings directly from MySQL and since I'm not very adept at navigating phpMySQL, I did it this way. If this isn't good enough to work with, let me know and I'll get you what you need if I can.

I looked at the threads you suggested but they didn't help too much, mostly because I don't really understand them! Sad

I really appreciate your taking the time to help such an obviously clueless person.

One more thing, I was able to add a new user from within Nuke - at least the user appears to exist in the database if I search for the username (within Nuke). However I can't sign in as this person, nor will Nuke send a confirmation email to the address I set for that user. I get the "Login Incorrect! Please Try Again..." message when I try to sign in. Does this help?

-Rick

Posted: Wed Jul 20, 2005 6:45 pm

I get a not 404 found on that page. Sad

Posted: Thu Jul 21, 2005 5:35 am

Sorry about that - you're right, th link is broken. Try going to http://homepage.mac.com/rickciervo and then selecting "My Downloads". The config images zip is the only file there. And feel free to look at some old pictures of my kids! Smile

Posted: Thu Jul 21, 2005 6:24 am

More troubleshooting details - I can use the YA feature to change my password (using the "Forgot My Password" link in the sigin in page) for the test user that I created. YA will send an email to the test user's email address and I can do that whole process, but I cannot actually log in after the password is changed. Still can't create a user the regular way either - I have to do it from within Admin and no confirmation emai is generated. Sad

Posted: Thu Jul 21, 2005 8:33 pm

rickciervo Should be all set I installed the old 4.4.0 version biggest trouble was the users_temp table wasn't being created. I'd hold off on updating the version until the next release.

Good Luck!
sixonetonoffun

Posted: Thu Jul 21, 2005 8:38 pm

Ahhhhh - you are a god!!!!

Thank you!!!!

See, this is what I get for dabbling in stuff I only half understand. Smile

-Rick

Posted: Thu Jul 21, 2005 8:46 pm

One last thing (isn't there always one last thing?!?) - when I go to admin, I see an error (misspelled by the way - it says "YOU DATABASE" and I think it should be "YOUR DATABASE") (all you database belong to us) that tells me to upgrade my database because the script is 4.4.0 and the database is 4.4.0 b2. Can I ignore this or do I really have to run cnbya.php again and possibly hurt myself again? Sad

-Rick

Posted: Thu Jul 21, 2005 9:41 pm

Crisis averted - I ran the script and upgraded the tables. All is well and the error message is no longer displayed.

Once again, thanks!!!! Smile

!

Posted: Thu Jul 21, 2005 10:41 pm

lol I guess the installer needs some better error checking but yeah I'm glad things worked out !!!!!!!!