So, I was making a portal with "Sipex´s Portal Creator" and I got it ready and all,(Did everything the program requested).
But when I try inserting it into the DB I get an error: "Unknown Column 'Id' in 'where clause'.
Might there be something wrong with the SQL file?
Sql file (Code):
Code:
UPDATE teleport_coords SET name = 'Portal to Horde mall ' WHERE id = 31;UPDATE teleport_coords SET mapId = '1' WHERE id = 31; UPDATE teleport_coords SET position_x = '7329' WHERE id = 31; UPDATE teleport_coords SET position_y = '-1534' WHERE id = 31; UPDATE teleport_coords SET position_z = '160' WHERE id = 31; INSERT INTO gameobject_names (entry, Type, DisplayID, Name, spellfocus) VALUES (290290, 22, 7146, 'Portal to Horde mall ', 31)