Strange problem with TFS

[Yaneek]

Hi,

I have problem with my TFS 3.5. TFS work normaly then suddenly start crashing during i turn on him.
It's screen of crash:
Pasteboard — Uploaded Image
On account and bans table i don't done nothing.

And it config my database:

sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "******"
	sqlDatabase = "tfs"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

Sorry for my english <3

 

[Unmarked]

I don't know exactly what the problem is, but I have this.

Its probably your 'encryptionType' because the error shows "sha1" too. I hope it might work if you change that.

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

 

[Yaneek]

@up
You have different configuration becouse you are using sqlite database. It can't be encrypt type becouse earlier TFS work normally. But thanks for interest

 

[Cornex]

Why should it be problems with account and bans table?

It stands it loads fine.

Something you doing before this happend?

 

[Yaneek]

No in database i don't do nothing. But I add guild war system as I remember.

 

[UpInSmoke]

encryptionType = "sha1"

change that to "plain"
plain is used for mysql also

 

[Yaneek]

Again it problem :/

 

[Unmarked]

I also said it but it must be it because it gives the error for sha1...

 

[Yaneek]

But I change it to "plain" and this problem is again.

 

[Cornex]

Try remove everything that you add before it crash.

 

[Shockah]

What error do you get after you've changed it back to plain? Could you post another screenshot of it if it's a different error.

 

[Yaneek]

When I changed encryption type to plain error with encryption disappeared but tfs crash same

 

[Shockah]

Retrace your steps and undo everything you done prior to the crash, that's the only thing I can suggest.

 

[Yaneek]

It's not problem with database, becouse i test it making nwe "clear" database. Anyone have "clear" tfs for tibia 8.6?
@EDIT
I change dtb type to sqlite, although i have mysql dtb and it work. God Why? Will it not work badly on the server?

Once error is

[31/01/2013 19:59:31] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP ( SELECT houses.owner, houses.id as hid, houses.name as house_name ,players.name FROM houses
[31/01/2013 19:59:31]             LEFT JOIN players ON players.id=houses.owner
[31/01/2013 19:59:31]             LEFT JOIN accounts ON players.account_id=accounts.id
[31/01/2013 19:59:31]             WHERE players.lastlogin < (UNIX_TIMESTAMP() - 10*24*60*60)
[31/01/2013 19:59:31]              AND accounts.premdays=0             AND	players.world_id =0)

But it is not so colorful as I think. I can not join to game :/
I think TFS Database Manager has problem with optimazing mysql database :/

Anyone can send me full working and "clear" TFS for Tibia 8.6?

#SOLVED
It's simply problem x)
My firewall blocked TFS connecting.