Jump to content
TrinityCore

DB Update and Statring Problem


docm
 Share

Recommended Posts

Hi,

today i tried to compile and start a new Trinity 3.3.5 instance.

Compile went fine and importing the world db to.

The first try to start the worldserver showed the following error:

 

>> Applying update "2016_11_23_00_world.sql" 'F1DDEB2'...
>> Applied 93 queries. Containing 1 new and 1800 archived updates.
In mysql_stmt_prepare() id: 170, sql: "INSERT INTO character_aura (guid, casterGuid, itemGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
In mysql_stmt_prepare() id: 170, sql: "INSERT INTO character_aura (guid, casterGuid, itemGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'itemGuid' in 'field list'
Unknown column 'itemGuid' in 'field list'
Could not prepare statements of the Character database, see log for details.

 

i was abler to fix this with "ALTER TABLE `character_aura` add `itemGuid` bigint(20) unsigned NOT NULL DEFAULT '0';" on the characters db

 

the next rry throwed the following error, where i don't know how to continue:

 

>> Loaded 645 permission definitions, 628 linked permissions and 4 default permissions in 5 ms
Loading Page Texts...
>> Loaded 1950 page texts in 10 ms
Loading Game Object Templates...
[1054] Unknown column 'faction' in 'field list'
[1054] Unknown column 'faction' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Segmentation fault

 

OS  is Centos 7.2

 

Thanks in Advance for help!

docm

Link to comment
Share on other sites

Hi,

 

you are right.

i had an older version in an old directory and had the new version compiled for a new directory.

starting the old version with the new database was the problem.

server is now running fine.

 

and i would like to thank you all for the greatc work you are doing!

 

regards

docm

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...