[Archive] Database error Unknown column 'ScriptName' in 'field list'
[Archive] Database error Unknown column 'ScriptName' in 'field list'
Original source
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.
rektbyfaith
11-04-2025, 05:13 PM #1Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
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.
Original source
Are you using EmuCoach repack? If so, re-extract the mysql server and try again
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
rektbyfaith
11-04-2025, 05:13 PM #2Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
Are you using EmuCoach repack? If so, re-extract the mysql server and try again
Original source
Quote:brian8544 said:nope i use a source leaked, sends this db error but don´t tell what table is.
Are you using EmuCoach repack? If so, re-extract the mysql server and try again
Click to expand...
rektbyfaith
11-04-2025, 05:13 PM #3Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
Quote:brian8544 said:nope i use a source leaked, sends this db error but don´t tell what table is.
Are you using EmuCoach repack? If so, re-extract the mysql server and try again
Click to expand...
Original source
Spell_Script_Names is the table that needs to be corrected.
rektbyfaith
11-04-2025, 05:13 PM #4Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
Spell_Script_Names is the table that needs to be corrected.
Original source
![[Image: 99166r.jpg]](http://i64.tinypic.com/99166r.jpg)
i have scriptname colum included and still get the error.
rektbyfaith
11-04-2025, 05:13 PM #5Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
i have scriptname colum included and still get the error.
Original source
Quote:ExO said:i have scriptname colum included and still get the error.
Spell_Script_Names is the table that needs to be corrected.
Click to expand...
rektbyfaith
11-04-2025, 05:13 PM #6Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
Quote:ExO said:i have scriptname colum included and still get the error.
Spell_Script_Names is the table that needs to be corrected.
Click to expand...
Original source
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
rektbyfaith
11-04-2025, 05:13 PM #7Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
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
Original source
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.
rektbyfaith
11-04-2025, 05:13 PM #8Archived author: amador90 • Posted: 2025-11-04T18:13:06.810156
Original source
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.
1 Guest(s)
1 Guest(s)