cant upload 210_updatepack.sql to database [soloved]

[kris914g]

hey i have followed the mysql guide https://github.com/mangoswiki/Wiki/wiki/MangosZero%2018.1%20Build%20Part%204#part-4---setting-up-the-mangos-server-databases and i have completed all steps

but ig got a error then i was trying to upload 210_updatepack.sql but i got this error message

error

SQL query:

- - Startup fixes2 UPDATE `creature_template` SET `flags_extra` =2050,

`civilian` =1,

`MovementType` =2 WHERE `entry` =550;

MySQL returned: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--Startup fixes 2

UPDATE `creature_template` SET `flags_extra` = 2050, `civilia' at line 1

[Hikari]

Therer are some missing spaces, therefore mysql tries to interpret the inline comments as sql commands instead of ignoring it.

Remove or replace the comments at the row 20 and 244 with

-- Startup fixes 2

-- Startup fixes

The space between -- and the following text is important.

[kris914g]

but wich file and where can i edit it?

[Hikari]

It's the file you've problems with: 210_updatepack.sql

[kris914g]

but then im go to line 20 in i cant finde the place to edit it and the other line? maby you can edit it and reupload to the database projekt with the fixed error so other people dont got this error?

[kris914g]

yea know i find out of it thanks but hare there more updates if yes how to install them