• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[8.41/42] The Forgotten Server 0.3.4PL2 (Crying Damson)

Status
Not open for further replies.
[17/06/2009 21:19:09] mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, ''); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)

I get that error each time i try to log on..
 
hmm

im kinda new with sql but you could try re-importing your sql.. make sure you put in schema.mysql too
 
Im having several problems when I updated my server from TFS 0.3.2 to 0.3.4.

1. In the Who is online section the first player appears with vocation "array", for the rest of the players the column is empty.
Here is my who is online. Using gesior AAC 0.3.4
PHP:
<?PHP
$order = $_REQUEST['order'];
if($order == 'level')
	$orderby = 'level';
elseif($order == 'vocation')
	$orderby = 'vocation';
if(empty($orderby))
	$orderby = 'name';
$players_online_data = $SQL->query('SELECT * FROM players WHERE online = 1 ORDER BY '.$orderby);
$number_of_players_online = 0;
foreach($players_online_data as $player) {
	$number_of_players_online++;
	if(is_int($number_of_players_online / 2))
		$bgcolor = $config['site']['darkborder'];
	else
		$bgcolor = $config['site']['lightborder'];
	$players_rows .= '<TR BGCOLOR='.$bgcolor.'><TD WIDTH=70%><A HREF="index.php?subtopic=characters&name='.$player['name'].'">'.$player['name'].'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=20%>'.$vocation_name[$player['promotion']][$player['vocation']].'</TD></TR>';
}
if($number_of_players_online == 0)
	//server status - server empty
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently no one is playing on '.$config['server']['serverName'].'.</TD></TR></TABLE></TD></TR></TABLE><BR>';
else
{
	//server status - someone is online
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently '.$number_of_players_online.' players are online.</TD></TR></TABLE></TD></TR></TABLE><BR>';
	//list of players
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD><A HREF="index.php?subtopic=whoisonline&order=name" CLASS=white>Name</A></TD><TD><A HREF="index.php?subtopic=whoisonline&order=level" CLASS=white>Level</A></TD><TD><A HREF="index.php?subtopic=whoisonline&order=vocation" CLASS=white>Vocation</TD></TR>'.$players_rows.'</TABLE>';
	//search bar
	$main_content .= '<BR><FORM ACTION="index.php?subtopic=characters" METHOD=post>  <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';
}
?>

2. Also players lose 4% exp when diying even tho my config lua says:
PHP:
deathLostPercent = 7

3. My blessing seller (I'm using the default one) is having the following debug:
PHP:
[19/06/2009 02:02:51] Lua Script Error: [Npc interface] 
[19/06/2009 02:02:51] data/npc/scripts/bless.lua:onCreatureSay

[19/06/2009 02:02:51] data/npc/lib/npcsystem/modules.lua:141: attempt to compare nil with number
[19/06/2009 02:02:51] stack traceback:
[19/06/2009 02:02:51] 	data/npc/lib/npcsystem/modules.lua:141: in function 'callback'
[19/06/2009 02:02:51] 	data/npc/lib/npcsystem/keywordhandler.lua:40: in function 'processMessage'
[19/06/2009 02:02:51] 	data/npc/lib/npcsystem/keywordhandler.lua:168: in function 'processNodeMessage'
[19/06/2009 02:02:51] 	data/npc/lib/npcsystem/keywordhandler.lua:122: in function 'processMessage'
[19/06/2009 02:02:51] 	data/npc/lib/npcsystem/npchandler.lua:381: in function 'onCreatureSay'
[19/06/2009 02:02:51] 	data/npc/scripts/bless.lua:8: in function <data/npc/scripts/bless.lua:8>

4. Finally Im getting this error when I execute TFS.exe:
PHP:
[17/06/2009 21:19:09] mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, ''); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)
 
Nr 1. Probably something wrong with your account maker, got to the account maker thread.
Nr 2. <Dont know>
Nr 3. If you use the default one, it should work, so you must have forgotten to replace some files when updating.
Nr 4. Go to server_motd and delete all tables in it.
 
It seems there are several crash bugs still. Anyone knows how to prevent them? I mean generally every crashbug so I dont need to be specific :)

Also, the "muted buffer" doesnt seem to have any 'cooldown' to go back at the 5 seconds mutebuff. Instead if just increases the time no matter how long you've waited to "spam"
Im using this in the spells to prevent one crash bug.
 
I heard the new TFS is released on the 30th.
I don't know exactly when though.
 
Is there any way to increase attack of rods/wands?

I MEAN FUNCTION LIKE setItemAttack but for rods/wands!!
 
debugassertion.png


Happens randomly when TFS 0.3.4 is already executed, server crashes.
 
Status
Not open for further replies.
Back
Top