Jump to content

  •  

Vincent

Member Since 05 Apr 2013
Offline Last Active Apr 26 2015 03:17 PM
-----

Issues I've Posted

    SQL Table "inventory" got the wrong typ

    Posted 25 Nov 2013

    I get sometimes a Error at the Console because of the Colum "favorite" at the "inventory" Table.

    At the main.sql favorite is:
    `favorite` tinyint(3) unsigned NOT NULL default '0',
    
    my suggestion make it to a normal int(10).

    Error:
    [SQL]: DB error - Out of range value for column 'favorite' at row 1
    [Debug]: at ..\src\char\char.c:986 - INSERT INTO `inventory` (`char_id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `favorite`, `bound`, `unique_id`, `card0`, `card1`, `card2`, `card3`) VALUES ('150003','2268', '1', '0', '1', '0', '0', '0', '-31', '0', '0', '0', '0', '0', '0'