#285 slots in large bags exceed tinyint character_items table column slot

Closed
opened 3 years ago by image · 1 comments
image commented 3 years ago

alter table character_items modify slot int(11) not null default 0;

``` alter table character_items modify slot int(11) not null default 0;```
image commented 3 years ago
Collaborator
07:40:18 E DBCore    : #1264: Out of range value for column 'slot' at row 1
Query:
REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (818817, 'NOT-EQUIPPED', 431, -123, 2, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0)
07:40:18 E DBCore    : #1264: Out of range value for column 'slot' at row 1
Query:
REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (819629, 'NOT-EQUIPPED', 431, -116, 120644, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0)
07:40:18 E DBCore    : #1264: Out of range value for column 'slot' at row 1
Query:
REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (819630, 'NOT-EQUIPPED', 431, -112, 30256, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0)
07:40:18 E DBCore    : #1264: Out of range value for column 'slot' at row 1
Query:
REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (827000, 'NOT-EQUIPPED', 431, -110, 9315, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0)
``` 07:40:18 E DBCore : #1264: Out of range value for column 'slot' at row 1 Query: REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (818817, 'NOT-EQUIPPED', 431, -123, 2, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0) 07:40:18 E DBCore : #1264: Out of range value for column 'slot' at row 1 Query: REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (819629, 'NOT-EQUIPPED', 431, -116, 120644, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0) 07:40:18 E DBCore : #1264: Out of range value for column 'slot' at row 1 Query: REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (819630, 'NOT-EQUIPPED', 431, -112, 30256, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0) 07:40:18 E DBCore : #1264: Out of range value for column 'slot' at row 1 Query: REPLACE INTO character_items (id, type, char_id, slot, item_id, creator,adorn0,adorn1,adorn2, condition_, attuned, bag_id, count, max_sell_value, account_id, login_checksum) VALUES (827000, 'NOT-EQUIPPED', 431, -110, 9315, '', 0, 0, 0, 100, 0, 833760, 1, 0, 88, 0) ```
Sign in to join this conversation.
Loading...
Cancel
Save
There is no content yet.