Console: "Error at SQL INSERT..."
LordValgor opened this issue ยท 4 comments
When placing unbreakable blocks, I receive the following error in the console:
[SEVERE] Error at SQL INSERT Query: java.sql.SQLException: columns x, y, z, world are not unique
This error appears when placing unbreakable blocks, and many of those blocks lose their unbreakable status and thus can be broken.
I assume that the two are related simply because of the error, but am not sure.
Hmm.. It seems to be mostly related to specific coordinates that I have previously placed unbreakable blocks in. I am properly deleting my blocks for sure, but it seems the sql file may have been corrupted some how..
I assume that adding some sort of "overwrite" function would fix this. In other words, if the sql detects a conflict, it just overwrites the coordinate, rather than throwing an error and not protecting the new block.
Yes this happens when the block of a field was removed using unnatural means like worldedit or some mod and then you try to place another field right were it was before. It will give you that error, it an be safely ignored.
Just thought I would comment on what you said.
As stated above, I am correctly removing the blocks (ie Not using worldguard or anything of the sort).
As for disregarding the error, thats fine, but that was not the issue I was having. As stated above, The blocks that I am placing which seem to give that error, are no longer protected. Ie they can be broken, by anything or anyone.
In order to resolve the issue, I have to delete the sql database, but then it soon happened again.
At any rate, I was able to work around the need for this feature, but I just thought that I would let you know that the feature is not working correctly.