[SOLVED] TC 3.3.5 stuck on retriving character list

[Troya]

As my title say i have a problem "stuck on retriving character list"

Now i have a five quests:

1) Is the problem in characters DB

2) Is it problem in Core

3) Can be a problem in CPU, witch work on big %

Please, giv me yours advice.

 

[Tommy]

2 & 3: do not pertain to "retrieving character list" prompt at all.

Are you getting any errors? Check your DBErrors.log or Server.log and paste the contents here. Any custom content? How old is your TC source? Did you run all of your SQL update queries (if any)? We need more information about what you've done.

 

[Troya]

2 & 3: do not pertain to "retrieving character list" prompt at all.

Are you getting any errors? Check your DBErrors.log or Server.log and paste the contents here. Any custom content? How old is your TC source? Did you run all of your SQL update queries (if any)? We need more information about what you've done.

yes i have some db errors.
DB errors: http://paste.emudevs.com/?paste=237
Server log: http://paste.emudevs.com/?paste=238
Yes i have custom content, like custom items, custom script, cata disply items..
I em not sure, but i think i use last version of TC from 2013, with no rbac system
I think i run all sql updates for auth and characters, ofc and for world

Btw, my host perfomanse:
3 GB ram
1 CPU
150 HDD
1 GB network

 

[Troya]

Still no one dont have answer?

 

[Kaev]

Still no one dont have answer?

Are these the complete logs? The pastes look kinda cut and short. I don't see anything wrong there, except the countless item errors. Can you post your configs and realmlist table?

EDIT:

I think i run all sql updates for auth and characters, ofc and for world

ALL updates? Or just to the point, where your core was downloaded? If you change the database structure with the updates (which they often do!), then you broke your database, because your core wants to read the old database structure.

 

[Sylica]

yes i have some db errors.
DB errors: http://paste.emudevs.com/?paste=237
Server log: http://paste.emudevs.com/?paste=238
Yes i have custom content, like custom items, custom script, cata disply items..
I em not sure, but i think i use last version of TC from 2013, with no rbac system
I think i run all sql updates for auth and characters, ofc and for world

Btw, my host perfomanse:
3 GB ram
1 CPU
150 HDD
1 GB network

I remember back in 2013, TrinityCore did have some issue with logins at one point in time. You must have that commit hash. Best thing you could do is revert back to how the core was, before all the editing took place. Sometimes, you break a line of coding, can cause the data to become corrupt during loading, which does happen.

Also it can be network related as well. I can't tell at this point, because I don't have the core back from that time. Best thing you can do also is update to a working core that has all the fixes. Just throwing some ideas out there.

 

[Jiinx]

confirm database settings in the config files match the right db settings, then confirm realmlist settings ins auth db are correct.

 

[Troya]

I think i find the problem, but still i em not sure witch is...

So my Database is ok, as my core, but only 2 custom scripts can do that issus.

1) Rochet2 Transmogrify v 5.0

2) Mond-WoW Custom log in

As in my core Rochet2 transmogrify not work that can be problem.. i still trying test that script.
Rochet2 isnt so much supported on fixing problems with script or adding it in core.

 

[Troya]

Stuck at char list, is fixed.

Before i used host perfomans:
3GB ram
1 Core
150 HDD

New host perfomans:
14GB ram
4 Core
1 TB HDD

there is no anymore stuck at char list.. so the problem was bad host i think.