Jump to content

Tribal

Members
 View Profile  See their activity

  • Posts

    8

  • Joined

  • Last visited

 Content Type 

Posts posted by Tribal

    SQL Debug logs - rAthena rev: d16e7e6

    in Source Support

    Posted 

     	[SQL]: DB error - Column 'dst_charname' cannot be null
	[Debug]: at log.cpp:470 - INSERT DELAYED INTO `chatlog` (`time`, `type`, `type_id`, `src_charid`, `src_accountid`, `src_map`, `src_map_x`, `src_map_y`, `dst_charname`, `message`) VALUES (NOW(), 'O', '0', '150002', '2000003', 'prontera', '152', '171', ?, ?)

    Hey guys, I have the following pop up in my syslog after I updated my rAthena to latest version and compiled. I fixed it by allowing the dst_charname to be null in _log database. But I thought I should report it never the less.

    Is this the recommended way to fix it, if not, what is?

    Thanks in advance,

    Kevin

    Numbers in Regular Chat

    in General Support

    Posted

    Hey, so I got this issue too, and would like to know how to fix it. The client I am using is 20170517

    I tried a 20161228 client, a 20170517 and a 20170614 one. Recompiled my personal test server using './configure --enable-packetver=<client version> --enable-prere=yes' (on CentOS 7 using devtools-7).


    I've found outa Client diff for 20151104 clients exists, but I don't know how to modify that to a more current one.

    Running latest master branches on rAthena and running 'git pull' on a regular basis on test server. However no fix has been found yet (at least by me). I found out on my live server the numbers have a different notation than on my test server currently. I tried using Wireshark for valuable output, but I couldn't find anything of use. (Could be my incompetence using Wireshark though). I did find out that it's the ZC_ACK_WHISPER02 packet which is defined in 'src/map/clif.cpp' with the following code: 

    void clif_wis_end(int fd, int result)
{
	struct map_session_data *sd = (session_isValid(fd) ? (struct map_session_data *)session[fd]->session_data : NULL);
#if PACKETVER < 20131223
	const int cmd = 0x98;
#else
	const int cmd = 0x9df;
#endif

	if (!sd)
		return;

	WFIFOHEAD(fd,packet_len(cmd));
	WFIFOW(fd,0) = cmd;
	WFIFOB(fd,2) = (char)result;
#if PACKETVER >= 20131223
	WFIFOL(fd,3) = sd->status.char_id;	// GID/CCODE
#endif
	WFIFOSET(fd,packet_len(cmd));
}

    If anyone could elaborate on this issue, please do.


    Thanks in advance,
    Kevin

×
×
  • Create New...