Hi !

I'm really stuck, so I registered to these forums. I hope someone will be able to help me .

I recently designed a XOOPS site using the latest version. All was working fine, until I messed with the fields in the Extended Members module. I added some custom fields so members can set their race/level/profession (it is a World Of Warcraft guild site). All was working fine, except that at some point, the Members section in the site told me there was no member found, despite the fact some users were in the DB.

So I logged out, to see if it was some sort of refresh problem -> big mistake. Now I can't log as admin any longer. Each time I enter my login/password, it tells me that this user has been deactivated or not yet activated.

What can I do, please? Is there a way to get things back into place without having to wipe my DB and reconfigure all the settings I took days to fine tune?

Thank you very much for your help!

Bye
Michoko

I recommend going to cpanel (or your equivalent), from there export a copy of your db (save an sql file on your PC).

Rebuild your site and add your DB minus the new fields you created. It sounds like something you did corrupted the XOOPS DB.

The export, rebuild and reload should not take too long and will allow you to reconstruct everything minus the most likely problem area.

Anyway, that's what I'd do....

Thanks Rabideau.

I did a backup of the DB, without the user_*** tables and profiles, then did a clean install. I then reinstalled the backup, and it seems to work.

It's fortunate I did not have a DB full of users though

Anyway, thanks a lot for your help!

Bye
Michoko

BTW, I found what caused this problem. I had added a field called "level" so members can enter their current WoW character level. It seems it made a conflict with the "level" field in the user table.

So if you create new fields, take care they don't have the same name as other fields in the DB

Bye
Michoko