search

taylorkelly / BigBrother

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

Server startup issue CB #670 #61

Closed MacG32 closed 13 years ago

MacG32 commented 13 years ago

BigBrother.yml:

general: rollbacks-per-tick: 2000 personal-log-files: true auto-watch: true debug-mode: false default-search-radius: 2 restore-fire: false stick-item: 280 library-autodownload: true excluded-blocks: [] tnt-threshold: 10.0 database: cleanse-age: 3d deletes-per-cleansing: '20000' max-records: '3000000' type: SQLITE send-delay: 4 mysql: port: 3306 username: minecraft engine: MyISAM prefix: '' low-priority-insert: true hostname: localhost password: '' database: minecraft watched: environment: lava-flow: true leaf-decay: true player: ip-player: true disconnect: true login: true teleport: true drop-item: true pickup-item: true explosions: tnt: true creeper: true misc: true chat: commands: true chat: true blocks: chest-changes: true block-place: true block-break: true misc: flint-logging: true door-open: true lever-switch: true button-press: true

Server startup errors:

2011-04-09 14:45:26 [INFO] [BBROTHER] ------------------------------------ 2011-04-09 14:45:26 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother! 2011-04-09 14:45:26 [INFO] [BBROTHER] Please note that, since this is far from complete, there will be many bugs. 2011-04-09 14:45:26 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON https://github.com/tkelly910/BigBrother/issues 2011-04-09 14:45:26 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for updates and build notifications. 2011-04-09 14:45:26 [INFO] [BBROTHER] ------------------------------------ 2011-04-09 14:45:26 [INFO] [BBROTHER] Building bbdata table... 2011-04-09 14:45:26 [SEVERE] [BBROTHER] Can't create the bbdata table org.h2.jdbc.JdbcSQLException: Table "BBDATA" already exists; SQL statement: CREATE TABLE bbdata (id INTEGER AUTO_INCREMENT PRIMARY KEY,date INT UNSIGNED NOT NULL DEFAULT '0',player INT UNSIGNED NOT NULL DEFAULT '0',action tinyint NOT NULL DEFAULT '0',world tinyint NOT NULL DEFAULT '0',x int NOT NULL DEFAULT '0',y tinyint UNSIGNED NOT NULL DEFAULT '0',z int NOT NULL DEFAULT '0',type smallint NOT NULL DEFAULT '0',data varchar(500) NOT NULL DEFAULT '',rbacked boolean NOT NULL DEFAULT '0');CREATE INDEX dateIndex on bbdata (date);CREATE INDEX playerIndex on bbdata (player);CREATE INDEX actionIndex on bbdata (action);CREATE INDEX worldIndex on bbdata (world);CREATE INDEX posIndex on bbdata (x,y,z);CREATE INDEX typeIndex on bbdata (type);CREATE INDEX rbackedIndex on bbdata (rbacked); [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.command.CommandList.update(CommandList.java:41) 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.tablemgrs.DBTable.createTable(DBTable.java:64) at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.(BBDataTable.java:44) at me.taylorkelly.bigbrother.tablemgrs.BBDataH2.(BBDataH2.java:10) at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTable.java:36) at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:142) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93) 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) 2011-04-09 14:45:26 [INFO] [BBROTHER] BBData H2 Driver r1 loaded! 2011-04-09 14:45:27 [SEVERE] [BBROTHER] Create World Table SQL Exception org.h2.jdbc.JdbcSQLException: 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:147) at me.taylorkelly.bigbrother.WorldManager.(WorldManager.java:24) at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:143) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93) 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) 2011-04-09 14:45:27 [INFO] [BBROTHER] Building bbusers table... 2011-04-09 14:45:27 [SEVERE] [BBROTHER] Can't create the bbusers table org.h2.jdbc.JdbcSQLException: Table "BBUSERS" already exists; SQL statement: CREATE TABLE bbusers (id INT AUTO_INCREMENT PRIMARY KEY,name varchar(32) NOT NULL DEFAULT 'Player',flags INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX idxUsername ON bbusers (name) [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.command.CommandList.update(CommandList.java:41) 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.tablemgrs.DBTable.createTable(DBTable.java:64) at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.(BBUsersTable.java:55) at me.taylorkelly.bigbrother.tablemgrs.BBUsersH2.(BBUsersH2.java:12) at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.getInstance(BBUsersTable.java:44) at me.taylorkelly.bigbrother.BBPlayerInfo.(BBPlayerInfo.java:50) at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:144) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93) 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) 2011-04-09 14:45:27 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.6 2011-04-09 14:45:27 [INFO] [BBROTHER] 'Help' support enabled 2011-04-09 14:45:27 [INFO] [BBROTHER] BigBrother 1.7.2-SNAPSHOT enabled

N3X15 commented 13 years ago

H2 errors should be fixed now.