char_state table

Number of posts : 84 Registration date : 2006-12-11

Not always an enrty is made in the char_state table when a char is logging into the game.
Does anyone knows why?

I use the latest stuff from SVN.

thanx in advance.

Subject: Re: char_state table Sat Apr 07, 2007 10:13 pm

clear the table totally and let it be filled from begining

Number of posts : 84 Registration date : 2006-12-11

it is/was empty.

another thing i saw was that when a new char is made, and this char is logging in direct after it is created, the entry is not made in the char_state table.

Subject: Re: char_state table Sat Apr 07, 2007 10:44 pm

u have to clean the table then restart server and on every player login to world he will be writen inside not before that
(also all his other characters will be written inside too)

Number of posts : 84 Registration date : 2006-12-11

thanx,

I will do that and monitor what happens.

Number of posts : 84 Registration date : 2006-12-11

I saw 2 things:

1. When a new char is created, the first time when this char logging in there is no registration in the char_state
2. When a GM is teleporting he is also removed from the char_state table

Number of posts : 38 Registration date : 2006-12-11

bartus wrote:: I saw 2 things:

1. When a new char is created, the first time when this char logging in there is no registration in the char_state
2. When a GM is teleporting he is also removed from the char_state table

He bartus i now the solution, contact me tru msn and i will tel it in dutch, its an old problem has to do whit triggers in db.

Subject: Re: char_state table Mon Apr 16, 2007 2:38 am

Gorm wrote:

bartus wrote:: I saw 2 things:

1. When a new char is created, the first time when this char logging in there is no registration in the char_state
2. When a GM is teleporting he is also removed from the char_state table

He bartus i now the solution, contact me tru msn and i will tel it in dutch, its an old problem has to do whit triggers in db.

i'm dutch let's hear it ^^
i will translate it sow e can share with community

Number of posts : 38 Registration date : 2006-12-11

Hmm can do it in english, but bartus is one of our players on dutch wow thats why msn.

So where to look for is if there are any triggers in characters table.

So in navicat just right click at table and choose disign, at the trigger tab check for any triggers and if so delete them, it's from older table and for some strange reason sometimes this happens.

It was in db3.1 for sure 3.2 i dont now and clean 3.3 its not there anymore.

Number of posts : 84 Registration date : 2006-12-11

ok, thanx, after deleting the trigger the problem was solved.