Mura on Railo and BlueOnyx

Once Railo is installed and configured on BlueOnyx, make sure you have a MySQL database created and have all the connection info, like username, database name, user password. Create the datasource in Railo Admin.

Download Mura Standard from www.getmura.com/download/mura-downloads/ to your local machine. Unzip or extract the .ZIP file. FTP all files up to your sites /web/ directory. I deleted everything in the /web/ folder EXCEPT /WEB-INF/. These files were created with the Railo install and left from the BO initial site creation.

In your browser, go to http:///index.cfm

I received this error:

Railo 3.3.1.000 Error (application) Message can't copy file [/home/.sites/33/site22/web/config/templates/settings.template.cfm] to [/home/.sites/33/site22/web/config/settings.ini.cfm] Detail Permission denied Stacktrace The Error Occurred in /home/.sites/33/site22/web/config/applicationSettings.cfm: line 88 86: 87: 88: 89: 90: called from/home/.sites/33/site22/web/Application.cfc: line 48 46: ---> 47: 48: 49: 50: We need to add Tomcat to the site's group and change permissions to write for the group on the /web/config/ directory and contents.

We need to adjust permissions

view plain print about
1vi /etc/group
find your site's group, e.g., site22 add tomcat to the group, similar to:
view plain print about
1site22:x:599:johnny,admin,billy,tomcat

Then recursively add write permissions for the /web/config/ directory. Once you are in the /web/ directory.

view plain print about
1chmod -R g+w config

This will allow site members to FTP files.

This will fix the permission denied for the config stuff

view plain print about
1chmod o+w config
But we probably didn't have to do that if we do this....

Navigate up a level and change ownership of /web/ to tomcat.

view plain print about
1cd ../
2chown tomcat.site22 web

Next to run the SEO URL query strings for Mura, you'll have to modify the /web/WEB-INF/web.xml file to allow the wildcards:

view plain print about
1vi /web/WEB-INF/web.xml

add the following lines:

view plain print about
1��<servlet-mapping>
2� ��<servlet-name>CFMLServlet</servlet-name>
3� ��<url-pattern>/index.cfm/*</url-pattern>
4��</servlet-mapping>
in with the rest of the servlet-mappings.

Restart tomcat.

view plain print about
1/sbin/service tomcat5 restart

You should be able to run your Mura site without issue. If you do, please comment here and I'll look into it.

Lost Mura Admin Password

Yikes! I forgot my Mura Admin Login Password!

Hey, it happens! Well forget retrieving it, reset the password instead.

In the tusers table update the password back to 'admin'. The hash equivalent is '21232F297A57A5A743894A0E4A801FC3'.

view plain print about
1UPDATE tusers
2SET Password = '21232F297A57A5A743894A0E4A801FC3'
3WHERE UserName = 'admin'

Go back to the Mura Admin Login screen and use 'admin' as username and password. Then go to Edit Profile within Mura and correct your password.

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

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  
 

Mura Extranet Custom Login

The standard Mura Extranet login page displays a lot of information, such as menus, titles and other items that may provide too much information before one may login. The way around this is to create a custom login page that does not display such info. I started with {Site Root}/{Site Name}/includes/themes/{MyTheme}/templates/blank.cfm and created {Site Root}/{Site Name}/includes/themes/{MyTheme}/templates/login.cfm

The basic login page, minus the "email my password" section looks like:

view plain print about
1<cfoutput>
2<cfinclude template="inc/html_head.cfm" />
3<body id="#$.getTopID()#" class="twoColSL depth#arrayLen($.event('crumbdata'))#">
4    <div id="container" class="#$.createCSSid($.content('menuTitle'))#">
5        #$.dspBody(body=$.content('body'),pageTitle=$.content('title'),crumbList=0,showMetaImage=0)#
6    </div>
7</body>
8</html>
9</cfoutput>

Then all we have to do is to go into Mura Admin > Site Setting > Edit Current Site (make sure you are on the right one!) and select the Extranet tab. In the Custom Login URL, put in the path to your custom login page. In my example it is: /{Site Root}/{Site Name}/index.cfm/login/?display=login

Well that's good. But I want more! I want to add my custom logic for auto logins based on passed URL parameters. See this post about Mura Extranet Auto Login Using URL Variables. But this does not work with my new custom login. It seems that that all requests go straight to my custom login bypassing my custom dsp_login.cfm in {Site Root}/{Site Name}/includes/custom/dsp_login.cfm. This is a total bummer and means that I have to take the logic out of the dsp_login.cfm and move it my custom login.cfm.

OK, so we move the logic over and now my login.cfm looks like:

view plain print about
1<cfparam name="request.status" default="">
2<cfparam name="request.linkServID" default="">
3<cfparam name="request.isBlocked" default="false">
4<cfparam name="variables.autologin" default="false">
5<cfset variables.rbFactory=$.getSite().getRBFactory() />
6
7<!--- check for the ID passed from client software and login fails - try once here, then send to login form --->
8<cfif NOT request.currentuser.isLoggedIn() AND NOT request.isBlocked AND NOT request.status eq 'failed'>
9    <!--- has Mura processed this yet? --->
10    <cfif IsDefined("request.ID1") AND IsDefined("request.ID2")>     
11        <cfset variables.autologin=true />
12        <cfset variables.ID1=request.ID1 />
13        <cfset variables.ID2=request.ID2 />
14    </cfif>
15</cfif>
16
17<!--- if processed above attempt auto login --->    
18<cfif variables.autologin >        
19    <cfoutput>
20        <span style="display:none">    
21            <form id="login" name="frmLogin" method="post" action="?nocache=1" >
22                <input type="text" id="txtUsername" name="username" value="#variables.ID1#" />
23                <input type="password" id="txtPassword" name="password" value="#variables.ID2#" />
24                <input type="hidden" name="doaction" value="login" />
25                <input type="hidden" name="linkServID" value="#HTMLEditFormat(request.linkServID)#" />
26                <input type="hidden" name="returnURL" value="#HTMLEditFormat(request.returnURL)#" />
27                <input type="submit" value="#htmlEditFormat(variables.rbFactory.getKey('user.login'))#" />
28            </form>
29            <invalidTag>
30                document.getElementById('login').submit();
31            </script>
32        </span>
33    </cfoutput>
34</cfif>
35
36
37<cfoutput>
38<cfinclude template="inc/html_head.cfm" />
39<body id="#$.getTopID()#" class="twoColSL depth#arrayLen($.event('crumbdata'))#">
40    <div id="container" class="#$.createCSSid($.content('menuTitle'))#">
41        #$.dspBody(body=$.content('body'),pageTitle=$.content('title'),crumbList=0,showMetaImage=0)#
42    </div>
43</body>
44</html>
45</cfoutput>

But Hey! This isn't working. Mura doesn't put the URL variables into the request scope as params as it does in the custom display_objects logic. Boo! But Mura DOES return a returnurl variable in the request scope. The request.returnurl variable contains our original URL variables. We can parse request.returnurl and get what we want to fill out our auto login form fields.

An example of request.returnurl would be http://127.0.0.1:8500/mura/cfjoe/?ID1=1234&ID2=56789 Now I know that all incoming http requests will be coming with this exact URL query string format. I can do some loose parsing to pull them out. (note: this is not using the standard Mura URL params format). Here's a snippet of the logic used to do what we want:

view plain print about
1<cfif IsDefined("request.returnurl") >
2    <cfif FindNoCase("ID1",request.returnurl) AND FindNoCase("ID2",request.returnurl) >    
3        <cfset variables.autologin=true />
4        
5        <!--- regex creates array w/ URL var value plus equal sign - need better regex here --->
6        <cfset variables.regexArray = REMatch("(?:=)[^&]*", request.returnurl) />
7        
8        <!--- remove equal sign and set vars--->            
9        <cfset variables.ID1 = Replace(variables.rexexArray[1],"=","") />
10        <cfset variables.ID2 = Replace(variables.regexArray[2],"=","") />
11    </cfif>
12</cfif>

Let's take a closer look at my regular expression used to parse out the URL variables.

view plain print about
1(?:=)[^&]*

This just matches "=1234" and "=56789". I'm sure a better regular expression will drop the "=" sign for us, but I just don't know it!

This:

view plain print about
1<cfset variables.regexArray = REMatch("(?:=)[^&]*", request.returnurl) />

creates an array:

array
1 =1234
2 =56789

So we'll have to use ColdFusion's Replace function to get rid of the "=" sign and set the variables for our form.

view plain print about
1<!--- remove equal sign and set vars--->            
2<cfset variables.ID1 = Replace(variables.rexexArray[1],"=","") />
3<cfset variables.ID2 = Replace(variables.regexArray[2],"=","") />

Putting it all together gives us this:

view plain print about
1<cfparam name="request.status" default="">
2<cfparam name="request.linkServID" default="">
3<cfparam name="request.isBlocked" default="false">
4<cfparam name="variables.autologin" default="false">
5<cfset variables.rbFactory=$.getSite().getRBFactory() />
6
7<!--- check for the ID passed from client software and login fails - try once here, then send to login form --->
8<cfif NOT request.currentuser.isLoggedIn() AND NOT request.isBlocked AND NOT request.status eq 'failed'>
9
10    <!--- has Mura processed this yet? --->
11    <cfif IsDefined("request.ID1") AND IsDefined("request.ID2")>
12        <cfset variables.autologin=true />
13        <cfset variables.ID1=request.ID1 />
14        <cfset variables.ID2=request.ID2 />
15        
16    <!--- 1st attempt with regular query string --->
17<cfelseif IsDefined("request.returnurl") >
18    <cfif FindNoCase("ID1",request.returnurl) AND FindNoCase("ID2",request.returnurl) >    
19        <cfset variables.autologin=true />
20        
21        <!--- regex creates array w/ URL var value plus equal sign - need better regex here --->
22        <cfset variables.regexArray = REMatch("(?:=)[^&]*", request.returnurl) />
23        
24        <!--- remove equal sign and set vars--->            
25        <cfset variables.ID1 = Replace(variables.rexexArray[1],"=","") />
26        <cfset variables.ID2 = Replace(variables.regexArray[2],"=","") />
27    </cfif>
28</cfif>
29</cfif>
30
31<!--- if processed above attempt auto login --->    
32<cfif variables.autologin >        
33    <cfoutput>
34        <!---variables.ID1 is #variables.ID1#<br/>
35        variables.ID2 is #variables.ID2#--->

36        <span style="display:none">    
37            <form id="login" name="frmLogin" method="post" action="?nocache=1" >
38                <input type="text" id="txtUsername" name="username" value="#variables.ID1#" />
39                <input type="password" id="txtPassword" name="password" value="#variables.ID2#" />
40                <input type="hidden" name="doaction" value="login" />
41                <input type="hidden" name="linkServID" value="#HTMLEditFormat(request.linkServID)#" />
42                <input type="hidden" name="returnURL" value="#HTMLEditFormat(request.returnURL)#" />
43                <input type="submit" value="#htmlEditFormat(variables.rbFactory.getKey('user.login'))#" />
44            </form>
45            <invalidTag>
46                document.getElementById('login').submit();
47            </script>
48        </span>
49    </cfoutput>
50</cfif>
51
52
53<cfoutput>
54<cfinclude template="inc/html_head.cfm" />
55<body id="#$.getTopID()#" class="twoColSL depth#arrayLen($.event('crumbdata'))#">
56    <div id="container" class="#$.createCSSid($.content('menuTitle'))#">
57        #$.dspBody(body=$.content('body'),pageTitle=$.content('title'),crumbList=0,showMetaImage=0)#
58    </div>
59</body>
60</html>
61</cfoutput>

The bottom line is that we can use custom login forms in Mura but they must contain all needed logic within and need to adapt to Mura's returned request variables.

Mura Extranet Auto Login Using URL Variables

We know that we must convert our URL variables to custom parameters per explained here: http://docs.getmura.com/developer-guides/back-end-development/url-structure-in-mura-cms. Once this is done we can utilize the request scope to access them per explained here: Accessing Mura URL Variables

When a client wants to access the intranet based on his assigned link, www.myextranet.com/params/username/Billy/pass/Bob we would use the request scope to parse out those URL variables. request.username = Billy and request.pass = Bob. OK, I acknowledge that this certainly not secure, but that's just the way the client wants it.

The overall concept is to take the variables and automatically submit them to a form within Mura. We'll have to use a few tests around it too.

Where do we start? Make a copy of {SiteRoot}/{SiteName}/includes/display_objects/dsp_login.cfm and place it in same site's /custom/ folder at {SiteRoot}/{SiteName}/includes/display_objects/custom/. Mura will look in the /custom/ folder before handling events or rendering content with the original dsp_login.cfm. Let's modify!

First we'll set up our tests. We want to ensure that the passed URL (custom parameters) are indeed passed. Then we want to make sure that the user is not already logged in and that it's the first time this attempt has been made. We don't want to send ourselves into an endless loop.

view plain print about
1<cfif isDefined("request.CUST_ID") AND isDefined("request.SEC_ID") AND NOT request.currentuser.isLoggedIn() AND NOT request.isBlocked AND NOT request.status eq 'failed'>

The normal Mura extranet login form action is the same we will use for our auto login.

view plain print about
1<form id="login" name="frmLogin" method="post" action="?nocache=1" >

We'll input our URL Custom Parameters as input:

view plain print about
1<input type="text" id="txtUsername" name="username" value="#request.username#" />
2<input type="password" id="txtPassword" name="password" value="#request.pass#" />

Then we'll use JavaScript to automatically submit the form for us.

view plain print about
1document.getElementById('login').submit();

Putting it all together and filling in the other required form input variables looks like:

view plain print about
1<!--- check for the ID passed from client software and login fails - try once here, then send to login form --->
2<cfif isDefined("request.username") AND isDefined("request.pass") AND NOT request.currentuser.isLoggedIn() AND NOT request.isBlocked AND NOT request.status eq 'failed'>
3    <cfoutput>
4        <span style="display:none">    
5            <form id="login" name="frmLogin" method="post" action="?nocache=1" >
6                <input type="text" id="txtUsername" name="username" value="#request.CUST_ID#" />
7                <input type="password" id="txtPassword" name="password" value="#request.SEC_ID#" />
8                <input type="hidden" name="doaction" value="login" />
9                <input type="hidden" name="linkServID" value="#HTMLEditFormat(request.linkServID)#" />
10                <input type="hidden" name="returnURL" value="#HTMLEditFormat(request.returnURL)#" />
11                <input type="submit" value="#htmlEditFormat(variables.rbFactory.getKey('user.login'))#" />
12            </form>
13            <invalidTag>
14                document.getElementById('login').submit();
15            </script>
16        </span>
17    </cfoutput>
18</cfif>

This goes in right underneat the <cfparam>s on the custom dsp_login.cfm. Give it a shot, it works great.

Accessing Mura URL Variables

With Mura's SES URL manipulation it can be hard to access URL variables for processing. E.g., what would Mura do with www.mysite.org/index.cfm?ID1=blah&ID2=moreblah?

I find myself in this position because links like these are hardcoded in older software in possession of customers unavailable for me to change. These links need to be maintained, but creating 404s for the multitude of variables that get passed back is unreasonable.

Mura accepts URL variables with the "params" URL keyword followed by key/value pairs, or custom parameters. It's explained here: http://docs.getmura.com/developer-guides/back-end-development/url-structure-in-mura-cms

So our URL www.mysite.org/index.cfm?ID1=blah&ID2=moreblah would have to look like www.mysite.org/index.cfm/params/ID1/blah/ID2/moreblah. I did this with the Tuckey URL Rewrite Filter on Tomcat. Full details on this accomplishment will come later. For now, we'll just assume that we have successfully converted our URL variables to custom parameters.

The whole point of this article is to access the URL variables. If you've done any experimenting, you'll find that anything referencing URL throws an error (well, I did anyway).

So if your index.cfm above had this cfdump – error!

view plain print about
1<cfdump var="#URL#" />

But using the custom parameters method, your URL variables in key/value pairs are stored in the request scope! cfdumping the entire request scope will pull up a lot of stuff, but here's that for which we are looking.

view plain print about
1<cfdump var="#request.ID1#" />
2<cfdump var="#request.ID2#" />

Gives us "blah" and "moreblah", respectively.

You can also find these in the Mura scope with $.event('variableName')

So cfdumping the below, returns the same results!

view plain print about
1<cfdump var="#$.event('ID1')#" />
2<cfdump var="#$.event('ID2')#" />

Returns "blah" and "moreblah"!

So look in the request scope to access you URL variables or in the mura scope, once they are set as custom parameters in the URL.

MSSQL Server Drop All Tables

Dropping all tables in a MSSQL Server Database. If you want to clear out all the tables and start fresh without having to change permissions, users, roles, etc. Use this command in the SQLQuery Analyzer window for your database.

view plain print about
1EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

One caveat is that it will not work if there are foreign key references among your tables. If you are experimenting with Mura installations, it will work fine.

__MuraResponse__ and Intercepting Content in Mura CMS

Working on developing a few Mura Plugins, I came across the __MuraResponse__ event property. This property is available in the "onRenderEnd" event, which apparently fires after all the content is rendered but before it is actually displayed. I couldn't find any documentation on __MuraResponse__ but came upon this great blog post titled "Intercepting Content in Mura CMS" by Tony Garcia

Here is a verbatim copy of that post which explains what __MuraResponse__ is and how to use it.

~~~~~~~~~~~~

I recently performed a minor update to my Embed Video Plugin for Mura CMS . One of the things this update addressed was a judge's comment from the Mura Plugin ColdFusion Throwdown  contest, which basically pointed out that I didn't provide documentation for how the EmbedVideo tag could be used within a component (a Mura display component, not a CFC). Well, the original version actually couldn't be used within a Mura component. So I decided to do something about it and figured this would be a good opportunity to demonstrate how you can intercept and modify output in Mura using a plugin or your site's custom eventhandler.

view plain print about
1<cffunction name="onRenderStart" output="false" returntype="void">
2    <cfargument name="event">
3    <cfset var body = "" />
4    <cfif pluginConfig.getSetting( "isEnabled" ) eq "yes">
5        <cfset body = event.getContentBean().getBody() />
6        <cfset body = parseTags( body ) />
7        <cfset event.getContentBean().setBody( body ) />
8    </cfif>
9</cffunction>

So, first there is a check to see if the plugin is enabled. If so, it grabs the content bean from the event object and assigns the body of the content to the variable "body." The parseTags function basically looks for any EmbedVideo tags in the body, parses their attributes, and replaces the tags with the appropriate video embedding code. The contentBean's body is then replaced with the modified copy before it is rendered and then displayed.

Notice, though, that we intercepted the content of the "body" property of the contentbean. This property contains the content which is entered into the content field of the page via the WYSIWYG editor when the page is created/edited. Because I did it this way, the EmbedVideo tag will only be parsed if it was entered into this field, but not if it was included in a display component (or any other custom display object). In fact, I'm not sure that this would work if the tag was put into the "Summary" field of the page either.

So in order to enable the plugin to parse the tag no matter where it appeared in the page output, I needed to be able to to access a variable which contained the entire page output (not just the body property). It turns out that there is a way to access it in an event property called "__MuraResponse__" (that's 2 underscores on either side). This property is available in the "onRenderEnd" event, which apparently fires after all the content is rendered but before it is actually displayed. So the new version of the plugin, I replaced the "onRenderStart" method with this "onRenderEnd" method:

view plain print about
1<cffunction name="onRenderEnd" output="false" returntype="void">
2    <cfargument name="event">
3    <cfset var output = "" />
4    <cfif pluginConfig.getSetting( "isEnabled" ) eq "yes">
5        <cfset output = event.getValue( "__MuraResponse__" ) />
6        <cfset output = parseTags( output ) />
7        <cfset event.setValue( "__MuraResponse__", output ) />
8    </cfif>
9</cffunction>

Not much has changed except for now I'm looking within "__ MuraResponse__" for the tag and parsing that. Now the tag works within the page, body, summary, components, display objects, and probably within other plugins as well (although I haven't tested that yet).

I hope this has been useful in showing how you can intercept content in Mura and modify it before it is actually displayed in the browser. It is worthwhile to note that while I used a plugin as an example, this can also be done outside of a plugin by putting custom events in your local eventHandler cfc and programmatically registering these events, as is explained in this entry in the Mura blog.

Mura Railo ErrorCode 0 Page not Found

In Mura sites on Railo, if one attempts to access a non-existent .CFM template, then an interesting error occurs. A Railo error page returns with an ErrorCode of 0. The message states, Page {requested template} not Found. This should be a 404 and not 0.

For example take a look at http://www.cfeclipse.org/about.cfm. There is no about.cfm on cfeclipse.org.

http://www.cfeclipse.org/about.cfm http://www.cfeclipse.org/about.cfm throws a Railo ErrorCode 0 and NOT a 404

Doesn't that look like it should return an ErrorCode 404?

Let's take a look at the response header: http://www.cfeclipse.org/about.cfm response header of 200 OK

This is why we are not getting any Tomcat or Railo 404 error interception.

Initially I went to the Railo Administrator Error Settings and played around there. This had no effect on this anomaly. But this is because, as you recall, that the response header reports a 200 OK. Not 404 or any other error. Thus, it's a Mura deal.

I did find a satisfactory solution based on an old Mura form post.

In {siteroot}/{siteID}/includes/eventHandler.cfc, I added this function:

view plain print about
1<cffunction name="onApplicationLoad" output="true" returntype="any">
2    <cfargument name="$">
3
4    <cfset var customHandler=createObject("component","customHandler").init()>
5    <cfset getBean("pluginManager").addEventHandler(customHandler,$.event('siteID'))>
6</cffunction>

I then created {siteroot}/{siteID}/includes/customHandler.cfc which looks like:

view plain print about
1<cfcomponent extends="mura.cfobject">
2    <cffunction name="onGlobalMissingTemplate" output="true" returntype="any">
3        <cfargument name="$">
4        <cflocation url="/" addtoken="false" />
5        <cfabort>
6        <!--- you could also set $.event("__MuraResponse__","true") instead of using the cfabort.--->
7    </cffunction>
8</cfcomponent>

It works great (so far!) and I have all Mura Page Not Founds going to the local site root (using cflocation) which is OK with me, instead of a custom error.

A concern that crept up was that when I do a Mura "Update Core Files", the changes will be overwritten. Well, I have been assured that eventHandler.cfc remains untouched during any Mura upgrades.

Next will be to create a Mura Plugin so that I will not have to edit code to change my Page Not Found response page as well as share with the Mura community.

How to Install Mura Plugins

It's simple, but finding where you install and deploy Mura plugins is not intuitive!

The most common complaint is, "I can't find the tab to upload the plugin! I clicked Plugins on the menu." The problem is that you do not install plugins in the Plugins section! Click on Site Settings on the upper right menu. Not on any of the dropdowns but on the Site Settings button itself.

Boom! Now you will see the tab that says "Plugins" in the body of the page. Not on the menu! Well, you'll see it there, but that's not what you want. Once you click the tab, you are good to go.

Now it's easy to find the plugin you downloaded from the getMura site, upload it and then deploy it, checking which sites on which you wish to use it.

If you do not see any of this, then you are probably not a Site Admin. Logoff and log back in as a Site Admin and try again.

Simple but not so simple!

More Entries

BlogCFC was created by Raymond Camden. This blog is running version 5.9.7. Contact Blog Owner