sgray

Homepage is working again. I have a pilot testing to submit a log to ensure that is working as well.

Our group is getting the following error when trying to access our squadron home page. The calendar page works fine. Server Error in '/' Application. The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: MySql.Data.MySqlClient.MySqlException: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [MySqlException (0x80004005): The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay] MySql.Data.MySqlClient.MySqlStream.ReadPacket() +306 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +67 MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) +17 MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +110 MySql.Data.MySqlClient.MySqlDataReader.NextResult() +772 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1515 MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar() +112 Logbook.DataAccessLayer.Database.queryCommandScalarIn(String sqlStr, String[] args) in C:\Users\propr\source\repos\Logbook\Logbook\DataAccessLayer\Database.cs:220 Logbook.DataAccessLayer.UserDAL.getSearchUser(Int32 userId, Int32 squadronId) in C:\Users\propr\source\repos\Logbook\Logbook\DataAccessLayer\UserDAL.cs:661 Logbook.DataAccessLayer.VirtualSquadronDAL.getSquadronUsers(Int32 squadronId, Permissions permissions) in C:\Users\propr\source\repos\Logbook\Logbook\DataAccessLayer\VirtualSquadronDAL.cs:801 Logbook.DataAccessLayer.VirtualSquadronDAL.getCompleteSquadron(Int32 squadronId, Int32 viewerId) in C:\Users\propr\source\repos\Logbook\Logbook\DataAccessLayer\VirtualSquadronDAL.cs:328 Logbook.Controllers.VirtualSquadronController.Index(Int32 id, Boolean error) in C:\Users\propr\source\repos\Logbook\Logbook\Controllers\VirtualSquadronController.cs:26 lambda_method(Closure , ControllerBase , Object[] ) +142 System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14 System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +157 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27 System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +22 System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +29 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +34 System.Web.Mvc.Async.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d() +50 System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +228 System.Web.Mvc.Async.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult) +10 System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +34 System.Web.Mvc.Async.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() +26 System.Web.Mvc.Async.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult) +100 System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +27 System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +13 System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +36 System.Web.Mvc.Controller.<BeginExecute>b__15(IAsyncResult asyncResult, Controller controller) +12 System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +22 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +26 System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10 System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState) +21 System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +28 System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9850389 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +50 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +163 Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4494.0

First, excellent Mod that I would have gladly paid what I paid for the Huey. I am certainly looking forward to v1.2 so that we can use mission generated ADF and FM. As for likely not making the Seahawk, I would kindly ask that you reconsider. Given the naval aspect in DCS, the enhanced Moose CSAR with downed pilots in the water, and the ASW script available, it would be great to have the SH/MH-60. While I understand the difficulty in creating the systems within the helicopter, having the model alone with the scripting options would greatly enhance the realism feel. Anyway, fantastic work on this project and looking forward to all the enhancements.

Been using this script for a couple of years now without issue.

The v0.12.1 is available here.

Our original mission seems to be running fine following the Hotfix with no crashes.

Well I thought we were good after removing moving vehicles, but crash again today. I cut out the crash part of the log, not sure if it indicates anything new. dcslog.txt Update: Well I found a couple of stationary vehicles that didn't have any waypoints, but did have a speed. So I set the speed to zero and saved. We will see if this one crashes.

For now I have removed all moving vehicles. Is it assumed that the most recent update caused this issue and do you know if ED is working to correct it?

@FlappieSo other than deleting vehicles, do you have a suggestion on an interim solution until ED solves the bug?

@BIGNEWYI swapped out the 18A and that got me to the mission running. Unfortunately, then started getting errors with vehicles (see logs above). So I removed the majority of vehicles and it ran for about 3 1/2 hours then crashed again. I am running it now after removing the last object that crashed it, so if it crashes I will post another log. Just to point out again, the crash happens on my standalone computer running as Mission, and on the dedicated server.

Well deleted nearly all AI vehicles and the mission ran for awhile and then crashed. @BIGNEWY@Flappie got any ideas what is going on behind the scenes? I am having to gut my mission that has been fully functional for months. Have you heard if any Nvidia drivers are causing issues? I did roll back one version just to see if that helped, but it didn't.

Seems to have caused a crash when an AI Striker fire a weapon. Deleted the three vehicles and trying again. Sure wish ED would just say what was changed that would cause these AI crashes. Seemed to work for awhile, then crash. See in the log on line 3527 a R-27ER was fired and immediately after got a crash. Seems to be a big rabbit hole trying to find the cause of AI and now weapons causing crashes. dcs.log

Well the 18A solved getting the mission to start at least, however, still crashing 15 minutes into the mission. Guess something else is bugged. dcs.log

So I think the take away here is that something did change in the last update causing the crash, as we have been using those aircraft for the past month at least without issue.

You the man Frosty!!!

Snowfox works fine with no crashes. The Caucasus mission we have been using for several weeks started crashing after the update. Snowfox is in the PG map, so maybe there is some issue with the Caucasus map since @Eagle7907 is having issues on that map.

Did that and still get a crash. Turned off Avast and also had the crash. Really strange, because this missions has worked fine for weeks without any issue then after this last update not so much. I guess I should have added that I found an old mission we had and Snowfox and they run just fine.

Deleted nearly 6000 files from the temp folder and tried the mission again to only get a crash. Thanks for the idea, but not a fix.

Thanks I removed all mods except SRS, LotATC, and Tacview and have attached the new log after repair and crash. FYI - crash occurs on standalone beta and server beta machines. dcs.log

Since the last update, I started getting crashes from a mission we have used for sometime now. One thing I noticed in the log was a new message along the lines of file was too big over 10M. So I removed some stuff (mainly sound files) and got the mission down to 7.6M. The size error is gone, but DCS still crashes. I turned on the expanded log writing (autoexec.cfg) as indicated in another thread and have attached the log and hope someone can point me to the issue. I did run a repair already as well. Thanks!dcs.log

I ended up deleting the Viacom Pro folder under VoiceAttack Apps and ran a repair. Then reinstalled the addons and it is working again. Really not sure what happened, but guessing something in my config got corrupted.

I am running it as Admin and do have Avast, but even turned that off and still the window is blank.

I am sure someone has a fix, thanks anyway!

I check and the keyboard is not disabled. When I do the CTRL-ALT-C, the VoiceAttack window says Opening Configuration Window and a all white window is created (you have to mouseover the icon in the task tray to see it), but then after 20 secs or so it disappears.

My apologies if I missed it posted, but since this last VoiceAttack update, the Configuration window won't display. Any steps suggested to get it working again would be most appreciated.