it happen when i updated my svn to latest rev

[NANORAY]

can someone help me with this script i got error when i updated my svn to latest rev.

 

here's the error:

 

: DB error - Duplicate entry 'userPeak-0' for key 1

[Debug]: at script.c:15981 - INSERT INTO mapreg(varname,value) VALUE('userPeak',1                                                                                     )

[Debug]: Source (NPC): user_counter (invisible/not on a map)

 

here's the script:

-	script	user_counter	-1,{
OnPCLoginEvent:

query_sql("SELECT value FROM mapreg WHERE varname='userOnline'",.@lastOnline);

if(getarraysize(.@lastOnline) == 0) {
	query_sql("INSERT INTO mapreg(varname,value) VALUE('userOnline',1)");
	set .@userOnline,1;
} else {
	query_sql("UPDATE mapreg SET value=value+1 WHERE varname='userOnline'");
	set .@userOnline,.@lastOnline[0]+1;
}

query_sql("SELECT value FROM mapreg WHERE varname='userPeak'",.@userPeak);

if((.@userOnline > .@userPeak[0]) || (getarraysize(.@userPeak) == 0)) {
	if(getarraysize(.@userPeak) == 0)
		.@newPeak$ = "INSERT INTO mapreg(varname,value) VALUE('userPeak',"+.@userOnline+")";
	else
		.@newPeak$ = "UPDATE mapreg SET value="+.@userOnline+" WHERE varname='userPeak'";
	query_sql(.@newPeak$);
	.@peak = .@userOnline;
} else {
	.@peak = .@userPeak[0];
}

end;

OnPCLogoutEvent:
query_sql("SELECT value FROM mapreg WHERE varname='userOnline'",.@lastOnlineB);
if(.@lastOnlineB[0] > 1)
	query_sql("UPDATE mapreg SET value=value-1 WHERE varname='userOnline'");
else
	query_sql("DELETE FROM mapreg WHERE varname='userOnline'");
end;
}

 

[nanakiwurtz]

Have you imported the file "sql-files/upgrades/upgrade_20150831.sql" ?

[NANORAY]

i already did a clean import of main.sql and log.sql

[nanakiwurtz]

Please update your server and retry

[Radian]

I think it's normal since the old record was deleted and you applied a new sql's the script will show a debug message? I guess correct me if im wrong..