[HELP] with Guilds

[drew666]

Ok guilds dont store in database.

We can make a guild in game. but it doesnt store in database and it doesnt store the guildchars either.

When we restart server it disappears.

yes i have tried the forums and ran the sql scripts that are release but still didnt fix problem

SO im asking if anyone know why this is happening.

[oLago]

The procedures are adding null values to columns where nulls can't exist, thus it fails entering the guild. There are several between Guilds, and GuildDetails Tables, you need to change the default values of these colums to 0.

You can do this one of two ways, first requires you to restart your pserver to get the subsequent error after fixing one [expect multiple restarts as the log will only give the first exception] or you can just go through the table and set all columns that do not except nulls to default bind of 0.

If you choose the first, it might still save the characters as being part of a guild thus they will not be able to form or join another guild so you will have to remove them manually from the database.

[drew666]

Can you explain the 1st opioion some more i dont understand what you mean.

[oLago]

The procedure is failing on the first null value being inserted in a column where it will not allow a null value. There are multiple columns in the two tables where the procedure will not give a value [thus it will be null], but the log because of the failure on the first instance of it will only give the first column that fails. So to fix the first column you must set the default value to 0, then start the server, try forming a guild, look for the next column failure, shutdown the server, fix the second failed column [repeat these over and over again for all the columns that fail].

The table dealing with the guildhouse has similar issues as well.

[drew666]

the problem is fixed already Thanks your explanation did help in the process of fixing and i wanted to say thanks.

[speccie]

So only thing what u need to do its to chage in PS_GameData>dbo.Guilds from NULL to 0 restart and it will work?

[Polypropylen]

old
#closed