[SOLVED] error [1054] Unknown column 'racemask' in 'field list'

[dadragon699]

hello i am having an issue i have looked everywhere trying to figure out how to fix this error but cant seem to find one i had a dev that added a sql file to my db and now i get a error


[1054] Unknown column 'racemask' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.the sql file he added is attached i hope someone can help me fix this

 

[Tommy]

As far as I can see the only table that requires racemask and doesn't have it is "playercreateinfo_spell_custom" table. Here's the base query for that table: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/base/dev/world_database.sql#L2528

 

[dadragon699]

i understand that but that table has the racemask in my db but yet i still get that error

 

[Sylica]

i understand that but that table has the racemask in my db but yet i still get that error

Well, this could be the problem with the offset of the two tables.

Look at the table structure, and notice it doesn't match your database.

Code from the sql patch:

DROP TABLE IF EXISTS `playercreateinfo_spell_custom`;
CREATE TABLE `playercreateinfo_spell_custom` (
  `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `Note` varchar(255) DEFAULT NULL,
  `Active` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`race`,`class`,`Spell`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Once I'm done with my project, I could redo the script. Plus, you're going from 5 columns to 4 columns. This is an old script, that's not update with the current trinitycore.