search

taylorkelly / BigBrother

GNU General Public License v3.0
29 stars 20 forks source link

Loading, SQL exists error #40

Closed ghost closed 13 years ago

ghost commented 13 years ago

When i start server first, all is fine. I start server after shutdown, show this error...

BBROTHER] Create World Table SQL Exception org.h2.jdbc.JdbcSQLException: Tabulka "BBWORLDS" already exists Table "BBWORLDS" already exists; SQL statement: CREATE TABLE bbworlds (id INTEGER PRIMARY KEY,name varchar(50) NOT NULL DEFAULT 'world'); [42101-153] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.command.ddl.CreateTable.update(CreateTable.java:108) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:212) at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:125) at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110) at me.taylorkelly.bigbrother.WorldManager.createWorldTable(WorldManager.java:142) at me.taylorkelly.bigbrother.WorldManager.(WorldManager.java:24) at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:129) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:514) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:94) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:72) at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215) at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202) at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257) at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)

N3X15 commented 13 years ago

Known issue, H2 doesn't check if the table exists or not. I've committed another attempt at fixing this, but even if it doesn't fix it, it's a harmless error, just annoying.