Database

[odda10]

Hallo,
Ik heb de plugin op mijn 1.7.2 craftbukkit server draaien, maar als ik /zcreate test doe en dan selecteer en dan /zsave dan krijg ik een error: 'no such table: zones'
Dus ik heb in de mysql database een table genaamd zones gemaakt, maar hij geeft nogsteeds dezelfde error.
Zou je hiermee kunnen helpen?

mvg,
odda

[Meaglin]

Heb je je database configuratie goed staan?

Je moet in bukkit.yml wel goed je database instellen.

[odda10]

Nu wel, had t niet gezien.
Als ik nu /zsave doe doet hij er wat langer over en zegt hij alsnog 'Error saving zone'
Nu geeft hij deze error:
[Informatie] [18:32:46 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'name' in 'field list'
[Informatie] [18:32:46 WARN]: at sun.reflect.GeneratedConstructorAccessor39.newInstance(Unknown Source)
[Informatie] [18:32:46 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[Informatie] [18:32:46 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
[Informatie] [18:32:46 WARN]: at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
[Informatie] [18:32:46 WARN]: at com.zones.persistence.Database.save(Database.java:225)
[Informatie] [18:32:46 WARN]: at com.zones.selection.ZoneCreateSelection.save(ZoneCreateSelection.java:49)
[Informatie] [18:32:46 WARN]: at com.zones.selection.ZoneSelection.confirm(ZoneSelection.java:232)
[Informatie] [18:32:46 WARN]: at com.zones.command.CreateCommands.save(CreateCommands.java:163)
[Informatie] [18:32:46 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Informatie] [18:32:46 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[Informatie] [18:32:46 WARN]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[Informatie] [18:32:46 WARN]: at java.lang.reflect.Method.invoke(Method.java:601)
[Informatie] [18:32:46 WARN]: at com.zones.command.CommandMap.run(CommandMap.java:137)
[Informatie] [18:32:46 WARN]: at com.zones.Zones.onCommand(Zones.java:184)
[Informatie] [18:32:46 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[Informatie] [18:32:46 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:196)
[Informatie] [18:32:46 WARN]: at org.bukkit.craftbukkit.v1_7_R1.CraftServer.dispatchCommand(CraftServer.java:542)
[Informatie] [18:32:46 WARN]: at net.minecraft.server.v1_7_R1.PlayerConnection.handleCommand(PlayerConnection.java:932)
[Informatie] [18:32:46 WARN]: at net.minecraft.server.v1_7_R1.PlayerConnection.a(PlayerConnection.java:814)

Ik heb geen idee wat ik hiermee moet..

[Meaglin]

Heb je het nog geprobeerd met de laaste build ? 3.0b1