Can't Install New Version

[snerd]

Getting this error at install................

Database error in vBulletin 3.7.3:

Invalid SQL:
CREATE TABLE vb3_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',
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;

[CareyCrew]

Is this the first install of Links directory or are you updating?

If it is an upgrade have you run the upgrade script?

[Our Sponsors]

[snerd]

New install. Failed all three tries. Used the remove feature all times before trying again. Still left two tables, I deleted them from phpMyadmin.

[Brian]

Can you post the rest of the error?

[Our Sponsors]

[snerd]

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(repid)
) TYPE=MyISAM' at line 12
Error Number : 1064

[Brian]

Please try downloading the files from here again, upload the forum/admincp/vbalinks_install.php file over your existing one, use the 'Uninstall' option, and then try re-installing.

[snerd]

Worked a treat, thanks Brian!


Edit: got it working okay, but when I hit the index page this error is at the top of the page:

Warning: implode() [function.implode]: Invalid arguments passed in [path]/links/index.php on line 118

That line is: $privcats = implode(', ', $vba_options['links_home_excats']) . iif($privcats, ", $privcats");


Edit 2: Well, it seems to be okay now after I set up and saved some of the settings in CP. That error is gone.

[snerd]

I think I have it set up finally, still need to add some sub-categories to the general directory. Take a look and see what you think:

http://www.americasforumz.com/links/

.