View Single Post
  #745  
Old 12-17-2004, 11:18 PM
Tbird66 Tbird66 is offline
 
Join Date: Dec 2004
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01048 seconds
  • Memory Usage 1,763KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete