search

taylorkelly / BigBrother

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

ALWAYS attempts to create tables upon startup #60

Closed miamore closed 13 years ago

miamore commented 13 years ago

11:51:02 [INFO] Permissions was Initialized. 11:51:02 [INFO] [BBROTHER] ------------------------------------ 11:51:02 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother! 11:51:02 [INFO] [BBROTHER] Please note that, since this is far from complete, th ere will be many bugs. 11:51:02 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON https://g ithub.com/tkelly910/BigBrother/issues 11:51:02 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for up dates and build notifications. 11:51:02 [INFO] [BBROTHER] ------------------------------------ 11:51:03 [INFO] [BBROTHER] Building bbdata table... 11:51:03 [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 UNSIGN ED NOT NULL DEFAULT '0',player INT UNSIGNED NOT NULL DEFAULT '0',action tiny int NOT NULL DEFAULT '0',world tinyint NOT NULL DEFAULT '0',x int NOT NULL D EFAULT '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);C REATE INDEX playerIndex on bbdata (player);CREATE INDEX actionIndex on bbdata (a ction);CREATE INDEX worldIndex on bbdata (world);CREATE INDEX posIndex on bbdata (x,y,z);CREATE INDEX typeIndex on bbdata (type);CREATE INDEX rbackedIndex on bb data (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:12 5) 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.ja va:44) at me.taylorkelly.bigbrother.tablemgrs.BBDataH2.(BBDataH2.java:10)

    at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTab

le.java:36) at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:142) 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(SimplePluginManage r.java:216) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:94) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:72) at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:264) at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleComma ndMap.java:196) at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80 ) at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:2 25) at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:391) at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:377) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283) at net.minecraft.server.ThreadServerApplication.run(SourceFile:375) 11:51:03 [INFO] [BBROTHER] BBData H2 Driver r1 loaded! 11:51:03 [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 DE FAULT '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:12 5) 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:118) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader .java:514) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage r.java:216) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:94) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:72) at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:264) at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleComma ndMap.java:196) at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80 ) at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:2 25) at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:391) at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:377) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283) at net.minecraft.server.ThreadServerApplication.run(SourceFile:375) 11:51:03 [INFO] [BBROTHER] Building bbusers table... 11:51:04 [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) N OT NULL DEFAULT 'Player',flags INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX i dxUsername 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:12 5) 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:1 2) at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.getInstance(BBUsersT able.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:118) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader .java:514) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage r.java:216) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:94) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:72) at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:264) at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleComma ndMap.java:196) at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80 ) at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:2 25) at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:391) at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:377) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283) at net.minecraft.server.ThreadServerApplication.run(SourceFile:375) 11:51:04 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.5.5 11:51:04 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support 11:51:04 [INFO] [BBROTHER] BigBrother 1.7.2-SNAPSHOT enabled 11:51:05 [INFO] Loaded Essentials build 2.1.20 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans. 11:51:05 [INFO] Loaded EssentialsSpawn build 2.1.20 maintained by Zenexer, ement alo, Aelux, Brettflan, KimKandor, snowleo and ceulemans. 11:51:05 [INFO] [Permissions] version 2.5.5 loaded 11:51:05 [INFO] Whitelist: Trying to load whitelist and settings... 11:51:05 [INFO] done. 11:51:05 [INFO] Whitelist version 2.7 is enabled! 11:51:05 [INFO] WorldEdit 4.3 enabled. 11:51:05 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions. 11:51:05 [INFO] WorldGuard: Permissions plugin detected! Using Permissions plugi n for permissions. 11:51:05 [WARNING] Found option with no heading blacklist.txt for 'Deny lava buc kets' 11:51:05 [INFO] WorldGuard: Blacklist loaded. 11:51:05 [INFO] WorldGuard: (world) Single session is enforced. 11:51:05 [INFO] WorldGuard: (world) TNT ignition is blocked. 11:51:05 [INFO] WorldGuard: (world) Lighters are PERMITTED. 11:51:05 [INFO] WorldGuard: (world) Lava fire is blocked. 11:51:05 [INFO] WorldGuard: (world) All fire spread is disabled. 11:51:05 [INFO] WorldGuard: Loaded configuration for world 'world" 11:51:05 [INFO] WorldGuard 5.0-alpha8 enabled. 11:51:05 [INFO] Reload complete. 11:51:05 [WARNING] Can't keep up! Did the system time change, or is the server o verloaded? 11:51:07 [INFO] [BBROTHER] Starting Cleanser thread... 11:51:07 [INFO] [BBROTHER] Cleaned out 0 records because of age in 0h00m00s. 11:51:07 [INFO] [BBROTHER] Ending Cleanser thread...

HawnSolo commented 13 years ago

Running into the same issue. Here's my output:

21:29:38 [INFO] [BBROTHER] ------------------------------------
21:29:38 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of
 BigBrother!
21:29:38 [INFO] [BBROTHER] Please note that, since this is far from complete, th
ere will be many bugs.
21:29:38 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON https://g
ithub.com/tkelly910/BigBrother/issues
21:29:38 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for up
dates and build notifications.
21:29:38 [INFO] [BBROTHER] ------------------------------------
21:29:38 [INFO] Need to download 1 object(s)
21:29:38 [INFO]  - Downloading file : http://mine.7chan.org/mirror/lib/postgresq
l.jar to lib/postgresql.jar
21:29:38 [INFO] (Meaning C:\Users\Shawn\AppData\Roaming\.minecraft server\bin\li
b\postgresql.jar)
21:29:39 [INFO]   + Download complete
21:29:40 [INFO] [BBROTHER] Building `bbdata` table...
21:29:40 [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 UNSIGN
ED NOT NULL DEFAULT '0',`player` INT UNSIGNED NOT NULL DEFAULT '0',`action` tiny
int NOT NULL DEFAULT '0',`world` tinyint NOT NULL DEFAULT '0',`x` int NOT NULL D
EFAULT '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);C
REATE INDEX playerIndex on bbdata (player);CREATE INDEX actionIndex on bbdata (a
ction);CREATE INDEX worldIndex on bbdata (world);CREATE INDEX posIndex on bbdata
 (x,y,z);CREATE INDEX typeIndex on bbdata (type);CREATE INDEX rbackedIndex on bb
data (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:12
5)
        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.ja
va:44)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataH2.(BBDataH2.java:10)

        at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTab
le.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(SimplePluginManage
r.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)
21:29:41 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
21:29:41 [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 DE
FAULT '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:12
5)
        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(SimplePluginManage
r.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)
21:29:42 [INFO] [BBROTHER] Building `bbusers` table...
21:29:43 [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) N
OT NULL DEFAULT 'Player',`flags` INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX i
dxUsername 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:12
5)
        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:1
2)
        at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.getInstance(BBUsersT
able.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(SimplePluginManage
r.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)
21:29:44 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.6
21:29:44 [INFO] [BBROTHER] 'Help' support enabled
21:29:44 [INFO] [BBROTHER] BigBrother 1.7.2-SNAPSHOT enabled
MrZoraman commented 13 years ago

I had this issue for a while too. But it is fixable. I went into the BigBrother.yml file, and under the database type, it was set as H2. I changed it to mysql, and then after that it worked fine. :)

HawnSolo commented 13 years ago

I'm using SQLite, though. I don't have a MySQL server set up; should I just switch back and forth or something?

MrZoraman commented 13 years ago

Well it looks like BigBrother does support SQLite, but it seems that people are having a variety of issues. I would reccomend setting up a MySql database. The instructions are clear and easy to follow. I put the link below.

https://github.com/tkelly910/BigBrother/wiki/Downloading-and-Installing-MySQL

On Sat, Apr 9, 2011 at 7:46 PM, HawnSolo < reply@reply.github.com>wrote:

I'm using SQLite, though. I don't have a MySQL server set up; should I just switch back and forth or something?

Reply to this email directly or view it on GitHub: https://github.com/tkelly910/BigBrother/issues/60#comment_978761

HawnSolo commented 13 years ago

Is there a way to migrate the SQLite database to the MySQL one? Now's not a good time to lose the tracking that BB's done.

miamore commented 13 years ago

First Make sure you have MySQL installed and have it connected successfully with BigBrother

Then try and use this guide: http://ariejan.net/2006/10/13/migrate-sqlite3-to-mysql-easily/

If that one doesn't work just search Google for something like " move SQLite data to MySQL" or something

Good Luck! ^.^

N3X15 commented 13 years ago

This is a bug in H2. I've added a workaround.