Sign in to follow this  
Followers 0
Wronglebowski

Problem Updating to Current

7 posts in this topic

Hey all, I've had a 3.3.5 server setup for some time now. Previously I updated the server once a week but after my friends stopped playing I stopped updating. Here I am six months later trying to update and I keep getting a DB Error when launching. 

"In mysql_stmt_prepare() id: 70, sql: "DELETE FROM spawn_group WHERE spawnType = ? AND spawnId = ?"
Table 'world.spawn_group' doesn't exist"

Looks like I need to tweak or update a DB somewhere, but I don't want to break anything. I kept my old folder setup so I'm still running that environment for now.

Any help would be great, thanks!

0

Share this post


Link to post
Share on other sites

Posted (edited)

Update your database.

To be specific, updated sql files containing `spawn_group` table are the following:

TrinityCore\sql\updates\world\3.3.5\2017_07_31_00_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_01_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_02_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_03_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_04_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_05_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_06_world.sql

Edited by Obitus
0

Share this post


Link to post
Share on other sites
26 minutes ago, Obitus said:

Update your database.

To be specific, updated sql files containing `spawn_group` table are the following:

TrinityCore\sql\updates\world\3.3.5\2017_07_31_00_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_01_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_02_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_03_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_04_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_05_world.sql
TrinityCore\sql\updates\world\3.3.5\2017_08_04_06_world.sql

Thanks, I figured I'd need to do something like that. I've always just relied on the launcher program itself to deploy the updates. Can someone give me an ELI5 on how to do them manually?

0

Share this post


Link to post
Share on other sites
33 minutes ago, Wronglebowski said:

Thanks, I figured I'd need to do something like that. I've always just relied on the launcher program itself to deploy the updates. Can someone give me an ELI5 on how to do them manually?

if you don't have custom world content, drop world database, download latest tdb , update core and leave core to do the job.

0

Share this post


Link to post
Share on other sites
1 hour ago, Aokromes said:

if you don't have custom world content, drop world database, download latest tdb , update core and leave core to do the job.

That's a great idea! Thanks.

0

Share this post


Link to post
Share on other sites
2 hours ago, Aokromes said:

if you don't have custom world content, drop world database, download latest tdb , update core and leave core to do the job.

Looks like there's been a development in how movemaps and such are extracted and read, and I'll have to regenerate. Doing that now, is there any major fixes/developments I should be aware of in the last six months? 

0

Share this post


Link to post
Share on other sites
6 hours ago, Wronglebowski said:

Looks like there's been a development in how movemaps and such are extracted and read, and I'll have to regenerate. Doing that now, is there any major fixes/developments I should be aware of in the last six months?

The best way is to look at the commits from your last commit (6 mos. ago). There are so many changes. Especially since you know that you will have to re-extract mmaps, vmaps, etc... ;)

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.