Unknown column 'draft.changesetID' in 'field list'

Posted At : October 21, 2011 3:31 PM | Posted By : ColdFusion Joe
Related Categories: Railo, Stuff That Didn't Work, Ubuntu, Mura, Errors, MySQL

Mura, unsuccessfully trying to do a Multi-Site Version Update with Core Version 5.4.4602 and Site Version 5.4.4602 just after updating the core files from Core Version 5.3.3088 and Site Version 5.3.3675.

Cannot reload application. It results in the following error: Unknown column 'draft.changesetID' in 'field list'

Also, cannot edit pages in the Site Manager, they will not open.

Mura on Ubuntu, Railo and MySQL.

Error:

Struct 
Entries:17
additional
Struct
DatabaseName
string MySQL
 
DatabaseVersion
string 5.1.41-3ubuntu12.10
 
Datasource
string mysite
 
DriverName
string MySQL-AB JDBC Driver
 
DriverVersion
string mysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )
 
SQL
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
 
cause
Struct 
Entries:14
additional
Struct
DatabaseName
string MySQL
 
DatabaseVersion
string 5.1.41-3ubuntu12.10
 
Datasource
string mysite
 
DriverName
string MySQL-AB JDBC Driver
 
DriverVersion
string mysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )
 
SQL
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
 
DataSource
string mysite
 
Detail
string  
 
ErrorCode
string 0
 
ExtendedInfo
string  
 
Message
string Unknown column 'draft.changesetID' in 'field list'
 
NativeErrorCode
number 1054
 
queryError
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
Sql
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
SQLState
string 42S22
 
StackTrace
string Unknown column 'draft.changesetID' in 'field list' 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:232):232 at railo.runtime.tag.Query.executeDatasoure(Query.java:580):580 at railo.runtime.tag.Query.doEndTag(Query.java:434):434 at content.contentgateway_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc:799):799 at content.contentgateway_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at dashboard.dashboardmanager_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc:222):222 at dashboard.dashboardmanager_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.view.vdashboard.dsp_main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm:188):188 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:764):764 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:717):717 at admin.application_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc:293):293 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.fw1.views.cdashboard.main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm:2):2 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:764):764 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:717):717 at admin.framework_cfc$cf.udfCall5(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:915):915 at admin.framework_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.framework_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:248):248 at admin.framework_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:376):376 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:200):200 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1973):1973 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:280):280 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717):717 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290):290 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176):176 at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145):145 at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92):92 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381):381 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235):235 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233):233 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191):191 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127):127 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109):109 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298):298 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857):857 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588):588 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489):489 at java.lang.Thread.run(Unknown Source):-1
 
TagContext
Array
1
Struct
codePrintHTML
string 797: draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate,<br> 798: draft.lastUpdateBy,tfiles.fileExt, draft.changesetID<br> <b>799: HAVING module.SiteID='#arguments.siteid#' AND draft.SiteID=&lt;cfqueryparam cfsqltype=&quot;cf_sql_varchar&quot; value=&quot;#arguments.siteID#&quot;/&gt;</b><br> 800: &lt;/cfquery&gt;<br> 801: <br>
 
codePrintPlain
string 797: draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, 798: draft.lastUpdateBy,tfiles.fileExt, draft.changesetID 799: HAVING module.SiteID='#arguments.siteid#' AND draft.SiteID=<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.siteID#"/> 800: </cfquery> 801:
 
column
number 0
 
id
string ??
 
line
number 799
 
raw_trace
string content.contentgateway_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc:799)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc
 
type
string cfml
 
 
2
Struct
codePrintHTML
string 220: &lt;cfargument name=&quot;sortDirection&quot; type=&quot;string&quot; required=&quot;true&quot; default=&quot;desc&quot;&gt;<br> 221: <br> <b>222: &lt;cfreturn variables.contentGateway.getDraftList(arguments.siteID,arguments.userID,arguments.limit,arguments.startDate,arguments.stopDate,arguments.sortBy,arguments.sortDirection) /&gt;</b><br> 223: &lt;/cffunction&gt;<br> 224: <br>
 
codePrintPlain
string 220: <cfargument name="sortDirection" type="string" required="true" default="desc"> 221: 222: <cfreturn variables.contentGateway.getDraftList(arguments.siteID,arguments.userID,arguments.limit,arguments.startDate,arguments.stopDate,arguments.sortBy,arguments.sortDirection) /> 223: </cffunction> 224:
 
column
number 0
 
id
string ??
 
line
number 222
 
raw_trace
string dashboard.dashboardmanager_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc:222)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc
 
type
string cfml
 
 
3
Struct
codePrintHTML
string 186: &lt;/div&gt;<br> 187: <br> <b>188: &lt;cfset rsList=application.dashboardManager.getDraftList(attributes.siteID,session.mura.userID,5) /&gt;</b><br> 189: &lt;div id=&quot;drafts&quot; class=&quot;divide&quot;&gt;<br> 190: &lt;h3&gt;#application.rbFactory.getKeyValue(session.rb,&quot;dashboard.draftsforreview&quot;)#&lt;/h3&gt;<br>
 
codePrintPlain
string 186: </div> 187: 188: <cfset rsList=application.dashboardManager.getDraftList(attributes.siteID,session.mura.userID,5) /> 189: <div id="drafts" class="divide"> 190: <h3>#application.rbFactory.getKeyValue(session.rb,"dashboard.draftsforreview")#</h3>
 
column
number 0
 
id
string ??
 
line
number 188
 
raw_trace
string admin.view.vdashboard.dsp_main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm:188)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm
 
type
string cfml
 
 
4
Struct
codePrintHTML
string 291: &lt;/cfif&gt;<br> 292: <br> <b>293: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#arguments.path#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 294: <br> 295: &lt;cfreturn response /&gt;<br>
 
codePrintPlain
string 291: </cfif> 292: 293: <cfsavecontent variable='response'><cfinclude template="#arguments.path#"/></cfsavecontent> 294: 295: <cfreturn response />
 
column
number 0
 
id
string ??
 
line
number 293
 
raw_trace
string admin.application_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc:293)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc
 
type
string cfml
 
 
5
Struct
codePrintHTML
string 1: &lt;cfset rc.ajax=doFBInclude(&quot;/muraWRM/admin/view/vDashboard/ajax/dsp_javascript.cfm&quot;)&gt;<br> <b>2: &lt;cfset rc.layout=doFBInclude(&quot;/muraWRM/admin/view/vDashboard/dsp_main.cfm&quot;)&gt;</b><br>
 
codePrintPlain
string 1: <cfset rc.ajax=doFBInclude("/muraWRM/admin/view/vDashboard/ajax/dsp_javascript.cfm")> 2: <cfset rc.layout=doFBInclude("/muraWRM/admin/view/vDashboard/dsp_main.cfm")>
 
column
number 0
 
id
string ??
 
line
number 2
 
raw_trace
string admin.fw1.views.cdashboard.main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm:2)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm
 
type
string cfml
 
 
6
Struct
codePrintHTML
string 913: &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>
 
codePrintPlain
string 913: </cfif> 914: 915: <cfsavecontent variable='response'><cfinclude template="#pathInfo.base#views/#pathInfo.path#.cfm"/></cfsavecontent> 916: 917: <cfreturn response />
 
column
number 0
 
id
string ??
 
line
number 915
 
raw_trace
string admin.framework_cfc$cf.udfCall5(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:915)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc
 
type
string cfml
 
 
7
Struct
codePrintHTML
string 246: 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>
 
codePrintPlain
string 246: 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 ) {
 
column
number 0
 
id
string ??
 
line
number 248
 
raw_trace
string admin.framework_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:248)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc
 
type
string cfml
 
 
 
type
string database
 
where
string  
 
 
DataSource
string mysite
 
Detail
string  
 
ErrorCode
string 0
 
ExtendedInfo
string  
 
Message
string Unknown column 'draft.changesetID' in 'field list'
 
name
string onRequest
 
NativeErrorCode
number 1054
 
queryError
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
rootCause
Struct 
Entries:14
additional
Struct
DatabaseName
string MySQL
 
DatabaseVersion
string 5.1.41-3ubuntu12.10
 
Datasource
string mysite
 
DriverName
string MySQL-AB JDBC Driver
 
DriverVersion
string mysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )
 
SQL
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
 
DataSource
string mysite
 
Detail
string  
 
ErrorCode
string 0
 
ExtendedInfo
string  
 
Message
string Unknown column 'draft.changesetID' in 'field list'
 
NativeErrorCode
number 1054
 
queryError
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
Sql
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
SQLState
string 42S22
 
StackTrace
string Unknown column 'draft.changesetID' in 'field list' 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:232):232 at railo.runtime.tag.Query.executeDatasoure(Query.java:580):580 at railo.runtime.tag.Query.doEndTag(Query.java:434):434 at content.contentgateway_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc:799):799 at content.contentgateway_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at dashboard.dashboardmanager_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc:222):222 at dashboard.dashboardmanager_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.view.vdashboard.dsp_main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm:188):188 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:764):764 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:717):717 at admin.application_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc:293):293 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.fw1.views.cdashboard.main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm:2):2 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:764):764 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:717):717 at admin.framework_cfc$cf.udfCall5(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:915):915 at admin.framework_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.framework_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:248):248 at admin.framework_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:376):376 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:200):200 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1973):1973 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:280):280 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717):717 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290):290 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176):176 at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145):145 at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92):92 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381):381 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235):235 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233):233 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191):191 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127):127 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109):109 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298):298 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857):857 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588):588 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489):489 at java.lang.Thread.run(Unknown Source):-1
 
TagContext
Array
1
Struct
codePrintHTML
string 797: draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate,<br> 798: draft.lastUpdateBy,tfiles.fileExt, draft.changesetID<br> <b>799: HAVING module.SiteID='#arguments.siteid#' AND draft.SiteID=&lt;cfqueryparam cfsqltype=&quot;cf_sql_varchar&quot; value=&quot;#arguments.siteID#&quot;/&gt;</b><br> 800: &lt;/cfquery&gt;<br> 801: <br>
 
codePrintPlain
string 797: draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, 798: draft.lastUpdateBy,tfiles.fileExt, draft.changesetID 799: HAVING module.SiteID='#arguments.siteid#' AND draft.SiteID=<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.siteID#"/> 800: </cfquery> 801:
 
column
number 0
 
id
string ??
 
line
number 799
 
raw_trace
string content.contentgateway_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc:799)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc
 
type
string cfml
 
 
2
Struct
codePrintHTML
string 220: &lt;cfargument name=&quot;sortDirection&quot; type=&quot;string&quot; required=&quot;true&quot; default=&quot;desc&quot;&gt;<br> 221: <br> <b>222: &lt;cfreturn variables.contentGateway.getDraftList(arguments.siteID,arguments.userID,arguments.limit,arguments.startDate,arguments.stopDate,arguments.sortBy,arguments.sortDirection) /&gt;</b><br> 223: &lt;/cffunction&gt;<br> 224: <br>
 
codePrintPlain
string 220: <cfargument name="sortDirection" type="string" required="true" default="desc"> 221: 222: <cfreturn variables.contentGateway.getDraftList(arguments.siteID,arguments.userID,arguments.limit,arguments.startDate,arguments.stopDate,arguments.sortBy,arguments.sortDirection) /> 223: </cffunction> 224:
 
column
number 0
 
id
string ??
 
line
number 222
 
raw_trace
string dashboard.dashboardmanager_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc:222)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc
 
type
string cfml
 
 
3
Struct
codePrintHTML
string 186: &lt;/div&gt;<br> 187: <br> <b>188: &lt;cfset rsList=application.dashboardManager.getDraftList(attributes.siteID,session.mura.userID,5) /&gt;</b><br> 189: &lt;div id=&quot;drafts&quot; class=&quot;divide&quot;&gt;<br> 190: &lt;h3&gt;#application.rbFactory.getKeyValue(session.rb,&quot;dashboard.draftsforreview&quot;)#&lt;/h3&gt;<br>
 
codePrintPlain
string 186: </div> 187: 188: <cfset rsList=application.dashboardManager.getDraftList(attributes.siteID,session.mura.userID,5) /> 189: <div id="drafts" class="divide"> 190: <h3>#application.rbFactory.getKeyValue(session.rb,"dashboard.draftsforreview")#</h3>
 
column
number 0
 
id
string ??
 
line
number 188
 
raw_trace
string admin.view.vdashboard.dsp_main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm:188)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm
 
type
string cfml
 
 
4
Struct
codePrintHTML
string 291: &lt;/cfif&gt;<br> 292: <br> <b>293: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#arguments.path#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 294: <br> 295: &lt;cfreturn response /&gt;<br>
 
codePrintPlain
string 291: </cfif> 292: 293: <cfsavecontent variable='response'><cfinclude template="#arguments.path#"/></cfsavecontent> 294: 295: <cfreturn response />
 
column
number 0
 
id
string ??
 
line
number 293
 
raw_trace
string admin.application_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc:293)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc
 
type
string cfml
 
 
5
Struct
codePrintHTML
string 1: &lt;cfset rc.ajax=doFBInclude(&quot;/muraWRM/admin/view/vDashboard/ajax/dsp_javascript.cfm&quot;)&gt;<br> <b>2: &lt;cfset rc.layout=doFBInclude(&quot;/muraWRM/admin/view/vDashboard/dsp_main.cfm&quot;)&gt;</b><br>
 
codePrintPlain
string 1: <cfset rc.ajax=doFBInclude("/muraWRM/admin/view/vDashboard/ajax/dsp_javascript.cfm")> 2: <cfset rc.layout=doFBInclude("/muraWRM/admin/view/vDashboard/dsp_main.cfm")>
 
column
number 0
 
id
string ??
 
line
number 2
 
raw_trace
string admin.fw1.views.cdashboard.main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm:2)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm
 
type
string cfml
 
 
6
Struct
codePrintHTML
string 913: &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>
 
codePrintPlain
string 913: </cfif> 914: 915: <cfsavecontent variable='response'><cfinclude template="#pathInfo.base#views/#pathInfo.path#.cfm"/></cfsavecontent> 916: 917: <cfreturn response />
 
column
number 0
 
id
string ??
 
line
number 915
 
raw_trace
string admin.framework_cfc$cf.udfCall5(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:915)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc
 
type
string cfml
 
 
7
Struct
codePrintHTML
string 246: 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>
 
codePrintPlain
string 246: 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 ) {
 
column
number 0
 
id
string ??
 
line
number 248
 
raw_trace
string admin.framework_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:248)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc
 
type
string cfml
 
 
 
type
string database
 
where
string  
 
 
Sql
string SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON active.contentID=tcontentassignments.contentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' AND active.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID INNER JOIN tcontentassignments ON draft.contentID=tcontentassignments.contentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and tcontentassignments.userID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID= 'mysite' union SELECT DISTINCT tmodule.Title AS module, active.ModuleID, active.SiteID, active.ParentID, active.Type, active.subtype, active.MenuTitle, active.Filename, active.ContentID, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent active INNER JOIN tcontent draft ON active.ContentID = draft.ContentID INNER JOIN tcontent tmodule ON draft.ModuleID = tmodule.ContentID LEFT join tfiles on active.fileID=tfiles.fileID WHERE draft.Active=0 AND active.Active=1 AND draft.lastUpdate>active.lastupdate and draft.changesetID is null and draft.lastUpdateByID= '0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY tmodule.Title, active.ModuleID, active.SiteID, active.ParentID, active.Type,active.subType, active.MenuTitle, active.Filename, active.ContentID, draft.IsNav, tmodule.SiteID, draft.SiteID, active.SiteID, active.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING tmodule.SiteID= 'mysite' AND draft.SiteID='mysite' AND active.SiteID='mysite' union SELECT DISTINCT module.Title AS module, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type, draft.subtype, draft.MenuTitle, draft.Filename, draft.ContentID, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams,draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID FROM tcontent draft INNER JOIN tcontent module ON draft.ModuleID = module.ContentID LEFT JOIN tcontent active ON draft.ContentID = active.ContentID and active.approved=1 LEFT join tfiles on draft.fileID=tfiles.fileID WHERE draft.Active=1 AND draft.approved=0 and active.contentid is null and draft.changesetID is null and draft.lastUpdateByID='0C8064B5-2017-4382-B316D40B79FA9682' GROUP BY module.Title, draft.ModuleID, draft.SiteID, draft.ParentID, draft.Type,draft.subType, draft.MenuTitle, draft.Filename, draft.ContentID, draft.IsNav, module.SiteID, draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, draft.lastUpdateBy,tfiles.fileExt, draft.changesetID HAVING module.SiteID='mysite' AND draft.SiteID='mysite'
 
SQLState
string 42S22
 
StackTrace
string Unknown column 'draft.changesetID' in 'field list' 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:232):232 at railo.runtime.tag.Query.executeDatasoure(Query.java:580):580 at railo.runtime.tag.Query.doEndTag(Query.java:434):434 at content.contentgateway_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc:799):799 at content.contentgateway_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at dashboard.dashboardmanager_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc:222):222 at dashboard.dashboardmanager_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.view.vdashboard.dsp_main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm:188):188 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:764):764 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:717):717 at admin.application_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc:293):293 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.fw1.views.cdashboard.main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm:2):2 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:764):764 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:717):717 at admin.framework_cfc$cf.udfCall5(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:915):915 at admin.framework_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438 at admin.framework_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:248):248 at admin.framework_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226 at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394 at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359 at railo.runtime.ComponentImpl._call(ComponentImpl.java:536):536 at railo.runtime.ComponentImpl._call(ComponentImpl.java:465):465 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1729):1729 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:376):376 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:200):200 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1973):1973 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:280):280 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717):717 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290):290 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176):176 at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145):145 at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92):92 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381):381 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235):235 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233):233 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191):191 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127):127 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109):109 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298):298 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857):857 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588):588 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489):489 at java.lang.Thread.run(Unknown Source):-1
 
TagContext
Array
1
Struct
codePrintHTML
string 797: draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate,<br> 798: draft.lastUpdateBy,tfiles.fileExt, draft.changesetID<br> <b>799: HAVING module.SiteID='#arguments.siteid#' AND draft.SiteID=&lt;cfqueryparam cfsqltype=&quot;cf_sql_varchar&quot; value=&quot;#arguments.siteID#&quot;/&gt;</b><br> 800: &lt;/cfquery&gt;<br> 801: <br>
 
codePrintPlain
string 797: draft.SiteID, draft.SiteID, draft.targetparams, draft.lastUpdate, 798: draft.lastUpdateBy,tfiles.fileExt, draft.changesetID 799: HAVING module.SiteID='#arguments.siteid#' AND draft.SiteID=<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.siteID#"/> 800: </cfquery> 801:
 
column
number 0
 
id
string ??
 
line
number 799
 
raw_trace
string content.contentgateway_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc:799)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/content/contentGateway.cfc
 
type
string cfml
 
 
2
Struct
codePrintHTML
string 220: &lt;cfargument name=&quot;sortDirection&quot; type=&quot;string&quot; required=&quot;true&quot; default=&quot;desc&quot;&gt;<br> 221: <br> <b>222: &lt;cfreturn variables.contentGateway.getDraftList(arguments.siteID,arguments.userID,arguments.limit,arguments.startDate,arguments.stopDate,arguments.sortBy,arguments.sortDirection) /&gt;</b><br> 223: &lt;/cffunction&gt;<br> 224: <br>
 
codePrintPlain
string 220: <cfargument name="sortDirection" type="string" required="true" default="desc"> 221: 222: <cfreturn variables.contentGateway.getDraftList(arguments.siteID,arguments.userID,arguments.limit,arguments.startDate,arguments.stopDate,arguments.sortBy,arguments.sortDirection) /> 223: </cffunction> 224:
 
column
number 0
 
id
string ??
 
line
number 222
 
raw_trace
string dashboard.dashboardmanager_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc:222)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/requirements/mura/dashboard/dashboardManager.cfc
 
type
string cfml
 
 
3
Struct
codePrintHTML
string 186: &lt;/div&gt;<br> 187: <br> <b>188: &lt;cfset rsList=application.dashboardManager.getDraftList(attributes.siteID,session.mura.userID,5) /&gt;</b><br> 189: &lt;div id=&quot;drafts&quot; class=&quot;divide&quot;&gt;<br> 190: &lt;h3&gt;#application.rbFactory.getKeyValue(session.rb,&quot;dashboard.draftsforreview&quot;)#&lt;/h3&gt;<br>
 
codePrintPlain
string 186: </div> 187: 188: <cfset rsList=application.dashboardManager.getDraftList(attributes.siteID,session.mura.userID,5) /> 189: <div id="drafts" class="divide"> 190: <h3>#application.rbFactory.getKeyValue(session.rb,"dashboard.draftsforreview")#</h3>
 
column
number 0
 
id
string ??
 
line
number 188
 
raw_trace
string admin.view.vdashboard.dsp_main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm:188)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/view/vDashboard/dsp_main.cfm
 
type
string cfml
 
 
4
Struct
codePrintHTML
string 291: &lt;/cfif&gt;<br> 292: <br> <b>293: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#arguments.path#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 294: <br> 295: &lt;cfreturn response /&gt;<br>
 
codePrintPlain
string 291: </cfif> 292: 293: <cfsavecontent variable='response'><cfinclude template="#arguments.path#"/></cfsavecontent> 294: 295: <cfreturn response />
 
column
number 0
 
id
string ??
 
line
number 293
 
raw_trace
string admin.application_cfc$cf.udfCall(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc:293)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/Application.cfc
 
type
string cfml
 
 
5
Struct
codePrintHTML
string 1: &lt;cfset rc.ajax=doFBInclude(&quot;/muraWRM/admin/view/vDashboard/ajax/dsp_javascript.cfm&quot;)&gt;<br> <b>2: &lt;cfset rc.layout=doFBInclude(&quot;/muraWRM/admin/view/vDashboard/dsp_main.cfm&quot;)&gt;</b><br>
 
codePrintPlain
string 1: <cfset rc.ajax=doFBInclude("/muraWRM/admin/view/vDashboard/ajax/dsp_javascript.cfm")> 2: <cfset rc.layout=doFBInclude("/muraWRM/admin/view/vDashboard/dsp_main.cfm")>
 
column
number 0
 
id
string ??
 
line
number 2
 
raw_trace
string admin.fw1.views.cdashboard.main_cfm$cf.call(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm:2)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/fw1/views/cdashboard/main.cfm
 
type
string cfml
 
 
6
Struct
codePrintHTML
string 913: &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>
 
codePrintPlain
string 913: </cfif> 914: 915: <cfsavecontent variable='response'><cfinclude template="#pathInfo.base#views/#pathInfo.path#.cfm"/></cfsavecontent> 916: 917: <cfreturn response />
 
column
number 0
 
id
string ??
 
line
number 915
 
raw_trace
string admin.framework_cfc$cf.udfCall5(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:915)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc
 
type
string cfml
 
 
7
Struct
codePrintHTML
string 246: 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>
 
codePrintPlain
string 246: 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 ) {
 
column
number 0
 
id
string ??
 
line
number 248
 
raw_trace
string admin.framework_cfc$cf.udfCall2(/opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc:248)
 
template
string /opt/railo/tomcat/webapps/ROOT/stg.mysite.com/admin/framework.cfc
 
type
string cfml
 
 
 
type
string database
 
where
string  
 

Comments Comments (0) | Send Send | 2281 Views | Bookmark and Share

Railo Tomcat 404 redirects and CGI vars

Posted At : March 25, 2011 4:30 PM | Posted By : ColdFusion Joe
Related Categories: Tomcat, Railo, Stuff That Didn't Work, 404 Errors, Ubuntu

I've run into an issue with 404 redirects on Ubuntu - Railo - Tomcat (no Apache).

I have the site's /WEB-INF/web.xml redirecting 404 errors to a custom 404.cfm which tries to read and act on certain CGI variables. The problem is that I'm not getting all the CGI variables, most are null. The QUERY_STRING is the only variable passed from the missing template. The rest are either null or for the 404.cfm.

What I want is the template path and query string of the missing template.

Here are some of the cfdumps I've tried:

view plain print about
1<cfdump var="#cgi#">
2<cfdump var="#getPageContext().getRequest()#"><!--- returns HTTPServletRequestWrap class, fields, methods --->
3<cfdump var="#getPageContext().getRequest().getOriginalRequest()#"><!--- returns ApplicationHttpRequest class, fields, methods --->
4<cfdump var="#getPageContext().getRequest().getOriginalRequest().getAttributeNames()#"><!--- returns apparently useable strings --->
5<cfdump var="#getPageContext().getRequest().getOriginalRequest().getAttribute("query_string")#"><!--- returns Empty:null --->
6<cfdump var="#getPageContext().getRequest().getOriginalRequest().getParameterNames()#"><!--- returns "id" --->
7<cfdump var="#getPageContext().getRequest().getOriginalRequest().getHeaderNames()#"><!--- returns apparently useable strings --->
8<cfdump var="#getPageContext().getRequest().getOriginalRequest().getQueryString()#"><!--- returns original template's query string Yay! --->
9<cfdump var="#getPageContext().getRequest().getOriginalRequest().getRequestURL()#"><!--- returns URL for 404.cfm --->
10<cfdump var="#getPageContext().getRequest().getOriginalRequest().getAttribute("Referer")#"><!--- returns Empty:null --->
11<cfdump var="#getPageContext().getRequest().getOriginalRequest().getAttribute("Redirect_URL")#"><!--- returns Empty:null --->

Any ideas would be GREATLY appreciated. Remember, Tomcat is the web server without Apache.

Comments Comments (0) | Send Send | 2895 Views | Bookmark and Share

The name [_dump] is already used by a Build in Function

Posted At : January 27, 2011 11:10 AM | Posted By : ColdFusion Joe
Related Categories: Railo, Stuff That Didn't Work, Ubuntu, Mura

UPDATED! RESOLVED

Clicking on the File Manager Menu item in Mura results in a Railo error: The name [_dump] is already used by a Build in Function

Mura
-Core Version 5.3.3088
-Site Version 5.3.2831
Railo 3.2.1.000 final
Ubuntu 10.04.1 LTS 32 bit

The name [_dump] is already used by a Build in Function

All tickets and forums show the issue as closed or resolved (mostly).

Updating the sites core and site files does not resolve the issue.

From my forum posting on Mura Support Forum came this extremely quick response.

Message:
This is an error that started on the new Railo 3.2. In Mura 5.4 we've replace the old file manager with CKFinder. However, if you need to use the old file manager you can go to /admin/filemanager/cffm.cfm and comment out the _dump method on line 157.

view plain print about
1<!---
2<cffunction name="_dump" output="yes" returntype="void">
3 <cfargument name="vartodump" required="yes" type="any">
4 <cfargument name="abort" required="no" default="yes" type="boolean">
5 <cfoutput>Dumping data:<br></cfoutput>
6 <cfdump var="#vartodump#">
7 <cfif abort><cfabort></cfif>
8</cffunction>
9--->

But, this does not help. If you notice, Matt addressed Mura 5.4 and not 5.3. The issue is fixed for the next version of Railo, but not this. He also points out that this started occurring with the latest version of Railo, 3.2. So we're stuck for now with no resolution.

UPDATE
You must make the change above on /admin/filemanager/cffm.cfm and NOT cffm.cfc. Above notes have been corrected. Thanks to Jonas London for the correction in the Mura Forum link up top.

Comments Comments (0) | Send Send | 1643 Views | Bookmark and Share

Railo not listening or serving pages on port 80

Posted At : January 6, 2011 1:58 PM | Posted By : ColdFusion Joe
Related Categories: Tomcat, Railo, Stuff That Didn't Work, Ubuntu

SOLVED!
Here's the setup:
Ubuntu Server 10.4 LTS 32bit
Railo 3.2.1 32bit Linux with Tomcat.
http://www.getrailo.org/down.cfm?item=/railo/remote/download/3.2.1.000/tomcat/linux/railo-3.2.1.000-pl0-linux-installer.run

Unable to serve pages on port 80.

Changed the server.xml config file by changing the listening from port 8888 to port 80.

view plain print about
1admin@railo:/$ cat opt/railo/tomcat/conf/server.xml
2<snip>
3 <Connector port="80" protocol="HTTP/1.1"
4 connectionTimeout="20000"
5 redirectPort="8443" />
6</snip>
7
8admin@railo:/etc$ sudo service railo_ctl restart
9
10admin@railo:/$ netstat -nap
11(No info could be read for "-p": geteuid()=1000 but you should be root.)
12Active Internet connections (servers and established)
13Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
14tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN -
15tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN -
16tcp 0 52 192.168.5.207:22 192.168.5.60:59938 ESTABLISHED -
17tcp6 0 0 127.0.0.1:8005 :::* LISTEN -
18tcp6 0 0 :::22 :::* LISTEN -
19udp 0 0 0.0.0.0:5353 0.0.0.0:* -
20udp 0 0 0.0.0.0:41555 0.0.0.0:* -

There's nothing listening on port 80! I can change server.xml to port 8080 and back to 8888 and it will listen and serve up pages on those ports but not port 80.

Iptables is off:

view plain print about
1admin@railo:/ $ sudo iptables -L -v
2Chain INPUT (policy ACCEPT 7599 packets, 657K bytes)
3 pkts bytes target prot opt in out source destination
4
5Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
6 pkts bytes target prot opt in out source destination
7
8Chain OUTPUT (policy ACCEPT 542 packets, 104K bytes)
9 pkts bytes target prot opt in out source destination

ufw is off:
view plain print about
1sadmin@railo:/ $ sudo ufw status
2Status: inactive

The reason this occurs is because Ubuntu will not let a process running non-root user bind to a port less than 1024. You do not want to run Tomcat as root due to security so we have to install and configure AUTHBIND.
  1. Install authbind
    2. view plain print about
    1sudo apt-get install authbind

  2. Make port 80 available to authbind (you need to be root):
    3. view plain print about
    1sudo touch /etc/authbind/byport/80
    2sudo chmod 500 /etc/authbind/byport/80
    3sudo chown railo /etc/authbind/byport/80

  3. do the same for port 443 if also using SSL
  4. Make IPv4 the default (authbind does not currently support IPv6). To do so, edit /opt/railo/tomcat/bin/setenv.sh by uncommenting or adding:
    5. view plain print about
    1CATALINA_OPTS="-Djava.net.preferIPv4Stack=true"

  5. Change startup.sh
    6. view plain print about
    1exec authbind --deep "$PRGDIR"/"$EXECUTABLE" start "$@"
    2# OLD: exec "$PRGDIR"/"$EXECUTABLE" start "$@"

  6. Modify server.xml to listen on port 80.

    Change from

    view plain print about
    1<Connector port="8888" protocol="HTTP/1.1"
    To
    view plain print about
    1<Connector port="80" protocol="HTTP/1.1"

  7. Modify server.xml to listen on port 443 if using SSL.
    Change
    view plain print about
    1<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"
    To
    view plain print about
    1<Connector port="443" protocol="HTTP/1.1" SSLEnabled="true"

  8. Resart Railo (Tomcat)
    9. view plain print about
    1admin@railo:/etc$ sudo service railo_ctl restart

Reference:
http://www.2ality.com/2010/07/running-tomcat-on-port-80-in-user.html
http://ubuntuforums.org/showthread.php?t=1545988
http://blogs.mulesoft.org/a-better-tomcat-for-ubuntu-and-debian/

Comments Comments (0) | Send Send | 4066 Views | Bookmark and Share
BlogCFC was created by Raymond Camden. This blog is running version 5.9.7. Contact Blog Owner