iR00T Posted May 13, 2008 Posted May 13, 2008 ok ive worled on this for days and dont kno wuts up QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( 'ghghgh', 'ghghgh', md5('ghgh'), 1, 100, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, 'Male', unix_timestamp(), '[email protected]', -1, '65.190.173.236', '65.190.173.236',0) thatis wut happens when someone trys to register ffor my game wtf Quote
Guest Anonymous Posted May 13, 2008 Posted May 13, 2008 Re: wtf tables are f d up Edited/added any querys to the users table? Quote
Ishy Posted May 13, 2008 Posted May 13, 2008 Re: wtf tables are f d up Try replacing it with: INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( 'ghghgh', 'ghghgh', md5('ghgh'), 1, 100, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, 'Male', unix_timestamp(), '[email protected]', -1, '65.190.173.236', '65.190.173.236') Quote
Haunted Dawg Posted May 13, 2008 Posted May 13, 2008 Re: wtf tables are f d up Toxication is right. But of course if you dont understand then post the register here. Quote
Silver Posted May 13, 2008 Posted May 13, 2008 Re: wtf tables are f d up Toxication is right. But of course if you dont understand then post the register here. There is no need to make pointless posts on every thread ya know...it's not a race to see who can get the highest amount of posts Quote
Haunted Dawg Posted May 13, 2008 Posted May 13, 2008 Re: wtf tables are f d up Toxication is right. But of course if you dont understand then post the register here. There is no need to make pointless posts on every thread ya know...it's not a race to see who can get the highest amount of posts It is not a pointless post, it to help. I dont care about the post count. Quote
Magictallguy Posted May 13, 2008 Posted May 13, 2008 Re: wtf tables are f d up Neither would I if I had 638 posts! (You did when I posted this anyway...) Quote
Haunted Dawg Posted May 13, 2008 Posted May 13, 2008 Re: wtf tables are f d up In this threat we can all see how zeon has the most posts :D :lol: Quote
Guest Anonymous Posted May 14, 2008 Posted May 14, 2008 Re: wtf tables are f d up Only have 907. not many at all. ^^ useless post.... Quote
iR00T Posted May 14, 2008 Author Posted May 14, 2008 Re: wtf tables are f d up ha wow im like the lowest in here Quote
fbiss Posted May 14, 2008 Posted May 14, 2008 Re: wtf tables are f d up *wrong category, moving topic* Quote
AlabamaHit Posted May 15, 2008 Posted May 15, 2008 Re: wtf tables are f d up look at thetop of the page make sure therew is not a space before <?php Quote
Croesy Posted May 16, 2008 Posted May 16, 2008 Re: wtf tables are f d up The problem is simple, it is one of counting ;) You have too many "VALUES". You should count the number of rows you are trying to INSERT and make sure it matches the number of VALUES you are inserting. The error message pretty much tells you this :) Quote
Haunted Dawg Posted May 16, 2008 Posted May 16, 2008 Re: wtf tables are f d up look at thetop of the page make sure therew is not a space before <?php Are you sure? Because i dont think by having this <?php echo 'hello'; ?> would make any difference. Croesy is right like i said... Toxication is right. But of course if you dont understand then post the register here. Try replacing it with: INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( 'ghghgh', 'ghghgh', md5('ghgh'), 1, 100, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, 'Male', unix_timestamp(), '[email protected]', -1, '65.190.173.236', '65.190.173.236') Quote
AlabamaHit Posted May 20, 2008 Posted May 20, 2008 Re: wtf tables are f d up actually a space in front of <?php would make a difference. lol 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.