L2J Server

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

please help me i need urgent help, i made backup with navicat, and today there was a problem, my character table got corrupted, so i wanted to restore backup, but i cant , i get error duplicate entry, pleae

just do a fix on that table or just restore the table in question

hope wrote:just do a fix on that table or just restore the table in question

i see...

ok iused ignore errors, continue on errors and it made it, allthoug said unssecsefully in the end...

you can select specific tables to restore in navicat, so... select all the others tables except that one.

later you check manually where is the issue in that table.

i have a big problem, it seams accounts were not fully restored...

how could i extract only accounts data table from the backup file ?

ok, so i can extract the tables separatly, i chose accounts table, but in the sql file only few accounts are there...why? pff

Someone tryed to hack you, check this duplicated password.
1. You can (and should) remove it.
2. Your website - piece of shit, if it allow such things.

i use acount manager that is here shared in l2j forum... but before i was using very odl version of it, maybe happend back then...

Read the error message...

You have duplicate entry for primary key. So there are 2 accounts of the same name what is not allowed ("..../etc/passwd"?)... Not to mention your account manager suck if it let creating accounts containing ".", "/" and so on... I bet i can delete or view any of your db tables with simple sql injection... So does anybody else who has even slightest idea...

Switch to this Account Manager, its updated and there is support for it.

Also remember that you are merging two tables with similar entries, you can get duplicates that way, so it would be better to delete that table and restore it with your backup, if there arent too many days of difference only a few accounts will be lost.

ThePhoenixBird wrote:Switch to this Account Manager, its updated and there is support for it.

Also remember that you are merging two tables with similar entries, you can get duplicates that way, so it would be better to delete that table and restore it with your backup, if there arent too many days of difference only a few accounts will be lost.

hello, thank you all

i switched to the new account manager, but i guess those acounts were made before, and stayed there

and since i always backed up, they stayed there

what can i do in the feature to make sure these dupilcate things dont happeN? and if they happen how can i steal read , extract the data inside them? since if i try to extract the accounts sql NOW from the backup file with that error inside them, navicat will extract it, but only few accounts inside the file...

i mean i want to be 100% sure of backups...