Dobrý den. Vím, že nemám server u fakahedy, ale také vím, že jsou tu rozumní lidé, kteří pomáhají. Vyskytl se umě takový problém s Figadminem i Ultrabanem v MySQL a to tento. Prosil bych tímto o Vaši pomoc, i když sem vesměs ani nemám psát.
Spoiler: zobrazit
Kód: Vybrat vše
2012-05-27 22:34:51 [INFO] [FigAdmin] Enabling FigAdmin v4.0.16
2012-05-27 22:34:51 [INFO] [FigAdmin] Creating table banlist.
2012-05-27 22:34:51 [SEVERE] [FigAdmin] Couldn't execute MySQL statement:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ROW_FORMAT=' at line 10
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
at selfservice.MySQLDatabase.initialize(MySQLDatabase.java:64)
at selfservice.FigAdmin.onEnable(FigAdmin.java:82)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:256)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:238)
at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:381)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:368)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:197)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:432)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)Ve fig adminu je to nastavené teoreticky dobře co jsem koukal.
Spoiler: zobrazit
Kód: Vybrat vše
mysql: true
mysql-database: jdbc:mysql://89.190.64.251:3306/minecraft_25566
mysql-user: minecraft_25566
mysql-password: HESLO
mysql-table: banlist
auto-complete: true
ip-ban: false
bans-to-banned-players: false
auto-ban-on-warnings: -1
auto-ban-time: 1 day
messages:
banMsgFailed: '&cPlayer &e%victim% &cis already banned!'
unbanMsg: '&aSuccessfully unbanned player &e%victim%&a!'
unbanMsgGlobal: '&e%victim% &6was unbanned by &e%player%&6!'
unbanMsgFailed: '&cFailed to unban &e%victim%&c!'
kickAllMsg: '%player% kicked everyone. Reason: %reason%'
kickDefaultReason: '&eBooted from server!'
kickGobalDefaultRason: '&eGlobal kick'
kickMsgVictim: 'You have been kicked by %player%. Reason: %reason%'
kickMsgBroadcast: '&e%victim% &6was kicked by &e%player%&6. Reason: &e%reason%'
kickMsgFailed: '&cKick failed: &6%victim% &cisn''t online.'
banMsgVictim: '&eYou have been banned by &e%player%&f.&6 Reason: %reason%'
banMsgBroadcast: '&e%victim% &6was banned by &e%player%&f.&6 Reason: &e%reason%'
banDefaultReason: '&eBan Hammer has Spoken!'
banOffline: '&eWarning: &8Player &a%player%&8 has not been on this server before.'
tempbanMsgVictim: 'You have been temp. banned by %player%. Reason: %reason%'
tempbanMsgBroadcast: '&e%victim% &6was temp. banned by &e%player%&6. Reason: &e%reason%'
LoginTempban: '&cYou are banned until &e%time%&c! Reason: &e%reason%'
LoginBan: '&cYou are banned from this server! Reason: &e%reason%'
LoginIPBan: '&cThis IP is banned!'
badPlayerName: '&cBad player name!'
playerNotOnline: '&cPlayer &e%player% &cis not online.'
warnMsgBroadcast: '&cPlayer &e%player%&f received a warning from &c%kicker%&f:'
warnMsgVictim: '&cYou have received a warning from &c%player%&f:'
reloadMsg: '&aReloaded FigAdmin.'
exportMsg: '&aExported banlist to banned-players.txt'
playerBanned: '&cPlayer %player% is banned.'
playerNotBanned: '&aPlayer %player% is not banned.'
ipBan: '&eIP banning is'
noPermission: '&cYou don''t have permission to do this.'
warnDeleted: '&aAll %number% warnings cleared for player &e%player%&a.'
warnNone: '&cNo warnings found for player &e%player%&c!'Edit:
Toto hlásí SQL
Spoiler: zobrazit
Kód: Vybrat vše
SQL-dotaz:
CREATE TABLE IF NOT EXISTS `banlist` (
`name` VARCHAR( 32 ) NOT NULL ,
`reason` TEXT NOT NULL ,
`admin` VARCHAR( 32 ) NOT NULL ,
`time` BIGINT( 20 ) NOT NULL ,
`temptime` BIGINT( 20 ) NOT NULL DEFAULT '0',
`type` INT( 11 ) NOT NULL DEFAULT '0',
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`ip` VARCHAR( 16 ) DEFAULT NULL
)
MySQL hlásí:
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a keyPři vložení tohoto:
Kód: Vybrat vše
CREATE TABLE IF NOT EXISTS `banlist` (
`name` varchar(32) NOT NULL,
`reason` text NOT NULL,
`admin` varchar(32) NOT NULL,
`time` bigint(20) NOT NULL,
`temptime` bigint(20) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(16) DEFAULT NULL
);Předem děkuji a doufám, že se spolu nějak domluvíme a chyba se opraví. S pozdravem Stano.
