Previous Thread
Next Thread
Print Thread
Hop To
Anonymous
Unregistered
Anonymous
Unregistered
After upgrading to 6.0.1 from 5.5.1, 700 users have disapeared from the database.

/Stefan

Anonymous
Unregistered
Anonymous
Unregistered
Hmm, no DELETE statements were issued for the w3t_Users table. If you manually query the db, does it give any results:

SELECT * FROM w3t_Users WHERE U_Username='usernameinquestion'

-------------------
Rick Baker
UBBThreads developer

Anonymous
Unregistered
Anonymous
Unregistered
When I query a user I know exist I will get an answer, otherwise not!

It should be around 2300 users, but after the upgrade only 1619.

/Stefan

Anonymous
Unregistered
Anonymous
Unregistered
Did any of your admins use the purge old users function? I really don't see any other way that the users could have been deleted. I just double checked the altertable files and there were no delete statements against the w3t_Users table.

-------------------
Rick Baker
UBBThreads developer

Anonymous
Unregistered
Anonymous
Unregistered
No, I haven't used that feature(I'am the only admin).

I have also noticed that some users are not searchable by their usernamn from the admin section on my current forum.

/Stefan

Anonymous
Unregistered
Anonymous
Unregistered
I have noticed that a lot of users cant be found searching by the Username, email or whatever. The only way they can be found is to list them by their letter with the "Show User" tool. But if I choose "All Users" they are not shown.

Most of the users that are invisible have been registered within 9 months but not all!? Some users have been registered 4 weeks ago and still works.

Users that are invisible do work fine at the moment but when I try to upgrade they don't work anymore but they still exist in the databse.

Please help!!

/Stefan

Anonymous
Unregistered
Anonymous
Unregistered
Has this problem been nailed yet??

I've got 6.0.2 up and going, and found at least one user that isn't showing up in the user list at all, they do show in the who's online while they're using the system, but not in the user list, nor does searching for them via the admin section.

They do show up in the database via phpmyadmin.

Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo

Anonymous
Unregistered
Anonymous
Unregistered
Rick,

I think I may have figured out why I'm missing about 80 users. Looks like the U_approved flag is not set for some users. I picked one and put yes in that field and viola that user showed up in the user list.

What would be the syntax to issue a command via phpmyadmin to run through and approve every record?

As a side note, I selected approve users and no one showed up in that, so the system knows they're there, but doesnt' know show them there, nor does it know to put them in limbo waiting to be approved.

Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo

Anonymous
Unregistered
Anonymous
Unregistered
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by so00:
I have noticed that a lot of users cant be found searching by the Username, email or whatever. The only way they can be found is to list them by their letter with the "Show User" tool. But if I choose "All Users" they are not shown.
</font><hr /></blockquote><font size="" face="">You have that problem too? I've had that problem for as long as I can remember. Some users I can type in their exact username just fine, they show up. Other users don't, but if I do a search by letter they show up fine. It boggles my mind <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Anonymous
Unregistered
Anonymous
Unregistered
Actually I figured mine out.

Running 6.0.2 now, and I noticed that the users that were missing were set to 'not approved' go into your database directly via phpmyadmin and take a look, soon as I changed the approved flag to yes they showed back up where they belong.

Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo

Anonymous
Unregistered
Anonymous
Unregistered
I really need some help on this one.

Exampel user Calle_B (UBBt 5.5.1)
Can't be found using Calle_B as the searchword using the admin tool. But if I browse users by the letter "C" it shows up.

If I do an SQL query the user can be found using this search pattern, select * from w3t_Users where u_username like "Calle_B%"
But not with this one, select * from w3t_Users where u_username like "%Calle_B%"

When I try to upgrade the Altertable script can't find the user.

/Stefan

Anonymous
Unregistered
Anonymous
Unregistered
Can the problem be that I have switched "Allow special characters" On and Off. It have been turned Off most of the time.

/S

Anonymous
Unregistered
Anonymous
Unregistered
Did the missing users have special characters in their usernames?

Regards,

Brett Harris
Infopop Corporation

Anonymous
Unregistered
Anonymous
Unregistered
so00

Silly question... but you didn't mention it. You did run the altertable5.5-6.0.php script when you upgraded right?

What happens when you go under admin and click "approve new users". Does anyone come up under there as unapproved?

<img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

"Happiness comes through doors you didn't even know you left open. "

Anonymous
Unregistered
Anonymous
Unregistered
If not, you can search for users whose U_Approved flag is set to IS NULL

Chances are pretty good that may have happened and doing a mass update will get them back.

Regards,

Brett Harris
Infopop Corporation

Anonymous
Unregistered
Anonymous
Unregistered
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by Brett Harris:
If not, you can search for users whose U_Approved flag is set to IS NULL
</font><hr /></blockquote><font size="" face="">To clearify some things here!

1. I haven't uppgraded my "live" forum yet so the problem is with 5.5.1 not the upgrade (Maybe I should start a new topic :-))

2. I have tried to upgrade but on a copy.

3. The strange users can't be found at all after the upgrade.

4. In 5.5.1 there is no Aproved field.

5. On the main page the total number of users that are displayed are correct but when I check under Admin -> User Stat, the number of users is aprox 1000 less.

6. At some point I did some modifications to the Index thing that was recomended a while ago. Can it be something wrong there? How can I check that the db structure is ok?

Thanks!

/Stefan

Anonymous
Unregistered
Anonymous
Unregistered
When you say "can't be found" are you saying that you can't find them in the database with something like phpMyAdmin or that you can't find them with a query in the ubb.threads user query tool?

Regards,

Brett Harris
Infopop Corporation

Anonymous
Unregistered
Anonymous
Unregistered
They can't be found with ubb.threads user query tool or phpMyAdmin.

/s

Anonymous
Unregistered
Anonymous
Unregistered
If they are totally gone and cannot be found with either tool then I would recommend that you ask them to re-register and then change the profile fields in the database to give them them correct number of posts, etc.

As Rick noted, there are no 'delete' statements issued from the import scripts so they may have been dropped on the way over.

Regards,

Brett Harris
Infopop Corporation

Anonymous
Unregistered
Anonymous
Unregistered
I don't like idea to tell the users to register again and to change the settings for 1000 users!

What if I upgrade and the problem still exist?

The users are in the db at the moment and they can login so the users do not experience any problems. It must be a way to keep them during the upgrade.

/Stefan

Anonymous
Unregistered
Anonymous
Unregistered
So you had tried this upgrade on a practice copy of your real database, right?

If so.... did you try it a second time on another copy to see if the users are lost again?

"Happiness comes through doors you didn't even know you left open. "

Anonymous
Unregistered
Anonymous
Unregistered
If that one user re-registers you won't need to chagne any settings for anyone else - maybe just the post counts for that one member, and that's only if they are concerned about it.

Why that one member is missing I can't answer and again, as Rick noted - there are NO delete statements issued during the upgrade.

If you want to delete the database, create a new one and do the import again you can try and see if they come over in a new import.

Regards,

Brett Harris
Infopop Corporation

Anonymous
Unregistered
Anonymous
Unregistered
You can always reimport them into a site which you setup but did not change any settings on (allow special characters) and see if they show up in that installaion.

Regards,

Brett Harris
Infopop Corporation

Anonymous
Unregistered
Anonymous
Unregistered
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by Brett Harris:
You can always reimport them into a site which you setup but did not change any settings on (allow special characters) and see if they show up in that installaion.

Regards,

Brett Harris
Infopop Corporation</font><hr /></blockquote><font size="" face="">The database was corrupt so I tried to repair it but it failed and the db fell apart totally. I had a backup of the db but 1000 users were missing. The damage is done and now I can upgrade ;-)

[This message was edited by so00 on September 18, 2002 at 04:29 AM.]

Anonymous
Unregistered
Anonymous
Unregistered
If you still have the users in the old ubb format then you can reimport the whole installation into a development database and see if they make it over.

If they were lost then I suspect that they were corrupt or did not match the criteria for viable accounts or one of them was corrupt and that caused the row counting to be off for the remainder of the import.

Did you lose all your Members AFTER a certain point? Meaning 399 - 1099?

Regards,

Brett Harris
Infopop Corporation


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Better moderator notification answer
by Morgan - 07/24/2021 7:29 AM
well this sucks..
by Bad Frog - 07/21/2021 6:15 PM
What does it mean?
by Morgan - 07/14/2021 3:21 AM
Who's Online Now
1 members (Gizmo), 59 guests, and 96 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5