|
Joined: Aug 2003
Posts: 24
Newbie
|
Newbie
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.
|
|
|
|
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
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
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
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?
|
|
|
|
Joined: Jun 2003
Posts: 1,025
Junior Member
|
Junior Member
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
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
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
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
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.
|
|
|
|
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
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
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
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
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
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
Joined: Aug 2003
Posts: 24 |
not sure what you want me to do...?
PLease explain
|
|
|
|
Joined: Aug 2003
Posts: 24
Newbie
|
Newbie
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
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
Joined: Aug 2003
Posts: 24 |
|
|
|
|
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
Joined: Aug 2003
Posts: 24 |
Can you help clean everything up? I don't have much but what's your rate?
|
|
|
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.
|
|
Posts: 449
Joined: February 2008
|
|
Forums63
Topics37,574
Posts293,926
Members13,850
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|