Thread: Add-On Releases - vBulletin Link Directory
View Single Post
  #657  
Old 11-09-2015, 10:49 PM
Dragonsys's Avatar
Dragonsys Dragonsys is offline
 
Join Date: Jan 2008
Location: DFW, Texas
Posts: 743
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by robbiefritz View Post
Edited the XML but instead of the incompatibility error, I get this:

Code:
Database error in vBulletin 4.2.3:

Invalid SQL:
CREATE TABLE vblinklist_category (
	id int(11) NOT NULL auto_increment,
	parentid int(11) NOT NULL default '0',
	displayorder int(11) NOT NULL default '0',
	name varchar(255) NOT NULL default '',
	description text,
	status smallint(5) NOT NULL default '0',
	defaulticon smallint(5) NOT NULL default '1',
	definedicon varchar(255) NOT NULL default '',
	groupshow smallint(5) NOT NULL default '1',
	groupshowlist varchar(255) NOT NULL default '',
	allowhtml smallint(1) NOT NULL default '0',
	allowbbcode smallint(1) NOT NULL default '1',
	allowsmilies smallint(1) NOT NULL default '1',
	linkurl tinyint(1) NOT NULL default '0',
	banner tinyint(1) NOT NULL default '0',
	thumbnail tinyint(1) NOT NULL default '0',
	picturelocation text,
	PRIMARY KEY (id)
) TYPE=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 'TYPE=MyISAM' at line 20
Error Number  : 1064
Request Date  : Sunday, August 16th 2015 @ 07:51:08 PM
Error Date    : Sunday, August 16th 2015 @ 07:51:08 PM
Script        : http://xxx.com/xxx/admincp/plugin.php?do=productimport
Referrer      : http://xxx.com/xxx/admincp/plugin.php?do=productadd
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.5.44-log

Thanks in advance.
This is due to your version of MySQL. Edit the XML file and remove all references to TYPE=MyISAM
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01143 seconds
  • Memory Usage 1,766KB
  • 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)bbcode_code
  • (1)bbcode_quote
  • (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