Cutemaki
-
Posts
3 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
Content Type
Profiles
Bug Tracker
Wiki
Release Notes
Forums
Downloads
Blogs
Events
Posts posted by Cutemaki
-
-
Fixed, just merged UDB for those 2 queries.
-
# YTDB_0.14.1_R580_MaNGOS_R11000_SD2_R1946_ACID_R307_RuDB_R38.6.7z
CentOS 5.1.3 x64
With latest Mangos Rev (from today); Mangos works but worldDB is just erroring. I split the DB into 6 parts to upload because of some issues (and to find out what was wrong since it timed out once in a while) and get an error on 2 parts. Doing these as queries now since I uploaded the rest only and only these 2 parts have errored me.
Also, I just directly uploaded this to mangos (mangos_world for me). Did not put any 'base' SQL down before importing this DB.
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Error:
#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'
Won't let me query this (or import) because all get that error. How do I change their values and/or is it necessary to have this?
-- Table structure for table `locales_gossip_menu_option`
UNLOCK TABLES -- -- Table structure for table `locales_gossip_menu_option` -- CREATE TABLE IF NOT EXISTS `locales_gossip_menu_option` ( `menu_id` smallint(6) unsigned NOT NULL DEFAULT '0', `id` smallint(6) unsigned NOT NULL DEFAULT '0', `option_text_loc1` text, `option_text_loc2` text, `option_text_loc3` text, `option_text_loc4` text, `option_text_loc5` text, `option_text_loc6` text, `option_text_loc7` text, `option_text_loc8` text, `box_text_loc1` text, `box_text_loc2` text, `box_text_loc3` text, `box_text_loc4` text, `box_text_loc5` text, `box_text_loc6` text, `box_text_loc7` text, `box_text_loc8` text, PRIMARY KEY (`menu_id`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `locales_gossip_menu_option` (
`menu_id` smallint(' at line 7
Some help would be appreciated =/ YTDB's forum is russian and don't know where else to ask.
Battlegrounds bugged?
in OldGeneral support
Posted
DB: YTDB_0.14.1_R580_MaNGOS_R11000_SD2_R1946_ACID_R307_RuDB_R38.6
OS: CentOS 5.1.3 x64
Just was wondering if Battlegrounds is bugged or has been disabled in latest rev? When I press the 'H' key (PvP Tab) I only have HONOR and ARENA show up and no options for Battlegrounds? As in Battlegrounds completely is not showing up.
Or is it because I'm using a BLIZZLIKE DB? I spoke to the Battlemasters in Stormwind War Room and used the command '.debug bg' and tried to enter a qeue but it does not seem to work?