Ultrabans

[Domotrno]

IP:82.208.17.38:27662

Dobrý deň,
Mám taký problém zo serverom.Vždy keď sa pripojím ma to dá do jailu a cez konzolu si musím dať pardon.
Keď si dám pardon,vypíše to niaký error:
> [18:13:47 ERROR]: [Ultrabans] Couldn't execute MySQL statement:
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near ")": syntax error)
at org.sqlite.DB.newSQLException(DB.java:383) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.DB.newSQLException(DB.java:387) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.DB.throwex(DB.java:374) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.NativeDB.prepare(Native Method) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.DB.prepare(DB.java:123) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.PrepStmt.<init>(PrepStmt.java:42) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.Conn.prepareStatement(Conn.java:404) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.Conn.prepareStatement(Conn.java:399) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.sqlite.Conn.prepareStatement(Conn.java:383) ~[minecraft_server.jar:git-Bukkit-d3e0b6f]
at com.modcrafting.ultrabans.db.SQLite.removeFromJaillist(SQLite.java:482) [Ultrabans.jar:?]
at com.modcrafting.ultrabans.commands.Pardon$1.run(Pardon.java:66) [Ultrabans.jar:?]
at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:53) [minecraft_server.jar:git-Bukkit-d3e0b6f]
at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:349) [minecraft_server.jar:git-Bukkit-d3e0b6f]
at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:680) [minecraft_server.jar:git-Bukkit-d3e0b6f]
at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:335) [minecraft_server.jar:git-Bukkit-d3e0b6f]
at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:629) [minecraft_server.jar:git-Bukkit-d3e0b6f]
at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:537) [minecraft_server.jar:git-Bukkit-d3e0b6f]
at java.lang.Thread.run(Thread.java:744) [?:1.7.0_51]

Ako to mám opraviť?

[Netrixmc]

[SQLITE_ERROR] SQL error or missing database (near ")": syntax error)
Přidej config

[Domotrno]

Database: SQLite
MySQL:
Database: jdbc:mysql://localhost:3306/minecraft
User: root
Password: root
Table: banlist
IPTable: banlistip
SQLite:
Filename: banlist
CleanOnBan: true
ClearWarnOnBan: false
Log:
Enabled: true
MaxWarning:
Enable: false
Amt: 5
Result: ban
Silent: true
Reason: Max Warnings
Temp:
Amt: 5
Mode: day
Label:
Console: CONSOLE
Reason: -
Lockdown: false
Login:
DupeCheck:
Enable: true
ProxyPingBack:
Enable: false
Timeout: 1000
Sync:
Enabled: false
Timing: 72000L
AutoUpdater:
Enabled: true
Chat:
IPCheck:
Enable: true
Blocking: '{Block}'
Result: warn
Silent: false
Reason: Advertising
SwearCensor:
Enable: true
Words: test testing tests
Blocking: '{Block}'
Result: warn
Silent: false
Reason: Language
SpamCheck:
Enable: true
Counter: 10
Result: kick
Silent: false
Reason: Spam
Muted:
Vannila: true
AllowedCommands:
- /login
- /register
Jail:
Mute: true
Vanilla: true
AllowedCommands:
- /login
- /register
Messages:
Ban:
MsgToVictim: '&6Bol si zabanovaný &7%admin%&6. Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was banned by &7%admin%&6. Reason: &7%reason%&6!'
Failed: '&4%victim%&c is already in banned.'
Denied: '&cYour ban attempt has been denied!'
Emo: '&cYou cannot ban yourself!'
Login: '&7%admin%&6 banned you from this server! Reason: &7%reason%&6!'
CheckBan:
Header: '&6Found &7%amt%&6 records for &7%victim%&6.'
None: '&cNo records found for &4%victim%&c.'
Clean:
Complete: '&6Deleted &7%amt%&6 player.dat files.'
DupeIP:
Failed: '&cUnable to view ip for &4%victim% &c!'
Header: '&6Scanning Current IP of &7%victim%&6: &7%ip% !'
Completed: '&aScanning Complete!'
Empty:
MsgToVictim: '&7%admin%&6 has cleared your inventory!'
MsgToSender: '&7%admin%&6 has cleared the inventory of &7%victim%&6!'
Online: '&4%victim%&c must be online.'
Export:
Failed: '&cCould not export ban lists.'
Completed: '&aExported banlists.'
History:
Header: '&6Ultrabans Listing &7%amt%&6 Records.'
Failed: '&cUnable to find any bans.'
Import:
Loading: '&cBe patient. Loading...'
Failed: '&cCould not import ban list.'
Completed: '&aSystem imported the banlist to the database.'
InvOf:
Failed: '&cUnable to find player.'
Console: '&cThis command must be executed by a &4player&c.'
IPBan:
MsgToVictim: '&6You have been ipbanned by &7%admin%&6. Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was ipbanned by &7%admin%&6. Reason: &7%reason%&6!'
IPNotFound: '&cIP address not found. &6Processed as a normal ban for &7%victim%&6!'
Failed: '&4%victim%&c is already in banned.'
Denied: '&cYour ipban attempt has been denied!'
Emo: '&cYou cannot ipban yourself!'
Login: '&7Your IP is banned!'
Jail:
MsgToVictim: '&6You have been jailed by &7%admin%&6. Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was jailed by &7%admin%&6. Reason: &7%reason%&6!'
SetJail: '&aJail has been set!'
SetRelease: '&aRelease has been set!'
Failed: '&4%victim%&c is already in jail.'
Online: '&4%victim%&c must be online to be jailed.'
Denied: '&cYour jail attempt has been denied!'
Emo: '&cYou cannot jail yourself!'
PlaceMsg: '&cYou cannot place blocks while you are jailed!'
BreakMsg: '&cYou cannot break blocks while you are jailed!'
Kick:
MsgToAll: '&6Everyone has been kicked by &7%admin%&6. Reason: &7%reason%&6!'
MsgToVictim: '&6You have been kicked by &7%admin%&6. Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was kicked by &7%admin%&6. Reason: &7%reason%&6!'
Online: '&4%victim%&c must be online.'
Denied: '&cYour kick has been denied!'
Emo: '&cYou cannot kick yourself!'
Lockdown:
Start: '&cLockdown initiated. &4Player Login&c disabled.'
End: '&aLockdown ended. &2Player Login&a reenabled.'
Status: '&cLockdown is disabled.'
LoginMsg: '&4Server is under a lockdown, Try again later!&c Sorry.'
Mute:
MuteMsgToSender: '&6You have muted &7%victim%&6.'
MuteMsgToVictim: '&4You have been muted!'
UnmuteMsgToSender: '&6You have unmuted &7%victim%&6.'
UnmuteMsgToVictim: '&aYou have been unmuted.'
Denied: '&cYour mute has been denied!'
Emo: '&cYou cannot mute yourself!'
Chat: '&cYour cry falls on deaf ears.'
Pardon:
Msg: '&7%victim%&6 was released from jail by &7%admin%&6!'
PermaBan:
MsgToVictim: '&6You have been permabanned by &7%admin%&6. Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was permabanned by &7%admin%&6. Reason: &7%reason%&6!'
Failed: '&4%victim%&c is already banned.'
Online: '&4%victim%&c must be online.'
Denied: '&cYour permaban has been denied!'
Emo: '&cYou cannot permaban yourself!'
Spawn:
MsgToVictim: '&cYou have been sent to spawn!'
MsgToSender: '&7%victim%&6 is now at spawn!'
Failed: '&4%victim%&c is not online.'
Starve:
MsgToVictim: '&cYou are now starving!'
MsgToSender: '&6%victim%&7 is now starving!'
Failed: '&4%victim%&c is not online.'
Denied: '&cYour starve attempt has been denied!'
Emo: '&cYou cannot starve yourself!'
TempBan:
MsgToVictim: '&6You have been tempbanned by &7%admin%&6 for &7%amt% %mode%s.&6
Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was tempbanned by &7%admin%&6 for &7%amt% %mode%s.&6
Reason: &7%reason%&6!'
Failed: '&4%victim%&c is already tempbanned!'
Denied: '&cYour tempban has been denied!'
Emo: '&cYou cannot tempban yourself!'
Login: '&6You have been tempbanned by &7%admin%&6 for &7%time%&6. Reason: &7%reason%&6!'
TempIpBan:
MsgToVictim: '&6You have been tempipbanned by &7%admin%&6 for &7%amt% %mode%s.&6
Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was tempipbanned by &7%admin%&6 for &7%amt% %mode%s.&6
Reason: &7%reason%&6!'
Failed: '&4%victim%&c is already tempipbanned!'
Denied: '&cYour tempipban has been denied!'
Emo: '&cYou cannot tempipban yourself!'
IPNotFound: '&cIP address not found.&6 Processed as a normal tempban for &7%victim%&6!'
TempJail:
MsgToVictim: '&6You have been tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6
Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6
Reason: &7%reason%&6!'
Failed: '&4%victim%&c is already jailed!'
Denied: '&cYour tempjail has been denied!'
Emo: '&cYou cannot tempjail yourself!'
Unban:
MsgToBroadcast: '&7%victim%&6 was unbanned by &7%admin%&6!'
PermaBanned: '&cUnable to unban, &7%victim%&c was Permabanned.'
Failed: '&4%victim%&c is already unbanned!'
Warn:
MsgToVictim: '&6You have been warned by &7%admin%&6. Reason: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 was warned by &7%admin%&6. Reason: &7%reason%&6!'
Denied: '&cYour warning has been denied!'
Emo: '&cYou cannot warn yourself!'
MaxWarn:
MsgToBroadcast: '&7%cmd%&6 performed by Ultrabans on &7%victim%&6. Reason: &7Reached
Max Warnings&6!'
Permission: You do not have the required permissions.
Mode:
Second: Second
Minute: Minute
Hour: Hour
Day: Day
Week: Week
Month: Month
Year: Year
Config:
Version: 3.0

[pitilon@seznam.cz]

Configy patří do CODE

[Domotrno]

Configy patří do CODE

Sorry,
Nabudúce budem vedieť

[Netrixmc]

Prosím, zašli nám to do code, takhle se v tom nevyznáme

-- 24 pro 2015, 08:25 --

Kód: Vybrat vše

Database: SQLite

Zkus smazat SQLite a nechat tam:

Kód: Vybrat vše

Database:

[Domotrno]

Kód: Vybrat vše

  VeDatabase:
MySQL:
  Database: jdbc:mysql://localhost:3306/minecraft
  User: root
  Password: root
  Table: banlist
  IPTable: banlistip
SQLite:
  Filename: banlist
CleanOnBan: true
ClearWarnOnBan: false
Log:
  Enabled: true
MaxWarning:
  Enable: false
  Amt: 5
  Result: ban
  Silent: true
  Reason: Max Warnings
  Temp:
    Amt: 5
    Mode: day
Label:
  Console: CONSOLE
  Reason: -
Lockdown: false
Login:
  DupeCheck:
    Enable: true
  ProxyPingBack:
    Enable: false
    Timeout: 1000
Sync:
  Enabled: false
  Timing: 72000L
AutoUpdater:
  Enabled: true
Chat:
  IPCheck:
    Enable: true
    Blocking: '{Block}'
    Result: warn
    Silent: false
    Reason: Advertising
  SwearCensor:
    Enable: true
    Words: test testing tests
    Blocking: '{Block}'
    Result: warn
    Silent: false
    Reason: Language
  SpamCheck:
    Enable: true
    Counter: 10
    Result: kick
    Silent: false
    Reason: Spam
Muted:
  Vannila: true
  AllowedCommands:
  - /login
  - /register
Jail:
  Mute: true
  Vanilla: true
  AllowedCommands:
  - /login
  - /register
Messages:
  Ban:
    MsgToVictim: '&6Bol si zabanovaný &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was banned by &7%admin%&6. Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already in banned.'
    Denied: '&cYour ban attempt has been denied!'
    Emo: '&cYou cannot ban yourself!'
    Login: '&7%admin%&6 banned you from this server! Reason: &7%reason%&6!'
  CheckBan:
    Header: '&6Found &7%amt%&6 records for &7%victim%&6.'
    None: '&cNo records found for &4%victim%&c.'
  Clean:
    Complete: '&6Deleted &7%amt%&6 player.dat files.'
  DupeIP:
    Failed: '&cUnable to view ip for &4%victim% &c!'
    Header: '&6Scanning Current IP of &7%victim%&6: &7%ip% !'
    Completed: '&aScanning Complete!'
  Empty:
    MsgToVictim: '&7%admin%&6 has cleared your inventory!'
    MsgToSender: '&7%admin%&6 has cleared the inventory of &7%victim%&6!'
    Online: '&4%victim%&c must be online.'
  Export:
    Failed: '&cCould not export ban lists.'
    Completed: '&aExported banlists.'
  History:
    Header: '&6Ultrabans Listing &7%amt%&6 Records.'
    Failed: '&cUnable to find any bans.'
  Import:
    Loading: '&cBe patient. Loading...'
    Failed: '&cCould not import ban list.'
    Completed: '&aSystem imported the banlist to the database.'
  InvOf:
    Failed: '&cUnable to find player.'
    Console: '&cThis command must be executed by a &4player&c.'
  IPBan:
    MsgToVictim: '&6You have been ipbanned by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was ipbanned by &7%admin%&6. Reason: &7%reason%&6!'
    IPNotFound: '&cIP address not found. &6Processed as a normal ban for &7%victim%&6!'
    Failed: '&4%victim%&c is already in banned.'
    Denied: '&cYour ipban attempt has been denied!'
    Emo: '&cYou cannot ipban yourself!'
    Login: '&7Your IP is banned!'
  Jail:
    MsgToVictim: '&6You have been jailed by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was jailed by &7%admin%&6. Reason: &7%reason%&6!'
    SetJail: '&aJail has been set!'
    SetRelease: '&aRelease has been set!'
    Failed: '&4%victim%&c is already in jail.'
    Online: '&4%victim%&c must be online to be jailed.'
    Denied: '&cYour jail attempt has been denied!'
    Emo: '&cYou cannot jail yourself!'
    PlaceMsg: '&cYou cannot place blocks while you are jailed!'
    BreakMsg: '&cYou cannot break blocks while you are jailed!'
  Kick:
    MsgToAll: '&6Everyone has been kicked by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToVictim: '&6You have been kicked by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was kicked by &7%admin%&6. Reason: &7%reason%&6!'
    Online: '&4%victim%&c must be online.'
    Denied: '&cYour kick has been denied!'
    Emo: '&cYou cannot kick yourself!'
  Lockdown:
    Start: '&cLockdown initiated. &4Player Login&c disabled.'
    End: '&aLockdown ended. &2Player Login&a reenabled.'
    Status: '&cLockdown is disabled.'
    LoginMsg: '&4Server is under a lockdown, Try again later!&c Sorry.'
  Mute:
    MuteMsgToSender: '&6You have muted &7%victim%&6.'
    MuteMsgToVictim: '&4You have been muted!'
    UnmuteMsgToSender: '&6You have unmuted &7%victim%&6.'
    UnmuteMsgToVictim: '&aYou have been unmuted.'
    Denied: '&cYour mute has been denied!'
    Emo: '&cYou cannot mute yourself!'
    Chat: '&cYour cry falls on deaf ears.'
  Pardon:
    Msg: '&7%victim%&6 was released from jail by &7%admin%&6!'
  PermaBan:
    MsgToVictim: '&6You have been permabanned by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was permabanned by &7%admin%&6. Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already banned.'
    Online: '&4%victim%&c must be online.'
    Denied: '&cYour permaban has been denied!'
    Emo: '&cYou cannot permaban yourself!'
  Spawn:
    MsgToVictim: '&cYou have been sent to spawn!'
    MsgToSender: '&7%victim%&6 is now at spawn!'
    Failed: '&4%victim%&c is not online.'
  Starve:
    MsgToVictim: '&cYou are now starving!'
    MsgToSender: '&6%victim%&7 is now starving!'
    Failed: '&4%victim%&c is not online.'
    Denied: '&cYour starve attempt has been denied!'
    Emo: '&cYou cannot starve yourself!'
  TempBan:
    MsgToVictim: '&6You have been tempbanned by &7%admin%&6 for &7%amt% %mode%s.&6
      Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was tempbanned by &7%admin%&6 for &7%amt% %mode%s.&6
      Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already tempbanned!'
    Denied: '&cYour tempban has been denied!'
    Emo: '&cYou cannot tempban yourself!'
    Login: '&6You have been tempbanned by &7%admin%&6 for &7%time%&6. Reason: &7%reason%&6!'
  TempIpBan:
    MsgToVictim: '&6You have been tempipbanned by &7%admin%&6 for &7%amt% %mode%s.&6
      Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was tempipbanned by &7%admin%&6 for &7%amt% %mode%s.&6
      Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already tempipbanned!'
    Denied: '&cYour tempipban has been denied!'
    Emo: '&cYou cannot tempipban yourself!'
    IPNotFound: '&cIP address not found.&6 Processed as a normal tempban for &7%victim%&6!'
  TempJail:
    MsgToVictim: '&6You have been tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6
      Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6
      Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already jailed!'
    Denied: '&cYour tempjail has been denied!'
    Emo: '&cYou cannot tempjail yourself!'
  Unban:
    MsgToBroadcast: '&7%victim%&6 was unbanned by &7%admin%&6!'
    PermaBanned: '&cUnable to unban, &7%victim%&c was Permabanned.'
    Failed: '&4%victim%&c is already unbanned!'
  Warn:
    MsgToVictim: '&6You have been warned by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was warned by &7%admin%&6. Reason: &7%reason%&6!'
    Denied: '&cYour warning has been denied!'
    Emo: '&cYou cannot warn yourself!'
  MaxWarn:
    MsgToBroadcast: '&7%cmd%&6 performed by Ultrabans on &7%victim%&6. Reason: &7Reached
      Max Warnings&6!'
  Permission: You do not have the required permissions.
Mode:
  Second: Second
  Minute: Minute
  Hour: Hour
  Day: Day
  Week: Week
  Month: Month
  Year: Year
Config:rsion: 3.0


Vymazanie Mysql nepomohlo

[ungurof]

Zkus nechat načít config znova. (Smaž config.yml a restartuj server)

[Domotrno]

Zkus nechat načít config znova. (Smaž config.yml a restartuj server)

Nejde pomýlil si sa iba v tom že nie config ale ten druhý súbor ten banlist,ale aj tak ďakujem

PROBLÉM VYRIÉŠENÝ!