#9 Hi, I get an error it i try to use a Mysql se... - Issues - NiftyWarp - Bukkit Plugins - Projects

Hi, I get an error it i try to use a Mysql se... #9

Defect
Accepted

Open

Assigned to

_ForgeUser8545624

_ForgeUser8545624 created this issue Mar 13, 2012

Maintainer

Hi,
I get an error it i try to use a Mysql server to store the NiftyWarp data.
NiftyWarp creates the table and creates the correct entry if I create a warp but if I try to delete one I get an error.
NiftyWarp also creates empty config-files.

Bukkit: 1.2.3-R0.2
NiftyWarp: 1.3.2

2012-03-12 17:13:05 [SEVERE] null
org.bukkit.command.CommandException: Unhandled exception executing command 'nwd' in plugin NiftyWarp v1.3.2
	at org.bukkit.command.PluginCommand.execute(PluginCommand.java:42)
	at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:166)
	at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:469)
	at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:906)
	at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:866)
	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:849)
	at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:33)
	at net.minecraft.server.NetworkManager.b(NetworkManager.java:229)
	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116)
	at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
	at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554)
	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452)
	at net.minecraft.server.ThreadServerApplication.run(SourceFile:490)
Caused by: javax.persistence.OptimisticLockException: Data has changed. updated [0] rows sql[delete from nw_warp where id=? and fully_qualified_name=? and name=? and owner=? and warp_type=? and world_name=? and x=? and y=? and z=? and pitch=? and yaw=?] bind[null]
	at com.avaje.ebeaninternal.server.persist.dml.DmlHandler.checkRowCount(DmlHandler.java:123)
	at com.avaje.ebeaninternal.server.persist.dml.DeleteHandler.execute(DeleteHandler.java:81)
	at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
	at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.delete(DmlBeanPersister.java:67)
	at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeDeleteBean(DefaultPersistExecute.java:128)
	at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:535)
	at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:557)
	at com.avaje.ebeaninternal.server.persist.DefaultPersister.delete(DefaultPersister.java:654)
	at com.avaje.ebeaninternal.server.persist.DefaultPersister.delete(DefaultPersister.java:464)
	at com.avaje.ebeaninternal.server.core.DefaultServer.delete(DefaultServer.java:1831)
	at com.avaje.ebeaninternal.server.core.DefaultServer.delete(DefaultServer.java:1821)
	at net.niftymonkey.niftywarp.persistence.EbeanServerPersistenceProvider.delete(EbeanServerPersistenceProvider.java:117)
	at net.niftymonkey.niftywarp.WarpManager.deleteWarp(WarpManager.java:232)
	at net.niftymonkey.niftywarp.commands.DeleteWarpCommand.onCommand(DeleteWarpCommand.java:66)
	at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
	... 12 more

Can you look into this please.

_ForgeUser8545624 added the tags Accepted Defect Mar 13, 2012
_ForgeUser8545624 posted a comment Mar 14, 2012

MarioG1,

The config file issue should be resolved once v1.3.3 of the pluging is approved.

AS for the error when deleting a warp when using MySQL.: I think this a little bit more involved, so we will need to add specific support for an MySQL server for the commands to work properly. We'll aim for getting this support in the next version of NiftyWarp.

Thanks for your patience

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