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 41 SQL=CREATE TABLE IF NOT EXISTS jos_alpha_userpoints ( `id` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL default '0', `referreid` varchar(160) NOT NULL default '', `upnid` varchar(25) NOT NULL default '', `points` int(11) NOT NULL default '0', `max_points` int(11) NOT NULL default '0', `last_update` datetime NOT NULL default '0000-00-00 00:00:00', `referraluser` varchar(160) NOT NULL default '', `referrees` int(11) NOT NULL default '0', `blocked` tinyint(1) NOT NULL default '0', `birthdate` date NOT NULL default '0000-00-00', `avatar` varchar(255) NOT NULL default '', `levelrank` int(11) NOT NULL default '0', `leveldate` date NOT NULL default '0000-00-00', `gender` tinyint(1) NOT NULL default '0', `aboutme` varchar(250) NOT NULL default '', `website` varchar(150) NOT NULL default '', `phonehome` varchar(30) NOT NULL default '', `phonemobile` varchar(30) NOT NULL default '', `address` varchar(150) NOT NULL default '', `zipcode` varchar(10) NOT NULL default '', `city` varchar(50) NOT NULL default '', `country` varchar(30) NOT NULL default '', `education` varchar(30) NOT NULL default '', `graduationyear` char(4) NOT NULL default '', `job` VARCHAR( 50 ) NOT NULL DEFAULT '', `facebook` varchar(150) NOT NULL default '', `twitter` varchar(150) NOT NULL default '', `icq` varchar(50) NOT NULL default '', `aim` varchar(50) NOT NULL default '', `yim` varchar(50) NOT NULL default '', `msn` varchar(50) NOT NULL default '', `skype` varchar(50) NOT NULL default '', `gtalk` varchar(50) NOT NULL default '', `xfire` varchar(50) NOT NULL default '', `profileviews` int(11) NOT NULL default '0', PRIMARY KEY (`id`), INDEX (referreid), UNIQUE KEY `userid` (`userid`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS jos_alpha_userpoints (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`referreid` varchar(160) NOT NULL default '',
`upnid` varchar(25) NOT NULL default '',
`points` int(11) NOT NULL default '0',
`max_points` int(11) NOT NULL default '0',
`last_update` datetime NOT NULL default '0000-00-00 00:00:00',
`referraluser` varchar(160) NOT NULL default '',
`referrees` int(11) NOT NULL default '0',
`blocked` tinyint(1) NOT NULL default '0',
`birthdate` date NOT NULL default '0000-00-00',
`avatar` varchar(255) NOT NULL default '',
`levelrank` int(11) NOT NULL default '0',
`leveldate` date NOT NULL default '0000-00-00',
`gender` tinyint(1) NOT NULL default '0',
`aboutme` varchar(250) NOT NULL default '',
`website` varchar(150) NOT NULL default '',
`phonehome` varchar(30) NOT NULL default '',
`phonemobile` varchar(30) NOT NULL default '',
`address` varchar(150) NOT NULL default '',
`zipcode` varchar(10) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`country` varchar(30) NOT NULL default '',
`education` varchar(30) NOT NULL default '',
`graduationyear` char(4) NOT NULL default '',
`job` VARCHAR( 50 ) NOT NULL DEFAULT '',
`facebook` varchar(150) NOT NULL default '',
`twitter` varchar(150) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`aim` varchar(50) NOT NULL default '',
`yim` varchar(50) NOT NULL default '',
`msn` varchar(50) NOT NULL default '',
`skype` varchar(50) NOT NULL default '',
`gtalk` varchar(50) NOT NULL default '',
`xfire` varchar(50) NOT NULL default '',
`profileviews` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (referreid),
UNIQUE KEY `userid` (`userid`)
) 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 41 SQL=CREATE TABLE IF NOT EXISTS jos_alpha_userpoints ( `id` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL default '0', `referreid` varchar(160) NOT NULL default '', `upnid` varchar(25) NOT NULL default '', `points` int(11) NOT NULL default '0', `max_points` int(11) NOT NULL default '0', `last_update` datetime NOT NULL default '0000-00-00 00:00:00', `referraluser` varchar(160) NOT NULL default '', `referrees` int(11) NOT NULL default '0', `blocked` tinyint(1) NOT NULL default '0', `birthdate` date NOT NULL default '0000-00-00', `avatar` varchar(255) NOT NULL default '', `levelrank` int(11) NOT NULL default '0', `leveldate` date NOT NULL default '0000-00-00', `gender` tinyint(1) NOT NULL default '0', `aboutme` varchar(250) NOT NULL default '', `website` varchar(150) NOT NULL default '', `phonehome` varchar(30) NOT NULL default '', `phonemobile` varchar(30) NOT NULL default '', `address` varchar(150) NOT NULL default '', `zipcode` varchar(10) NOT NULL default '', `city` varchar(50) NOT NULL default '', `country` varchar(30) NOT NULL default '', `education` varchar(30) NOT NULL default '', `graduationyear` char(4) NOT NULL default '', `job` VARCHAR( 50 ) NOT NULL DEFAULT '', `facebook` varchar(150) NOT NULL default '', `twitter` varchar(150) NOT NULL default '', `icq` varchar(50) NOT NULL default '', `aim` varchar(50) NOT NULL default '', `yim` varchar(50) NOT NULL default '', `msn` varchar(50) NOT NULL default '', `skype` varchar(50) NOT NULL default '', `gtalk` varchar(50) NOT NULL default '', `xfire` varchar(50) NOT NULL default '', `profileviews` int(11) NOT NULL default '0', PRIMARY KEY (`id`), INDEX (referreid), UNIQUE KEY `userid` (`userid`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS jos_alpha_userpoints (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`referreid` varchar(160) NOT NULL default '',
`upnid` varchar(25) NOT NULL default '',
`points` int(11) NOT NULL default '0',
`max_points` int(11) NOT NULL default '0',
`last_update` datetime NOT NULL default '0000-00-00 00:00:00',
`referraluser` varchar(160) NOT NULL default '',
`referrees` int(11) NOT NULL default '0',
`blocked` tinyint(1) NOT NULL default '0',
`birthdate` date NOT NULL default '0000-00-00',
`avatar` varchar(255) NOT NULL default '',
`levelrank` int(11) NOT NULL default '0',
`leveldate` date NOT NULL default '0000-00-00',
`gender` tinyint(1) NOT NULL default '0',
`aboutme` varchar(250) NOT NULL default '',
`website` varchar(150) NOT NULL default '',
`phonehome` varchar(30) NOT NULL default '',
`phonemobile` varchar(30) NOT NULL default '',
`address` varchar(150) NOT NULL default '',
`zipcode` varchar(10) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`country` varchar(30) NOT NULL default '',
`education` varchar(30) NOT NULL default '',
`graduationyear` char(4) NOT NULL default '',
`job` VARCHAR( 50 ) NOT NULL DEFAULT '',
`facebook` varchar(150) NOT NULL default '',
`twitter` varchar(150) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`aim` varchar(50) NOT NULL default '',
`yim` varchar(50) NOT NULL default '',
`msn` varchar(50) NOT NULL default '',
`skype` varchar(50) NOT NULL default '',
`gtalk` varchar(50) NOT NULL default '',
`xfire` varchar(50) NOT NULL default '',
`profileviews` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (referreid),
UNIQUE KEY `userid` (`userid`)
) TYPE=MyISAM;
Невозможно удалить выбранный файл: 'tick.png'