JInstaller::install: SQL Error. 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 'CREATE TABLE IF NOT EXISTS `jos_iprice_sections` ( `id` INT(11) NOT NULL A' at line 1 SQL=CREATE TABLE IF NOT EXISTS `jos_iprice_sections` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `ordering` int(11) NOT NULL, `discid` int(11), `checked_out` int(11) unsigned default '0', `checked_out_time` datetime default '0000-00-00 00:00:00', `published` tinyint(1) unsigned NOT NULL default '1', `owner` int(11) unsigned NOT NULL default '62', `params` text, `description` TEXT, PRIMARY KEY (`id`), KEY `idx_name` (`name`(255)), KEY `idx_checked_out` (`checked_out`) ) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_iprice_sections` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL,
`ordering` int(11) NOT NULL,
`discid` int(11),
`checked_out` int(11) unsigned default '0',
`checked_out_time` datetime default '0000-00-00 00:00:00',
`published` tinyint(1) unsigned NOT NULL default '1',
`owner` int(11) unsigned NOT NULL default '62',
`params` text,
`description` TEXT,
PRIMARY KEY (`id`),
KEY `idx_name` (`name`(255)),
KEY `idx_checked_out` (`checked_out`)
) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
Component Install: SQL error or missing or unreadable SQL 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 'CREATE TABLE IF NOT EXISTS `jos_iprice_sections` ( `id` INT(11) NOT NULL A' at line 1 SQL=CREATE TABLE IF NOT EXISTS `jos_iprice_sections` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `ordering` int(11) NOT NULL, `discid` int(11), `checked_out` int(11) unsigned default '0', `checked_out_time` datetime default '0000-00-00 00:00:00', `published` tinyint(1) unsigned NOT NULL default '1', `owner` int(11) unsigned NOT NULL default '62', `params` text, `description` TEXT, PRIMARY KEY (`id`), KEY `idx_name` (`name`(255)), KEY `idx_checked_out` (`checked_out`) ) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_iprice_sections` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL,
`ordering` int(11) NOT NULL,
`discid` int(11),
`checked_out` int(11) unsigned default '0',
`checked_out_time` datetime default '0000-00-00 00:00:00',
`published` tinyint(1) unsigned NOT NULL default '1',
`owner` int(11) unsigned NOT NULL default '62',
`params` text,
`description` TEXT,
PRIMARY KEY (`id`),
KEY `idx_name` (`name`(255)),
KEY `idx_checked_out` (`checked_out`)
) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
Делал как в этом топе.