安装 alphauserpoints-v1.5.组件 出错 求解决
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 tcitzx_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) N
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 tcitzx_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) N
没有找到相关结果
已邀请:
5 个回复
QQ被盗了
赞同来自:
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'
安装 组件 出错
User Points System component for Joomla!.
不是本人 - no no no!
赞同来自:
3P网络 - 背着回忆的旅游人,即使是再细微的风景,也会留在心中的一个角落~
赞同来自:
因此,这可能是该组件本身的 bug,我会向作者反映一下,请暂停使用此组件,等待进一步消息。
追梦人 - 梦想每个人都有,但不是每个人都有勇气去坚信,我有
赞同来自:
打开安装包里面的 backend 目录里面的 install.mysql.sql 和 install.mysql.utf8.sql 这两个文件,将文件中的 “TYPE=MyISAM” 字串都替换成“ENGINE = MyISAM”,就可以了。
刚刚测试了一下,这个方法能解决此问题。
我已经更新了下载栏目的文件,请重新下载安装 AUP 汉化版
。
3P网络 - 背着回忆的旅游人,即使是再细微的风景,也会留在心中的一个角落~
赞同来自: