Pilot Archive

RE 3, Cert 5 - Novaldex Droid Interface Mark II - Currently listed as RE 2

btw, the Kuat Systems, lvl 8, 40K output reactor is real, it's been one of my two prides in the loot, and not RE'd yet. If you want to kick it out for being "unusual" or throwing off the numbers, I understand.

13pt verdana; COLOR: white; font-size-adjust: none; font-stretch: normal" color=white>Error Occurred While Processing Request 15pt verdana; COLOR: black; font-size-adjust: none; font-stretch: normal">Error Executing Database Query.Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY A.sortOrder' at line 6"The error occurred in D:\Inetpub\wwwroot\starcraft\component\sql_ComponentAttributeSelect.cfm: line 20
Called from D:\Inetpub\wwwroot\starcraft\component\dsp_View.cfm: line 19
Called from D:\Inetpub\wwwroot\starcraft\component\index.cfm: line 27
Called from D:\Inetpub\wwwroot\starcraft\index.cfm: line 43
Called from D:\Inetpub\wwwroot\starcraft\component\sql_ComponentAttributeSelect.cfm: line 20
Called from D:\Inetpub\wwwroot\starcraft\component\dsp_View.cfm: line 19
Called from D:\Inetpub\wwwroot\starcraft\component\index.cfm: line 27
Called from D:\Inetpub\wwwroot\starcraft\index.cfm: line 43

18 : 	INNER JOIN Attribute A ON CA.attributeID = A.AttributeID


19 : 	WHERE  CA.ComponentTypeAttributeID = CA.ComponentTypeAttributeID


20 : 	#PreserveSingleQuotes(variables.sFilter)#


21 : 	ORDER BY A.sortOrder


22 : 

---

SQLSELECT CA.attributeID, A.name as Attribute, A.sortOrder, A.Prefer FROM ComponentTypeAttribute CA INNER JOIN Attribute A ON CA.attributeID = A.AttributeID WHERE CA.ComponentTypeAttributeID = CA.ComponentTypeAttributeID AND CA.componentTypeID = ORDER BY A.sortOrderDATASOURCEstarcraftVENDORERRORCODE1064SQLSTATE42000Please 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.

BrowserMozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7Remote Address65.93.27.24Referrerhttp://www.spaceloot.com/index.cfm?method=component.save&componentTypeID=5Date/Time22-Oct-05 07:03 PMStack Traceat cfsql_ComponentAttributeSelect2ecfm195429727.runPage(D:\Inetpub\wwwroot\starcraft\component\sql_ComponentAttributeSelect.cfm:20) at cfdsp_View2ecfm1936298278.runPage(D:\Inetpub\wwwroot\starcraft\component\dsp_View.cfm:19) at cfindex2ecfm532486292.runPage(D:\Inetpub\wwwroot\starcraft\component\index.cfm:27) at cfindex2ecfm860438218.runPage(D:\Inetpub\wwwroot\starcraft\index.cfm:43) at cfsql_ComponentAttributeSelect2ecfm195429727.runPage(D:\Inetpub\wwwroot\starcraft\component\sql_ComponentAttributeSelect.cfm:20) at cfdsp_View2ecfm1936298278.runPage(D:\Inetpub\wwwroot\starcraft\component\dsp_View.cfm:19) at cfindex2ecfm532486292.runPage(D:\Inetpub\wwwroot\starcraft\component\index.cfm:27) at cfindex2ecfm860438218.runPage(D:\Inetpub\wwwroot\starcraft\index.cfm:43)

java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY A.sortOrder' at line 6"


	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)


	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)


	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)


	at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)


	at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)


	at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)


	at com.mysql.jdbc.Statement.execute(Statement.java:906)


	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)


	at coldfusion.sql.Executive.executeQuery(Executive.java:974)


	at coldfusion.sql.Executive.executeQuery(Executive.java:886)


	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229)


	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)


	at cfsql_ComponentAttributeSelect2ecfm195429727.runPage(D:\Inetpub\wwwroot\starcraft\component\sql_ComponentAttributeSelect.cfm:20)


	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 cfdsp_View2ecfm1936298278.runPage(D:\Inetpub\wwwroot\starcraft\component\dsp_View.cfm:19)


	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 cfindex2ecfm532486292.runPage(D:\Inetpub\wwwroot\starcraft\component\index.cfm:27)


	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 cfindex2ecfm860438218.runPage(D:\Inetpub\wwwroot\starcraft\index.cfm:43)


	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)

New Booster:
RE 9, Cert 9 - SubPro Mark IV "Acceletron" Boosters

New Shield:
RE 10, Cert 10 - Sienar Design Systems "Secret Ops" Shield Generation System

Message Edited by Seiryuu on 10-22-2005 07:50 PM

When trying to do a search for RE 10, Any Status, all components tried, I get an "Invalid RE choice" response.

---

Seiryuu wrote:
You had asked for suggestions and I just remembered the tool I would love -- a pre-RE comparison table. This allows us to enter the best numbers of the parts we have, then it gives rankings exactly like we see after entering a component (mins, maxes, standard deviation, rank, etc).

That way we could have a quick reference on where the "part" falls overall which would make deciding whether to wait or to engineer it easy.

---

This is a really good idea. I've made a note of it for future development.

---

Component Search Results

No components matched the search criteria.

And that is true for every item I've tried so far.

---

---

keiban wrote:

received the following error while entering items, I'll try again and see if it happens...

---

Love the new interface. Glad to see this is picking up quite a bit.

Finally getting around to adding my stuff as I am not too embarrased of my loadouts any longer. Haha.

Keep up the great work.