Need help Unknown SQL Error

[hadiesyafiq 7]

hi all...

my map-server sometimes showing unknown SQL error...can someone help me how to fix this?

below is the picture of map-server ..

[SinjiPrasetio 3]

Well please check your char,c at arount line 3943
You fill find this code

static void char_parse_frommap_scdata_update(int fd)
{
	int account_id = RFIFOL(fd, 2);
	int char_id = RFIFOL(fd, 6);
	int val1 = RFIFOL(fd, 12);
	int val2 = RFIFOL(fd, 16);
	int val3 = RFIFOL(fd, 20);
	int val4 = RFIFOL(fd, 24);
	short type = RFIFOW(fd, 10);

	if (SQL_ERROR == SQL->Query(inter->sql_handle, "REPLACE INTO `%s`"
			" (`account_id`,`char_id`,`type`,`tick`,`total_tick`,`val1`,`val2`,`val3`,`val4`)"
			" VALUES ('%d','%d','%d','%d','%d','%d','%d','%d','%d')",
			scdata_db, account_id, char_id, type, INFINITE_DURATION, INFINITE_DURATION, val1, val2, val3, val4)
	) {
		Sql_ShowDebug(inter->sql_handle);
	}
	RFIFOSKIP(fd, 28);
}

check if this code is te same with your source, if your code is changed, please follow above code, and recompile.

Hope this helps!

[SinjiPrasetio 3]

Hello,
Are you made a source modification?
This error should not occurs on fresh Hercules.

Can you provide more information about this?

[hadiesyafiq 7]

On 7/5/2021 at 7:34 PM, SinjiPrasetio said:

Hello,
Are you made a source modification?
This error should not occurs on fresh Hercules.

Can you provide more information about this?

Now i found this error will appear when character weight over 50%..but how to fix it?

[hadiesyafiq 7]

2 hours ago, SinjiPrasetio said:

Well please check your char,c at arount line 3943
You fill find this code

static void char_parse_frommap_scdata_update(int fd) { int account_id = RFIFOL(fd, 2); int char_id = RFIFOL(fd, 6); int val1 = RFIFOL(fd, 12); int val2 = RFIFOL(fd, 16); int val3 = RFIFOL(fd, 20); int val4 = RFIFOL(fd, 24); short type = RFIFOW(fd, 10); if (SQL_ERROR == SQL->Query(inter->sql_handle, "REPLACE INTO `%s`" " (`account_id`,`char_id`,`type`,`tick`,`total_tick`,`val1`,`val2`,`val3`,`val4`)" " VALUES ('%d','%d','%d','%d','%d','%d','%d','%d','%d')", scdata_db, account_id, char_id, type, INFINITE_DURATION, INFINITE_DURATION, val1, val2, val3, val4) ) { Sql_ShowDebug(inter->sql_handle); } RFIFOSKIP(fd, 28); }

static void char_parse_frommap_scdata_update(int fd)
{
	int account_id = RFIFOL(fd, 2);
	int char_id = RFIFOL(fd, 6);
	int val1 = RFIFOL(fd, 12);
	int val2 = RFIFOL(fd, 16);
	int val3 = RFIFOL(fd, 20);
	int val4 = RFIFOL(fd, 24);
	short type = RFIFOW(fd, 10);

	if (SQL_ERROR == SQL->Query(inter->sql_handle, "REPLACE INTO `%s`"
			" (`account_id`,`char_id`,`type`,`tick`,`total_tick`,`val1`,`val2`,`val3`,`val4`)"
			" VALUES ('%d','%d','%d','%d','%d','%d','%d','%d','%d')",
			scdata_db, account_id, char_id, type, INFINITE_DURATION, INFINITE_DURATION, val1, val2, val3, val4)
	) {
		Sql_ShowDebug(inter->sql_handle);
	}
	RFIFOSKIP(fd, 28);
}

check if this code is te same with your source, if your code is changed, please follow above code, and recompile.

Hope this helps!

Thank you very much sir @SinjiPrasetio it work...it different from mine just INFINITE_DURATION...mine just single word...

[SinjiPrasetio 3]

On 7/8/2021 at 3:32 AM, hadiesyafiq said:

Thank you very much sir @SinjiPrasetio it work...it different from mine just INFINITE_DURATION...mine just single word...

U're welcome! ^^