Issues with Towny (New Town can't do anything )

Discussion in 'Spigot Plugin Help' started by Gaburaisu, Oct 9, 2019.

  1. Hi,
    A new player joined and did /t new
    But there was no message, the Town was created but when I did /t nameofthetown, there was nothing (no text)
    and this error when I type /t nameofthetown :


    The player coudn't add resident and do other commands.
    Did I mess up with something in the config ?
    My plugins are : Warp, dynmap, LuckPerms, WorldEdit, ChatMessenger,OpenInv,LoginSecurity,PlaceholderAPI,Craftconomy3,EasySetSpawn,Elevator,BetterChairs,WorldBorder,WorldGuard,SimpleTPA,SkinsRestorer,OldCombatMechanics,BasicAntiCheat,Vault,StaffPlus,Towny,ExtraContexts,QuickShop,ChatEx and Dynmap-Towny

    I'm on 1.12.2 and there was nothing until now.
     

    Attached Files:

  2. You're using CC3 for an economy plugin. It is a physical economy and you will have to make a vault-chest in order to store the town bank's money. I don't remember how that's done and it doesn't look like that plugin has been updated in a while. If you want to use a physical economy maybe consider switching to TheNewEconomy.
     
  3. CC3 is not a physical economy, (so my currency isn't) and I didn't have this issue before (with Towny and CC3)
    I forgot to say that recently, I added another currency, I don't know if Towny supports other currencies (I don't want to use 2 currencies for Towny, but only for my server in general)

    EDIT : When I type /t new, the message "[Towny] null" appears in the chat

    And in the console :
    Code (Text):
    > [18:13:10 INFO]: kagaribestgirl issued server command: /t new KagariKingdom
    > [18:13:10 WARN]: Returning offline Player UUID for : town-kagarikingdom
    > [18:13:10 WARN]: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed for column "WORLDNAME"; SQL statement:
    INSERT INTO cc3_balance (balance, worldName, username_id, currency_id) VALUES (?, ?, (SELECT id from cc3_account WHERE cc3_account.name=? AND bank=?),?) [23502-199]
    > [18:13:10 WARN]: at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)
    > [18:13:10 WARN]: at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
    > [18:13:10 WARN]: at org.h2.message.DbException.get(DbException.java:205)
    > [18:13:10 WARN]: at org.h2.message.DbException.get(DbException.java:181)
    > [18:13:10 WARN]: at org.h2.table.Column.validateConvertUpdateSequence(Column.java:418)
    > [18:13:10 WARN]: at org.h2.table.Table.validateConvertUpdateSequence(Table.java:824)
    > [18:13:10 WARN]: at org.h2.command.dml.Insert.insertRows(Insert.java:175)
    > [18:13:10 WARN]: at org.h2.command.dml.Insert.update(Insert.java:132)
    > [18:13:10 WARN]: at org.h2.command.CommandContainer.update(CommandContainer.java:133)
    > [18:13:10 WARN]: at org.h2.command.Command.executeUpdate(Command.java:267)
    > [18:13:10 WARN]: at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:200)
    > [18:13:10 WARN]: at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:154)
    > [18:13:10 WARN]: at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
    > [18:13:10 WARN]: at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
    > [18:13:10 WARN]: at com.greatmancode.craftconomy3.storage.sql.SQLStorageEngine.getAccount(SQLStorageEngine.java:138)
    > [18:13:10 WARN]: at com.greatmancode.craftconomy3.storage.StorageEngine.getAccount(StorageEngine.java:63)
    > [18:13:10 WARN]: at com.greatmancode.craftconomy3.account.AccountManager.getAccount(AccountManager.java:56)
    > [18:13:10 WARN]: at net.milkbowl.vault.economy.plugins.Economy_Craftconomy3.createPlayerAccount(Economy_Craftconomy3.java:263)
    > [18:13:10 WARN]: at com.palmergames.bukkit.towny.TownyEconomyHandler.getBalance(TownyEconomyHandler.java:255)
    > [18:13:10 WARN]: at com.palmergames.bukkit.towny.object.TownyEconomyObject.getHoldingBalance(TownyEconomyObject.java:170)
    > [18:13:10 WARN]: at com.palmergames.bukkit.towny.object.TownyEconomyObject.setBalance(TownyEconomyObject.java:146)
    > [18:13:10 WARN]: at com.palmergames.bukkit.towny.command.TownCommand.newTown(TownCommand.java:1924)
    > [18:13:10 WARN]: at com.palmergames.bukkit.towny.command.TownCommand.newTown(TownCommand.java:1878)
    > [18:13:10 WARN]: at com.palmergames.bukkit.towny.command.TownCommand.parseTownCommand(TownCommand.java:210)
    > [18:13:10 WARN]: at com.palmergames.bukkit.towny.command.TownCommand.onCommand(TownCommand.java:120)
    > [18:13:10 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
    > [18:13:10 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
    > [18:13:10 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:648)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.PlayerConnection.handleCommand(PlayerConnection.java:1401)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.PlayerConnection.a(PlayerConnection.java:1236)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:45)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:1)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.PlayerConnectionUtils$1.run(SourceFile:13)
    > [18:13:10 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    > [18:13:10 WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.SystemUtils.a(SourceFile:46)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:748)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:406)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:679)
    > [18:13:10 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:577)
    > [18:13:10 WARN]: at java.lang.Thread.run(Thread.java:748)
     
    EDIT 2 : The other currency is not a problem, I deleted it and it was the same.
     
    #3 Gaburaisu, Oct 10, 2019
    Last edited: Oct 10, 2019