[Hockey][Mr.Sports]
[Football][Basketball][Baseball]
[Teams4Sale]
[Super Trn.]
[Hall of Fame]
[Rankings]
[Records]
[Teams]
[Players]
[Owners]
[Leagues]
[Help]
    
[ Baseball: Mr. Sports ]

Draft AnalysisWho's HotWho's NotLeaders Yearly StatsTop Performers
Pitching Probables Player Rankings Trends Injury Report MLB Rosters Search/Stats
Players of the Week QualifiersGames PlayedBest WeeksBest StreaksGames Per Week

Mr Sports Not-so-Hot Players
Week 01, 2018 thru Week 01, 2018

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered.
 
The error occurred in C:/Websites/baseball.mrsports.com/natl/plnot.cfm: line 95
Called from C:/Websites/baseball.mrsports.com/natl/plnot.cfm: line 1
Called from C:/Websites/baseball.mrsports.com/natl/plnot.cfm: line 95
Called from C:/Websites/baseball.mrsports.com/natl/plnot.cfm: line 1
93 :         GROUP BY feeds.player,players.earned
94 :          HAVING SUM(CONVERT(REAL,SUBSTRING(feeds.points,1,4))) >= #range2#
95 :           ORDER BY #sortby#
96 : </CFQUERY>
97 : <CFELSE>

SQLSTATE   22012
DATASOURCE   baseball
VENDORERRORCODE   8134
SQL    SELECT feeds.player,players.earned, pts=AVG(CONVERT(REAL,SUBSTRING(feeds.points,5,4))), totpts=SUM(CONVERT(REAL,SUBSTRING(feeds.points,5,4))), games=SUM(CONVERT(REAL,SUBSTRING(feeds.points,1,4))), ppg=(SUM(CONVERT(REAL,SUBSTRING(feeds.points,5,4))) / SUM(CONVERT(REAL,SUBSTRING(feeds.points,1,4)))) FROM feeds,players WHERE feeds.player = players.player and feeds.period BETWEEN '201801' AND '201801' GROUP BY feeds.player,players.earned HAVING SUM(CONVERT(REAL,SUBSTRING(feeds.points,1,4))) >= 0 ORDER BY pts ASC
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.198.15.20
Referrer  
Date/Time   18-Oct-18 01:30 PM
Stack Trace
at cfplnot2ecfm110408921._factor3(C:/Websites/baseball.mrsports.com/natl/plnot.cfm:95) at cfplnot2ecfm110408921.runPage(C:/Websites/baseball.mrsports.com/natl/plnot.cfm:1) at cfplnot2ecfm110408921._factor3(C:/Websites/baseball.mrsports.com/natl/plnot.cfm:95) at cfplnot2ecfm110408921.runPage(C:/Websites/baseball.mrsports.com/natl/plnot.cfm:1)

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.e(Unknown Source)
	at macromedia.jdbc.sqlserver.dda_.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddd.j(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddea.next(Unknown Source)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:356)
	at coldfusion.sql.Executive.getRowSet(Executive.java:613)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1470)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfplnot2ecfm110408921._factor3(C:\Websites\baseball.mrsports.com\natl\plnot.cfm:95)
	at cfplnot2ecfm110408921.runPage(C:\Websites\baseball.mrsports.com\natl\plnot.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.seefusion.Filter.doFilter(Filter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)