Jump to content
  • 0

Populating Mangos Database Issue [Fixed]


ImperialXT

Question

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, '');

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

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.

Link to comment
Share on other sites

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....

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use