Previous Thread
Next Thread
Print Thread
Rate Thread
#257783 08/29/2003 1:07 PM
Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
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.

Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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.

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
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.

Joined: Mar 2001
Posts: 644
Member
Member
Offline
Joined: Mar 2001
Posts: 644
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...

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
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?

Sponsored Links
Joined: Jun 2003
Posts: 1,025
Junior Member
Junior Member
Offline
Joined: Jun 2003
Posts: 1,025
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.

Joined: Mar 2001
Posts: 644
Member
Member
Offline
Joined: Mar 2001
Posts: 644
I just created an account and logged right in. You must have disabled email checking.

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
yes.. i c u. Hopefully we can resolve this. I'd at least like to have valid emails....

Thanks for the temp solution.

Joined: Jun 2003
Posts: 1,025
Junior Member
Junior Member
Offline
Joined: Jun 2003
Posts: 1,025
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.

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
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.


Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Do this SQL Query for me (within 24 hours) LOL


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

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
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...

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
Ok..

U_Approved = sKE
U_Number - 1438

current board stats say = 1402

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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.

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
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!

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
I also went ahead and removed both your username(s) and Zack's from the DB.

Forgot to thank Zack as well! Thanks Zack!

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
Gives me error when I try to edit:

querywindow.php: Missing table


Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
There is no querywindow.php in UBB.Threads?

Admin -> SQL Command

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

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
not sure what you want me to do...?

PLease explain

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
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





Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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.

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
ok... I can do that. Bu twhat is the command to change that new user Admin to User 2

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
First find out their existing user number

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



Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
OK... done.

Still no PM's

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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.

Joined: Aug 2003
Posts: 24
Newbie
Newbie
Offline
Joined: Aug 2003
Posts: 24
Can you help clean everything up? I don't have much but what's your rate?


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)