[Help] 1062 - Duplicate entry '#####' for key 1.

[Shadow345]

I'm using aldimasters db, (its supposed to be v12, from what I've read anyway). However, there are various things in game missing, such as the tower npc.

I searched a bit before posting this here.

When I use the teleport code to teleport into the tower, the entering dungeon screen comes up, freezes and crashes. I then have to go through the database to place the char in a working world/map to login again.

However, this is NOT what my problem is. When I attempt to add the Rabbit Hat (M) into the data_item table, i get the error:

1062 - Duplicate entry '16716' for key 1.

There is no other entry for 16716. I'm assuming something has happened to the original entry made by aldi that is causing this to happen. (When I try to spawn 16716 in game, nothing happens, no items appear in my inventory, and the client doesn't crash!)

I'm assuming the table itself needs a repair before I attempt to enter the files myself to fix this problem.

(I'm using aldi's DB rev 1 + official flyff files, this is not going to be a released server, its just something for me and a friend to test cash shop combo's, thus, it'd help if I knew why its saying there's a duplicate entry, and how to solve the issue so i can start filling it up with cs sets that don't show up and/or aren't in the version yet)

 

[IHXFRYZZ]

I'm using aldimasters db, (its supposed to be v12, from what I've read anyway). However, there are various things in game missing, such as the tower npc.

I searched a bit before posting this here.

When I use the teleport code to teleport into the tower, the entering dungeon screen comes up, freezes and crashes. I then have to go through the database to place the char in a working world/map to login again.

However, this is NOT what my problem is. When I attempt to add the Rabbit Hat (M) into the data_item table, i get the error:

1062 - Duplicate entry '16716' for key 1.

There is no other entry for 16716. I'm assuming something has happened to the original entry made by aldi that is causing this to happen. (When I try to spawn 16716 in game, nothing happens, no items appear in my inventory, and the client doesn't crash!)

I'm assuming the table itself needs a repair before I attempt to enter the files myself to fix this problem.

(I'm using aldi's DB rev 1 + official flyff files, this is not going to be a released server, its just something for me and a friend to test cash shop combo's, thus, it'd help if I knew why its saying there's a duplicate entry, and how to solve the issue so i can start filling it up with cs sets that don't show up and/or aren't in the version yet)

Hello Again..

i suggest u 2 made an sql of the database. ( wich mean making it a text file xD) and look for the code that is duplicated and u will find it.. remember that in data_items there are 5 pages not only one.. however.. this is caali related...

and i already told u in other post.. is not supported here... one more question about caali files and no one will answer u ;-;

including me :/

 

[Shadow345]

Hello Again..

i suggest u 2 made an sql of the database. ( wich mean making it a text file xD) and look for the code that is duplicated and u will find it.. remember that in data_items there are 5 pages not only one.. however.. this is caali related...

and i already told u in other post.. is not supported here... one more question about caali files and no one will answer u ;-;

including me :/

Thanks, I really have highly appreciated your help, i'll turn the sql into a txt document and see if I can find it. And, I meant to throw a question in there I missed. I was going to ask exactly what ''caali's files'' are, then I thought about it for a sec and realized.

Sorry I'm so slow. xD Thanks again, I won't mention the files again. If i made this post without mentioning what files I'm using, and simply based my questions on the database, is that allowed? Or, is it that aldi's database itself is made for these files? If that's the case then again, I am sorry. :x

 

[IHXFRYZZ]

Thanks, I really have highly appreciated your help, i'll turn the sql into a txt document and see if I can find it. And, I meant to throw a question in there I missed. I was going to ask exactly what ''caali's files'' are, then I thought about it for a sec and realized.

Sorry I'm so slow. xD Thanks again, I won't mention the files again. If i made this post without mentioning what files I'm using, and simply based my questions on the database, is that allowed? Or, is it that aldi's database itself is made for these files? If that's the case then again, I am sorry. :x

its ok shadow :3u can pm me if u need my messenger i can help u there.. but as i said..

i higly recommend u that dont use caali.. u will end hating flyff servers xD

also.. they are banned from variuos reasons.. mostly the virus they got.. but also for respect to caali, cuz the files were leaked from them :/

so if u need help pm me asking for my messenger and i will be glad helping u :3