Jump to content
  • 0

Urgent please SQL DB problem!


Kido

Question


  • Group:  Members
  • Topic Count:  127
  • Topics Per Day:  0.03
  • Content Count:  1445
  • Reputation:   163
  • Joined:  08/17/13
  • Last Seen:  

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

 

s175.jpg

 

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

AYNJk36.png

 

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 Kido
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...