I've spent a few days searching in here for some help but couldn't find anything.

I've just recently upgraded my older 6.0.2 to 6.2.3. My first problem is new users can not register.

http://www.filambasketball.com/ubbthreads/newuser.php?Cat=

And I'm finding that some of the forms say in the profile pages have radio buttons with the text missing. You'll see a example in the newuser page as well...

Please help.

Looks like you're missing a lot of language strings.

Try reuploading the complete clean /languages directory. There have been lots of changes in this area.

Hi Josh,

First of, thanks for the prompt response. I re-uploaded a clean /languages folder and that fixed the missing text and login problem until it comes to the confirmation portion of the reg.

I get this error:

"We were unable to find the account to verify. If this account was registered over 24 hours ago then you will need to re-register as it has been deleted. Otherwise, please check your confirmation email and make sure you followed the link correctly.

Please use your back button to return to the previous page. "


I've registered 3 separate times with different emails and this is what happened the last time I registered.

I also tried to search for those names via the search function available in the Admin are but it said that it could not locate the username/email...

Please help.

Do you have User Registration Approval on in the control panel?

Look under Admin -> Config Settings -> User Registration Settings

It says "Approve all new user registrations? (An email will be sent to all Admins when a user registers after they verify their email if this option is turned on)"

Or take a look at the Admin panel under User Management -> Approve New Users and see if the accounts you registered are there...

Just tossing out a couple ideas...

Hey Zack,

Thanks but I did not enable those functions but just in case I even checked twice to make sure...

Any other ideas? Josh?

I tried registering by specifing a password and having it generate one both. It gives the above error when following the link from the email.

When trying to use the login link it gives the follow result:

The email for this account has not yet been verified.

When I try to register the same login name it returns:
Login Name exists

So it is making the appropriate entries into the database, it seems to be isolated to the verify email portion. Perhaps an interim solution would be to turn off email verification until this gets fixed. That way people will still be able to sign up for the board.

I just created an account and logged right in. You must have disabled email checking.

yes.. i c u. Hopefully we can resolve this. I'd at least like to have valid emails....

Thanks for the temp solution.

Unfortunately, it appears that those who registered while email verification was on still need to to verify thier email.

I really have no idea why this would be happening. Do you have mods installed or is everything stock. If everything is stock I would recommend simply reuploading everything. If you have mods installed, which mods. Well, I guess it is pretty obvious looking at your site that you IIP installed, but those are minor changes that shouldn't affect this. So if you could list any other mods you have installed or let us know if it is otherwise stock that might help us track down this problem.

I've installed the chat mod, calendar mod (which after upgrading removed the calendar interface) and that's about it...

I'll try to re-upload again. Do you suggest removing all files, then doing a clean upload?

Any help is greatly appreciated.

Do this SQL Query for me (within 24 hours) LOL


SELECT U_Approved, U_Number
FROM w3t_Users
WHERE U_Username = 'joshpet2'

Hi Josh,

I know it's friday night... Sorry. But I have phpMyAdmin installed and I ran query. Still very very new at this prog so kindly bare with me.

I do see you entry, but don't know what I need to be looking for. I am ready for instruction...

Ok..

U_Approved = sKE
U_Number - 1438

current board stats say = 1402

No problem.... my test entry would be automatically deleted in 24 hours so I was curious what it said.

Hmmm....

I think I see the problem........

The U_Approved field seems to be truncated at 3 characters. Are you sure you ran all the altertables?

Try this:

ALTER TABLE w3t_Users
CHANGE U_Approved
U_Approved VARCHAR( 8 ) NOT NULL

That should fix the database field..... now everyone who was goofed up.... let's set them as email verified so that they can login.

UPDATE w3t_Users
SET U_Approved = 'yes'



Now try registering a user and see if that's fixed.

Wow... you are the man!!! I am forever grateful.

I've been able to log in. And the new user usually receivess a welcome PM. It shows new PM available but nothing is in the inbox.

I screwed up earlier and ran the altertable script twice. Lost all my PM's... I can deal with that for now unless you know of a fix...

Once again, thank you!

I also went ahead and removed both your username(s) and Zack's from the DB.

Forgot to thank Zack as well! Thanks Zack!

No running the altertables twice will royally hose things. The only way back with the PMs is to restore a backup and try again.

If the PM isn't showing up, it's usually because you don't have a User#2 (the super admin for the site).


Try this Query:


SELECT U_Username
FROM w3t_Users
WHERE U_Number = 2

Gives me error when I try to edit:

querywindow.php: Missing table

There is no querywindow.php in UBB.Threads?

Admin -> SQL Command

then enter it in the box and see if it reutrns any results.

not sure what you want me to do...?

PLease explain

Ohhh.. duh,

Sorry.

here is my result:

Here are the results of your command: "SELECT U_Username FROM w3t_Users WHERE U_Number = 2 ".
U_Username

OK - you don't have a user number 2.

It's in theory impossible to delete it... but somehow it's gone. It's supposed to be the main admin for the site.

You might want to create a user (maybe named "Admin" or something) and make it an administrator... then change it's user number to user #2.

Then the private messages will appear.

ok... I can do that. Bu twhat is the command to change that new user Admin to User 2

First find out their existing user number

UPDATE w3t_User
SET U_Number = 2
WHERE U_Username = 'whatevername'

OK... done.

Still no PM's

That'll only fix the welcome PM that people recieve when they sign up.

It sounds like you've got major database problems if you ran the altertables twice.

You might want to restore your backup and try again.

Run ALL the altertables from your old version to the version you installed ONLY once. Then you shouldn't have so much trouble. If the database structure isn't right, you'll continually encounter issues like this.

Can you help clean everything up? I don't have much but what's your rate?