please help Field 'Weights' doesn't have a default value

[TryNot42]

Hello guys i Try to use revcms 1.9.9.9 but I get always this error if i try to register


Field 'Weights' doesn't have a default value


can anyone help me ?

[MentaL]

[The General]

Go to your database and click on structure. Scroll down to Weights and click on edit it. THen add a default value.

[TryNot42]

I searched for The weights in Database but there isn't Weights

[ηєwв]

Go to the users table > design view and tick "allow null" for Weights

[FullmetalPride]

'Weights' should be in users.

[TryNot42]

what do i need swtich there then can anyone tell me ?

[Mathu]

Run this in your database:

ALTER TABLE users ADD `Weights` int(11) NOT NULL DEFAULT '0';

[TPStudios]

Run this in your database:

ALTER TABLE users ADD `Weights` int(11) NOT NULL DEFAULT '0';

Does this code work with IIS?

[Mathu]

Does this code work with IIS?

Of course. :)

[HabboRyanz]

hey...do i have to delete anything first because it returns :[SQL]ALTER TABLE users ADD `Weights` int(11) NOT NULL DEFAULT '0';[Err] 1060 - Duplicate column name 'Weights'