mysql error help

Discussion in 'MySQL' started by bunny76, Feb 22, 2009.

  1. #1
    #1136 - Column count doesn't match value count at row 1


    anyone know how i can rectify this please?
     
    bunny76, Feb 22, 2009 IP
  2. dowhile

    dowhile Active Member

    Messages:
    37
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    93
    #2
    Is that from insert statement? If it is as it says values and columns count don't match.
     
    dowhile, Feb 22, 2009 IP
  3. bunny76

    bunny76 Member

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    43
    #3
    i was uploading some games on my site and importing sql but i got this error
     
    bunny76, Feb 22, 2009 IP
  4. bunny76

    bunny76 Member

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    43
    #4
    this is the full message

    SQL query:

    INSERT INTO `ava_games`
    VALUES ( 100001, 'Breakout', 'Remake Of Classic Breakout', '100001', '102', 3, 1, '', '500', '500', '', '1' ) ;



    MySQL said:

    #1136 - Column count doesn't match value count at row 1
     
    bunny76, Feb 22, 2009 IP
  5. bunny76

    bunny76 Member

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    43
    #5
    please ignore above this is what im getting now

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in



    // The following should not be edited
    $con = mysql_connect("$server","$username","$password");
    if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }
    mysql_select_db("$database", $con);

    //mysql_query("UPDATE ava_games SET height='300' WHERE height='0'") or die (mysql_error());

    //
    $sql = mysql_query("SELECT * FROM ava_settings");
    $row = mysql_fetch_array($sql);
    $site_name = $row['site_name'];
    $site_description = $row['site_description'];
    $site_keywords = $row['site_keywords'];
    $site_url = $row['site_url'];
    $seo_on = $row['seo_on'];
    $template_url = $row['template_url'];
    $max_results = $row['max_results'];
    $image_height = $row['image_height'];
    $image_width = $row['image_width'];
    $adsense = $row['adsense'];
    $cat_numbers = $row['cat_numbers'];
    $email_on = $row['email_on'];
    $add_to_site = $row['add_to_site'];
    $plays = $row['plays'];
    $language = $row['language'];
    $featured = $row['featured_games'];
    $play_limit = $row['play_limit'];
    $adsense_id = $row['adsense_id'];
    $new_plays = 4;
    //

    // Convert super globals
    if (phpversion() >= '5.0.0')
    {
    $HTTP_POST_VARS = ($_POST);
    $HTTP_GET_VARS = ($_GET);
    }
    ?>




    is there a problem in the red line above if so any ideas please??
     
    bunny76, Feb 22, 2009 IP
  6. bunny76

    bunny76 Member

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    43
    #6
    Parse error: syntax error, unexpected T_STRING in /home/latestme/public_html/xxxarcades.net/config.php on line 20
     
    bunny76, Feb 22, 2009 IP