TFS 1.X+ blob data out of range?

[Mjmackan]

TFS 1.3
Having issues after i added new items to the server, tried a couple of commands to make the INT higher but didnt succeed.

Error:

Mar 22 21:39:41 164-132-112-191 tfs[8995]: Message: Out of range value for column 'itemtype' at row 12
Mar 22 21:39:41 164-132-112-191 tfs[8995]: [290B blob data]

Can i higher the blob overall or do i need to be specific to the item and if so, how? I have no clue.

 

[oen432]

Change itemtype datatype from SMALLINT to MEDIUMINT you can also make it unsigned, there are no negative ids.

 

[Mjmackan]

Change itemtype datatype from SMALLINT to MEDIUMINT you can also make it unsigned, there are no negative ids.

How do you do this practical? I tried with some sql injects but didnt succeed.

 

[Evil Puncker]

How do you do this practical? I tried with some sql injects but didnt succeed.

Fixed data type mismatch from itemtype (#3311) · otland/forgottenserver@e146147

A free and open-source MMORPG server emulator written in C++ - Fixed data type mismatch from itemtype (#3311) · otland/forgottenserver@e146147

github.com