I Get this when i register, please help

Field 'role' doesn't have a default value <--- Please help i get this when i register

ALTER TABLE users ADD COLUMN role INT(11) NOT NULL;

run that sql.

Quote:

---

Originally Posted by Vaulient

ALTER TABLE users ADD COLUMN role INT(11) NOT NULL;

run that sql.

---

[SQL]ALTER TABLE users ADD COLUMN role INT(11) NOT NULL;
[Err] 1060 - Duplicate column name 'role'

this happen when i run the sql

oh , oops , sorry , I misread your problem

ALTER TABLE users
ALTER COLUMN role SET DEFAULT '0';

run that

Quote:

---

Originally Posted by Vaulient

oh , oops , sorry , I misread your problem

ALTER TABLE users
ALTER COLUMN role SET DEFAULT '0';

run that

---

Now i get this

Field 'gotw_points' doesn't have a default value <---

run this ...

ALTER TABLE users
ALTER COLUMN gotw_points SET DEFAULT '0';



it's very obvious ..

Quote:

---

Originally Posted by Vaulient

run this ...

ALTER TABLE users
ALTER COLUMN gotw_points SET DEFAULT '0';



it's very obvious ..

---

When i click " check in " to client i get black screen then it go to /me i use plusemu from xen

Quote:

---

Originally Posted by Zlatan

When i click " check in " to client i get black screen then it go to /me i use plusemu from xen

---

Thats nothing to do with the register, this is because you've configured the emulator wrong, if you use google chrome then open up the console to check what errors are logged. Theirs your answer to solve problem :w00t:

It appears that your register problem has been solved. What you're having now is the swf problem . You need to check your swf paths

Since register issue has been fixed, please, create a new help thread for the next issue.