Results 1 to 2 of 2

Thread: Column count doesn't match value count at row 1

  1. #1
    Join Date
    Jul 2007

    Question Column count doesn't match value count at row 1

    After a failed installation we:

    Removed tables.

    Removed phrases.

    Removed fields from the datastore table.

    Removed scheduled tasks.

    Removed settings.

    Removed templates.
    when we attempt reinstallation we receive:

    Database error in vBulletin 3.0.9:

    Invalid SQL: INSERT INTO phrasetype VALUES (575, 'adv_links_cp', 'vBadvanced Links Directory CP', 3)
    mysql error: Column count doesn't match value count at row 1

    mysql error number: 1136

    Date: Thursday 12th of July 2007 10:53:09 AM
    Username: Administrator
    IP Address:
    is this a know bug, is there a fix?

  2. #2
    Join Date
    Jan 2004
    Georgia, USA

    Default Re: Column count doesn't match value count at row 1

    Sounds like your 'phrasetype' table has been altered, which is a bit unusual (first time I've seen anyone with the probelm anyways). If you'll look in the install file for this bit of code:
    PHP Code:
                $DB_site->query("INSERT INTO " TABLE_PREFIX "phrasetype VALUES (575, 'adv_links_cp', 'vBadvanced Links Directory CP', 3)");
    $DB_site->query("INSERT INTO " TABLE_PREFIX "phrasetype VALUES (574, 'adv_links', 'vBadvanced Links Directory', 3)"); 
    And replace it with this:
    PHP Code:
                $DB_site->query("INSERT INTO " TABLE_PREFIX "phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (575, 'adv_links_cp', 'vBadvanced Links Directory CP', 3)");
    $DB_site->query("INSERT INTO " TABLE_PREFIX "phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (574, 'adv_links', 'vBadvanced Links Directory', 3)"); 
    Then you should be able to complete the install afterwards.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Link Count
    By Grae in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 02-28-2007, 03:13 AM
  2. New post count
    By attroll in forum Troubleshooting & Problems
    Replies: 15
    Last Post: 01-13-2007, 10:41 PM
  3. anologue count down watch
    By MDN in forum Module & Modification Discussion & Requests
    Replies: 0
    Last Post: 09-11-2006, 08:12 AM
  4. new post count on the portal
    By evandaeman in forum "How Do I..." Questions
    Replies: 1
    Last Post: 11-15-2005, 12:34 PM
  5. Count down option?
    By vtec44 in forum Feedback & Suggestions
    Replies: 0
    Last Post: 05-09-2005, 10:39 AM

Posting Permissions

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