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: {}
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