Solved error in tfs

[JonatasLucas]

hello people I am with this small error to reset my character and use tfs 0.4 site

 

[Limos]

ALTER TABLE `players` ADD `reset` INT NOT NULL DEFAULT 0;

 

[JonatasLucas]

I'm there with this error and another that player logs out and the character does not save

 

[Limos]

ALTER TABLE `killers` ADD `war` int(11) NOT NULL DEFAULT 0;

And for the executeQuery, add this in 100-compat.lua

db.executeQuery = db.query

 

[JonatasLucas]

as well add compact.lua

 

[Limos]

What do you mean? You can add this line in data/lib/100-compat.lua

db.executeQuery = db.query

Or change db.executeQuery to db.query in record.lua.

 

[JonatasLucas]

can now pass me the table that saves the players because when they are around lvl 8 Logging out

 

[Limos]

What is the problem exactly? It saves the player if it has save to 1 in the database in the table players.

 

[JonatasLucas]

start line 16 48 24 968

 

[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

 

[JonatasLucas]

error #1060 - Duplicate column name 'cast'

of this error when running just above error #1060 - Duplicate column name 'cast'

 

[Limos]

Do you still get the error "MYSQL ERROR: Unknown column `cast` in `field list`" in your console?

 

[JonatasLucas]

yes

/\

 

[Limos]

ALTER TABLE `players` ADD `castViewers` INT(11) NOT NULL DEFAULT '0'

 

[JonatasLucas]

Thanks! thanks for the help I added a query and it worked

ALTER TABLE `players` ADD `castDescription` INT(11) NOT NULL DEFAULT '0'

 

[Limos]

castDescription should be VARCHAR(255) instead of INT.
You can drop the column

ALTER TABLE `players` DROP `castDescription`

Then readd it again

ALTER TABLE `players` ADD `castDescription` VARCHAR(255) NOT NULL

 

[JonatasLucas]

Thank worked doubt resolved