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

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 ?

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

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

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

'Weights' should be in users.

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

http://i47.tinypic.com/25samqb.png

Run this in your database:

Code:

---

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

---

Quote:

---

Originally Posted by Mathu

Run this in your database:

Code:

---

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

---

---

Does this code work with IIS?

Quote:

---

Originally Posted by TPStudios

Does this code work with IIS?

---

Of course. :)

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'