Kido Posted August 19, 2013 Posted August 19, 2013 (edited) I have problems with the DB, i jsut changed eathena to rathena the problem is that mysql is not reading some DBs this is the example of a player he also does not have any item in its storage and cart and invetory i tryied to import de DB that i saved but is not working ;-; i got this errors storage [Err] 1062 - Duplicate entry '21448' for key 'PRIMARY' [Err] INSERT INTO `storage` (`id`, `account_id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `card0`, `card1`, `card2`, `card3`, `expire_time`) VALUES (21448, 2000119, 4116, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0); [Msg] Finished - Unsuccessfully -------------------------------------------------- inventory [Err] 1062 - Duplicate entry '82121' for key 'PRIMARY' [Err] INSERT INTO `inventory` (`id`, `char_id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `card0`, `card1`, `card2`, `card3`, `expire_time`) VALUES (82121, 150482, 2528, 1, 4, 1, 4, 0, 4133, 0, 0, 0, 0); [Msg] Finished - Unsuccessfully -------------------------------------------------- cart_inventory [Err] 1146 - Table 'ragnarok.cart_inventory' doesn't exist [Err] INSERT INTO `cart_inventory` (`id`, `char_id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `card0`, `card1`, `card2`, `card3`, `expire_time`) VALUES (1, 150051, 714, 150, 0, 1, 0, 0, 0, 0, 0, 0, 0); [Msg] Finished - Unsuccessfully -------------------------------------------------- this is my sql tables please help ): edit: solved how? i had the wrong name of a table in mysql so i just change it the last name afert "bound" table was wrong, so i just changed its name to unique_id and it worked fine hope it helps in the future! thanks anyway for reading this Edited August 20, 2013 by Kido Quote
Question
Kido
I have problems with the DB, i jsut changed eathena to rathena
the problem is that mysql is not reading some DBs
this is the example of a player
he also does not have any item in its storage and cart and invetory
i tryied to import de DB that i saved but is not working ;-;
i got this errors
storage
inventory
cart_inventory
this is my sql tables
please help ):
edit:
solved
how?
i had the wrong name of a table in mysql so i just change it
the last name afert "bound" table was wrong, so i just changed its name to unique_id and it worked fine
hope it helps in the future!
thanks anyway for reading this
Edited by Kido0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.