Results 1 to 5 of 5

Thread: Invalid SQL Durning Install

  1. #1

    Default Invalid SQL Durning Install

    Database error in vBulletin 3.8.5:

    Invalid SQL:

    INSERT INTO product
    (productid, title, description, version, active)
    VALUES (
    'adv_links',
    'vBadvanced Links Directory',
    'vBadvanced Links Directory',
    '3.3.0',
    1,
    'http://www.vbadvanced.com'
    );

    MySQL Error : Column count doesn't match value count at row 1
    Error Number : 1136

  2. #2

    Default

    Database error in vBulletin 3.8.5:

    Invalid SQL:
    CREATE TABLE adv_links (
    linkid int(11) NOT NULL auto_increment,
    `name` varchar(255) NOT NULL default '',
    linkurl text NOT NULL,
    linkrecipurl text NOT NULL,
    catid smallint(5) unsigned NOT NULL default '0',
    description text NOT NULL,
    keywords varchar(255) default NULL,
    views int(10) NOT NULL default '0',
    posts int(10) unsigned NOT NULL default '0',
    valid smallint(5) NOT NULL default '0',
    `open` smallint(3) unsigned NOT NULL default '0',
    notes varchar(255) NOT NULL default '',
    sticky smallint(3) unsigned NOT NULL default '0',
    hasthumb varchar(20) NOT NULL,
    username varchar(50) default NULL,
    dateline int(10) unsigned NOT NULL default '0',
    lastupdated int(10) unsigned NOT NULL default '0',
    userid int(10) unsigned NOT NULL default '0',
    votenum smallint(5) unsigned NOT NULL default '0',
    votetotal smallint(5) unsigned NOT NULL default '0',
    ipaddress varchar(15) NOT NULL default '',
    lastpostid int(10) unsigned NOT NULL default '0',
    lastpostdateline int(10) unsigned NOT NULL default '0',
    lastpostuserid int(10) unsigned NOT NULL default '0',
    lastpostusername varchar(255) default NULL,
    PRIMARY KEY (linkid),
    KEY catid (catid,valid,dateline),
    KEY lastupdated (lastupdated),
    FULLTEXT KEY `name` (`name`),
    FULLTEXT KEY description (description),
    FULLTEXT KEY keywords (keywords)
    ) TYPE=MyISAM;

    MySQL Error : Table 'adv_links' already exists
    Error Number : 1050

  3. #3
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    Thank you for pointing this out. It looks like there was a small error in the forum/admincp/vbalinks_install.php file that could cause that error with a new install, though I've just updated that file in the download package here to include the fix. If you will download the files from here again, upload that one to your server over the existing file, run the 'Uninstall' option from the admincp/vbalinks_install.php file, and then you should be able to reinstall afterward.
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  4. #4

    Default

    Yes Sir..

  5. #5

    Default

    It worked. Thank you for all your hard work!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Invalid URL
    By HenrikHansen in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 02-28-2008, 02:37 PM
  2. Invalid - invalid URL error?
    By Planet vB in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 11-28-2007, 12:47 PM
  3. Some Invalid SQL
    By joggele in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-25-2006, 01:20 PM
  4. Invalid SQL
    By SLGR in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 04-07-2006, 01:46 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
  •