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