Lua database error when trying to save the game

[Guerra]

Hello guys,

i am trying this error when trying to save my server. It started after I added new items to my items.otb !! Does anyone know how to solve this problem?



I am also receiving this information on the console and it had never happened before ...

 

[Addams]

What kind of items did you add? Looks like 'itemtype' needs a bigger int, Try this sql query.

ALTER TABLE player_items MODIFY itemtype SMALLINT NOT NULL DEFAULT '0'

 

[Evil Puncker]

dude you gave us no info at all, the main one: what server are you using?

 

[Guerra]

dude you gave us no info at all, the main one: what server are you using?

sorry gentlemen, use i use tfs 1.3

Post automatically merged: Aug 30, 2020

What kind of items did you add? Looks like 'itemtype' needs a bigger int, Try this sql query.

ALTER TABLE player_items MODIFY itemtype SMALLINT NOT NULL DEFAULT '0'

it didn't work, it still doesn't save. I added some normal giant emerald, sapphire and ruby items. I also added some dolls to use on some systems. Nothing out of the ordinary ...

 

[Addams]

The default storage for itemtype in latest TFS is small int, You can increase it to INT but I am not sure how this will affect the server.

ALTER TABLE player_items MODIFY itemtype INT NOT NULL DEFAULT '0'

 

[Guerra]

The default storage for itemtype in latest TFS is small int, You can increase it to INT but I am not sure how this will affect the server.

ALTER TABLE player_items MODIFY itemtype INT NOT NULL DEFAULT '0'

do this query in the player_itens table?

 

[Addams]

just insert it in the database

 

[Guerra]

just insert it in the database

I ran the command and apparently solved it, I managed to save the game without error. Thank you very much for your help my friend!

Post automatically merged: Aug 30, 2020

but I’m still getting that information when I save the houses. Could you tell me what it is and if it interferes with the game?

 

[Addams]

First 2 lines looks like its a house check script like this one

Lua - Problem check house

My script work, but when the house is clear, items dont go inside depot, they disappear :o how to solve? tfs 1.2 local function doCheckHouses() local dias = 15 local tempo = os.time() - (dias * 24 * 60 * 60) local registros = db.storeQuery("SELECT `houses`.`owner`, `houses`.`id`...

otland.net

others are normal TFS startup console

 

[Guerra]

First 2 lines looks like its a house check script like this one

Lua - Problem check house

My script work, but when the house is clear, items dont go inside depot, they disappear :o how to solve? tfs 1.2 local function doCheckHouses() local dias = 15 local tempo = os.time() - (dias * 24 * 60 * 60) local registros = db.storeQuery("SELECT `houses`.`owner`, `houses`.`id`...

otland.net

others are normal TFS startup console

I just tested, the houses are not saving. when the player uses the command! leave items from the houses instead of going to the deposit, they disappear !!

 

[Addams]

No, it check the houses left, Like when a player do (!leavehouse).

 

[Guerra]

No, it check the houses left, Like when a player do (!leavehouse).

I just tested it, when the player uses the! leavehouse command their items disappear and are not returned to the depot

 

[Addams]

That's different bug/issue and not related to this thread, Create a different thread with all the information and house/scripts you added lately.

 

[Guerra]

That's different bug/issue and not related to this thread, Create a different thread with all the information and house/scripts you added lately.

ok ty man