NetGore

What is giving you those errors? The MySQL Query Browser? Or something in NetGore? If its not something in NetGore, then I can't really do anything about it as its probably just a bug in the other software.

Ok. Thanks for the info. I'll test out the server program when i get back from work tonight or tomorrow after my morning classes.

I've also a problem with mysql. I've the database in a "real" server. And the problem is caused by BTREE command in

DROP TABLE IF EXISTS `character`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character` (
`id` int(11) NOT NULL,
`account_id` int(11) DEFAULT NULL,
`character_template_id` smallint(5) unsigned DEFAULT NULL,
`name` varchar(30) NOT NULL,
`permissions` tinyint(3) unsigned NOT NULL,
`map_id` smallint(5) unsigned NOT NULL DEFAULT '1',
`shop_id` smallint(5) unsigned DEFAULT NULL,
`chat_dialog` smallint(5) unsigned DEFAULT NULL,
`ai_id` smallint(5) unsigned DEFAULT NULL,
`x` float NOT NULL DEFAULT '100',
`y` float NOT NULL DEFAULT '100',
`respawn_map` smallint(5) unsigned DEFAULT NULL,
`respawn_x` float NOT NULL DEFAULT '50',
`respawn_y` float NOT NULL DEFAULT '50',
`body_id` smallint(5) unsigned NOT NULL DEFAULT '1',
`move_speed` smallint(5) unsigned NOT NULL DEFAULT '1800',
`cash` int(11) NOT NULL DEFAULT '0',
`level` tinyint(3) unsigned NOT NULL DEFAULT '1',
`exp` int(11) NOT NULL DEFAULT '0',
`statpoints` int(11) NOT NULL DEFAULT '0',
`hp` smallint(6) NOT NULL DEFAULT '50',
`mp` smallint(6) NOT NULL DEFAULT '50',
`stat_maxhp` smallint(6) NOT NULL DEFAULT '50',
`stat_maxmp` smallint(6) NOT NULL DEFAULT '50',
`stat_minhit` smallint(6) NOT NULL DEFAULT '1',
`stat_maxhit` smallint(6) NOT NULL DEFAULT '1',
`stat_defence` smallint(6) NOT NULL DEFAULT '1',
`stat_agi` smallint(6) NOT NULL DEFAULT '1',
`stat_int` smallint(6) NOT NULL DEFAULT '1',
`stat_str` smallint(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `template_id` (`character_template_id`),
KEY `respawn_map` (`respawn_map`),
KEY `character_ibfk_2` (`map_id`),
KEY `idx_name` (`name`) USING BTREE,
KEY `account_id` (`account_id`),
KEY `shop_id` (`shop_id`),
CONSTRAINT `character_ibfk_2` FOREIGN KEY (`map_id`) REFERENCES `map` (`id`) ON UPDATE CASCADE,
CONSTRAINT `character_ibfk_3` FOREIGN KEY (`respawn_map`) REFERENCES `map` (`id`) ON UPDATE CASCADE,
CONSTRAINT `character_ibfk_4` FOREIGN KEY (`character_template_id`) REFERENCES `character_template` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `character_ibfk_5` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `character_ibfk_6` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Where is the problem? It just says that check the corresponding syntax near USING BTREE.

Thanks for your help.. =)

And what is your definition of a 'real server'? Is it running the correct version of MySQL?

The USING BTREE shouldn't be outputted anymore. But if it is, using the latest version of MySQL like you should be will fix the issue.

Well.. when I say real server I mean U1 Intel Xeon 3Ghz Quad Core, 8GB ddr3, 500GB.. But still you say that if I update mysql it should work? Oh yeah and the os is 64-bit Debian

try removing USING BTREE it doesn't "need" to be there really.

I thought so too.. But you never know.. But thanks..=)

Are you using v0.2.0? Since I just double-checked v0.2.1, and the "USING BTREE" doesn't exist in that dump.