Ubuntu Mounting HTC One M8 SD Card

error: exited with non-zero exit status 32: mount: unknown filesystem type 'exfat'

I added a 64 Gigabyte SDcard to my HTC One M8 phone and could not connect to add music or files. The issue is that Ubuntu 14.01 cannot read exFAT formatted drives, which includes most SDCards.

We have to enable exFAT in Ubuntu 14.01 using fuse. Fuse is already in Ubuntu but we have to install the exFAT packages.

view plain print about
1sudo apt-get install exfat-fuse exfat-utils

Then uplug your phone from the USB port and plug it back in. Then, in your phone, go into settings (I just scrolled the top bar down) and tap USB File sharing - USB file sharing mode. Then enable Disk Drive - Mount as disk drive.

In just a second you will than be able to see your SDCard in File Manager. Start dragging and dropping your folder onto your phone.

MySQL Workbench on LinuxMint 12

Can't install MySQL Workbench on LinuxMint 12? Can't find MySQL Workbench in the Software Manager or Synaptic? Here's all you have to do:

view plain print about
1sudo add-apt-repository ppa:olivier-berten/misc
2sudo apt-get update
3sudo apt-get install mysql-workbench-gpl

Add a repostitory that has MySQL Workbench, update and then apt-get install.

Check your LInuxMint menu under Development and you have MySQL Workbench!

Linux Tar Zip GZip

ZIP

To compress a directory with zip do the following:

view plain print about
1zip -r my_archive_name.zip directory_to_compress

Here's how you extract a zip archive:

view plain print about
1unzip my_archive_name.zip

TAR

Tar is a very commonly used archiving format on Linux systems. The advantage with tar is that it consumes very little time and CPU to compress files, but the compression isn't very much either. Here's how you compress a directory:

view plain print about
1tar -cvf my_archive_name.tar directory_to_compress

And to extract the archive:

view plain print about
1tar -xvf my_archive_name.tar.gz

This will extract the files in the my_archive_name.tar archive into the current directory. Like with the tar format you can optionally extract the files to a different directory:

view plain print about
1tar -xvf my_archive_name.tar -C /folder/extract_to_this_directory/

TAR.GZ

To compress a directory utilizing TAR.GZ use the following syntax:

view plain print about
1tar -zcvf my_archive_name.tar.gz /folder/directory_to_compress

To decompress an archive use the following syntax:

view plain print about
1tar -zxvf my_archive_name.tar.gz

This will extract the files in the archive_name.tar.gz archive in the current directory. Like with the tar format you can optionally extract the files to a different directory:

view plain print about
1tar -zxvf my_archive_name.tar.gz -C /folder/extract_to_this_directory/

TAR.BZ2

This format has the best level of compression among all of the formats. But this comes at a cost – in time and in CPU. Here's how you compress a directory using tar.bz2:

view plain print about
1tar -jcvf my_archive_name.tar.bz2 /folder/directory_to_compress

This will extract the files in the archive_name.tar.bz2 archive in the current directory. To extract the files to a different directory use:

view plain print about
1tar -jxvf my_archive_name.tar.bz2 -C /folder/extract_to_this_directory/

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  
 

Recursively chmod Directories Only

Recursively chmod directories only or files only.

The command to chmod all sub directories under you current directory is:

view plain print about
1find . -type d -exec chmod 755 {} \;

The command to chmod all files in your current directory and all sub directories is:

view plain print about
1find . -type f -exec chmod 644 {} \;

The only difference between the two is the type flag. d for directory and f for file.

Railo Tuckey UrlRewrite Application - Part 1

Railo, Tomcat, Tuckey URL Rewrite filter and 301 redirects read from a database using ColdFusion or CFML.

Instead of constantly rewriting the urlrewrite.xml file with vi or nano directly on the server, we built a small ColdFusion/Railo/CFML application to easily edit our 301 redirects.

The admin side, which will not be shown here and is easy to duplicate, allows the user to add pages which will 301 redirect. They simply enter the old URL and the new URL. The table, titled redirect, has 3 columns, RedirectID, OldPath, NewPath. For example, the user wishes /my/old/page.cfm to go to my/new/directory/page.cfm with a 301 status code, and thus, would enter

What this application does:

  1. Reads the current urlrewrite.xml using cffile
  2. Writes a backup of the current urlrewrite.xml with cffile
  3. Queries the database for desired 301 redirects
    1. Creates xml
    2. With rules
  4. Looping and outputting 301 query
  5. writes the new urlrewrite.xml
  6. reads it again and dumps for our viewing pleasure.

We take advantage of the rules filter which turns on and off access to private directories like Railo and Mura admin per this blog entry.

Here's the code:

view plain print about
1<!--- ulrewritexml.cfm --->
2<!--- This app creates the xml file used for assigned 301 redirects --->
3<!--- writes urlrewrite.xml used by Tuckey rewrite filter in Tomcat --->
4
5<cfset variables.datasourcename="MyDatabase" >
6
7<!--- set file path of urlrewrite.xml --->
8<cfset variables.xmlfilepath="/opt/railo/tomcat/webapps/ROOT/cfjoe.com/WEB-INF/urlrewrite.xml">
9
10<!--- set on/off for rules - see the xml for rules --->
11<!--- we use this to disable public access to private directories --->
12<cfset variables.ruleenable="true">
13
14    
15<!--- read the current urlrewrite.xml --->
16<cffile action="read"
17        file="#xmlfilepath#"
18        variable="urlrewritexml">

19        
20<!--- make the back up and save --->
21<cffile action="write"
22        file="#xmlfilepath#.#DateFormat(Now(),"yyyymmdd")#-#TimeFormat(Now(),"HHmm")#"
23        fixnewline="yes"
24        output="#urlrewritexml#">

25        
26<!--- make the new xml from database --->
27<cfquery name="q301" datasource="#datasourcename#">
28 SELECT    RedirectID, OldPath, NewPath
29     FROM        redirect
30</cfquery>
31
32<cfxml variable="urlrewrite2xml">
33<?xml version="1.0" encoding="utf-8"?>
34<!DOCTYPE urlrewrite PUBLIC "-//tuckey.org//DTD UrlRewrite 3.2//EN"
35 "http://tuckey.org/res/dtds/urlrewrite3.2.dtd">

36
37<!--
38
39 Configuration file for UrlRewriteFilter
40 http://tuckey.org/urlrewrite/
41
42-->

43<urlrewrite>
44
45 <rule>
46 <note>
47 The rule means that requests to /test/status/ will be redirected to /rewrite-status
48 the url will be rewritten.
49 </note>
50 <from>/test/status/</from>
51 <to type="redirect">%{context-path}/rewrite-status</to>
52 </rule>
53    
54    <!--- here are the rules! --->
55 <!-- disable Railo Admin -->
56 <rule enabled="<cfoutput>#ruleenable#</cfoutput>">
57 <name>Disable Railo</name>
58 <from>^/railo-context/admin/(.*)$</from>
59 <to>null</to>
60 <set type="status">403</set>
61 </rule>
62    
63 <!-- disable Mura Admin -->
64 <rule enabled="<cfoutput>#ruleenable#</cfoutput>">
65 <name>Disable Mura</name>
66 <from>^/admin/(.*)$</from>
67 <to>null</to>
68 <set type="status">403</set>
69 </rule>
70    
71 <!-- disable WebAdmin directory -->
72 <rule enabled="<cfoutput>#ruleenable#</cfoutput>">
73 <name>Disable WebAdmin</name>
74 <from>^/WebAdmin/(.*)$</from>
75 <to>null</to>
76 <set type="status">403</set>
77 </rule>
78
79 <!-- 301 redirects from urlrewrite app -->
80    <cfoutput query="q301">
81 <rule>
82 <from>#OldPath#</from>
83 <to type="permanent-redirect">#NewPath#</to>
84 </rule>
85    </cfoutput>
86
87 <outbound-rule>
88 <note>
89 The outbound-rule specifies that when response.encodeURL is called (if you are using JSTL c:url)
90 the url /rewrite-status will be rewritten to /test/status/.
91
92 The above rule and this outbound-rule means that end users should never see the
93 url /rewrite-status only /test/status/ both in thier location bar and in hyperlinks
94 in your pages.
95 </note>
96 <from>/rewrite-status</from>
97 <to>/test/status/</to>
98 </outbound-rule>
99
100</urlrewrite>    
101</cfxml>
102<cfset newurlrewritexml = ToString(urlrewrite2xml)>
103
104<!--- write the new urlrewrite.xml --->
105<cffile action="write"
106        file="#xmlfilepath#"
107        fixnewline="yes"
108        output="#newurlrewritexml#">

109
110<!--- read the new one --->        
111<cffile action="read"
112        file="#xmlfilepath#"
113        variable="viewurlrewritexml">

114
115<!--- lets look at it --->
116<p>The new urlrewrite.xml</p>        
117<cfdump var="#ToString(viewurlrewritexml)#">

SES URLs with Mura, Railo, Tomcat, Ubuntu

SES URLs with Mura, Railo, Tomcat, Ubuntu

It can't be done without URL Rewrite Filter from http://www.tuckey.org/urlrewrite/ .

Though I could easily wget the zip file to my Ubuntu server, Unzip is not installed, therefore, and I was unsuccessful trying to gunzip or gzip –d the zip file. I didn't want to get started downloading every little thing available whenever it was needed so I chose to download to my PC and FTP to a directory my FTP account could access. I chose the binaries zip file from http://www.tuckey.org/urlrewrite/ , unzipped into my PC, and FTP'ed up to the server.

Once on the server move the lib to my tomcat/lib directory

view plain print about
1admin@railo:/opt/railo/tomcat$ sudo mv webapps/ROOT/mysite.com/mysite/assets/urlrewrite-3.2.0.jar lib/
2admin@railo:/opt/railo/tomcat$ ls -la lib/
3total 5224
4drwxr-xr-x 2 railo railo 4096 2011-01-26 14:20 .
5drwxr-xr-x 9 railo railo 4096 2011-01-04 12:14 ..
6-rw-r--r-- 1 railo railo 15240 2010-12-17 16:37 annotations-api.jar
7-rw-r--r-- 1 railo railo 53752 2010-12-17 16:37 catalina-ant.jar
8-rw-r--r-- 1 railo railo 129627 2010-12-17 16:37 catalina-ha.jar
9-rw-r--r-- 1 railo railo 1191060 2010-12-17 16:37 catalina.jar
10-rw-r--r-- 1 railo railo 235004 2010-12-17 16:37 catalina-tribes.jar
11-rw-r--r-- 1 railo railo 32384 2010-12-17 16:37 el-api.jar
12-rw-r--r-- 1 railo railo 108570 2010-12-17 16:37 jasper-el.jar
13-rw-r--r-- 1 railo railo 525001 2010-12-17 16:37 jasper.jar
14-rw-r--r-- 1 railo railo 1407902 2010-12-17 16:37 jasper-jdt.jar
15-rw-r--r-- 1 railo railo 76693 2010-12-17 16:37 jsp-api.jar
16-rw-r--r-- 1 railo railo 88224 2010-12-17 16:37 servlet-api.jar
17-rw-r--r-- 1 railo railo 758137 2010-12-17 16:37 tomcat-coyote.jar
18-rw-r--r-- 1 railo railo 249650 2010-12-17 16:37 tomcat-dbcp.jar
19-rw-r--r-- 1 railo railo 70035 2010-12-17 16:37 tomcat-i18n-es.jar
20-rw-r--r-- 1 railo railo 51966 2010-12-17 16:37 tomcat-i18n-fr.jar
21-rw-r--r-- 1 railo railo 55037 2010-12-17 16:37 tomcat-i18n-ja.jar
22-rw-r--r-- 1 admin admin 198436 2011-01-26 14:17 urlrewrite-3.2.0.jar

Then change group and ownership to railo:

view plain print about
1admin@railo:/opt/railo/tomcat$ sudo chown railo.railo lib/urlrewrite-3.2.0.jar
2admin@railo:/opt/railo/tomcat$ ls -la lib/
3total 5224
4drwxr-xr-x 2 railo railo 4096 2011-01-26 14:20 .
5drwxr-xr-x 9 railo railo 4096 2011-01-04 12:14 ..
6-rw-r--r-- 1 railo railo 15240 2010-12-17 16:37 annotations-api.jar
7-rw-r--r-- 1 railo railo 53752 2010-12-17 16:37 catalina-ant.jar
8-rw-r--r-- 1 railo railo 129627 2010-12-17 16:37 catalina-ha.jar
9-rw-r--r-- 1 railo railo 1191060 2010-12-17 16:37 catalina.jar
10-rw-r--r-- 1 railo railo 235004 2010-12-17 16:37 catalina-tribes.jar
11-rw-r--r-- 1 railo railo 32384 2010-12-17 16:37 el-api.jar
12-rw-r--r-- 1 railo railo 108570 2010-12-17 16:37 jasper-el.jar
13-rw-r--r-- 1 railo railo 525001 2010-12-17 16:37 jasper.jar
14-rw-r--r-- 1 railo railo 1407902 2010-12-17 16:37 jasper-jdt.jar
15-rw-r--r-- 1 railo railo 76693 2010-12-17 16:37 jsp-api.jar
16-rw-r--r-- 1 railo railo 88224 2010-12-17 16:37 servlet-api.jar
17-rw-r--r-- 1 railo railo 758137 2010-12-17 16:37 tomcat-coyote.jar
18-rw-r--r-- 1 railo railo 249650 2010-12-17 16:37 tomcat-dbcp.jar
19-rw-r--r-- 1 railo railo 70035 2010-12-17 16:37 tomcat-i18n-es.jar
20-rw-r--r-- 1 railo railo 51966 2010-12-17 16:37 tomcat-i18n-fr.jar
21-rw-r--r-- 1 railo railo 55037 2010-12-17 16:37 tomcat-i18n-ja.jar
22-rw-r--r-- 1 railo railo 198436 2011-01-26 14:17 urlrewrite-3.2.0.jar

Now move the ulrewrite.xml to the appropriate WEB-INF directory:

view plain print about
1admin@railo:/opt/railo/tomcat$ sudo mv webapps/ROOT/mysite.com/mysite/assets/urlrewrite.xml webapps/ROOT/WEB-INF/

Don't forget to change ownership:

view plain print about
1admin@railo:/opt/railo/tomcat$ sudo chown railo.railo webapps/ROOT/WEB-INF/urlrewrite.xml

Now you can follow these very clear instructions from Adam Presley and Steve Good.

http://blog.adampresley.com/2010/ses-urls-with-mura-on-tomcat/
http://stevegood.org/blog/rewriting-urls-with-railo-resin-for-mura-cms/

But there are some differences....

My /opt/railo/tomcat/webapps/ROOT/WEB-INF/web.xml contained only:

view plain print about
1<web-app xmlns="http://java.sun.com/xml/ns/javaee"
2 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
3 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
4 version="2.5">

5
6 <display-name>Welcome to Tomcat</display-name>
7 <description>
8 Welcome to Tomcat
9 </description>
10</web-app>

So I added this right after the <description> tag

view plain print about
1<!-- URL Rewrite Filter -->
2 <filter>
3 <filter-name>UrlRewriteFilter</filter-name>
4 <filter-class>org.tuckey.web.filters.urlrewrite.UrlRewriteFilter</filter-class>
5 <init-param>
6 <param-name>logLevel</param-name>
7 <param-value>WARN</param-value>
8 </init-param>
9 </filter>
10 <filter-mapping>
11 <filter-name>UrlRewriteFilter</filter-name>
12 <servlet-name>CFMLServlet</servlet-name>
13 </filter-mapping>
14
15 <!-- SES URL pattern -->
16 <servlet-mapping>
17 <servlet-name>CFMLServlet</servlet-name>
18 <url-pattern>/index.cfm/*</url-pattern>
19 </servlet-mapping>

There is a /opt/railo/tomcat/conf/web.xml which contains all the mappings and all the other servlet-mappings.

In urlrewrite.xml in the same /WEB-INF/ folder this was added under the /test/status/ rule

view plain print about
1<rule>
2        <note>
3            Makes all requests forward to /index.cfm/whatever-came-next
4            Ignores admin URLs so the admin still works correctly for Mura.
5        </note>
6        <from>^/(?!admin|plugins|js|css|assets|images|tasks|railo-context|flex2gateway|wysiwyg)(.*)$</from>
7        <to>/index.cfm/$1</to>
8    </rule>

Railo Tomcat 404 redirects and CGI vars

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

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

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

Here are some of the cfdumps I've tried:

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

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

How to Set Up Mura Staging and Production Sites

The client/customer/company wants a separate Staging and Production server. They are not interested in using Mura's preview, draft and publish functionality.

The site is running:
Mura
-Core Version 5.3.3088
-Site Version 5.3.2831
Railo 3.2.1.000 final
Ubuntu 10.04.1 LTS 32 bit

Fortunately, setting up a staging and production server in Mura cannot be easier. There are a few things you should know first though.

  1. Your staging and production server have to be on the same machine.
  2. If it's a VM, virtual machine, the servers will both have to be within the same VM.
  3. You will need to put your production site's datasource in your Railo/CF engine's site.

Follow these directions straight off of Mura's site
http://docs.getmura.com/index.cfm/installation-set-up/staging-to-production-deployment/

Instance Deployment

  1. Install an instance of Mura on each server
  2. Make sure you have site(s) in each install with identical siteid(s) in both instances.
  3. Update appropriate connectToStaging script to reflect database name (if it's not muraDB). These scripts can be found in /config/setup/db/connectToStaging/*.sql.
  4. Run the connectToStaging script on the Production database

NOTE: I did not run the connectToStaging script because when I created the 2nd site, it was a complete copy of the other. The database too. As the sites were identical, I felt I didn't need to take this synchronization step.

The production instance should be ready to go at this point, and next you will set up the Staging instance to push content and assets to the Production instance.

Staging Instance Configuration

  1. Open settings.ini.cfm
  2. Set mode (mode=staging) in settings.ini.cfm
  3. Change the word "production" between the brackets ( [production] ) in the second set of settings to [staging]
  4. Set the following values to tell the staging instance where to push content and assets. These are just example settings and may not reflect your actual environment.
  5. view plain print about
    1productionDatasource=muraDB
    2 productionAssetPath=/tasks/sites
    3 productionWebroot=C:\Inetpub\mura\www
    4 productionFiledir=C:\Inetpub\mura\www\tasks\sites

    NOTE: In my case I only changed the productionDatasource and productionWebroot and left the others blank. productionAssetPath and productionFiledir both associate with AssetPath and Filedir which are both optional.

  6. In Site Settings, set your deployment preference to autodeploy or manual. Manual deployment can happen anytime (even if autodeploy is selected) by clicking the "lightning bolt" icon in the far right column.

For Production Here are a few more things I would recommend doing:

  1. Remove all but maybe 1 or 2 users from the Production Mura Admin.
  2. Turn off your Railo Administrator, or block access. See ColdFusion Joe - Hide, block and secure railo-context from your Railo Tomcat, JBoss, Resin servers
  3. Turn off your Mura Admin in production - using the urlrewrite filter. For details, see: ColdFusion Joe - SES URLs With Mura on Tomcat. Here's what we did differently with production's urlrewrite.xml

    view plain print about
    1<rule>
    2 <note>
    3 Makes all requests forward to /index.cfm/whatever-came-next
    4 Ignores admin URLs so the admin still works correctly for Mura.
    5 took 'admin' out of regex to turn off Mura admin - other stuff works.
    6 </note>
    7 <from>^/(?!plugins|js|css|assets|images|tasks|railo-context|flex2gateway|wysiwyg)(.*)$</from>
    8 <to>/index.cfm/$1</to>
    9 </rule>

    I just took "admin" out of the regular expression we are using to allow directories.

That is all you need to set up a staging and production environment in Mura. It's pretty easy. Something that may not be easy is figuring out where to "deploy the site to production" the site. I call it "promoting the site to production". As a super admin in Mura, click on Site Settings in the right side of the top yellow bar. You'll see your site. Just click on the little green sperm cell with an arrow head - lightening bolt?

SES URLrewrite Filter to Hide index.cfm

So you need to hide index.cfm from the browser for pretty SES URLs for sites on Railo/Tomcat/Ubuntu and no Apache.

First, you will need the Url Rewrite Filter (http://tuckey.org/urlrewrite/).

See the related entry to see how to install and configure.

Modify your urlrewrite.xml to include:

view plain print about
1<urlrewrite>
2 <rule>
3 <note>
4 Enable TomCat to have SES links.
5 </note>
6 <condition type="request-uri" operator="notequal">\.(bmp|gif|jpe?g|png|css|js|txt|pdf|doc|xls|xml|cfc|ico)$</condition>
7 <from>^/(?!cdn|src|railo-context)(.*)$</from>
8 <to>/index.cfm/$1</to>
9 </rule>
10</urlrewrite>

Restart Railo/Tomcat

view plain print about
1sudo service railo_ctrl restart

Now you should see directory paths in your URL without the preceding index.cm.

Reference:
http://groups.google.com/group/railo/browse_thread/thread/fe19d30f1cccff7d?pli=1
http://aarongreenlee.com/share/url-rewrite-tomcat/

More Entries

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