[SOLVED] [Trinity] Restart Issues

[Andrew]

Ok, so first off I'd like to apologize if linking ******* threads is unacceptable after reading this: (Recruitment Section: NO site or forum links, NO private server advertisements (server's website link, twitters, FB, etc.) and NO content that isn't related to emulation. If failed to obey, it is a risk of a ban.)

I wasn't sure if this applied seeing that it's about an emulation issue. Feel free to remove the links if they are not allowed to be posted for I am new to this forum as of five minutes ago. -.-

Anyway, on to my problem.




So I just recently deleted all spawned NPC/Gameobjects in the world to get rid of useless shit I don't need for my realm, but now after I've done this when the realm restarts, the worldserver.exe tries to load all the deleted npcs and it takes like 3 fucking hours to reboot...... And it's pissing me off...... Can someone tell me how to fix this?.....

Original help posts:

[Links Removed - We don't want backlinks to that site.]

 

[Tommy]

Ok, so first off I'd like to apologize if linking ******* threads is unacceptable after reading this: (Recruitment Section: NO site or forum links, NO private server advertisements (server's website link, twitters, FB, etc.) and NO content that isn't related to emulation. If failed to obey, it is a risk of a ban.)

I wasn't sure if this applied seeing that it's about an emulation issue. Feel free to remove the links if they are not allowed to be posted for I am new to this forum as of five minutes ago. -.-

Anyway, on to my problem.




So I just recently deleted all spawned NPC/Gameobjects in the world to get rid of useless shit I don't need for my realm, but now after I've done this when the realm restarts, the worldserver.exe tries to load all the deleted npcs and it takes like 3 fucking hours to reboot...... And it's pissing me off...... Can someone tell me how to fix this?.....

Original help posts:

[Links Removed - We don't want backlinks to that site.]

Remember, when removing spawns you also need to empty other data from tables since they aren't being used anymore, such as:

• quest_template
  creature_questender
  creature_queststarter
  creature_ai_scripts
  creature_loot_template
  gameobject_loot_template
  gameobeject_questender
  gameobject_queststarter
  smart_scripts
  pool_creature
  pool_gameobject
  pool_quest
  waypoints
  waypoint_data
  waypoint_scripts
  quest_poi
  quest_poi_points
  npc_vendor
  npc_trainer

Technically, they are still being used, but only when you spawn the needed creature for those tables to actually have a purpose.

If I forgot a table, that isn't my fault. XD

Anyway, the reason we don't allow those links is because we don't want backlinks to their site. It would've probably saved you some time if you typed your issue out instead us having to go to another site just to look at your issue.

 

[Andrew]

You need to be more specific. Did you delete them from creature_template, creature, gameobject_template and gameobject tables? Remember, when removing spawns you also need to empty other data from tables since they aren't being used anymore, such as:

• quest_template
  creature_questender
  creature_queststarter
  creature_ai_scripts
  creature_loot_template
  gameobject_loot_template
  gameobeject_questender
  gameobject_queststarter
  smart_scripts
  pool_creature
  pool_gameobject
  pool_quest
  waypoints
  waypoint_data
  waypoint_scripts
  quest_poi
  quest_poi_points
  npc_vendor
  npc_trainer

If I forgot a table, that isn't my fault. XD

Anyway, the reason we don't allow those links is because we don't want backlinks to their site. It would've probably saved you some time if you typed your issue out instead us having to go to another site just to look at your issue.

Fair enough. Anyway, I deleted everything in the following tables as told to do by Rochet and a few others off that previous linked site:

"Creature"
"Creature_Addon"
"Creature_ai_scripts"

Keep in mind I emptied the data for only the "Creature" table and it started doing this. Someone suggested I empty the other two as well and it would possibly fix it, but it didn't. I restarted my realm and it's taken over 2 hours 48 minutes as of right now and it's still restarting.

Someone on the TrinityCore forums mentioned to just readd a fresh TDB and phase the NPCs rather than despawning them but I'm not too sure on how to do that seeing that I'm somewhat new to emulation.

So what you're saying is I need to remove everything from all of those as well?

 

[Tommy]

Fair enough. Anyway, I deleted everything in the following tables as told to do by Rochet and a few others off that previous linked site:



Keep in mind I emptied the data for only the "Creature" table and it started doing this. Someone suggested I empty the other two as well and it would possibly fix it, but it didn't. I restarted my realm and it's taken over 2 hours 48 minutes as of right now and it's still restarting.

Someone on the TrinityCore forums mentioned to just readd a fresh TDB and phase the NPCs rather than despawning them but I'm not too sure on how to do that seeing that I'm somewhat new to emulation.

I know you deleted them from their spawns table, you also mentioned deleting gameobject spawns too. I was giving you an option to delete data from those other tables because technically they aren't being used. Also, if your server takes that long to start up, then that surely isn't a database issue. I doubt redoing your database will fix the issue, I've emptied the creature and gameobject tables before and still had a 4 second start/restart time.

Kind of hard to pinpoint the exact issue considering all I know is that you emptied the creature and gameobject spawn tables. Can you take a screenshot of your worldserver? Also, what are the specs of your PC? One more thing, is this a fresh compile?

 

[Andrew]

I know you deleted them from their spawns table, you also mentioned deleting gameobject spawns too. I was giving you an option to delete data from those other tables because technically they aren't being used. Also, if your server is take that long to start up, then that surely isn't a database issue. I doubt redoing your database will fix the issue, I've emptied the creature and gameobject tables before and still had a 4 second start/restart time.

Kind of hard to pinpoint the exact issue considering all I know is that you emptied the creature and gameobject spawn tables. Can you take a screenshot of your worldserver? Also, what are the specs of your PC? One more thing, is this a fresh compile?

Well, in all honesty it is the database itself because I own two realms, and only the one I tampered with creature templates in takes ages to restart. My other one starts perfectly fine so it's not a PC issue or anything especially since it's not even hosted on my computer atm. And yes, this is a fresh compile, done by myself using the latest revision. It was done about a day ago.




------Edit-------


I'm just going to restart fresh on a brand new compiled core. Is there any way someone could help me out once it's up and running? It'd be appreciated. PM me your Skype if so.

 

[Tommy]

Well, in all honesty it is the database itself because I own two realms, and only the one I tampered with creature templates in takes ages to restart. My other one starts perfectly fine so it's not a PC issue or anything especially since it's not even hosted on my computer atm. And yes, this is a fresh compile, done by myself using the latest revision. It was done about a day ago.

I still don't see how this will cause your server to have a short start time, as I mentioned I've done this countless times and my server started in seconds. I guess I would recommend adding all of the data back into those tables and see if that is actually it.

 

[Andrew]

I still don't see how this will cause your server to have a short start time, as I mentioned I've done this countless times and my server started in seconds. I guess I would recommend adding all of the data back into those tables and see if that is actually it.

Edited my last post. =)

 

[Tommy]

Edited my last post. =)

You compiled and set it up yourself, didn't you? XD

Either way, add me on Skype and I'll see what I can do: [Removed Skype Info] -- If you didn't get it, tell me. I waited awhile for you to add me.

 

[Hamar]

Are you running your database on a different server?

 

[Andrew]

Are you running your database on a different server?

What do you mean?

You compiled and set it up yourself, didn't you? XD

Either way, add me on Skype and I'll see what I can do: [Removed Skype Info] -- If you didn't get it, tell me. I waited awhile for you to add me.

Sorry, I wasn't paying attention to the thread. PM it to me and I'll add you when I'm awake since you're offline. (going to sleep now)

 

[Tommy]

What do you mean?







Sorry, I wasn't paying attention to the thread. PM it to me and I'll add you when I'm awake since you're offline. (going to sleep now)

He's basically asking is the database not on the same server as the TrinityCore binary files. (authserver.exe, worldserver.exe, etc)

 

[Andrew]

He's basically asking is the database not on the same server as the TrinityCore binary files. (authserver.exe, worldserver.exe, etc)

Oh, yes, the DB is on the same server.