NSFL

Gross

Funny

WTF

Normal Porn

Freak Porn

User Challenges

Cute

Nature is Metal

Celebs

Art & Music

Politics

Fights

Muchoers Gone Wild

Meta

Awesome

Happy

Browser Games
Mucho User possumbasher
possumbasher
Noob
7 Rep

Member since October 4, 2018
Last seen

Comments by possumbasher

Page 2 Page 4
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT * FROM ( SELECT PC.ParentCommentText AS CommentText, PC.ParentCommentID as CommentID, PC.SubmissionID, PC.ParentCommentTimeStamp AS comment_timestamp, SP.SubmissionTitle, SP.PrettyURL FROM ParentComments AS PC INNER JOIN SubmissionsPublished AS SP ON SP.SubmissionID = PC.SubmissionID WHERE PC.UserID = 261 UNION ALL SELECT CC.ChildCommentText AS CommentText, CC.ChildCommentID as CommentID, CC.SubmissionID, CC.ChildCommentTimeStamp, SP.SubmissionTitle, SP.PrettyURL FROM ChildComments AS CC INNER JOIN SubmissionsPublished AS SP ON SP.SubmissionID = CC.SubmissionID WHERE CC.UserID = 261 ) T ORDER BY comment_timestamp DESC OFFSET 200 ROWS FETCH NEXT 100 ROWS ONLY
DatabaseName
stringMySQL
DatabaseVersion
string8.4.5
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-j-9.2.0 (Revision: a3909bfeb62d5a517ab444bb88ba7ecf26100297)
Datasource
stringMuchoZucko_old
DataSource
stringMuchoZucko_old
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OFFSET 200 ROWS FETCH NEXT 100 ROWS ONLY' at line 34
NativeErrorCode
number1064
queryError
stringSELECT * FROM ( SELECT PC.ParentCommentText AS CommentText, PC.ParentCommentID as CommentID, PC.SubmissionID, PC.ParentCommentTimeStamp AS comment_timestamp, SP.SubmissionTitle, SP.PrettyURL FROM ParentComments AS PC INNER JOIN SubmissionsPublished AS SP ON SP.SubmissionID = PC.SubmissionID WHERE PC.UserID = 261 UNION ALL SELECT CC.ChildCommentText AS CommentText, CC.ChildCommentID as CommentID, CC.SubmissionID, CC.ChildCommentTimeStamp, SP.SubmissionTitle, SP.PrettyURL FROM ChildComments AS CC INNER JOIN SubmissionsPublished AS SP ON SP.SubmissionID = CC.SubmissionID WHERE CC.UserID = 261 ) T ORDER BY comment_timestamp DESC OFFSET 200 ROWS FETCH NEXT 100 ROWS ONLY
Sql
stringSELECT * FROM ( SELECT PC.ParentCommentText AS CommentText, PC.ParentCommentID as CommentID, PC.SubmissionID, PC.ParentCommentTimeStamp AS comment_timestamp, SP.SubmissionTitle, SP.PrettyURL FROM ParentComments AS PC INNER JOIN SubmissionsPublished AS SP ON SP.SubmissionID = PC.SubmissionID WHERE PC.UserID = 261 UNION ALL SELECT CC.ChildCommentText AS CommentText, CC.ChildCommentID as CommentID, CC.SubmissionID, CC.ChildCommentTimeStamp, SP.SubmissionTitle, SP.PrettyURL FROM ChildComments AS CC INNER JOIN SubmissionsPublished AS SP ON SP.SubmissionID = CC.SubmissionID WHERE CC.UserID = 261 ) T ORDER BY comment_timestamp DESC OFFSET 200 ROWS FETCH NEXT 100 ROWS ONLY
SQLState
string42000
StackTrace
stringlucee.runtime.exp.DatabaseException: 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 'OFFSET 200 ROWS FETCH NEXT 100 ROWS ONLY' at line 34 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:837) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:685) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:293) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:239) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at usercomments_cfm$cf$27.call(/userComments.cfm:217) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at application_cfc$cf.udfCall(/Application.cfc:37) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string215: OFFSET&nbsp;#QueryOffset#&nbsp;ROWS<br> 216: FETCH&nbsp;NEXT&nbsp;100&nbsp;ROWS&nbsp;ONLY<br> <b>217: &lt;/cfquery&gt;</b><br> 218: <br> 219: &lt;/cfif&gt;<br>
codePrintPlain
string215: OFFSET #QueryOffset# ROWS 216: FETCH NEXT 100 ROWS ONLY 217: </cfquery> 218: 219: </cfif>
column
number0
id
string??
line
number217
Raw_Trace
stringusercomments_cfm$cf$27.call(/userComments.cfm:217)
template
stringZ:\MuchoZucko_Old\userComments.cfm
type
stringcfml
2
Struct
codePrintHTML
string35: <br> 36: &nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;onRequest(&nbsp;string&nbsp;targetPage&nbsp;)&nbsp;{<br> <b>37: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;arguments.targetPage;</b><br> 38: &nbsp;&nbsp;&nbsp;&nbsp;}<br> 39: <br>
codePrintPlain
string35: 36: function onRequest( string targetPage ) { 37: include arguments.targetPage; 38: } 39:
column
number0
id
string??
line
number37
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:37)
template
stringZ:\MuchoZucko_Old\Application.cfc
type
stringcfml
type
stringdatabase
where
string