Jump to content
MakeWebGames

wtf tables are f d up


iR00T

Recommended Posts

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

Link to comment
Share on other sites

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')
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 :)

Link to comment
Share on other sites

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')

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...