SQLITE_ERROR: (no such table: radiationLevels) #18


  • New
  • Defect
Open
Assigned to _ForgeUser8604644
  • _ForgeUser5988981 created this issue Jan 12, 2014

    What steps will reproduce the problem?
    1. Log into a server, specifically into a world that is not in config.yml for Apocalyptic (teleporting to non-Apocalyptic worlds with multiverse seems to not generate the error)

    What is the expected output? What do you see instead?
    Expected no errors in bukkit output, seeing errors.

    What version of the product are you using?
    Apocalyptic v2.3.3
    SQLibrary v7.0
    Bukkit 1.7.2-R0.2-b2974jnks
    Multiverse-Core v2.5-b677
    Multiverse-Portals v2.5-b699
    Multiverse-NetherPortals v2.5-b668

    Do you have an error log of what happened?
    see following:
    [14:47:01] [Server thread/INFO]: MonkeyJamboree[/192.168.1.108:57681] logged in with entity id 855 at ([WimmyWhamWhamWozzle2014] 164.11704957770417, 69.0, 217.63958744446572)
    [14:47:01] [Server thread/WARN]: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: radiationLevels)
    [14:47:01] [Server thread/WARN]:     at org.sqlite.DB.newSQLException(DB.java:383)
    [14:47:01] [Server thread/WARN]:     at org.sqlite.DB.newSQLException(DB.java:387)
    [14:47:01] [Server thread/WARN]:     at org.sqlite.DB.throwex(DB.java:374)
    [14:47:01] [Server thread/WARN]:     at org.sqlite.NativeDB.prepare(Native Method)
    [14:47:01] [Server thread/WARN]:     at org.sqlite.DB.prepare(DB.java:123)
    [14:47:01] [Server thread/WARN]:     at org.sqlite.Stmt.execute(Stmt.java:113)
    [14:47:01] [Server thread/WARN]:     at lib.PatPeter.SQLibrary.Database.query(Database.java:242)
    [14:47:01] [Server thread/WARN]:     at net.cyberninjapiggy.apocalyptic.Apocalyptic.loadRadiation(Apocalyptic.java:479)
    [14:47:01] [Server thread/WARN]:     at net.cyberninjapiggy.apocalyptic.events.PlayerJoin.onPlayerJoin(PlayerJoin.java:38)
    [14:47:01] [Server thread/WARN]:     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    [14:47:01] [Server thread/WARN]:     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    [14:47:01] [Server thread/WARN]:     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    [14:47:01] [Server thread/WARN]:     at java.lang.reflect.Method.invoke(Unknown Source)
    [14:47:01] [Server thread/WARN]:     at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:425)
    [14:47:01] [Server thread/WARN]:     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    [14:47:01] [Server thread/WARN]:     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:481)
    [14:47:01] [Server thread/WARN]:     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:466)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.PlayerList.c(PlayerList.java:225)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.PlayerList.a(PlayerList.java:116)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.LoginListener.c(LoginListener.java:78)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.LoginListener.a(LoginListener.java:42)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.NetworkManager.a(NetworkManager.java:149)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.ServerConnection.c(SourceFile:134)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.MinecraftServer.u(MinecraftServer.java:655)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.DedicatedServer.u(DedicatedServer.java:250)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.MinecraftServer.t(MinecraftServer.java:545)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:457)
    [14:47:01] [Server thread/WARN]:     at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617)

    Please provide any additional information below.
    Possibly related: Zombies catch fire and die in sunlight regardless of burnInDaylight settings in config.yml.
    Only added one world under worlds in config.yml for the specified Apocalyptic world. Is this not the correct way to set up the plugin? (there doesn't seem to be any sort of wiki or guide on setting these things up that I can find). Here are my settings (most of them defaults):
    maxRadiationWashable: 1.5
    radiationCures:
      - GOLDEN_APPLE
    worlds:
      Apocalypse:
        radiationRate: 0.1
        radiationTop: 120
        radiationBottom: 40
        texturepack: true
        fallout: true
        zombie: true
        mobs:
          mutants:
            zombie: true
            creeper: true
            skeleton: true
          zombies:
            spawnLimit: 512
            burnInDaylight: false
            health: 25.0
            speedMultiplier: 3.0
            damageMultiplier: 2
            hordeInstinct: true
            targetRange: 32.0
            hordeSize:
              min: 7
              max: 21
            effects:
              hunger: true
              weakness: true
              slowness: true
              nausea: true
    regions:
      fallout:
        - aRegionThatHasFallout
      noFallout:
        - aRegionThatHasNoFallout
    meta:
      #Do not edit version
      version: 2.3.3
      version-check: true
      auto-update: true
      show-download-progress: true
      #True to use permissions. False defaults to requiring op for most commands.
      permissions: false

  • _ForgeUser5988981 added the tags New Defect Jan 12, 2014
  • _ForgeUser8604644 posted a comment Jan 12, 2014

    Thanks for all the info you gave me. As a temporary fix until I update SQLibrary compatibility, try downgrading to SQLibrary 6.1, as that is the latest version I built against.


    Edited Jan 13, 2014
  • _ForgeUser5988981 posted a comment Jan 13, 2014

    Oh, awesome. That seems to work. Thanks! Out of curiosity, is there a reason you use SQLibrary over just whatever bukkit has built in for the db?

  • _ForgeUser8604644 posted a comment Jan 13, 2014

    @MonkeyJamboree: Go

    If bukkit has support for SQLite, I will gladly switch over.

  • _ForgeUser5988981 posted a comment Jan 13, 2014

    It actually does now, AFAIK... I am not a plugin developer, but bukkit.yml by default uses sqlite in the database section, and you can switch that to mysql if you want to use that instead.

    Personally, bukkit should have a more generic "database" interface and then obfuscate that and let bukkit server admins set up whatever db server they want, but that's just my opinion.


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