Steve Wrote
Thorgarth wrote:
Receiving an "Error in CheckForMaintenanceFacilities" Error 91 was generated by Aurora, Object variable or With block variable not set.
Message continues to repeat until I kill the program.
I have maintenance turned off for this galaxy.
Update: First receive this error message:
Error 3075 was generated by DAO.Datebase
Syntax error (missing operator) in query express 'f.RaceID = 827 and f.SystemID = f.Xcor = -76964650 and f.Ycor = -128283291 and s.FleetID = f.FleetID and s.CurrentMaint > 0'.
Thanks for the update. The error 91 will occur when trying access a database record that doesn't exist, which is explained by the error above as it would stop the database record being retrieved. What is puzzling me though is trying to recreate it. It's a fairly common function call and a short function. I have identified the piece of code that almost matches the above but the above is missing a small section between 'SystemID =' and 'f.Xcor' which does exist in the code. Somehow the string variable that holds the SQL seems to have lost a section from the middle of the text. I have added a breakpoint to the function so I will keep tracking it and try to recreate the problem.
Steve
I have just had the same series of errors with a variation in the f.RaceID=800 and f.systemID=and f.Xcor=-54975801 and f.Ycor=139132388, everything else is identical. Get this series of errors every time I try and advance time.
if I try to advance time in SM mode the event log gets the following message:
SM only Event type message continued System N/A Event pentarch.org/viewforum.php?f=11
I can only assume Aurora is telling me to look at the Aurora website? :cry: .
I know its cold comfort but at least there are now two separate instances of this bug, which means it is almost certainly not related to some type of setup or installation issue. On the other hand, it isn't happening to everyone which would suggest it is a fairly rare set of circumstances that causes it and it might be a data fix - which would mean it isn't terminal

.
There is one difference between the two reports that could be important.
Thorgath reported "f.RaceID = 827 and f.SystemID = f.Xcor = -76964650 and f.Ycor = -128283291"
Your bug is f.RaceID=800 and f.systemID=and f.Xcor=-54975801 and f.Ycor=139132388
You have an 'and' between f.SystemID and f.Xcor which is missing in Thorgath's report. This was what I was referring to when I mentioned that a small section of the string variable was missing.
The actual code section is:
sSQL = "select s.CurrentMaint from Fleet f, Ship s where f.RaceID = " & obj.RaceID & " and f.SystemID = " & SystemID & " and f.Xcor = " & obj.Xcor & " and f.Ycor = " & obj.Ycor & " and s.FleetID = f.FleetID and s.CurrentMaint > 0"
The value for SystemID is missing entirely but the 'and' is also missing from Thorgath's error report, which made me think some type of corruption was involved. If the only thing missing is actually SystemID, which is a separate variable rather than part of the string, then there are more potential answers to the problem.
SystemID isn't set to 0 - it isn't there at all - which might suggest it has a null value somehow. Did you get any errors relating to a null value before this error happened?
EDIT: Did you by any chance fire any box launchers before this happened? If you did, then I think I have found the problem. It's fixed for v4.3. The workaround for v4.26 is to delete the records from the WeaponRecharge table in the database
Steve