Kido Posted August 19, 2013 Group: Members Topic Count: 127 Topics Per Day: 0.03 Content Count: 1445 Reputation: 163 Joined: 08/17/13 Last Seen: July 11, 2019 Share 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 Link to comment Share on other sites More sharing options...
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 KidoLink to comment
Share on other sites
0 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.