WorldGuard MySQL error

Discussion in 'Bukkit Help' started by userdel_9192018, Feb 26, 2013.

Thread Status:
Not open for further replies.
  1. Offline

    userdel_9192018

    Hey, I'm having problems with my worldguard MySQL, i get this error
    Code:
    2013-02-26 08:58:56 [SEVERE] You need to update your database to the latest version.
    Please see region_storage_update_20110325.sql
    2013-02-26 08:58:56 [SEVERE] at com.sk89q.worldguard.protection.databases.MySQLDatabase.<init>(MySQLDatabase.java:79)
    2013-02-26 08:58:56 [SEVERE] at com.sk89q.worldguard.protection.GlobalRegionManager.create(GlobalRegionManager.java:155)
    2013-02-26 08:58:56 [SEVERE] at com.sk89q.worldguard.protection.GlobalRegionManager.load(GlobalRegionManager.java:130)
    2013-02-26 08:58:56 [SEVERE] at com.sk89q.worldguard.protection.GlobalRegionManager.preload(GlobalRegionManager.java:194)
    2013-02-26 08:58:56 [SEVERE] at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onEnable(WorldGuardPlugin.java:149)
    2013-02-26 08:58:56 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
    2013-02-26 08:58:56 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
    2013-02-26 08:58:56 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
    2013-02-26 08:58:56 [SEVERE] at org.bukkit.craftbukkit.v1_4_R1.CraftServer.loadPlugin(CraftServer.java:282)
    2013-02-26 08:58:56 [SEVERE] at org.bukkit.craftbukkit.v1_4_R1.CraftServer.enablePlugins(CraftServer.java:264)
    2013-02-26 08:58:56 [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.j(MinecraftServer.java:321)
    2013-02-26 08:58:56 [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.e(MinecraftServer.java:300)
    2013-02-26 08:58:56 [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.a(MinecraftServer.java:259)
    2013-02-26 08:58:56 [SEVERE] at net.minecraft.server.v1_4_R1.DedicatedServer.init(DedicatedServer.java:149)
    2013-02-26 08:58:56 [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.run(MinecraftServer.java:399)
    
    I really don't know what to do and how to fix this, I'm using fluctisHost and i'm already given a database, which i have to use.

    This is my WorldGuard config.yml
    Show Spoiler

    Code:
    #
    # WorldGuard's main configuration file
    #
    # This is the global configuration file. Anything placed into here will
    # be applied to all worlds. However, each world has its own configuration
    # file to allow you to replace most settings in here for that world only.
    #
    # About editing this file:
    # - DO NOT USE TABS. You MUST use spaces or Bukkit will complain. If
    #  you use an editor like Notepad++ (recommended for Windows users), you
    #  must configure it to "replace tabs with spaces." In Notepad++, this can
    #  be changed in Settings > Preferences > Language Menu.
    # - Don't get rid of the indents. They are indented so some entries are
    #  in categories (like "enforce-single-session" is in the "protection"
    #  category.
    # - If you want to check the format of this file before putting it
    #  into WorldGuard, paste it into http://yaml-online-parser.appspot.com/
    #  and see if it gives "ERROR:".
    # - Lines starting with # are comments and so they are ignored.
    #
     
    regions:
        use-scheduler: true
        use-creature-spawn-event: true
        sql:
            use: true
            dsn: jdbc:mysql://5.135.136.16/viktjanp6412DB
            username: viktjanp6412
            password: ********
        enable: true
        invincibility-removes-mobs: false
        high-frequency-flags: false
        wand: 334
        max-claim-volume: 30000
        claim-only-inside-existing-regions: false
        max-region-count-per-player:
            default: 7
    auto-invincible: false
    use-player-move-event: true
    security:
        deop-everyone-on-join: false
        block-in-game-op-command: false
    host-keys: {}
    summary-on-start: true
    op-permissions: true
    protection:
        item-durability: true
        remove-infinite-stacks: false
        disable-xp-orb-drops: false
        disable-obsidian-generators: false
    gameplay:
        block-potions: []
        block-potions-overly-reliably: false
    simulation:
        sponge:
            enable: true
            radius: 3
            redstone: false
    default:
        pumpkin-scuba: false
        disable-health-regain: false
    physics:
        no-physics-gravel: false
        no-physics-sand: false
        vine-like-rope-ladders: false
        allow-portal-anywhere: false
        disable-water-damage-blocks: []
    ignition:
        block-tnt: false
        block-tnt-block-damage: false
        block-lighter: false
    fire:
        disable-lava-fire-spread: false
        disable-all-fire-spread: false
        disable-fire-spread-blocks: []
        lava-spread-blocks: []
    mobs:
        block-creeper-explosions: false
        block-creeper-block-damage: false
        block-wither-explosions: false
        block-wither-block-damage: false
        block-wither-skull-explosions: false
        block-wither-skull-block-damage: false
        block-enderdragon-block-damage: false
        block-enderdragon-portal-creation: false
        block-fireball-explosions: false
        block-fireball-block-damage: false
        anti-wolf-dumbness: false
        disable-enderman-griefing: false
        block-painting-destroy: false
        block-item-frame-destroy: false
        block-plugin-spawning: true
        block-above-ground-slimes: false
        block-other-explosions: false
        block-zombie-door-destruction: false
        block-creature-spawn: []
    player-damage:
        disable-fall-damage: false
        disable-lava-damage: false
        disable-fire-damage: false
        disable-lightning-damage: false
        disable-drowning-damage: false
        disable-suffocation-damage: false
        disable-contact-damage: false
        teleport-on-suffocation: false
        disable-void-damage: false
        teleport-on-void-falling: false
        disable-explosion-damage: false
        disable-mob-damage: false
        disable-death-messages: false
    chest-protection:
        enable: false
        disable-off-check: false
    crops:
        disable-creature-trampling: false
        disable-player-trampling: false
    weather:
        prevent-lightning-strike-blocks: []
        disable-lightning-strike-fire: false
        disable-thunderstorm: false
        disable-weather: false
        disable-pig-zombification: false
        disable-powered-creepers: false
        always-raining: false
        always-thundering: false
    dynamics:
        disable-mushroom-spread: false
        disable-ice-melting: false
        disable-snow-melting: false
        disable-snow-formation: false
        disable-ice-formation: false
        disable-leaf-decay: false
        disable-grass-growth: false
        disable-mycelium-spread: false
        disable-vine-growth: false
    blacklist:
        use-as-whitelist: false
        logging:
            console:
                enable: true
            database:
                enable: false
                dsn: jdbc:mysql://localhost:3306/minecraft
                user: root
                pass: ''
                table: blacklist_events
            file:
                enable: false
                path: worldguard/logs/%Y-%m-%d.log
                open-files: 10
    


    Please help me.
    thnx
     
  2. Offline

    Lolmewn

    It is known that WorldGuard doesn't work too well with MySQL. I'd suggest switching to flatfile, although you could also run the region_storage_update_20110325.sql file to update your current database.
     
  3. Offline

    lokpique

    Try using...
    dsn: jdbc:mysql://5.135.136.16:3306/viktjanp6412DB

    see if that works.

    EDIT : also it's telling you to update the database (so you can probably ignore hardcoding the port, in fact)... but it seems to be pointing you to a script you can run to update the database

    The script file is located in the contrib folder from the worldguard zip file.
    region_storage_update_20110325.sql
     
  4. Offline

    MajikTom

    same problem here, and running the sql on the database produces errors becuase the tables were never created in the first place.
    Does someone have a DDL script to create the tables?
     
Thread Status:
Not open for further replies.

Share This Page