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<init>(
    18:56:04 [SEVERE]      at
    18:56:04 [SEVERE]      at
    18:56:04 [SEVERE]      at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onEnable(
    18:56:04 [SEVERE]      at
    18:56:04 [SEVERE]      at
    18:56:04 [SEVERE]      at org.bukkit.plugin.SimplePluginManager.enablePlugin(
    18:56:04 [SEVERE]      at org.bukkit.craftbukkit.CraftServer.loadPlugin(
    18:56:04 [SEVERE]      at org.bukkit.craftbukkit.CraftServer.enablePlugins(
    18:56:04 [SEVERE]      at net.minecraft.server.MinecraftServer.t(
    18:56:04 [SEVERE]      at net.minecraft.server.MinecraftServer.a(
    18:56:04 [SEVERE]      at net.minecraft.server.MinecraftServer.init(
    18:56:04 [SEVERE]      at
    18:56:04 [SEVERE]      at
    Therefore, I downloaded region_storage_update_20110325.sql from here:

    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):
            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