[ascent] transport creatures error in WORLD DB

[Matt-One]

hi, i have just compiled the latest ascent core 2756 with NCD 734 now the problem is this when ascent load Transports i receive this error...

Sql query failed due to [Table 'world.transpor_creatures'] doesn't exist...

but where i can find this table?

 

[ismails]

hi, i have just compiled the latest ascent core 2756 with NCD 734 now the problem is this when ascent load Transports i receive this error...

Sql query failed due to [Table 'world.transpor_creatures'] doesn't exist...

but where i can find this table?

 

[plnt8]

lol dnt wori about it, the server should run perfectly fine, my old ascent version had the same prob and it ran perfectly.

 

[KingXCrosses]

not really, there should be a fix in your sql updates folder, wit the table name too, so its not much of a problem

 

[Espionage724]

lol dnt wori about it, the server should run perfectly fine, my old ascent version had the same prob and it ran perfectly.

same here

 

[Matt-One]

evrything i can tell you is :compile sometimes ascent yourself,cse this weird compiles is pissin server,just tested it myself, when i do my server's compiles it doesnt need and fucking tansport_creatures table,but ok here it is:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for transport_creatures
-- ----------------------------
CREATE TABLE `transport_creatures` (
  `transport_entry` int(10) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
-- ----------------------------
-- Records 
-- ----------------------------

well i have find this tonight:

CREATE TABLE `transport_creatures` (
`transport_entry` int(10) unsigned NOT NULL,
`creature_entry` int(10) unsigned NOT NULL,
`position_x` float NOT NULL,
`position_y` float NOT NULL,
`position_z` float NOT NULL,
`orientation` float NOT NULL,
PRIMARY KEY (`transport_entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

in some post on the ascentemu forum and the problem is gone however many thx