Software Error

[Mark Ingram]

Hi,

im getting the following error:

Software error:
Unknown field id: fix_ts at globals.pl line 150.

Now, i can get rid of this error by adding a row into the fielddefs table
corresponding to the fix_ts field. But that seems like a bit of a cheap way
out. Why does process_bug.cgi through this error up?
In other CGI files it works just fine, but in here it throws up an error.


The code i have written follows (around line 1500):

	for (my $i = 0; $i <= $#idlist; $i++) {
		my $strSQL = "";
		SendSQL("SELECT origfix_ts FROM bugs WHERE bug_id = $idlist[$i]");
		my $origfix_ts = FetchOneColumn();
		if ($origfix_ts == "0000-00-00 00:00:00") {
			# First time that the bug has been fixed, so update the value
			$strSQL = "UPDATE bugs SET origfix_ts = NOW(), fix_ts = NOW() WHERE
bug_id = $idlist[$i]";
		}
		else {
			# Not the first time this bug has been fixed, so only update the actual
fix date, not the original one
			$strSQL = "UPDATE bugs SET fix_ts = NOW() WHERE bug_id = $idlist[$i]";
		}
		SendSQL($strSQL);
	}


Any help you can offer is much appreciated.

Best Regards,

Mark Ingram
Software Engineer
Nexsan Technologies
33 - 35 Parker Centre
Mansfield Road
Derby
DE21 4SZ