JInstaller::install: Ошибка 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' at line 22 SQL=CREATE TABLE IF NOT EXISTS `jos_datsogallery` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `imgtitle` text NOT NULL, `imgauthor` varchar(50) default NULL, `imgtext` text NOT NULL, `imgdate` varchar(20) default NULL, `imgcounter` int(11) NOT NULL default '0', `imgdownloaded` int(11) NOT NULL default '0', `imgvotes` int(11) NOT NULL default '0', `imgvotesum` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `imgoriginalname` varchar(50) NOT NULL default '', `imgfilename` varchar(50) NOT NULL default '', `imgthumbname` varchar(50) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `owner` varchar(50) NOT NULL default '', `approved` int(1) NOT NULL default '0', `useruploaded` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_datsogallery` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`imgtitle` text NOT NULL,
`imgauthor` varchar(50) default NULL,
`imgtext` text NOT NULL,
`imgdate` varchar(20) default NULL,
`imgcounter` int(11) NOT NULL default '0',
`imgdownloaded` int(11) NOT NULL default '0',
`imgvotes` int(11) NOT NULL default '0',
`imgvotesum` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`imgoriginalname` varchar(50) NOT NULL default '',
`imgfilename` varchar(50) NOT NULL default '',
`imgthumbname` varchar(50) NOT NULL default '',
`checked_out` int(11) NOT NULL default '0',
`owner` varchar(50) NOT NULL default '',
`approved` int(1) NOT NULL default '0',
`useruploaded` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Компонент Установить: Ошибка SQL или нечитаемый файл 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' at line 22 SQL=CREATE TABLE IF NOT EXISTS `jos_datsogallery` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `imgtitle` text NOT NULL, `imgauthor` varchar(50) default NULL, `imgtext` text NOT NULL, `imgdate` varchar(20) default NULL, `imgcounter` int(11) NOT NULL default '0', `imgdownloaded` int(11) NOT NULL default '0', `imgvotes` int(11) NOT NULL default '0', `imgvotesum` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `imgoriginalname` varchar(50) NOT NULL default '', `imgfilename` varchar(50) NOT NULL default '', `imgthumbname` varchar(50) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `owner` varchar(50) NOT NULL default '', `approved` int(1) NOT NULL default '0', `useruploaded` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_datsogallery` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`imgtitle` text NOT NULL,
`imgauthor` varchar(50) default NULL,
`imgtext` text NOT NULL,
`imgdate` varchar(20) default NULL,
`imgcounter` int(11) NOT NULL default '0',
`imgdownloaded` int(11) NOT NULL default '0',
`imgvotes` int(11) NOT NULL default '0',
`imgvotesum` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`imgoriginalname` varchar(50) NOT NULL default '',
`imgfilename` varchar(50) NOT NULL default '',
`imgthumbname` varchar(50) NOT NULL default '',
`checked_out` int(11) NOT NULL default '0',
`owner` varchar(50) NOT NULL default '',
`approved` int(1) NOT NULL default '0',
`useruploaded` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
14.07.2022, 20:00:50