Revcms CLIENT ERROR

[Xeon Retro]

Hy Guys , When loading client I get this. Please Help me! @EmielJ @banana33 @asesinato

Unknown column 'account_locked' in 'where clause'

[MentaL]

[asesinato]

Run this query:

ALTER TABLE users ADD `account_locked` enum('0','1') NOT NULL DEFAULT '0';

That should resolve your issue.

[Xeon Retro]

Now i have this Unknown column 'staff_pin' in 'where clause' @asesinato

[asesinato]

Run this query:

ALTER TABLE users ADD `staff_pin` text;

[Xeon Retro]

Where is the staff Pin? I' Don't know what is the document @asesinato

[asesinato]

It's a staff pin to stop staffs accounts getting hacked. Each user should be assigned a unique pin to their account. You can remove this by removing the PHP code in the top of your client.

[Xeon Retro]

yes but, i ' haven't got any pin, can i modify it?

- - - Updated - - -

Ok, I've found the pin, Thanks very much!!!

[Lewislol]

yes but, i ' haven't got any pin, can i modify it?

- - - Updated - - -

Ok, I've found the pin, Thanks very much!!!

To add pins you can just run this query.

UPDATE users SET staff_pin = md5('PinHere') WHERE username = 'YourUsername'

If your pin system does not use hashing you could just run this

UPDATE users SET staff_pin = 'PinHere' WHERE username = 'YourUsername'

Not tested these but they should work if anyone can see a problem with them feel free to correct it.