Hi, after moving our Fogbugz database to a new MySQL-server (on Ubuntu Linux) and running install.sh to upgrade the old install to version 7.1.8, we're getting this error message when we try to access the heartbeat.asp web page:
! The Fog Creek Maintenance Service has reported an error. (200) CCmd:
Argument cannot be null. Parameter name: schema SQL: UPDATE
DiscussTopic SET dt = DATE_ADD(dt, INTERVAL -3600 SECOND) WHERE
ixDiscussTopic <= ? AND ixDiscussTopic > ? Params: II 1: 21 2: -979 at
Wasabi.Runtime.ADO.Cursor.FillSchema (System.Data.DataTable schema)
[0x00000] at Wasabi.Runtime.ADO.Cursor.set_Reader
(System.Data.Common.DbDataReader value) [0x00000] at
Wasabi.Runtime.ADO.KeySetCursor..ctor (System.Data.Common.DbCommand
command, Boolean noUpdates) [0x00000] at
Wasabi.Runtime.ADO.KeySetCursor..ctor (System.Data.Common.DbCommand
command) [0x00000] at Wasabi.Runtime.ADO.RecordSet..ctor
(Wasabi.Runtime.ADO.Command command) [0x00000] at
Wasabi.Runtime.ADO.Command.Execute (System.Object ignored1,
System.Object ignored2, Nullable`1 Options) [0x00000] at
FogCreek.FogBugz.CCmd.InternalExecute (System.String& sError) [0x00000]
Wasabi.Runtime.WasabiException (0x80004005): Argument cannot be null.
Parameter name: schema SQL: UPDATE DiscussTopic SET dt = DATE_ADD(dt,
INTERVAL -3600 SECOND) WHERE ixDiscussTopic <= ? AND ixDiscussTopic > ?
Params: II 1: 21 2: -979 at Wasabi.Runtime.ADO.Cursor.FillSchema
(System.Data.DataTable schema) [0x00000] at
Wasabi.Runtime.ADO.Cursor.set_Reader (System.Data.Common.DbDataReader
value) [0x00000] at Wasabi.Runtime.ADO.KeySetCursor..ctor
(System.Data.Common.DbCommand command, Boolean noUpdates) [0x00000] at
Wasabi.Runtime.ADO.KeySetCursor..ctor (System.Data.Common.DbCommand
command) [0x00000] at Wasabi.Runtime.ADO.RecordSet..ctor
(Wasabi.Runtime.ADO.Command command) [0x00000] at
Wasabi.Runtime.ADO.Command.Execute (System.Object ignored1,
System.Object ignored2, Nullable`1 Options) [0x00000] at
FogCreek.FogBugz.CCmd.InternalExecute (System.String& sError) [0x00000]
at Wasabi.Runtime.Error.RaiseException (Int32 number, System.String
source, System.String description, System.String helpfile, Nullable`1
helpcontext) [0x00000] at FogCreek.FogBugz.CCmd.Execute (Nullable`1
nCacheClearLevel) [0x00000] at
FogCreek.FogBugz.CHeartbeatTask.PerformTask (Wasabi.Runtime.Function`3
fxErr, Int32 nTimeout) [0x00000] at
FogCreek.FogBugz.__Global.SingleHeartbeat (Int32 cMaxBayesianRequests,
Int32 cMaxMailMessages, Int32 nEmailTimeout) [0x00000] at
FogCreek.FogBugz.__Global.StartHeartbeat () [0x00000]
I've tried deleting everything in the DiscussTopic table, and tried dropping it completely, but that didn't do anything to solve this problem.
This command returns a "+":
lynx "http://host.domain.com/FogBugz/heartbeat.asp?fSkipCDBCopier=1&fSkipHeartbeatTasks=1"http://host.domain.com/FogBugz/heartbeat.asp?fSkipHeartbeatTasks=1"
We tried running the SQL query manually, this worked fine. Is there any way of removing this job from the list of jobs that the maintenance service thinks it should do?
We're also getting problems editing our cases after the upgrade, adding a new case works fine, but when we try to edit them later we get a message saying the webpage was expired.
Any suggestions as to what we could do to fix this problem?
Thanks