Issues with WorldGuard MySQL

Discussion in 'Bukkit Help' started by UniqueBen, Aug 15, 2012.

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

    UniqueBen

    Hi guys, When ever I execute https://raw.github.com/sk89q/worldguard/master/region_storage_update_20110325.sql as an SQL Query on the worldguard database I get this error.
    Code:
    #1025 - Error on rename of './worldguard/region_cuboid' to './worldguard/#sql2-cc7-29b3f' (errno: 152)
    Console Output:

    Code:
    16.08 04:58:21 [Server] INFO GroupManager - INFO -  Data files refreshed.
    16.08 04:58:21 [Multicraft] Skipped 82 lines due to rate limit (30/s)
    16.08 04:58:11 [Server] INFO at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    16.08 04:58:11 [Server] INFO at net.minecraft.server.NetworkManager.b(NetworkManager.java:281)
    16.08 04:58:11 [Server] INFO at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    16.08 04:58:11 [Server] INFO at net.minecraft.serverhook.NetServerHandlerProxy.a(NetServerHandlerProxy.java:124)
    16.08 04:58:11 [Server] INFO at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    16.08 04:58:11 [Server] INFO at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    16.08 04:58:11 [Server] INFO at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:878)
    16.08 04:58:11 [Server] INFO at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:492)
    16.08 04:58:11 [Server] INFO at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168)
    16.08 04:58:11 [Server] INFO at com.sk89q.bukkit.util.DynamicPluginCommand.execute(DynamicPluginCommand.java:44)
    16.08 04:58:11 [Server] INFO at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onCommand(WorldGuardPlugin.java:203)
    16.08 04:58:11 [Server] INFO at com.sk89q.minecraft.util.commands.CommandsManager.execute(CommandsManager.java:409)
    16.08 04:58:11 [Server] INFO at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:464)
    16.08 04:58:11 [Server] INFO at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:509)
    16.08 04:58:11 [Server] INFO at com.sk89q.minecraft.util.commands.CommandsManager.invokeMethod(CommandsManager.java:522)
    16.08 04:58:11 [Server] INFO at java.lang.reflect.Method.invoke(Method.java:597)
    16.08 04:58:11 [Server] INFO at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    16.08 04:58:11 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    16.08 04:58:11 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    16.08 04:58:11 [Server] INFO at com.sk89q.worldguard.bukkit.commands.RegionCommands.define(RegionCommands.java:101)
    16.08 04:58:11 [Server] INFO at com.sk89q.worldguard.protection.GlobalRegionManager.get(GlobalRegionManager.java:237)
    16.08 04:58:11 [Server] INFO at com.sk89q.worldguard.protection.GlobalRegionManager.create(GlobalRegionManager.java:155)
    16.08 04:58:11 [Server] INFO at com.sk89q.worldguard.protection.databases.MySQLDatabase.<init>(MySQLDatabase.java:72)
    16.08 04:58:11 [Server] INFO at com.sk89q.worldguard.protection.databases.MySQLDatabase.connect(MySQLDatabase.java:143)
    16.08 04:58:11 [Server] INFO at java.sql.DriverManager.getConnection(DriverManager.java:185)
    16.08 04:58:11 [Server] INFO at java.sql.DriverManager.getConnection(DriverManager.java:582)
    16.08 04:58:11 [Server] INFO at org.sqlite.JDBC.connect(JDBC.java:64)
    16.08 04:58:11 [Server] INFO at org.sqlite.JDBC.createConnection(JDBC.java:74)
    16.08 04:58:11 [Server] INFO java.sql.SQLException: invalid database address: /mysql://localhost:3306/worldguard
    16.08 04:58:11 [Server] SEVERE [WorldGuard] invalid database address: /mysql://localhost:3306/worldguard
    Conf file:
    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
        sql:
            use: true
            dsn: /mysql://localhost:3306/worldguard
            username: root
            password: *******
        enable: true
        invincibility-removes-mobs: false
        high-frequency-flags: false
        wand: 288
        max-claim-volume: 30000
        claim-only-inside-existing-regions: false
        max-region-count-per-player:
            default: 7
        use-creature-spawn-event: true
    auto-invincible: true
    use-player-move-event: true
    op-permissions: true
    protection:
        item-durability: true
        remove-infinite-stacks: false
        disable-xp-orb-drops: false
        disable-obsidian-generators: true
    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
        allow-portal-anywhere: false
        disable-water-damage-blocks: []
    ignition:
        block-tnt: true
        block-tnt-block-damage: true
        block-lighter: false
    fire:
        disable-lava-fire-spread: true
        disable-all-fire-spread: true
        disable-fire-spread-blocks: []
        lava-spread-blocks: []
    mobs:
        block-creeper-explosions: false
        block-creeper-block-damage: true
        block-enderdragon-block-damage: true
        block-fireball-explosions: false
        block-fireball-block-damage: true
        anti-wolf-dumbness: false
        disable-enderman-griefing: true
        block-creature-spawn: []
        block-painting-destroy: false
        block-plugin-spawning: true
    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: true
        disable-explosion-damage: false
        disable-mob-damage: false
        disable-death-messages: false
    chest-protection:
        enable: false
        disable-off-check: false
    crops:
        disable-creature-trampling: true
        disable-player-trampling: false
    weather:
        prevent-lightning-strike-blocks: []
        disable-lightning-strike-fire: true
        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: true
        disable-grass-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
    summary-on-start: true
    host-keys: {}
    
     
  2. Offline

    Panzerwurst

    I might be wrong but it looks like its trying to rename the table

    region_cuboid

    To

    #sql2-cc7-29b3f



    Its not using the alter command
     
  3. Offline

    Switch0r

    Is it fixed yet ?
     
  4. Offline

    lJunKunl

    Fixed yet?
     
Thread Status:
Not open for further replies.

Share This Page