Cannot personalize tables? #75


  • New
  • Defect
Open
Assigned to _ForgeUser7265008
  • FabioZumbi12 created this issue Aug 1, 2014

    What steps will reproduce the problem?
    1. On auto-save inventories, i getting the errors.
    2. I changed the tables to:

    tables:
      prefix: 'f84ix_'
      suffix: ''
      player: 'users'
      inventory: 'inventarios'
      enderchest: 'enderchests'

    What version of the product are you using?
    Craftbukkit 1.7.9

    Please provide any additional information below.

    [01:18:19 INFO]: null
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'playe
    rname' in 'where clause'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    ~[?:1.8.0_05]
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    ~[?:1.8.0_05]
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
    rce) ~[?:1.8.0_05]
            at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_0
    5]
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[craftbukkit-1.
    7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.Util.getInstance(Util.java:382) ~[craftbukkit-1.7.9.ja
    r:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[craf
    tbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[craftbuk
    kit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[craftbuk
    kit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) ~[craftbukkit-1
    .7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) ~[craftbukki
    t-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) ~[cra
    ftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
    va:2111) ~[craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
    2273) ~[craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler.getPlayerI
    D(MySQLDatabaseHandler.java:134) ~[InventorySQL.3.4.7.jar:?]
            at tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler.savePlayer
    Inventory(MySQLDatabaseHandler.java:79) ~[InventorySQL.3.4.7.jar:?]
            at tk.manf.InventorySQL.manager.DatabaseManager.savePlayer(DatabaseManag
    er.java:76) [InventorySQL.3.4.7.jar:?]
            at tk.manf.InventorySQL.InventorySQLPlugin$1.run(InventorySQLPlugin.java
    :77) [InventorySQL.3.4.7.jar:?]
            at org.bukkit.craftbukkit.v1_7_R3.scheduler.CraftTask.run(CraftTask.java
    :53) [craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at org.bukkit.craftbukkit.v1_7_R3.scheduler.CraftScheduler.mainThreadHea
    rtbeat(CraftScheduler.java:345) [craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-
    g8688bd4-b3092jnks]
            at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:6
    00) [craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:2
    60) [craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:5
    58) [craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java
    :469) [craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]
            at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:6
    28) [craftbukkit-1.7.9.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks]

  • FabioZumbi12 added the tags New Defect Aug 1, 2014
  • FabioZumbi12 posted a comment Aug 1, 2014

    Probally, is because may table already existis, and the colluns is not created! Can you make a way to we personalize the coluns too? I use in Joomla, and Joomla uses "username" for playername.

  • _ForgeUser7265008 posted a comment Aug 2, 2014

    @FabioZumbi12: Go

    I will probably not add such a feature, this would be pretty overloading.


To post a comment, please login or register a new account.