Worldguard Error

Hi when i start my Server i get this error:

Code:

2012-06-14 01:31:38 [INFO] [WorldGuard] Enabling WorldGuard v5.5.2
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft) TNT ignition is PERMITTED.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft) Lighters are PERMITTED.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft) Lava fire is blocked.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft) All fire spread is disabled.
2012-06-14 01:31:38 [INFO] [WorldGuard] Loaded configuration for world 'UltimateMinecraft'
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_nether) TNT ignition is PERMITTED.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_nether) Lighters are PERMITTED.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_nether) Lava fire is blocked.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_nether) All fire spread is disabled.
2012-06-14 01:31:38 [INFO] [WorldGuard] Loaded configuration for world 'UltimateMinecraft_nether'
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_the_end) TNT ignition is PERMITTED.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_the_end) Lighters are PERMITTED.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_the_end) Lava fire is blocked.
2012-06-14 01:31:38 [INFO] [WorldGuard] (UltimateMinecraft_the_end) All fire spread is disabled.
2012-06-14 01:31:38 [INFO] [WorldGuard] Loaded configuration for world 'UltimateMinecraft_the_end'
2012-06-14 01:31:38 [SEVERE] You need to update your database to the latest version.
        Please see region_storage_update_20110325.sql
2012-06-14 01:31:38 [SEVERE]    at com.sk89q.worldguard.protection.databases.MySQLDatabase.<init>(MySQLDatabase.java:81)
2012-06-14 01:31:38 [SEVERE]    at com.sk89q.worldguard.protection.GlobalRegionManager.load(GlobalRegionManager.java:147)
2012-06-14 01:31:38 [SEVERE]    at com.sk89q.worldguard.protection.GlobalRegionManager.preload(GlobalRegionManager.java:186)
2012-06-14 01:31:38 [SEVERE]    at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onEnable(WorldGuardPlugin.java:140)
2012-06-14 01:31:38 [SEVERE]    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)
2012-06-14 01:31:38 [SEVERE]    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
2012-06-14 01:31:38 [SEVERE]    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
2012-06-14 01:31:38 [SEVERE]    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:256)
2012-06-14 01:31:38 [SEVERE]    at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:238)
2012-06-14 01:31:38 [SEVERE]    at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:381)
2012-06-14 01:31:38 [SEVERE]    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:368)
2012-06-14 01:31:38 [SEVERE]    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:197)
2012-06-14 01:31:38 [SEVERE]    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:432)
2012-06-14 01:31:38 [SEVERE]    at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
2012-06-14 01:31:38 [INFO] [ChestShop] Enabling ChestShop v3.42
2012-06-14 01:31:38 [INFO] [ChestShop] LWC version 4.2.1 (b700-git-MANUAL) (May 20, 2012) loaded.
2012-06-14 01:31:38 [INFO] [ChestShop] Vault loaded - using iConomy 6
2012-06-14 01:31:38 [INFO] Done (7.590s)! For help, type "help" or "?"

How can i fix it?

My config.yml:

Code:

regions:
    use-scheduler: true
    sql:
        use: true
        url: mysql://localhost:3306/minecraft
        username: root
        password: *****
        dsn: jdbc:mysql://localhost/minecraft
    enable: true
    invincibility-removes-mobs: false
    high-frequency-flags: false
    wand: 287
    max-claim-volume: 30000
    claim-only-inside-existing-regions: false
    max-region-count-per-player:
        default: 7

Name of my database is of course "minecraft"


I'm using Wamp Server for my MySql Databases (Wampserver 2.2)

MySql Version: 5.5.24
PhpMyAdmin Version: 5.3.13
Apache Version: 2.2.22

 

Read the error.

You need to update your database by running that file. So load up PHPMyAdmin, select the right database, go to the 'SQL' tab, copy and paste the contents of this ( https://raw.github.com/sk89q/worldguard/master/region_storage_update_20110325.sql ) into the large text box, run the query.

 

When i do this i get this error:

Code:

Fehler
 
SQL-Befehl:
 
ALTER TABLE `region_cuboid` DROP FOREIGN KEY `fk_region_cuboid_region` ;
 
MySQL meldet: Dokumentation
#1146 - Table 'minecraft.region_cuboid' doesn't exist 

 

i get that too its because the "worldguard" database isn't selected idk how to fix it

ok use SQLBuddy and select the database before hand, but now its saying that the tables don't exist.

fix for that if you need it :
https://github.com/sk89q/worldguard/blob/master/region_storage.sql
then also do the other one at :
https://raw.github.com/sk89q/worldguard/master/region_storage_update_20110325.sql
YAY ALL WORKING NOW!! XD
TY SOO MUCH andrewpo

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Is running mySQL necessary, or beneficial as opposed to the default?

I had errors on the second SQL query link. region_storage_update_.....

 

Wow i got it working

 

Not really. I think the data from the database/flatfile are cached anyway inside the plugin when it starts.

 

Thanks, for now I am running it stock. Wondered if mySql would net better performance out of the server overall. Some mods actually do not recommend using mySql yet they give the option. So far I just have iConomy in mySql.