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 Modules Support forums / 
  3. Module troubleshooting 
  4.  / Xoops can't see users imported into DB
Register
1
ivan8r
Xoops can't see users imported into DB

  • 2006/3/2 19:03

  • ivan8r

  • Just popping in

  • Posts: 57

  • Since: 2003/10/1


I recently had a problem with my XOOPS site which was running 2.0.10, so I decided to dump my database into an SQL file and start over again using 2.2.3a Final. After the new version was setup, I started importing all of my old data. For some reason, the users that I imported cannot be seen within the new version of Xoops.

Is there something I can do to make these users work again without having to delete the records and start over from scratch?
Ivan Vasquez
http://www.akwebz.com
2
Herko
Re: Xoops can't see users imported into DB

  • 2006/3/2 19:18

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


Why didn't you follow the normal update procedures? XOOPS 2.2.x has a different user management module than 2.0.x, so your data will have to be tranformed into the correct data, and the XOOPS updater takes care of that.

Herko
3
ivan8r
Re: Xoops can't see users imported into DB

  • 2006/3/2 19:29

  • ivan8r

  • Just popping in

  • Posts: 57

  • Since: 2003/10/1


I didn't update because I was having serious problems with my database. I decided to create a brand new database and repopulate it with the data from my previous site. On the day that I had these problems, I was unable to post my questions to the XOOPS site (still not sure why), so I did what I thought was the best solution.

Is there any solution to my problem, or will I have to remove my imported users and add them again manually?
Ivan Vasquez
http://www.akwebz.com
4
svaha
Re: Xoops can't see users imported into DB

  • 2006/3/2 20:22

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Quote:

ivan8r wrote:
I didn't update because I was having serious problems with my database. I decided to create a brand new database and repopulate it with the data from my previous site. On the day that I had these problems, I was unable to post my questions to the XOOPS site (still not sure why), so I did what I thought was the best solution.

Is there any solution to my problem, or will I have to remove my imported users and add them again manually?

Maybe the best thing to do is install 2.0.10 again, then fill your database with the data you have in your sql file and then update to 2.2.3
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
5
ivan8r
Re: Xoops can't see users imported into DB

  • 2006/3/2 20:53

  • ivan8r

  • Just popping in

  • Posts: 57

  • Since: 2003/10/1


That solution is not feasible for me right now. I have a bunch of users that have already been waiting since last week to have the site operational, so starting over again just isn't possible right now.

I've decided to put up a disclaimer on the home page explaining that all users will have to re-register.

It's too bad that there's not a better solution. It took me some time to get all those records back into the database since the fields from the old version of XOOPS don't match up perfectly with the fields available in the new version.

After examining the data in the database, the only difference that I noticed between the old and new data is that the password field seems to have a different encryption (or something) used in this version. Besides that, all the other fields are populated the same as the test entries I manually created.

If somebody else has a solution I can attempt via SQL statements or via Xoops, please let me know, but for now, I give up.

Thanks for all your help up to now.

Ivan
Ivan Vasquez
http://www.akwebz.com
6
Anonymous
Re: Xoops can't see users imported into DB

  • 2006/3/2 21:10

  • Anonymous

  • Posts: 0

  • Since:


Have you installed the profiles module, and populated the user_profile table as well as the users table with your user data?
7
ivan8r
Re: Xoops can't see users imported into DB

  • 2006/3/2 21:50

  • ivan8r

  • Just popping in

  • Posts: 57

  • Since: 2003/10/1


Wow! I think you found the problem! I only have 2 entries in that table and they are also the 2 records that are working correctly.

I went to my old DB and checked that table to see if I could get some data to enter here, but that table had no records.

In checking for that data, I also noticed a table called xoops_user_profile_field, and that table does have data which seem to include some preferences for each user.

I'm going to try and create some data for these tables to see if this fixes the issues I'm having. Thanks for pointing me in this direction!!!!

Ivan
Ivan Vasquez
http://www.akwebz.com
8
ivan8r
Re: Xoops can't see users imported into DB

  • 2006/3/2 22:25

  • ivan8r

  • Just popping in

  • Posts: 57

  • Since: 2003/10/1


Ok, I seem to be making some progress now. I can now see all of my users in Xoops!

Now my problem is that the passwords that were setup in the previous version no longer work. Is there a global change I can make to reset all the passwords? Or is there some sort of way to convert old passwords into the new format?
Ivan Vasquez
http://www.akwebz.com

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

288 user(s) are online (180 user(s) are browsing Support Forums)

Members: 0

Guests: 288

more...

Donat-O-Meter

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

Latest GitHub Commits