Populating Mangos Database Issue [Fixed]

[ImperialXT]

Info:

Mysql 5.1

debian 6.0 Squeeze

following guide http://getmangos.eu/bb/post/3392/#p3392

Issue:

When doing:

mysql -u root -p mangos < mangos.sql

I'm getting:

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

Fix:

Goto line 1368

replace what's there with:

(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, 0, 1, 2, 100, 8, 5242886, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 7, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 130, '');

[bels]

I got this same error. Normally that means the number of columns do not match the number of values. For example:

insert into tables (column_one,column_two,column_three) values(value_one, value_two); //missing a value for column_three

That previous statement would produce this kind of error to my knowledge. I haven't looked close enough at the line of sql that is throwing this error yet to figure out which column isn't matching up to a value yet but once I do, I'll post the fixed line here unless someone beats me to it.

[ImperialXT]

I got this same error. Normally that means the number of columns do not match the number of values. For example:

insert into tables (column_one,column_two,column_three) values(value_one, value_two); //missing a value for column_three

That previous statement would produce this kind of error to my knowledge. I haven't looked close enough at the line of sql that is throwing this error yet to figure out which column isn't matching up to a value yet but once I do, I'll post the fixed line here unless someone beats me to it.

I posted the fix above....

[bels]

Yeah, saw that shortly after I posted mine. Thanks! I left the post just for anyone who isn't real familiar with SQL, in case they get an error like that in the future.