Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Please Help Me At Column count doesn't match value count at row 1

    i Got error in the mysql: "Column count doesn't match value count at row 1"

    Here is the code of my php:

    PHP Code:
    $ia mysql_query("INSERT INTO `accounts` (`name`,`password`,`birthday`,`email`,`banreason`,`macs`) VALUES ('".$username."','".sha1($password)."','".$birth."','".$email."','".$username."', '1', '0', '0')") or die(mysql_error()); 
    Whats is my problem

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,849
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    "Column count doesn't match value count at row 1"
    That's obvious from your query
    (`name`,`password`,`birthday`,`email`,`banreason`,`macs`)
    ('".$username."','".sha1($password)."','".$birth."','".$email."','".$username."', '1', '0', '0')
    . Isn't it?
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)

  • #3
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hhhm i think

  • #4
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Here a video that i made few second ago on my problem that for you will be more easier get to the solution and the php file:

    http://www.mediafire.com/?yfhyjn3iyt0

  • #5
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    You don't need a video, you've named 6 columns and are trying to insert 8 values. Doesn't compute.

  • #6
    New Coder
    Join Date
    Mar 2009
    Location
    Michigan
    Posts
    26
    Thanks
    2
    Thanked 0 Times in 0 Posts
    This is a forum for posters and developers with actual problems. You are trying to make a registration page for a MapleStory private server - which infringes on Nexon America's intellectual property rights. If you are desperate for help, I highly suggest going on forums specialized in (illegal) activities for this, such as RaGEZONE.

    You should note that several of the top private servers are getting legitimate DMCAs for opening their game to the public, so if you want to stay safe, I strongly advise to not even continue with making your server.

    If you would like to know more about the risks or experience of setting up a private server, send me a PM or ask me here; I've been following the community for quite a while now because I've played MapleStory (and admittedly, have tried some servers ). Nexon is finally doing the right thing and taking action against some of these server owners.

    Also, you can't get a MAC address from a web script, so why bother including that?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •