Mysql Problem Help Please!

[kostas136]

Hello Otlanders when i creat a character and loggout this error comes up?
the character starts from the begining when you relogg
Mysql_Real_Query (): UPDATE `Spelarnas SET` lastlggin "

 

[dominique120]

Give appropriate information(read the rules) or your thread will be deleted.

 

[Limos]

ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0',
ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

 

[kostas136]

BUMP

 

[EvilSkillz]

BUMP

add what limos posted in your mysql query

 

[kostas136]

Help with this one Please!!!

 

[kostas136]

and sorry for my english!

 

[aristo]

Rebulid db...hejsan.geoip dont exist, like next collumn's. think bad script or server killing yourself ;

 

[Limos]

ALTER TABLE `killers` ADD `war` TINYINT(1) NOT NULL DEFAULT 0;

I don't how the geoip table is supposed to look like, but you can also just remove the query about it in the script.

 

[kostas136]

i dont get ive try now 3-5times..

 

[kostas136]

ALTER TABLE `killers` ADD `war` TINYINT(1) NOT NULL DEFAULT 0; its fixed and thx Limos!
but still have problem with loggin to God!

 

[Limos]

You can remove the query for the geoip table, it's probable in login.lua (data/creaturescripts/scripts/login.lua).