FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

FogBugz Internal Error

Hi,

I am getting the following.  I have cleared out the mailbox (using Outlook Express), and there are no email's in there! I made sure that they were deleted, the deleted folder emptied, and the option checked for "Remove from server when deleted from 'Deleted Items'".

---------------
The Fog Creek Maintenance Service has reported an error.

14/03/2005 17:27:39: A message is stuck in mailbox XXX on server MAILSERVERXXX. Use Outlook Express to clear this message so FogBugz can continue. Click here to have FogBugz begin importing your mail from this mailbox again.

The FogBugz Maintenance Service is not running.

15/03/2005 09:37:26: The last time the FogBugz Maintenance Service ran successfully was 12/03/2005 23:59.


When I try and hit the Heartbeat.asp page on the actual server it's self, I get the following:
===========
An internal error occurred in FogBugz. If you are unsure of how to fix this error, and you have made no changes to the source code of FogBugz, please report this error to Fog Creek Software by clicking "Submit." 

File:  /DefectTracking/CCmd.asp 

Line:  136 

Error:  The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. SQL: SELECT DISTINCT Bug.ixBug AS ixBug FROM ( Bug INNER JOIN Mailbox ON Bug.ixMailbox = Mailbox.ixMailbox) INNER JOIN Area ON Bug.ixArea = Area.ixArea WHERE Bug.ixMailBox <> 0 AND Mailbox.nDeleteSPAM > 0 AND Bug.fReplied = 0 AND Bug.fForwarded = 0 AND ( ( Bug.fOpen = 0 AND Bug.ixCategory = 3 AND DATEDIFF(day, Bug.dtClosed, '2005-3-15 9:38:44') >= Mailbox.nDeleteSPAM AND Bug.ixStatus = 13 ) OR ( DATEDIFF(day, Bug.dtOpened, '2005-3-15 9:38:44') >= Mailbox.nDeleteSPAM AND Area.nType = 3)) ORDER BY Bug.ixBug Params: 

Browser:  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322) 

Number:  0x800A00C8 

Category:  CCmd 

Column:  -1 

QueryString:  a 

URL:  /DefectTracking/heartbeat.asp 

Content Length:  0 

Local Addr:  10.100.0.94 

Remote Addr:  10.100.0.94 

Time:  15/03/2005 09:38:44 


========================
Can anyone help?  It is becoming a bit of an issue!  We have followed all of the set-up guides, enabled anonymous access, set the anonymous user to be the FogBugz user, etc.
George Leithead Send private email
Tuesday, March 15, 2005
 
 
I believe that this is due to the UK-US date format!

If I execute the SQL statement using the date format "YYYY-MM-DD" (2005-3-15) locally using Query Analizer, it's fine.  However If I change it to "YYYY-DD-MM" it fails with the same SQL error!

Could it be this?  If so, how do I fix it?
George Leithead Send private email
Tuesday, March 15, 2005
 
 
Hi George-
Yes, it looks like we must have some improper date-parsing code. I'm working on a fix right now, and will email you as soon as I have it tested.
Brett Kiefer Send private email
Tuesday, March 15, 2005
 
 
Hi-

We're talking about the best way to fix the general problem: in your case, it sounds like the quickest way to get you running again is to do the following:

In util.asp, there are three instances of this line:

stNow = Year(Now()) & "-" & Month(Now()) & "-" & Day(Now()) & " " & _

Replace each of these with this line

stNow = Year(Now()) & "-" & Day(Now()) & "-" & Month(Now()) & " " & _

. . . and then hit heartbeat.asp again to test it.

Thanks!
Brett
Brett Kiefer Send private email
Tuesday, March 15, 2005
 
 
Ahah!  That's done it!  It appears to be working as expected now!
George Leithead Send private email
Tuesday, March 15, 2005
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.