{"issue":{"state":"open","pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"user":{"avatar_url":"https://secure.gravatar.com/avatar/1e56caef6884ed6025966a056da79af6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"1e56caef6884ed6025966a056da79af6","url":"https://api.github.com/users/frostino","login":"frostino","id":827389},"milestone":null,"assignee":null,"labels":[],"updated_at":"2011-11-02T00:23:15Z","comments":3,"closed_at":null,"url":"https://api.github.com/repos/blueriver/MuraCMS/issues/159","body":"This is a production site and I'm unable to get to the list of inactive users.\r\n\r\n\r\nCatch\r\nEntries:17\r\nadditional\t\r\nStruct\r\nDatabaseName\t\r\nstring\tMySQL\r\nDatabaseVersion\t\r\nstring\t5.0.92-community\r\nDatasource\t\r\nstring\tmurapro\r\nDriverName\t\r\nstring\tMySQL-AB JDBC Driver\r\nDriverVersion\t\r\nstring\tmysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )\r\nSQL\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\ncause\t\r\nStruct\r\nEntries:14\r\nadditional\t\r\nStruct\r\nDatabaseName\t\r\nstring\tMySQL\r\nDatabaseVersion\t\r\nstring\t5.0.92-community\r\nDatasource\t\r\nstring\tmurapro\r\nDriverName\t\r\nstring\tMySQL-AB JDBC Driver\r\nDriverVersion\t\r\nstring\tmysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )\r\nSQL\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nDataSource\t\r\nstring\tmurapro\r\nDetail\t\r\nstring\t\r\nErrorCode\t\r\nstring\t0\r\nExtendedInfo\t\r\nstring\t\r\nMessage\t\r\nstring\tYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and tusers.siteid = 'lakeside' and tusers.inactive= ' at line 7\r\nNativeErrorCode\t\r\nnumber\t1064\r\nqueryError\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nSql\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nSQLState\t\r\nstring\t42000\r\nStackTrace\t\r\nstring\tYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and tusers.siteid = 'lakeside' and tusers.inactive= ' at line 7 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934):2934 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616):1616 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708):1708 at com.mysql.jdbc.Connection.execSQL(Connection.java:3255):3255 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293):1293 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:867):867 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:237):237 at railo.runtime.tag.Query.executeDatasoure(Query.java:576):576 at railo.runtime.tag.Query.doEndTag(Query.java:430):430 at user.usergateway_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userGateway.cfc:313):313 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at user.usermanager_cfc$cf.udfCall3(/home/lakeside/public_html/requirements/mura/user/userManager.cfc:650):650 at user.usermanager_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userManager.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.view.vpublicusers.dsp_advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm:214):214 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:762):762 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:715):715 at admin.application_cfc$cf.udfCall(/home/lakeside/public_html/admin/Application.cfc:345):345 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.fw1.views.cpublicusers.advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm:48):48 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:762):762 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:715):715 at admin.framework_cfc$cf.udfCall5(/home/lakeside/public_html/admin/framework.cfc:915):915 at admin.framework_cfc$cf.udfCall(/home/lakeside/public_html/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.framework_cfc$cf.udfCall2(/home/lakeside/public_html/admin/framework.cfc:248):248 at admin.framework_cfc$cf.udfCall(/home/lakeside/public_html/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:347):347 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:174):174 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1991):1991 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1958):1958 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91):91 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103):103 at com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:376):376 at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:254):254 at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:164):164 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87):87 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187):187 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265):265 at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:436):436 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682):682 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743):743 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662):662 at java.lang.Thread.run(Thread.java:662):662\r\nTagContext\t\r\nArray\r\n1\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t311: lower(tusers.#params.getSortBy()#) #params.getSortDirection()#<br> 312: &lt;/cfif&gt;<br> <b>313: &lt;/cfif&gt;</b><br> 314: &lt;/cfquery&gt;<br> 315: <br>\r\ncodePrintPlain\t\r\nstring\t311: lower(tusers.#params.getSortBy()#) #params.getSortDirection()# 312: </cfif> 313: </cfif> 314: </cfquery> 315:\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t313\r\nraw_trace\t\r\nstring\tuser.usergateway_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userGateway.cfc:313)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/requirements/mura/user/userGateway.cfc\r\ntype\t\r\nstring\tcfml\r\n2\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t648: &lt;cfargument name=&quot;siteid&quot; type=&quot;any&quot; hint=&quot;deprecated, use userFeedBean.setSiteID()&quot; default=&quot;&quot;/&gt;<br> 649: &lt;cfargument name=&quot;isPublic&quot; type=&quot;any&quot; hint=&quot;deprecated, use userFeedBean.setIsPublic()&quot; default=&quot;&quot;/&gt;<br> <b>650: &lt;cfreturn variables.userGateway.getAdvancedSearch(arguments.data,arguments.siteid,arguments.isPublic) /&gt;</b><br> 651: &lt;/cffunction&gt;<br> 652: <br>\r\ncodePrintPlain\t\r\nstring\t648: <cfargument name=\"siteid\" type=\"any\" hint=\"deprecated, use userFeedBean.setSiteID()\" default=\"\"/> 649: <cfargument name=\"isPublic\" type=\"any\" hint=\"deprecated, use userFeedBean.setIsPublic()\" default=\"\"/> 650: <cfreturn variables.userGateway.getAdvancedSearch(arguments.data,arguments.siteid,arguments.isPublic) /> 651: </cffunction> 652:\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t650\r\nraw_trace\t\r\nstring\tuser.usermanager_cfc$cf.udfCall3(/home/lakeside/public_html/requirements/mura/user/userManager.cfc:650)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/requirements/mura/user/userManager.cfc\r\ntype\t\r\nstring\tcfml\r\n3\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t212: <br> 213: &lt;cfsilent&gt;<br> <b>214: &lt;cfset request.rslist=application.userManager.getAdvancedSearch(session,attributes.siteid,1) /&gt;</b><br> 215: &lt;cfif request.rslist.recordcount eq 1&gt;<br> 216: &lt;cflocation url=&quot;index.cfm?fuseaction=cPublicUsers.editUser&amp;userid=#request.rslist.userid#&amp;siteid=#URLEncodedFormat(attributes.siteid)#&quot; /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t212: 213: <cfsilent> 214: <cfset request.rslist=application.userManager.getAdvancedSearch(session,attributes.siteid,1) /> 215: <cfif request.rslist.recordcount eq 1> 216: <cflocation url=\"index.cfm?fuseaction=cPublicUsers.editUser&userid=#request.rslist.userid#&siteid=#URLEncodedFormat(attributes.siteid)#\" />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t214\r\nraw_trace\t\r\nstring\tadmin.view.vpublicusers.dsp_advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm:214)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm\r\ntype\t\r\nstring\tcfml\r\n4\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t343: &lt;/cfif&gt;<br> 344: <br> <b>345: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#arguments.path#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 346: <br> 347: &lt;cfreturn response /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t343: </cfif> 344: 345: <cfsavecontent variable='response'><cfinclude template=\"#arguments.path#\"/></cfsavecontent> 346: 347: <cfreturn response />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t345\r\nraw_trace\t\r\nstring\tadmin.application_cfc$cf.udfCall(/home/lakeside/public_html/admin/Application.cfc:345)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/Application.cfc\r\ntype\t\r\nstring\tcfml\r\n5\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t46: ---&gt;<br> 47: &lt;cfset rc.ajax=doFBInclude(&quot;/muraWRM/admin/view/vPublicUsers/ajax/dsp_javascript.cfm&quot;)&gt;<br> <b>48: &lt;cfset rc.layout=doFBInclude(&quot;/muraWRM/admin/view/vPublicUsers/dsp_advancedSearch.cfm&quot;)&gt;</b><br>\r\ncodePrintPlain\t\r\nstring\t46: ---> 47: <cfset rc.ajax=doFBInclude(\"/muraWRM/admin/view/vPublicUsers/ajax/dsp_javascript.cfm\")> 48: <cfset rc.layout=doFBInclude(\"/muraWRM/admin/view/vPublicUsers/dsp_advancedSearch.cfm\")>\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t48\r\nraw_trace\t\r\nstring\tadmin.fw1.views.cpublicusers.advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm:48)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm\r\ntype\t\r\nstring\tcfml\r\n6\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t913: &lt;/cfif&gt;<br> 914: <br> <b>915: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#pathInfo.base#views/#pathInfo.path#.cfm&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 916: <br> 917: &lt;cfreturn response /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t913: </cfif> 914: 915: <cfsavecontent variable='response'><cfinclude template=\"#pathInfo.base#views/#pathInfo.path#.cfm\"/></cfsavecontent> 916: 917: <cfreturn response />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t915\r\nraw_trace\t\r\nstring\tadmin.framework_cfc$cf.udfCall5(/home/lakeside/public_html/admin/framework.cfc:915)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/framework.cfc\r\ntype\t\r\nstring\tcfml\r\n7\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t246: viewNotFound();<br> 247: }<br> <b>248: out = view( request.view );</b><br> 249: for ( i = 1; i lte arrayLen(request.layouts); i = i + 1 ) {<br> 250: if ( structKeyExists(request, 'layout') and not request.layout ) {<br>\r\ncodePrintPlain\t\r\nstring\t246: viewNotFound(); 247: } 248: out = view( request.view ); 249: for ( i = 1; i lte arrayLen(request.layouts); i = i + 1 ) { 250: if ( structKeyExists(request, 'layout') and not request.layout ) {\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t248\r\nraw_trace\t\r\nstring\tadmin.framework_cfc$cf.udfCall2(/home/lakeside/public_html/admin/framework.cfc:248)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/framework.cfc\r\ntype\t\r\nstring\tcfml\r\ntype\t\r\nstring\tdatabase\r\nwhere\t\r\nstring\t\r\nDataSource\t\r\nstring\tmurapro\r\nDetail\t\r\nstring\t\r\nErrorCode\t\r\nstring\t0\r\nExtendedInfo\t\r\nstring\t\r\nMessage\t\r\nstring\tYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and tusers.siteid = 'lakeside' and tusers.inactive= ' at line 7\r\nname\t\r\nstring\tonRequest\r\nNativeErrorCode\t\r\nnumber\t1064\r\nqueryError\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nrootCause\t\r\nStruct\r\nEntries:14\r\nadditional\t\r\nStruct\r\nDatabaseName\t\r\nstring\tMySQL\r\nDatabaseVersion\t\r\nstring\t5.0.92-community\r\nDatasource\t\r\nstring\tmurapro\r\nDriverName\t\r\nstring\tMySQL-AB JDBC Driver\r\nDriverVersion\t\r\nstring\tmysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )\r\nSQL\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nDataSource\t\r\nstring\tmurapro\r\nDetail\t\r\nstring\t\r\nErrorCode\t\r\nstring\t0\r\nExtendedInfo\t\r\nstring\t\r\nMessage\t\r\nstring\tYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and tusers.siteid = 'lakeside' and tusers.inactive= ' at line 7\r\nNativeErrorCode\t\r\nnumber\t1064\r\nqueryError\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nSql\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nSQLState\t\r\nstring\t42000\r\nStackTrace\t\r\nstring\tYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and tusers.siteid = 'lakeside' and tusers.inactive= ' at line 7 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934):2934 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616):1616 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708):1708 at com.mysql.jdbc.Connection.execSQL(Connection.java:3255):3255 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293):1293 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:867):867 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:237):237 at railo.runtime.tag.Query.executeDatasoure(Query.java:576):576 at railo.runtime.tag.Query.doEndTag(Query.java:430):430 at user.usergateway_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userGateway.cfc:313):313 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at user.usermanager_cfc$cf.udfCall3(/home/lakeside/public_html/requirements/mura/user/userManager.cfc:650):650 at user.usermanager_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userManager.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.view.vpublicusers.dsp_advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm:214):214 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:762):762 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:715):715 at admin.application_cfc$cf.udfCall(/home/lakeside/public_html/admin/Application.cfc:345):345 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.fw1.views.cpublicusers.advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm:48):48 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:762):762 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:715):715 at admin.framework_cfc$cf.udfCall5(/home/lakeside/public_html/admin/framework.cfc:915):915 at admin.framework_cfc$cf.udfCall(/home/lakeside/public_html/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.framework_cfc$cf.udfCall2(/home/lakeside/public_html/admin/framework.cfc:248):248 at admin.framework_cfc$cf.udfCall(/home/lakeside/public_html/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:347):347 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:174):174 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1991):1991 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1958):1958 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91):91 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103):103 at com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:376):376 at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:254):254 at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:164):164 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87):87 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187):187 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265):265 at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:436):436 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682):682 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743):743 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662):662 at java.lang.Thread.run(Thread.java:662):662\r\nTagContext\t\r\nArray\r\n1\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t311: lower(tusers.#params.getSortBy()#) #params.getSortDirection()#<br> 312: &lt;/cfif&gt;<br> <b>313: &lt;/cfif&gt;</b><br> 314: &lt;/cfquery&gt;<br> 315: <br>\r\ncodePrintPlain\t\r\nstring\t311: lower(tusers.#params.getSortBy()#) #params.getSortDirection()# 312: </cfif> 313: </cfif> 314: </cfquery> 315:\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t313\r\nraw_trace\t\r\nstring\tuser.usergateway_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userGateway.cfc:313)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/requirements/mura/user/userGateway.cfc\r\ntype\t\r\nstring\tcfml\r\n2\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t648: &lt;cfargument name=&quot;siteid&quot; type=&quot;any&quot; hint=&quot;deprecated, use userFeedBean.setSiteID()&quot; default=&quot;&quot;/&gt;<br> 649: &lt;cfargument name=&quot;isPublic&quot; type=&quot;any&quot; hint=&quot;deprecated, use userFeedBean.setIsPublic()&quot; default=&quot;&quot;/&gt;<br> <b>650: &lt;cfreturn variables.userGateway.getAdvancedSearch(arguments.data,arguments.siteid,arguments.isPublic) /&gt;</b><br> 651: &lt;/cffunction&gt;<br> 652: <br>\r\ncodePrintPlain\t\r\nstring\t648: <cfargument name=\"siteid\" type=\"any\" hint=\"deprecated, use userFeedBean.setSiteID()\" default=\"\"/> 649: <cfargument name=\"isPublic\" type=\"any\" hint=\"deprecated, use userFeedBean.setIsPublic()\" default=\"\"/> 650: <cfreturn variables.userGateway.getAdvancedSearch(arguments.data,arguments.siteid,arguments.isPublic) /> 651: </cffunction> 652:\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t650\r\nraw_trace\t\r\nstring\tuser.usermanager_cfc$cf.udfCall3(/home/lakeside/public_html/requirements/mura/user/userManager.cfc:650)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/requirements/mura/user/userManager.cfc\r\ntype\t\r\nstring\tcfml\r\n3\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t212: <br> 213: &lt;cfsilent&gt;<br> <b>214: &lt;cfset request.rslist=application.userManager.getAdvancedSearch(session,attributes.siteid,1) /&gt;</b><br> 215: &lt;cfif request.rslist.recordcount eq 1&gt;<br> 216: &lt;cflocation url=&quot;index.cfm?fuseaction=cPublicUsers.editUser&amp;userid=#request.rslist.userid#&amp;siteid=#URLEncodedFormat(attributes.siteid)#&quot; /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t212: 213: <cfsilent> 214: <cfset request.rslist=application.userManager.getAdvancedSearch(session,attributes.siteid,1) /> 215: <cfif request.rslist.recordcount eq 1> 216: <cflocation url=\"index.cfm?fuseaction=cPublicUsers.editUser&userid=#request.rslist.userid#&siteid=#URLEncodedFormat(attributes.siteid)#\" />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t214\r\nraw_trace\t\r\nstring\tadmin.view.vpublicusers.dsp_advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm:214)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm\r\ntype\t\r\nstring\tcfml\r\n4\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t343: &lt;/cfif&gt;<br> 344: <br> <b>345: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#arguments.path#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 346: <br> 347: &lt;cfreturn response /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t343: </cfif> 344: 345: <cfsavecontent variable='response'><cfinclude template=\"#arguments.path#\"/></cfsavecontent> 346: 347: <cfreturn response />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t345\r\nraw_trace\t\r\nstring\tadmin.application_cfc$cf.udfCall(/home/lakeside/public_html/admin/Application.cfc:345)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/Application.cfc\r\ntype\t\r\nstring\tcfml\r\n5\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t46: ---&gt;<br> 47: &lt;cfset rc.ajax=doFBInclude(&quot;/muraWRM/admin/view/vPublicUsers/ajax/dsp_javascript.cfm&quot;)&gt;<br> <b>48: &lt;cfset rc.layout=doFBInclude(&quot;/muraWRM/admin/view/vPublicUsers/dsp_advancedSearch.cfm&quot;)&gt;</b><br>\r\ncodePrintPlain\t\r\nstring\t46: ---> 47: <cfset rc.ajax=doFBInclude(\"/muraWRM/admin/view/vPublicUsers/ajax/dsp_javascript.cfm\")> 48: <cfset rc.layout=doFBInclude(\"/muraWRM/admin/view/vPublicUsers/dsp_advancedSearch.cfm\")>\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t48\r\nraw_trace\t\r\nstring\tadmin.fw1.views.cpublicusers.advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm:48)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm\r\ntype\t\r\nstring\tcfml\r\n6\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t913: &lt;/cfif&gt;<br> 914: <br> <b>915: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#pathInfo.base#views/#pathInfo.path#.cfm&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 916: <br> 917: &lt;cfreturn response /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t913: </cfif> 914: 915: <cfsavecontent variable='response'><cfinclude template=\"#pathInfo.base#views/#pathInfo.path#.cfm\"/></cfsavecontent> 916: 917: <cfreturn response />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t915\r\nraw_trace\t\r\nstring\tadmin.framework_cfc$cf.udfCall5(/home/lakeside/public_html/admin/framework.cfc:915)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/framework.cfc\r\ntype\t\r\nstring\tcfml\r\n7\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t246: viewNotFound();<br> 247: }<br> <b>248: out = view( request.view );</b><br> 249: for ( i = 1; i lte arrayLen(request.layouts); i = i + 1 ) {<br> 250: if ( structKeyExists(request, 'layout') and not request.layout ) {<br>\r\ncodePrintPlain\t\r\nstring\t246: viewNotFound(); 247: } 248: out = view( request.view ); 249: for ( i = 1; i lte arrayLen(request.layouts); i = i + 1 ) { 250: if ( structKeyExists(request, 'layout') and not request.layout ) {\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t248\r\nraw_trace\t\r\nstring\tadmin.framework_cfc$cf.udfCall2(/home/lakeside/public_html/admin/framework.cfc:248)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/framework.cfc\r\ntype\t\r\nstring\tcfml\r\ntype\t\r\nstring\tdatabase\r\nwhere\t\r\nstring\t\r\nSql\t\r\nstring\t Select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName, tusers.Password, tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.Ext, tusers.ContactForm, tusers.Admin, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt from tusers left join tfiles on tusers.photofileID=tfiles.fileID where tusers.type=2 and tusers.isPublic = and tusers.siteid = 'lakeside' and tusers.inactive= order by tusers.lname asc\r\nSQLState\t\r\nstring\t42000\r\nStackTrace\t\r\nstring\tYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and tusers.siteid = 'lakeside' and tusers.inactive= ' at line 7 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934):2934 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616):1616 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708):1708 at com.mysql.jdbc.Connection.execSQL(Connection.java:3255):3255 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293):1293 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:867):867 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:237):237 at railo.runtime.tag.Query.executeDatasoure(Query.java:576):576 at railo.runtime.tag.Query.doEndTag(Query.java:430):430 at user.usergateway_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userGateway.cfc:313):313 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at user.usermanager_cfc$cf.udfCall3(/home/lakeside/public_html/requirements/mura/user/userManager.cfc:650):650 at user.usermanager_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userManager.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.view.vpublicusers.dsp_advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm:214):214 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:762):762 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:715):715 at admin.application_cfc$cf.udfCall(/home/lakeside/public_html/admin/Application.cfc:345):345 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.fw1.views.cpublicusers.advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm:48):48 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:762):762 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:715):715 at admin.framework_cfc$cf.udfCall5(/home/lakeside/public_html/admin/framework.cfc:915):915 at admin.framework_cfc$cf.udfCall(/home/lakeside/public_html/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at admin.framework_cfc$cf.udfCall2(/home/lakeside/public_html/admin/framework.cfc:248):248 at admin.framework_cfc$cf.udfCall(/home/lakeside/public_html/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:347):347 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:174):174 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1991):1991 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1958):1958 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91):91 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103):103 at com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:376):376 at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:254):254 at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:164):164 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87):87 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187):187 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265):265 at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:436):436 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682):682 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743):743 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662):662 at java.lang.Thread.run(Thread.java:662):662\r\nTagContext\t\r\nArray\r\n1\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t311: lower(tusers.#params.getSortBy()#) #params.getSortDirection()#<br> 312: &lt;/cfif&gt;<br> <b>313: &lt;/cfif&gt;</b><br> 314: &lt;/cfquery&gt;<br> 315: <br>\r\ncodePrintPlain\t\r\nstring\t311: lower(tusers.#params.getSortBy()#) #params.getSortDirection()# 312: </cfif> 313: </cfif> 314: </cfquery> 315:\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t313\r\nraw_trace\t\r\nstring\tuser.usergateway_cfc$cf.udfCall(/home/lakeside/public_html/requirements/mura/user/userGateway.cfc:313)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/requirements/mura/user/userGateway.cfc\r\ntype\t\r\nstring\tcfml\r\n2\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t648: &lt;cfargument name=&quot;siteid&quot; type=&quot;any&quot; hint=&quot;deprecated, use userFeedBean.setSiteID()&quot; default=&quot;&quot;/&gt;<br> 649: &lt;cfargument name=&quot;isPublic&quot; type=&quot;any&quot; hint=&quot;deprecated, use userFeedBean.setIsPublic()&quot; default=&quot;&quot;/&gt;<br> <b>650: &lt;cfreturn variables.userGateway.getAdvancedSearch(arguments.data,arguments.siteid,arguments.isPublic) /&gt;</b><br> 651: &lt;/cffunction&gt;<br> 652: <br>\r\ncodePrintPlain\t\r\nstring\t648: <cfargument name=\"siteid\" type=\"any\" hint=\"deprecated, use userFeedBean.setSiteID()\" default=\"\"/> 649: <cfargument name=\"isPublic\" type=\"any\" hint=\"deprecated, use userFeedBean.setIsPublic()\" default=\"\"/> 650: <cfreturn variables.userGateway.getAdvancedSearch(arguments.data,arguments.siteid,arguments.isPublic) /> 651: </cffunction> 652:\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t650\r\nraw_trace\t\r\nstring\tuser.usermanager_cfc$cf.udfCall3(/home/lakeside/public_html/requirements/mura/user/userManager.cfc:650)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/requirements/mura/user/userManager.cfc\r\ntype\t\r\nstring\tcfml\r\n3\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t212: <br> 213: &lt;cfsilent&gt;<br> <b>214: &lt;cfset request.rslist=application.userManager.getAdvancedSearch(session,attributes.siteid,1) /&gt;</b><br> 215: &lt;cfif request.rslist.recordcount eq 1&gt;<br> 216: &lt;cflocation url=&quot;index.cfm?fuseaction=cPublicUsers.editUser&amp;userid=#request.rslist.userid#&amp;siteid=#URLEncodedFormat(attributes.siteid)#&quot; /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t212: 213: <cfsilent> 214: <cfset request.rslist=application.userManager.getAdvancedSearch(session,attributes.siteid,1) /> 215: <cfif request.rslist.recordcount eq 1> 216: <cflocation url=\"index.cfm?fuseaction=cPublicUsers.editUser&userid=#request.rslist.userid#&siteid=#URLEncodedFormat(attributes.siteid)#\" />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t214\r\nraw_trace\t\r\nstring\tadmin.view.vpublicusers.dsp_advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm:214)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/view/vPublicUsers/dsp_advancedSearch.cfm\r\ntype\t\r\nstring\tcfml\r\n4\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t343: &lt;/cfif&gt;<br> 344: <br> <b>345: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#arguments.path#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 346: <br> 347: &lt;cfreturn response /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t343: </cfif> 344: 345: <cfsavecontent variable='response'><cfinclude template=\"#arguments.path#\"/></cfsavecontent> 346: 347: <cfreturn response />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t345\r\nraw_trace\t\r\nstring\tadmin.application_cfc$cf.udfCall(/home/lakeside/public_html/admin/Application.cfc:345)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/Application.cfc\r\ntype\t\r\nstring\tcfml\r\n5\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t46: ---&gt;<br> 47: &lt;cfset rc.ajax=doFBInclude(&quot;/muraWRM/admin/view/vPublicUsers/ajax/dsp_javascript.cfm&quot;)&gt;<br> <b>48: &lt;cfset rc.layout=doFBInclude(&quot;/muraWRM/admin/view/vPublicUsers/dsp_advancedSearch.cfm&quot;)&gt;</b><br>\r\ncodePrintPlain\t\r\nstring\t46: ---> 47: <cfset rc.ajax=doFBInclude(\"/muraWRM/admin/view/vPublicUsers/ajax/dsp_javascript.cfm\")> 48: <cfset rc.layout=doFBInclude(\"/muraWRM/admin/view/vPublicUsers/dsp_advancedSearch.cfm\")>\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t48\r\nraw_trace\t\r\nstring\tadmin.fw1.views.cpublicusers.advancedsearch_cfm$cf.call(/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm:48)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/fw1/views/cpublicusers/advancedsearch.cfm\r\ntype\t\r\nstring\tcfml\r\n6\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t913: &lt;/cfif&gt;<br> 914: <br> <b>915: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#pathInfo.base#views/#pathInfo.path#.cfm&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 916: <br> 917: &lt;cfreturn response /&gt;<br>\r\ncodePrintPlain\t\r\nstring\t913: </cfif> 914: 915: <cfsavecontent variable='response'><cfinclude template=\"#pathInfo.base#views/#pathInfo.path#.cfm\"/></cfsavecontent> 916: 917: <cfreturn response />\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t915\r\nraw_trace\t\r\nstring\tadmin.framework_cfc$cf.udfCall5(/home/lakeside/public_html/admin/framework.cfc:915)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/framework.cfc\r\ntype\t\r\nstring\tcfml\r\n7\t\r\nStruct\r\ncodePrintHTML\t\r\nstring\t246: viewNotFound();<br> 247: }<br> <b>248: out = view( request.view );</b><br> 249: for ( i = 1; i lte arrayLen(request.layouts); i = i + 1 ) {<br> 250: if ( structKeyExists(request, 'layout') and not request.layout ) {<br>\r\ncodePrintPlain\t\r\nstring\t246: viewNotFound(); 247: } 248: out = view( request.view ); 249: for ( i = 1; i lte arrayLen(request.layouts); i = i + 1 ) { 250: if ( structKeyExists(request, 'layout') and not request.layout ) {\r\ncolumn\t\r\nnumber\t0\r\nid\t\r\nstring\t??\r\nline\t\r\nnumber\t248\r\nraw_trace\t\r\nstring\tadmin.framework_cfc$cf.udfCall2(/home/lakeside/public_html/admin/framework.cfc:248)\r\ntemplate\t\r\nstring\t/home/lakeside/public_html/admin/framework.cfc\r\ntype\t\r\nstring\tcfml\r\ntype\t\r\nstring\tdatabase\r\nwhere\t\r\nstring\t","html_url":"https://github.com/blueriver/MuraCMS/issues/159","number":159,"title":"Error when using Advanced Search in Site Members to show all inactive accounts (5.5.4468)","id":2116568,"created_at":"2011-11-01T23:41:41Z"},"action":"created","comment":{"user":{"avatar_url":"https://secure.gravatar.com/avatar/1e56caef6884ed6025966a056da79af6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"1e56caef6884ed6025966a056da79af6","url":"https://api.github.com/users/frostino","login":"frostino","id":827389},"updated_at":"2011-11-02T00:23:14Z","url":"https://api.github.com/repos/blueriver/MuraCMS/issues/comments/2598126","body":"That appears to have fixed it.  Thanks, Matt!","id":2598126,"created_at":"2011-11-02T00:23:14Z"}}