[Question] Navicat

[zorgish]

I cant execute any SQL file without this error: (this is just some random teleporter)

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_names` VALUES ('75330', 'Quag', 'Teleporter', '', '1', '7', '0', '1', '0', null, '21666', '21666', '21666', '21666', '1', '1', '0', null);
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('75330', '80', '80', '35', '100000', '100000', '100000', '1', '3', '1500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25', '100000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully


I tried alot Of SQL´s but none of them has woorked. I cant even lookup Display ID in ADE before an error comes up

Please help me. WHY does it do that to me?
Sry for my bad english...im SWE

[Sonic Waffle]

Because there are somethings missing. It doesn't have all the information required to insert the new SQL. Either wait for an update or manually put in the SQLs.

[Kiev]

Your database is either:

Out of date for the SQL Query or
The Query is out of date for your database

Giving you a compatibility issue. This could mean your trying to execute OLD Sql's that were created for a different database structure, or your using a old database.

[zorgish]

I am using Athena V3. You guys know any good Teleporter or custom vendor items? i dont want to get SQL errors all the time

[daithi112]

I think Kiev is right.

[Kiev]

Teleporter is usually done via C++ or .Lua. Not through the database. As for items use wow-v.com or get a database editor.. Or even better. Learn to do it yourself xD

[zorgish]

oh yeah i have a DB editor now..it didnt work for like 2 days ago..but now? huh..yeah..thats wierd...But know im doing my own Lua and Quests im getting better every second

Ty for all the help. Ive never figured out what the problems was without you.

THANK YOU

[Kiev]

Your welcome.

[Ground Zero]

I noticed you're using my old Athena repack, that's a bit out of date fyi, it would be alot easier to run Database updates and use a more up to date version of LHDB.
You will be less likley to encounter problems then.