Installing error in your SQL syntax

[DSMrSinister]

I am getting this error when trying to install the latest version of vBadvanced Links Directory!

i am running

MySQL Version 4.0.16
PHP 4.4.1



Database error in vBulletin 3.6.1:

Invalid SQL:

CREATE TABLE adv_links (
linkid int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
linkurl TEXT NOT NULL default '',
linkrecipurl TEXT NOT NULL default '',
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',
suspended smallint(3) 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 '',
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 linkid (linkid,suspended,valid,dateline),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY description (description),
FULLTEXT KEY keywords (keywords)
) ENGINE=MyISAM;

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 'ENGINE=MyISAM' at line 31
Error Number : 1064

[Brian]

That query is correct, so I'm not entirely sure how you would get that error. Would you mind submitting a support ticket via the Members' Area here so I can have a look?

[DSMrSinister]

Done! if you need any more info please PM me and i will get it to you.!