1. NOTE: Bukkit may cease to exist in the near future. For more information, read this thread.

Issue updating worldguard mysql database

Discussion in 'WorldGuard' started by Pricetx, Jul 26, 2012.

  1. Pricetx

    Pricetx New Member

    When I tried to start WorldGuard with mysql enabled I received the following output in my console.

    Code (Text):
    18:56:04 [SEVERE] You need to update your database to the latest version.
                    Please see region_storage_update_20110325.sql
    18:56:04 [SEVERE]      at com.sk89q.worldguard.protection.databases.MySQLDatabase.<init>(MySQLDatabase.java:81)
    18:56:04 [SEVERE]      at com.sk89q.worldguard.protection.GlobalRegionManager.load(GlobalRegionManager.java:147)
    18:56:04 [SEVERE]      at com.sk89q.worldguard.protection.GlobalRegionManager.preload(GlobalRegionManager.java:186)
    18:56:04 [SEVERE]      at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onEnable(WorldGuardPlugin.java:140)
    18:56:04 [SEVERE]      at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)
    18:56:04 [SEVERE]      at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
    18:56:04 [SEVERE]      at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:386)
    18:56:04 [SEVERE]      at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:264)
    18:56:04 [SEVERE]      at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:246)
    18:56:04 [SEVERE]      at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:387)
    18:56:04 [SEVERE]      at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:374)
    18:56:04 [SEVERE]      at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:208)
    18:56:04 [SEVERE]      at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:438)
    18:56:04 [SEVERE]      at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
     
    Therefore, I downloaded region_storage_update_20110325.sql from here: https://github.com/sk89q/worldguard/blob/master/region_storage_update_20110325.sql

    However, when I run the command
    Code (Text):
    sudo mysql worldguard < region_storage_update_20110325.sql
     
    I get the following output:
    Code (Text):
    ERROR 1025 (HY000) at line 5: Error on rename of './worldguard/region_cuboid' to './worldguard/#sql2-712-f100' (errno: 152)
     
    WorldGuard will now start without error, but I feel that the update probably didn't successfully apply.

    Any help would be greatly appreciated.

    Config below:

    Code (Text):
        sql:
            use: true
            dsn: jdbc:mysql://localhost/minecraft_db
            username: minecraft
            password: password_removed
     
  2. sblimit

    sblimit New Member

    I'am having this same problem, any suggestions?
  3. Thundagar

    Thundagar New Member

    Also have the same problem tho i'm trying to update via phpmysql