New accounts never appear

Nuke Cadet Joined: Mar 30, 2007 Posts: 1

I finally got all my smtp issues worked out but it appears I have another registration problem.

User account created, email sent, email recived.

I verify in the databas that there is an entry in nuke_users_temp and it is the correct entry.

The email link is then clicked, It takes me to the site and says I have been validated. When I actually try and login it tells me "Login Incorrect".

I check the nuke_users_temp, the nuke_users, and nuke_authors. That account is nowhere to be found! The only things in there are the anonymous account and the god account. Any refernce to that created account is now gone.

What I have already done:
1) Open modules/Your_Account/index.php:
replace: Header("Location: modules.php
with: Header("Refresh: 0;url=modules.php

2) Verified the security codes are displaying

3) confirmed the url/ip

4) tested this on FOUR different boxes with numerous accounts.

What I have
Windows 2003 SP2 R2
Apache 2.2.4
Php 5.2.1
MySql 5.0.31
PhpMyadmin 2.10.02
phpnuke 8

Any help is greatly appreciated! I am even willing willing to re verify anything. This is driving me crazy!

Posted: Wed Aug 22, 2007 6:00 am

It sounds like there is a misfire in the function that actually creates the new account within the Your Account module.

Usually this occurs when upgrades are done, as the insert statement and/or update statement is given one extra field or something is taken away. The sql statement doesn't actually fire due to an error and you are left wondering what just happened.

If you are still having this issue, what I would suggest is to check your sql statement via your phpmyadmin or mysql and validate that it is actually working in the code.

-sting