(Ascent) Trouble adding custom vendor

[skitzo]

i been making custom vendors for my server...i just got a new build and when i go to add the same vendors that i been using for my old server to the new one it doesnt take.

is there some sql query command that i have to run on the new build to upload my vendors.

thanks

oh heres the batch error

[Err] 1364 - Field 'invisibility_type' doesn't have a default value
[Err] INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (50086, 200, 200, 814, 100000, 100000, 10000, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
[Msg] Finished - Unsuccessfully

[MentaL]

[Juggalo90]

try changeing "MEMO" to 0

[skitzo]

thanks for the answer but it didnt work...same error.

[rr2739]

Err] 1364 - Field 'invisibility_type' doesn't have a default value

look at the error

it says that the collumn invisibility_type doesnt have a defualt value so simply add addition 0 in values , make sure it matches the collumn count from left to right

problem solved

also just a thought
Cosa Nostra Vendors

[Juggalo90]

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type)
VALUES (50086, 200, 200, 814, 100000, 100000, 10000, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0);

Try that

[skitzo]

ok thanks...i'll give it a shot.