I'm fairly new to MySQL and databases in general, but I know my way around well enough. Just by doing a google search, I already saw there are about 20 of these threads already but my issue is different. I receive 2 error strings from Worldguard + MySQL every time I start my server: http://pastebin.com/MWkzc445 and http://pastebin.com/TRfk0LEJ I then queried region_storage_update_20110325.sql on my database, and this is the message I received back. WorldGuard doesn't generate any tables at all; does it want me to make all of the blank tables and then query it with region_storage_update_20110325.sql? My config: I understand if this is the wrong place to put it, since this is in general Bukkit issues and not plugin related issues, but I was just seeing if anyone on here knew the fix for this, since google didn't reveal anything. Lastly, sorry for my English, it is not my primary language.
Your in the right place. And second I wouldn't use MySQL unless needed. But worldedit does not need it.
It's not just "simply updating" it. It's running queries to generate tables. Anyways, I made more progress. I ran the region_storage query, THEN ran the region_storage_update, but now it comes back with:
Stuck on that error. I have set up everything including the blacklist database just fine until I reached this.
I suggest not using MySQL with WorldGuard. It is known to... not work very well. Flatfile works awesome though.
I guess I will just switch to flatfile. I am, I'm using it for logblock and inventorySQL Thanks for the advice, I saw your post about using flatfile on some other threads having the same issue, but I was just seeing if I could get it to work. Anyways, I just switched to flatfile, and it already feels like a relief to have no startup errors. Thanks for everyone's help.
No need to tag staff for marking your thread as solved. I've already done it for this one, but for future reference, just below the title at the top of the screen, on the right-hand side, you'll see Thread Tools. Hover the mouse over that, click Edit Thread, change it from No Prefix to Solved, and click Save.