L2J Server

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


Hello..I have a problem with heroes...I have apply on my pack the Olympiad Period by janii which is for heroes every 1 and 15th of each month...Now my server is in the second period...The heroes spawned as well...After my server restarts...The heroes gone...My G/S shows me 0 heroes Loaded...But in SQL is still heroes...Also in Heroes Diary SQL when i try to open it i get this :




What should i do now?Any suggestions....

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


Hello..I have a problem with heroes...I have apply on my pack the Olympiad Period by janii which is for heroes every 1 and 15th of each month...Now my server is in the second period...The heroes spawned as well...After my server restarts...The heroes gone...My G/S shows me 0 heroes Loaded...But in SQL is still heroes...Also in Heroes Diary SQL when i try to open it i get this :




What should i do now?Any suggestions....

If you read the error,it tells you the solution...

Yes it probably says the solution but i dont know much about sql...Thats why i upload the image...Could you please tell me what to do?

Kind regards John

there is no primary key for that table. it's not an error, it's just how it is.

Heroes before server restarts was ok...After my server restarts there is o heroes...What happens?:/ I didnt do anything...I didnt change anything...Just servers restarted...

Sorry for double posting but is there any guy who can help me with my problem...

Maybe updating the server from old rev to the Freya changelog #2, there was a problem..

Nakamoura wrote:Yes it probably says the solution but i dont know much about sql...Thats why i upload the image...Could you please tell me what to do?

Kind regards John

You need to learn some of the basics of SQL to work with a l2j server.

Read this wikipedia topic to learn about primary keys,is not difficul.Then,yu can select a primary key in navicat.


http://en.wikipedia.org/wiki/Unique_key