Transpor_Data error plz Read!

[Arugos]

Hi guys , first of all ... i just want to thanks the replyers , because im pretty sure ill get good help and also just tell me if you need more infos , sorry no pic also.


Ok i'm geting this error ---Sql querry failed due to [Table 'ascent.transport_creatures.... anyway i think that enought and im pretty sure if you know the rest if you already got any error before , please reply if you know how to fix this problem ! Merry Xmass everyone!

[~SaiLyn~]

Your table isnt properly stable , other than that you would need to fix some stuff around or upated it for it to work.

I'll make your life simple . Delet the transport_data table , and copy and paste whats bellow here into notpad and save it as an .sql and than execute it and you should be fine.

 CREATE TABLE `transport_data` (
  `entry` int(10) unsigned NOT NULL default '0',
  `name` text character set utf8 collate utf8_unicode_ci,
  `period` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='World System';
 
INSERT INTO `transport_data` VALUES ('181646', 'Azuremyst and Auberdine', '251162');
INSERT INTO `transport_data` VALUES ('176495', 'Grom\'Gol Base Camp and Undercity', '333044');
INSERT INTO `transport_data` VALUES ('177233', 'Forgotton Coast and Feathermoon Stronghold', '317040');
INSERT INTO `transport_data` VALUES ('176310', 'Menethil Harbor and Auberdine', '261004');
INSERT INTO `transport_data` VALUES ('176231', 'Menethil Harbor and Theramore Isle', '282824');
INSERT INTO `transport_data` VALUES ('176244', 'Teldrassil and Auberdine', '309295');
INSERT INTO `transport_data` VALUES ('175080', 'Grom\'Gol Base Camp and Orgrimmar', '303463');
INSERT INTO `transport_data` VALUES ('164871', 'Orgrimmar and Undercity', '356284');
INSERT INTO `transport_data` VALUES ('20808', 'Ratchet and Booty Bay', '350818');

[LJN]

What about this...

[~SaiLyn~]

I really dont know , to tell you the truth , I would help you if I could , but the thing is i have no table called " transport_creature"

[LJN]

Im using NCDB rev 700

[Arugos]

Ty very much for the help so far but just so you know the table in navicat(that what i use) is called Transport_data , but when i start the server i get the creature error

[~SaiLyn~]

Nightmare try deleting your transport_data and use the one i gave here

[Arugos]

i tryed but it didnt work , the one u gave me is exactly the one i got

[MysticViper]

CREATE TABLE `transport_creatures` (
  `entry` int(11) NOT NULL default '0',
  `transport_entry` int(11) NOT NULL default '0',
  `offsetX` float NOT NULL,
  `offsetY` float NOT NULL,
  `offsetZ` float NOT NULL,
  `offsetO` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;