I have a couple of issues with my install:
1. From instructions.txt:
b. Unzip the files somewhere convenient. The templates and natch
subdirectories are for convenience only. You don't need these.
c. Upload local_links.php, local_links_template.xml and get_hotlinks.php
into your *main forum* directory
The only copy I could find of get_hotlinks.php was in the natch subdirectory. The other 2 files were in the root of the unzipped folder. Did I use the correct file?
2. I receive the following error while creating tables:
Database error in vBulletin 3.0.3:
Invalid SQL:
CREATE TABLE IF NOT EXISTS local_linkslink (
linkid int(11) NOT NULL auto_increment,
linkname varchar(255) NOT NULL,
linkdesc text NOT NULL,
linkurl text NOT NULL,
linkhits mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
linkforum smallint(5) NOT NULL,
linkcheck int(10) unsigned NOT NULL,
linkstatus int(10) DEFAULT '0' NOT NULL,
linkdate int(10) NOT NULL,
linkusername text NOT NULL,
linkuserid int(10) NOT NULL,
linkmoderate int(2) NOT NULL,
linkmoddate int(10) DEFAULT '0' NOT NULL,
linkreviewfreq smallint(5) DEFAULT '0' NOT NULL,
PRIMARY KEY (linkid),
FULLTEXT KEY namedesc (linkname,linkdesc)
)
mysql error: The used table type doesn't support FULLTEXT indexes
mysql error number: 1214
I can create the table using Execute SQL Query in AdminCP and putting the qualifier ENGINE = MYISAM; at the end of the CREATE() statement, but then when I re-run local_links_install.php it does not see the table (I can successfully execute a SELECT * FROM local_linkslink query). I've tried skipping the table verification step, but I receive array errors in step 3.
I'm running MySQL 4.1.7 with both MyISAM and InnoDB storage engines enabled. As I'm running on Windows, the InnoDB storage engine is the default instead of MyISAM. InnoDB doesn't support FULLTEXT indexes, thus the need for the qualifier ENGINE = MYISAM;
Any suggestions?
Thanks!
|