Pilot Archive

Might want to have some way to handle those components where cert level != re level. I've got a cert level 5 cap with an re level of 10. It's certainly going to skew mass numbers, as it's 47.9k

There is a div by zero bug in the submission code, exposed by the aforementioned capacitor. Sorry about the length of this. I don't think anything but the first part will be of use, but I don't know anything about ColdFusion. The dump was too big for a PM too

Division by zero.
Division by zero is not allowed.
 
The error occurred in C:\work\lib\StdDevPop.cfm: line 50
Called from C:\work\component\mod_UpdateSummaryTables.cfm: line 38
Called from C:\work\component\mod_Save.cfm: line 48
Called from C:\work\component\index.cfm: line 39
Called from C:\work\index.cfm: line 41

48 :     SumxBar = SumxBar + ((MyArray[i] - xBar)*(MyArray[i] - xBar));
49 :     }
50 :   Return Sqr(SumxBar/NumValues);
51 : }
52 : 

 Please try the following:

    * Check the ColdFusion documentation to verify that you are using the correct syntax.
    * Search the Knowledge Base to find a solution to your problem.

Browser   	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.10) Gecko/20050716 Firefox/1.0.6
Remote Address   	66.92.72.222
Referrer   	http://spaceloot.com/index.cfm?method=component.save&componentTypeID=7
Date/Time   	13-Aug-05 06:25 PM
Stack Trace
at cfStdDevPop2ecfm1054827919$funcSTDDEVPOP.runFunction(C:\work\lib\StdDevPop.cfm:50) 
at cfmod_UpdateSummaryTables2ecfm460054253.runPage(C:\work\component\mod_UpdateSummaryTables.cfm:38) 
at cfmod_Save2ecfm381422325.runPage(C:\work\component\mod_Save.cfm:48) 
at cfindex2ecfm443615864.runPage(C:\work\component\index.cfm:39) 
at cfindex2ecfm1131503897.runPage(C:\work\index.cfm:41)

coldfusion.runtime.DivideByZeroException: Division by zero.
	at coldfusion.runtime.CfJspPage._div(CfJspPage.java:2034)
	at cfStdDevPop2ecfm1054827919$funcSTDDEVPOP.runFunction(C:\work\lib\StdDevPop.cfm:50)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:250)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:165)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1768)
	at cfmod_UpdateSummaryTables2ecfm460054253.runPage(C:\work\component\mod_UpdateSummaryTables.cfm:38)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
	at cfmod_Save2ecfm381422325.runPage(C:\work\component\mod_Save.cfm:48)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
	at cfindex2ecfm443615864.runPage(C:\work\component\index.cfm:39)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
	at cfindex2ecfm1131503897.runPage(C:\work\index.cfm:41)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:105)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Rather than fix the divide-by-zero bug, I've turned off submissions of mixed RE/Cert level classes for the time being. Since they're not being included in the aggregate data and they blow up the individual component view, there's not much use for them in the system right now. I deactivated all the existing components from those classes (less than 10 components). The DB0 was coming up in the detail view when the system attempted to compare the submitted component against the level and class population data - since there is none, it puked.

I added a link that will enable users to delete their own components. It's on the component detail view.

Message Edited by Raja_Asenn on 08-13-2005 07:13 PM

- fixed a bug that was blowing up the component view under some circumstances

- converted the optimal (min or max, as appropriate to the attribute) value for a given level/attribute to a link that brings up a view of the individual component that has that attribute

Missing: L7 Weapon Class: Rendili FG1-A Blaster

Since shields are evened front and back when you enter space, and they evidently do not reset when you remove them from the ship, if the numbers are not averaged, they will throw off the aggregate badly. How are those unbalanced shields handled in the database, how are they handled in reverse engineering? Should we take one shield to space and adjust shields to the front (adjust front shields 4 perhaps) and take the part off. Then do the same thing with the rear shields? Will this give you uber-RE'd shields?

Level 7 shields are way out of whack in more than one category. Someone has entered in some very screwy numbers.

And one of the engine or capacitor levels had a skewed aggregate in one category. I forgot to note which one.

Need three new categories.

used items (armor and hp don't go into aggregate)
RE'd items (separate aggregate?)
crafted items (separate aggregate as well.)

And a new item class:
chassis

Then you can use all this to create a ship calculator.

Two level 6 reactors not in the mix
(unknown) proton chamber, 6, 485.9, 13196.5, 12350.8
(unknown) multi-core, 6, 473.6, 13563.3, 11193.8