The Darkness Posted January 21, 2013 Posted January 21, 2013 Hey guys, I'm having a problem I have tried resetting phpMYadmin by creating a new database but, I'm having a problem when people login they see this "QUERY ERROR: Unknown column 'mlevel' in 'field list' Query was UPDATE users SET level=level+1,exp=60,energy=energy+2,brave=brave+2,maxenergy=maxenergy+2,maxbrave=maxbrave+2, hp=hp+50,maxhp=maxhp+50,mlevel=mlevel+1 where userid=3" I really need help what has gone wrong I can't seem to find it...?? Pls help me kind regards Quote
sniko Posted January 21, 2013 Posted January 21, 2013 The solution is right there. QUERY ERROR: Unknown column 'mlevel' in 'field list' Either, add a column to `users` called `mlevel`, or restructure the query to not include the update to the column `mlevel`. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.