Server freezing on item obtaining

[Kurofly]

'Sup there.

 

I'm having trouble with my current server, I've set up a new clean offline server and whenever I kill a monster or use '@item' command the server freezes.

I have no error in the consoles but I know it freezes because the client interface still works and the server doesn't tell me when I log out, even more it thinks I'm still online even after trying to log back several times.

 

I have the latest git revision (updated it 5 min ago) (compiled too) and here are the files you may want to know about:

 

src/common/mmo.h:

#ifndef PACKETVER
	#define PACKETVER 20151104
#endif

src/config/core.h:

#define PACKET_OBFUSCATION

db_packet_db.txt:

packet_db_ver: 55
//packet_db_ver: default
packet_keys_use: default

2015-11-04aRagexe diffed without the 'disable packet encryption' option (client found here)

(I actually just checked the recommended and the 'use ragnarok icon' options)

 

clientinfo.xml:

<?xml version="1.0" encoding="euc-kr" ?>
<clientinfo>
	<desc>Ragnarok Online Client Information</desc>
	<servicetype>korea</servicetype>
	<servertype>primary</servertype>
	<connection>
		<display>Local</display>
      	<address>127.0.0.1</address>
      	<port>6900</port>
      	<version>55</version>
      	<langtype>0</langtype>
		<registrationweb>www.ragnarok.com</registrationweb>
		<loading>
			<image>loading00.jpg</image>
			<image>loading01.jpg</image>
			<image>loading02.jpg</image>
			<image>loading03.jpg</image>
			<image>loading04.jpg</image>
		</loading>
		<yellow>
			<admin>2000000</admin>
			<admin>2000001</admin>
			<admin>2000002</admin>
		</yellow>
   	</connection>
</clientinfo>

I tried changing the ragexe and the same problem occurs each time, whatever the diffing options.

 

My previous server was a svn revision (r17726), I can't test it on my new ragexe but it works fine with others (2013 and 2012)

 

I managed to temporarly solve the problem by updating my sql-files with the 'uprages' folder and other sql files (I only loaded the main.sql and logs.sql at first) but it suddenly came back, I have no idea what triggered that error the second time, I don't think I did anything unusual..

 

 

 Well I tried a few things but seems I'm stuck there, I have to call for help 

 

There's one thing I'm not sure about, about when I diffed my client:

 

At first I clicked ok without checking and it gave me an error.

 

 

So I changed it to 'itemInfo.lub' and it worked fine (since my file has a cap)

 

 

I don't know if it's related to my issue but since it concerns the iteminfo.lub it might have something to do with it, anyway with or without the cap I still have the same error.

 

 

Whew, that makes a lot to read. Sorry about this and thanks for your support 

Edited June 28, 2016 by Kurofly

[Kurofly]

Ah so it's an xampp related problem (I didn't think the database itself would be bugged ^^)

 

Solved (at least for now, I'll edit this topic if the problem occurs again) by getting back to mysql, you should do the same Technoken.

 

Thanks a lot for letting me know, oh and don't forget to do a complete uninstallation of the xampp workbench before downloading mysql back cause I forgot ^^

(uninstall + delete C:\ProgramFiles\Mysql + delete C:\ProgramData\Mysql + delete C:\Users\<YOUR_USER_NAME>\AppData\Roaming\MySQL + reboot, some of those folder may be hidden)

[Technoken]

It's related to what i've posted here LINK

 

They told me it wasn't because of rAthena fies, rather it's because of the database.

 

Try to access your log db while the client is frozen and see if will show an error on mapserver.

 

As of now I still can't fix this issue. Are you also using XAMPP?

Edited June 29, 2016 by Technoken