I have been sniflin around the database, tried some things. And dumb me, now all users have the status in the backend:Confirmed X. the X=is the red X. Also a clock is displayed on the column: approved.

Is their someone who nows a Sql code or other trick to approve every users en aso confirmed?
Thank you very much!
Byeee!

Before you mess with the database you might wanna create backups..

But thats not what you like to hear now is it..

I have no clue what you might have done to get this effect..

You would need a php script to change all your fields.. im thinking maybe you have just edited the default state of the field ?

Or you have tinkered with the ID numbers and somehow your userbase is out of synch.. now cb thinks users are unapproved..

In any case.. what i would do.. since you don't know.. is make a backup of this bad state (better than nothing).. and try the synching tool that comes with CB in the backend..

Then i would like to know how the database looks. you should have just as many fields in comprofiler as in users table..

anyway.. WEiRD situation.. and i have no clue what you might have done so the fix is unknown.. BACKUP before you do ANYTHING, even NOW!!!

~T.

Yes, the problem is solved!
Thank you Trail