Hero Problem...

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
Nakamoura
Posts: 62
Joined: Wed Sep 02, 2009 8:03 am

Hero Problem...

Post by Nakamoura »

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 :

Image


What should i do now?Any suggestions....
bagun
Posts: 55
Joined: Sun Oct 03, 2010 12:09 pm

Re: Hero Problem...

Post by bagun »

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 :

Image


What should i do now?Any suggestions....
If you read the error,it tells you the solution...
Server Developer/Admin of L2Jservers
User avatar
Nakamoura
Posts: 62
Joined: Wed Sep 02, 2009 8:03 am

Re: Hero Problem...

Post by Nakamoura »

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
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: Hero Problem...

Post by jurchiks »

there is no primary key for that table. it's not an error, it's just how it is.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
User avatar
Nakamoura
Posts: 62
Joined: Wed Sep 02, 2009 8:03 am

Re: Hero Problem...

Post by Nakamoura »

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...
User avatar
Nakamoura
Posts: 62
Joined: Wed Sep 02, 2009 8:03 am

Re: Hero Problem...

Post by Nakamoura »

Sorry for double posting but is there any guy who can help me with my problem...
User avatar
SolidSnake
Posts: 865
Joined: Wed Jan 20, 2010 6:54 pm
Location: Italy

Re: Hero Problem...

Post by SolidSnake »

Maybe updating the server from old rev to the Freya changelog #2, there was a problem..
Image
bagun
Posts: 55
Joined: Sun Oct 03, 2010 12:09 pm

Re: Hero Problem...

Post by bagun »

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
Server Developer/Admin of L2Jservers
Post Reply