JInstaller: :Install: Error SQL DB function failed with error number 1064
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 CHARACTER SET `utf8` COLLATE `utf8_general_ci` AUTO_INCREMENT=12' at line 23 SQL=CREATE TABLE IF NOT EXISTS `ro7c0_hwdvidscategories` ( `id` int(50) NOT NULL auto_increment, `parent` int(50) NOT NULL default '0', `category_name` varchar(250) default NULL, `category_description` text, `date` datetime NOT NULL default '0000-00-00 00:00:00', `access_b_v` tinyint(1) NOT NULL default '0', `access_u_r` varchar(7) NOT NULL default 'RECURSE', `access_v_r` varchar(7) NOT NULL default 'RECURSE', `access_u` int(11) NOT NULL default '-2', `access_lev_u` varchar(250) NOT NULL default '0,1', `access_v` int(11) NOT NULL default '-2', `access_lev_v` varchar(250) NOT NULL default '0,1', `thumbnail` text NOT NULL default '', `num_vids` int(50) NOT NULL default '0', `num_subcats` int(50) NOT NULL default '0', `order_by` varchar(15) NOT NULL default '0', `ordering` int(50) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci` AUTO_INCREMENT=12 ;
SQL =
CREATE TABLE IF NOT EXISTS `#__hwdvidscategories` (
`id` int(50) NOT NULL auto_increment,
`parent` int(50) NOT NULL default '0',
`category_name` varchar(250) default NULL,
`category_description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`access_b_v` tinyint(1) NOT NULL default '0',
`access_u_r` varchar(7) NOT NULL default 'RECURSE',
`access_v_r` varchar(7) NOT NULL default 'RECURSE',
`access_u` int(11) NOT NULL default '-2',
`access_lev_u` varchar(250) NOT NULL default '0,1',
`access_v` int(11) NOT NULL default '-2',
`access_lev_v` varchar(250) NOT NULL default '0,1',
`thumbnail` text NOT NULL default '',
`num_vids` int(50) NOT NULL default '0',
`num_subcats` int(50) NOT NULL default '0',
`order_by` varchar(15) NOT NULL default '0',
`ordering` int(50) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci` AUTO_INCREMENT=12 ;
نصب افزونه: SQL error file DB function failed with error number 1064
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 CHARACTER SET `utf8` COLLATE `utf8_general_ci` AUTO_INCREMENT=12' at line 23 SQL=CREATE TABLE IF NOT EXISTS `ro7c0_hwdvidscategories` ( `id` int(50) NOT NULL auto_increment, `parent` int(50) NOT NULL default '0', `category_name` varchar(250) default NULL, `category_description` text, `date` datetime NOT NULL default '0000-00-00 00:00:00', `access_b_v` tinyint(1) NOT NULL default '0', `access_u_r` varchar(7) NOT NULL default 'RECURSE', `access_v_r` varchar(7) NOT NULL default 'RECURSE', `access_u` int(11) NOT NULL default '-2', `access_lev_u` varchar(250) NOT NULL default '0,1', `access_v` int(11) NOT NULL default '-2', `access_lev_v` varchar(250) NOT NULL default '0,1', `thumbnail` text NOT NULL default '', `num_vids` int(50) NOT NULL default '0', `num_subcats` int(50) NOT NULL default '0', `order_by` varchar(15) NOT NULL default '0', `ordering` int(50) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci` AUTO_INCREMENT=12 ;
SQL =
CREATE TABLE IF NOT EXISTS `#__hwdvidscategories` (
`id` int(50) NOT NULL auto_increment,
`parent` int(50) NOT NULL default '0',
`category_name` varchar(250) default NULL,
`category_description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`access_b_v` tinyint(1) NOT NULL default '0',
`access_u_r` varchar(7) NOT NULL default 'RECURSE',
`access_v_r` varchar(7) NOT NULL default 'RECURSE',
`access_u` int(11) NOT NULL default '-2',
`access_lev_u` varchar(250) NOT NULL default '0,1',
`access_v` int(11) NOT NULL default '-2',
`access_lev_v` varchar(250) NOT NULL default '0,1',
`thumbnail` text NOT NULL default '',
`num_vids` int(50) NOT NULL default '0',
`num_subcats` int(50) NOT NULL default '0',
`order_by` varchar(15) NOT NULL default '0',
`ordering` int(50) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci` AUTO_INCREMENT=12 ;
