Database error Unknown column 'ScriptName' in 'field list'

amador90 · Jan 30, 2017

Worldserver issue.

Loading GameObject models...
Loading Script Names...
[1054] Unknown column 'ScriptName' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

on log files didn´t have any table issue, only said Unknown column 'ScriptName' in 'field list'

someone can help me??

Log:

Realm running as realm ID 1
Using World DB: TDB 6.04
Unable to open PendingSQL_Characters.sql, ignoring.
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ./
VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1
VMap data directory is: ./vmaps
Loading Trinity strings...
>> Loaded 1040 Trinity strings from table trinity_string in 3 ms
Initialize data stores...
>> Initialized 98 DBC data stores in 441 ms
Using enUS DBC Locale
Initialize Spell Difficulty ...
Loading SpellInfo store...
>> Loaded spell info store in 534 ms
Loading TalentSpellInfo store....
Loading SpellPowerInfo store....
Loading SkillLineAbilityMultiMap Data...
>> Loaded 8834 SkillLineAbility MultiMap Data in 1 ms
Loading Spell custom attributes...
>> Loaded spell custom attributes in 141 ms
Loading Research Site Zones...
>> Loaded 321 Archeology research site zones in 1990 ms.
Loading Research Site Loot...
>> Loaded 0 Archeology site loot. DB table `research_loot` is empty.
Loading GameObject models...
Loading Script Names...
[1054] Unknown column 'ScriptName' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

brian8544 · Jan 30, 2017

Are you using EmuCoach repack? If so, re-extract the mysql server and try again

amador90 · Jan 30, 2017

brian8544 said:
Are you using EmuCoach repack? If so, re-extract the mysql server and try again

nope i use a source leaked, sends this db error but don´t tell what table is.

ExO · Jan 30, 2017

Spell_Script_Names is the table that needs to be corrected.

amador90 · Jan 30, 2017

i have scriptname colum included and still get the error.

amador90 · Jan 30, 2017

ExO said:
Spell_Script_Names is the table that needs to be corrected.

i have scriptname colum included and still get the error.

Crandalius · Feb 2, 2017

I can confirm this issue. As soon you rename the table it decides tot tell you that the table does not exist but as soon you rename back to spell_script_names it would work.. Something weird with it

mirracle · Apr 16, 2020

You must have ScriptName in all these tables:

Code:

>> Loaded 8176 GameObject models in 6 ms
Loading Script Names...
SQL: SELECT DISTINCT(ScriptName) FROM battleground_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM conversation_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM creature WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM creature_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM criteria_data WHERE ScriptName <> '' AND type = 11 UNION SELECT DISTINCT(ScriptName) FROM gameobject WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM gameobject_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM item_script_names WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM areatrigger_scripts WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM areatrigger_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM spell_script_names WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM transports WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM game_weather WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM conditions WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM outdoorpvp_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM scene_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM quest_template_addon WHERE ScriptName <> '' UNION SELECT DISTINCT(script) FROM instance_template WHERE script <> ''
[1054] Unknown column 'ScriptName' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

I fixed it by this.

Database error Unknown column 'ScriptName' in 'field list'

Attachments