MySQL Query Help

ZoneHotel

New Member
Sep 11, 2015
7
1
Hey guys. I'm using RevCMS with Azure emu. Long story cut short, I've tried signing up and by chance I'm having an SQL error and seemed to of forgotten how to insert columns. Anyway, I'm getting this error upon sign up...

Unknown column 'password' in 'field list'

could somebody help me here? Just post up a fix for me, I'll +rep :)
 

ZoneHotel

New Member
Sep 11, 2015
7
1
Add the column password to users table manually or just run this query: ALTER TABLE users ADD password VARCHAR(60);
Thanks, that worked bud. Now I've got another error unfortunately, lol.
Unknown column 'mail' in 'field list'

thanks for your time in advance.
 

Yadz

Active Member
Feb 20, 2015
174
25
Run this; ALTER TABLE users ADD mail VARCHAR(60);

However it looks like you're not using the right database, otherwise the database should have these collumns added already.
 

Users who are viewing this thread

Top