about mangostwo mangos.sql ERROR 1136 (21S01) at line 1327

[wywgk]

mysql -u root -p mangos < mangos.sql

ERROR 1136 (21S01) at line 1327: Column count doesn't match value count at row 1

mangos.sql 1327

INSERT INTO `creature_template` VALUES

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

/*!40000

howto?

[Chucksta]

I can confirm the error when attempting to execute that script. I used Workbench to attempt to execute that single script.

Looking at the creature_template table and starting at the SpeedRun field (easily identified and used by myself as a quick initial check on the number of fields), the SQL script has 57 fields after this field, and 27 before it, whereas the table itself has 49 after the SpeedRun field and 21 before it.

[antz]

What are you trying to do ?

What's the source of that SQL ?

[Hans Werner]

Hello,

i have the same Problem like wywgk.

My source of that sql is /home/mangos/server/sql

is there already a solution for the problem?

[madmax]

mangos.sql gives you a blank database.

You can use the database the database repo instead.

https://github.com/mangostwo/database

Once you have it cloned go into _tools and run the script to generate the full database, once you have this import it into the database.

[Chucksta]

There is something wrong with that script: too many fields

Looking at the mangos.sql file in the other cores, they all have this script, but have the correct number of fields.

The script field contents differ between the cores, so someone needs to look at this who knows what the make-up of the offending script should be.

[antz]

Repull... import errors should be fixed

[Hans Werner]

Thanks for all your help. It's working. Nice Support and great server. It's my first debian mangos, 2 years ago i had a windows mangos. Mangos is Incredible

Hans