Forum > Serverside Modding

HeidiSQL error

(1/2) > >>

darkleen:
i was trying to make a item import to HeidiSQL but it give this error SQL Error (1054): unknown column ,name2, in fleld list, can any help me out here plz

schlumpf:
well, there is no column named "name2" then.

Solarion:
Lemme guess. You used wow-v and either your core is not supported by it  or your server is on Cataclysm, am I correct?

darkleen:
no my server is a worth 3,5.5a

Morfium:
Usually your statement is something like:

INSERT INTO tablename (column1,column2) VALUES(value1,value2);

It seems the column name2 which is in your insert statement tries to add a column name2 which is not present in your db.
You could try to delete the column and corresponding value from your insert statement.

If it's like:
INSERT INTO items (name, name2, guid,...) VALUES ('Uber Staff', 'Ubersuperroxx0rstaff',334,...)

you might want to try it by removing name2 and 'Ubersuperroxx0rstaff'.
But tbh. If your insert statement has such differences compared to your database you might have gotten it for the wrong database structure or version.
E.g. if you have a trinity core a mangos db item might have a similar structure but if they differ you'd have to manually change each insert statement, which could, depending on your item count, get rather annoying.

Navigation

[0] Message Index

[#] Next page