User disappears from db after activation in PHP-Nuke

Nuke Cadet Joined: Feb 12, 2007 Posts: 3

hi
I have a problem with users registration.
they register, recieve confirmation email, user click link, nuke says account its activated, but after cant login.

I can see when user register that he is stored in nuke_users_temp table, but when user click on confirmation link he disapears from database.

Cant find any help on this.
qhen i imported .sql tables from original 8.0 file the only thing i changed was deleting all cities not from my country.
My comercial web hoster uses a windows server and register globals is off.
I get this message from phpmyadmin in nuke_users

Code:

PRIMARY and INDEX keys should not both be set for column `user_id`

can it be one of this reasons or can I somehow debug the error

regards

Posted: Tue Feb 13, 2007 11:51 am

This may be the bio and ublock problem experienced on MySQL 5.x database servers. Try editing the attributes of the bio field in the nuke_users table of your database. Change the NULL field from NOT NULL to NULL also give the ublock field a default value of 0.

Nuke Cadet Joined: Feb 12, 2007 Posts: 3

Already made the change in bio field and didnt solve the problem.
in ublock i cant hust assign directly a 0 value to default

Code:

Mensagens do MySQL : Documentação
#1101 - BLOB/TEXT column 'ublock' can't have a default value

I gess its because its a text column

If I change Type to "Tinyint" size/value to 1 and default to 0 I get

Code:

Mensagens do MySQL : Documentação
#1366 - Incorrect integer value: '' for column 'ublock' at row 1

I dont want to mess to much trying to gess.
could you please be more precise?

Site Admin Joined: Aug 17, 2003 Posts: 12397

As I can't post the code on this forum, I posted it on my own:

For a solution
http://evaders.swrebellion.com/forums/postp309.html#309

Posted: Thu Feb 15, 2007 5:43 am

My apologies for the error. I didnt see that the ublock field was of type tinytext (See I am human after all Embarassed

).

Evaders script works fine. Or you could use phpMyAdmin to change the NULL attribute of the ublock field from NOT NULL to NULL. You should also remove the default 0 for that field if it was added.