Ragnarok Offline Newbie Pack 2022 | Make your RO server in less then 5 minutes

[Ragnarok Offline Newbie Pack 2022 | Make your RO server in less then 5 minutes]

Good Day,

 

Many thanks to all of you who took time to reply and explain.

 

On 5/9/2020 at 1:55 AM, anacondaq said:

Everything looks like you have corrupted tables inside database. The solution for fixing all tables (repair all mysql tables) you can inside readme.md, read the guide please. 

 

 

Yes thank you!! This is exactly what the problem was.  I took time to read (the manual) and found some relevant information, I was unaware of.

 

On 5/9/2020 at 12:49 AM, csktwyr said:

hey there bro, you can try this fix made by sir anacondaq on his earlier reply to this thread:

 

You saved my bacon with this one quote, It worked ! All of the package is currently running on a PC that goes into sleep mode frequently => damaged db due to incorrect shutdown. I understand that I need to either apply a proper shutdown procedure of the server when quitting, or to run the SQL / Emulator on a dedicated server that stays permenantly on.

 

On 5/9/2020 at 1:33 AM, Naruto said:

well its intended for local/private/testing and not for a real server

 

just ask someone to hook it up for you 

 

It is too small of a "server" to bother someone with all the hassle (file exchange, DB backups, confs). The issue is solved, and I hope I can manage to get the next one fixed by reading documentation and these posts .

 

Thanks again to all of you for the support, and for this well designed package.

 

 

 

 

[Ragnarok Offline Newbie Pack 2022 | Make your RO server in less then 5 minutes]

Hello dear Hercules users and admins,

 

I am running this package since a few months with very few modifications.

This setup was operating quite nicely but since a few days I am facing an issue. I made few reasearch on the forum, but unable to get a clear solution to this case. 

 

There are some cases of trasactions where a specific in game action cause a complete freeze.  For instance getting an MVP item, socketting a card, selling to a NPC, Resetting stats, using command "@item" ...

I am not sure whether it is the SQL server, or the emulator which is frozen, however, I can bypass the freeze by requesting a SQL server restart (yellow flag), and the action is carried out sucessfully. This solution is not viable on normal conditions, and I seek the cause of this issue.

 

Maybe some of you know about this issue, and have a fix? 

My SQL database has been backed up, any solution is welcome.

 

Thanks a lot in advance