Error with mangos.sql fresh install.

[eidosmatrix]

Hi everybody!

I'm installing the server from the scratch and everything is going ok until the step that I need create de mangos database (mangos.sql).

The file is that come from the repository.

The error: "ERROR 1136 (21S01) at line 1279: Column count doesn't match value count at row 1"

I was looking into the file and this line is an INSERT to the creature_template table.

A week ago I did another fresh installation and I didn't had the error.

I suppose that it could be a little error but the table has 85 fields and I don't have idea which is the field that is wrong.

I will appreciate some feedback

Thanks!

[eidosmatrix]

OK.. I found the bug... the 'creature_template' table for this db_version of mangos.sql script add an extra field (vehicle_id) in the table... but the INSERT doesn't updated...

just must add one value in the statement in position 6 (start count from the end).

db_version: required_11385_01_mangos_creature_template

Here is my fixed STATEMENT:

INSERT INTO `creature_template` VALUES

(1,0,0,0,0,0,10045,0,0,0,'Waypoint(Only GM can see it)','Visual',NULL,0,1,1,64,64,0,0,5,35,35,0,0.91,1.14286,1,0,2,3,0,10,1,2000,2200,8,4096,0,0,0,0,0,0,1,2,100,8,5242886,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,130,'');

Hope this help!

[tinpolone]

it seems that you had already installed the .sql before.

you can try to install the version which after 11385

[zergtmn]

Fixed in 11389