XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Xoops 2.2 - Loss of user accounts
Register
1
tic174
Xoops 2.2 - Loss of user accounts

  • 2005/7/30 16:08

  • tic174

  • Just popping in

  • Posts: 11

  • Since: 2003/12/9


Hey there,

Ive just updated to XOOPS 2.2 (btw its amazing! great job ) and ive just noticed that two of my most active users on my sites accounts have gone missing.
We have hundreds of inactive accounts and i dont know if any of them have gone missing.

The question that i have is, is there any way of getting back those two lost accounts?

Thanx alot

[WPC]Tic

2
jdseymour
Re: Xoops 2.2 - Loss of user accounts

Check your backup of the database before the upgrade. Look at the new structure and try to insert them into the database via querry. Not sure all their setting would be correct though.

I assume that you did search the database for their account first though.
3
tic174
Re: Xoops 2.2 - Loss of user accounts

  • 2005/7/30 16:17

  • tic174

  • Just popping in

  • Posts: 11

  • Since: 2003/12/9


Quote:
search the database


Of course i did well er.... no

Dont suppose you made one of those great flash tutorials on how to search the database? Or know where i can find out how to do that?

Thanx alot m8

4
jdseymour
Re: Xoops 2.2 - Loss of user accounts

No but I do have a couple of articles for making regular backups of your database. Both are spotlighted on my sites front page.

Browse the user table in phpmyadmin to see if the accounts are there.
5
rowdie
Re: Xoops 2.2 - Loss of user accounts

  • 2005/7/30 16:28

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


To search for your user in the database run the query:

SELECT * FROM `xoopsprefix_users` WHERE uname='lostuser' OR loginname='lostuser' OR name='lostuser'


Replace xoopsprefix with your actual prefix, and lostuser with the name of one of the missing users. Do them one at a time.
6
tic174
Re: Xoops 2.2 - Loss of user accounts

  • 2005/7/30 16:31

  • tic174

  • Just popping in

  • Posts: 11

  • Since: 2003/12/9


Hey guys,

I`d better ask solo, about that database stuff, if i poke around in there knowing me il probably mess it up worse then i have done

Il post back with what he says.

Thanx alot for the help.

7
solo71
Re: Xoops 2.2 - Loss of user accounts

  • 2005/7/31 15:30

  • solo71

  • Module Developer

  • Posts: 941

  • Since: 2003/1/29


Ok, I think I have found the problem. All your users are still there Tic: Oaksy, Tiddles, and so on. Except that for the users you can't see, they don't have filled in the 'name' field.

Remember the new authentification system requires to have 3 level login: name, username and password.

In your case, any users having left the 'name' field blank, seems to have diseappeard.

What can we do in this case?

8
m0nty
Re: Xoops 2.2 - Loss of user accounts

  • 2005/7/31 15:35

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


ask em to login with their username and then fill in their display name by editing their profile..

or manually edit the db find their username and then add it manually :)
9
tic174
Re: Xoops 2.2 - Loss of user accounts

  • 2005/7/31 21:10

  • tic174

  • Just popping in

  • Posts: 11

  • Since: 2003/12/9


Hey guys,

I asked them to log in and fill in their display name, and he said he gets this messege when he tries to log in.

Quote:
says the user is either deactivated or isnt activated yet


Also he said when he tried to re-register he got this messege:-

Quote:
i tryed to reregester . but says the name and email address is already taken


I dont know if any of that help at all?

Thanx alot for the help guys.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

342 user(s) are online (305 user(s) are browsing Support Forums)

Members: 0

Guests: 342

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits