# 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.