This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!

Menu

Author Topic: [SOLVED] SQL Querry Error for custom race  (Read 635 times)

MrHade

  • Registred Member
  • BLP Convertor
  • *****
  • Posts: 5
    • View Profile
[SOLVED] SQL Querry Error for custom race
« on: July 22, 2014, 06:15:26 pm »
Hello modcraft people, i am following this tutorial viewtopic.php?f=26&t=165
to add somes races to my trinitycore server.
And i have a problem with the SQL part. When i run the first querry:
[spoiler:1f2e4j8u]SET @NEW_RACE = 9; -- ID of adding race.
SET @NEW_CLASS = 1; -- ID of class of the new race.
SET @COPY_RACE = 1; -- ID of the race where we copy datas.
DELETE FROM `playercreateinfo_spell` WHERE race = @NEW_RACE AND class = @NEW_CLASS ;
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`)
SELECT @NEW_RACE, @NEW_CLASS, `Spell`, `Note` FROM `playercreateinfo_spell` WHERE race = @COPY_RACE AND class = @NEW_CLASS;[/spoiler:1f2e4j8u]
I get this ....
[spoiler:1f2e4j8u][SQL] SET @NEW_RACE = 9;
Affected rows: 0
Time: 0.001ms

[SQL]  -- ID of adding race.
SET @NEW_CLASS = 1;
Affected rows: 0
Time: 0.000ms

[SQL]  -- ID of class of the new race.
SET @COPY_RACE = 1;
Affected rows: 0
Time: 0.000ms

[SQL]  -- ID of the race where we copy datas.
DELETE FROM `playercreateinfo_spell` WHERE race = @NEW_RACE AND class = @NEW_CLASS ;
[Err] 1054 - Unknown column 'race' in 'where clause'[/spoiler:1f2e4j8u]
I am running a Mysql 5.5.9 server, TrinityCore compiled by me :). And it's 3.3.5a.

Sorry if my english is bad.
Thanks for you're help.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »