Invalid SQL Durning Install

[Rideharder1]

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

[Rideharder1]

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

[Our Sponsors]

[Brian]

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.

[Rideharder1]

Yes Sir..

[Our Sponsors]

[Rideharder1]

It worked. Thank you for all your hard work!