The Darkness Posted January 21, 2013 Share 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 Link to comment Share on other sites More sharing options...
sniko Posted January 21, 2013 Share 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 Link to comment Share on other sites More sharing options...
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.