Trim characters off of right on a string

Trim characters off of right on a string. Trim off a certain number of characters on the right side of a string. Here's a quick easy method to cut off an exact number off the right portion without reversing the string and using various other string manipulation techniques. The concept is simple, find the length of the string

view plain print about
1len(MyString)
and then subtract the number of characters you want removed, e.g., 3
view plain print about
1len(MyString) - 3
We just use this result to count thenumber of characters from the left and keep those using left() function.
view plain print about
1left(MyString, (len(MyString) - 3))

CFM Pages Not Working After Server IP Change

BlueOnyx JSP and Servlets, including ColdFusion, CFM, CFML, Railo templates do not run after changing the IP address of the site and server. CFM displays as text.

Datacenter adjustments forced a change in IP addresses for my BlueOnyx server. The IP address of the server, and subsquently, the IP addresses of each of the sites within, had to be changed. Not a big issue, but then all of the CFM pages displayed as text. Not cool.

When the IP address was changed through the BlueOnyx Admin GUI, all of the vhosts were changed, inadvertantly dropping the JSP and Servlet switches. This can be added back either manually entering or through the GUI.

Option 1
Manually entering: find your SiteID for the site.

view plain print about
1basename $(ls -l /home/sites/| grep www.example.tld | awk '{ print $11}')

Then edit the vhosts file, using the correct SiteID

view plain print about
1vi /etc/httpd/conf/vhost/site1

adding back the JSP code:

view plain print about
1# BEGIN JSP SECTION. DO NOT EDIT MARKS OR IN BETWEEN.
2JkMount /* ajp13
3JkMount /*.jsp ajp13
4JkMount /servlet/* ajp13
5# END JSP SECTION. DO NOT EDIT MARKS OR IN BETWEEN.

Then restart httpd:

view plain print about
1/etc/init.d/httpd restart

Now you should be serving up those fancy CFM pages.

Option 2
Through the GUI, in the Web settings for the site, uncheck Enable JSP and Servlets and save. When it finishes saving and resetting, recheck or enable Enable JSP and Servlets and save. This will add 2 lines of the above code block, but you still need to add this to run CFML.

view plain print about
1JkMount /* ajp13

So you still have to edit vhosts (SiteID!)

view plain print about
1vi /etc/httpd/conf/vhost/site1

Change the JSP section from this:

view plain print about
1# BEGIN JSP SECTION. DO NOT EDIT MARKS OR IN BETWEEN.
2JkMount /*.jsp ajp13
3JkMount /servlet/* ajp13
4# END JSP SECTION. DO NOT EDIT MARKS OR IN BETWEEN.
to this:
view plain print about
1# BEGIN JSP SECTION. DO NOT EDIT MARKS OR IN BETWEEN.
2JkMount /* ajp13
3JkMount /*.jsp ajp13
4JkMount /servlet/* ajp13
5# END JSP SECTION. DO NOT EDIT MARKS OR IN BETWEEN.

Then restart httpd:

view plain print about
1/etc/init.d/httpd restart

Back in business, running your fantastice CFML site!

RegEx for Numbers and Dollar Signs and Periods or Commas

Need some regular expressions for numbers with dollar signs and commas or periods?

I came across a scenario where we needed to filter field values which could possibly include text and all other string characters and just perform action on some dirty numbers. By dirty numbers I mean data for money and square footage, which would include dollar signs ($), periods (.) and commas (,).

The data needed to be filtered to determine if did just contain numbers, AND commas, dollar signs or periods. Any fields with text or other characters were to be ignored.

Here is the regular expression, reg ex, used:

view plain print about
1^[,0-9\.\$]+$

The CFML REFind check looks like this:

view plain print about
1REFind("^[,0-9\.\$]+$", fieldValue)
with "fieldValue" being the variable.

We just wanted to remove the commas from all numeric values and change commas in text values to semi colons. The whole regex check and action looks like this:

view plain print about
1<cfif REFind("^[,0-9\.\$]+$", fieldValue)>
2 <cfset fieldValue = Replace(fieldValue,",","","ALL")>
3 <cfelse>
4 <cfset fieldValue = Replace(fieldValue,",",";","ALL")>
5</cfif>

Just a few minor notes... The dollar sign ($) and period (.) are special characters and have to be escaped by preceding with a forward slash (\).

Here are some example tests used:

view plain print about
112344,234,345 = #ReFind("^[,0-9\.\$]+$","12344,234,345")#<br/>
2$12344,234,345 = #ReFind("[,0-9\.\$]+$","$12344,234,345")#<br/>
3$12344,234.345 = #ReFind("[,0-9\.\$]+$","$12344,234.345")#<br/>
412344.234.345 = #ReFind("^[,0-9\.\$]+$","12344.234.345")#<br/>
5as$dfa2,32344 = #ReFind("^[,0-9\.\$]+$","as$dfa2,32344")#<br/>
6asdfasdf,rt$yu = #ReFind("^[,0-9\.\$]+$","asdfasdf,rt$yu")#<br/>
7$123412.4567 = #ReFind("^[,0-9\.\$]+$","$123412.4567")#<br/>
8asdfa,12341.3456.sdfg,dgfh = #ReFind("^[,0-9\.\$]+$","asdfa,12341.3456.sdfg,dgfh")#<br/>
9It cost me $33.00 = #ReFind("^[,0-9\.\$]+$","It cost me $33.00")#<br/>
10It cost me $33 = #ReFind("^[,0-9\.\$]+$","It cost me $33")#<br/>
11It cost me 33.00 = #ReFind("^[,0-9\.\$]+$","It cost me 33.00")#<br/>

can't cast String [] to a value of type [numeric]

Railo Error Message
invalid call of the function getJerseyColor (), first Argument (Color) is of invalid type, can't cast String [] to a value of type [numeric]

Using a UDF (User Defined Function) created to convert a numeric value to a string within a returned query. We have an integer stored in the database table which represents a color value. It is much easier for the user to actually read the color name instead of mentally trying to convert the number to a the color value each time. We are actually looking at Jersey colors and Jersey numbers, so coaches and evaluators can quickly and easily identify each player.

Here's the UDF:

view plain print about
1<cffunction name="getJerseyColor">
2    <cfargument name="Color" type="numeric" required="true" />
3    <cfset var JerseyColor = "" />
4    <cfswitch expression="#arguments.Color#">
5        <cfcase value="1">
6            <cfset JerseyColor = "Yellow" />
7        </cfcase>
8        <cfcase value="2">
9            <cfset JerseyColor = "Blue" />
10        </cfcase>
11        <cfcase value="3">
12            <cfset JerseyColor = "Purple" />
13        </cfcase>
14        <cfcase value="4">
15            <cfset JerseyColor = "Yellow/Blue" />
16        </cfcase>
17        <cfcase value="5">
18            <cfset JerseyColor = "Green/Blue" />
19        </cfcase>
20    </cfswitch>
21    <cfreturn JerseyColor />
22</cffunction>

Here's how the UDF is called:

view plain print about
1<cfset filterPlayer.Color = getJerseyColor(filterPlayer.Color) />

Here it is utilized replacing the returned query value for "Color":

view plain print about
1<cfquery name="filterPlayer" datasource="#application.datasource#">
2    SELECT     playerid    AS "ID",
3        rate1        AS "Color",
4        rate2        AS "Num"
5    FROM     tblplayerinfo
6</cfquery>
7<!--- make jersey color human readable --->
8<cfloop query="filterPlayer">
9    <cfset filterPlayer.Color = getJerseyColor(filterPlayer.Color) />
10</cfloop>

Now about the error....

Testing on development produced no error, while Production generated the error. Both columns in each MySQL database were numeric, of type smallint(6) and defaulted to Null. In this case, we are talking about "rate1" column aliased as "Color". The only difference between the two database columns was that the development MySQL database had actual numeric values in each row. Production had Null values in every "rate1" column row.

Doing a little reasearch, mainly Googling "can't cast string to a number value" turned up some issues about Railo and null values while casting strings to numbers. Some pondering led to realization that the column needed non Null numeric values to allow the UDF to run.

The solution was to replace the Null values in the numeric int() column to actual numeric values. Setting to 0 (zero) worked. Now the UDF runs perfectly.

Adding Spaces to Column Name Alias in a Query of Query

How does one add a space to an alias of a column name in Railo, MySQL in a query of queries?

I ran into an issue when attempting to import a query data set as a CSV (comma seperated value). The application to which I was importing required that the CSV column names have spaces, e.g., "Mom Email", "Mom Phone". My column headers correctly did not have any spaces, e.g., "momemail", "momphone". The way to change the column headers was to alias them with the "AS" statement and quotes.

My initial error message was:

Encountered "\"First Name\"" at line 1, column 25.
Was expecting one of:
"AS" ...
"FROM" ...
...
"," ...
"." ...
"+" ...
"-" ...
"*" ...
"||" ...
"/" ...
"**" ...
".*" ...
"(" ...

My query was:

view plain print about
1<cfquery name="filterPlayer" dbtype="query">
2SELECT     firstname     AS "First Name",
3    lastname     AS "Last Name",
4    homephone     AS "Home Phone",
5    cellphone     AS "Cell Phone",
6    dadphone     AS "Dad Phone",
7    momphone     AS "Mom Phone",
8    email         AS "Email",
9    dademail     AS "Dad Email",
10    momemail     AS "Mom Email"
11FROM     getPlayers
12ORDER BY lastname
13</cfquery>

The first thing to look for is the double quotes around the alias. AS "First Name". You will also note the dbtype="query", the query is a query-of-queries. The original query is "getPlayers" as seen in the FROM getPlayers statement.

The query appears to be formed correctly, which was really confusing.

The solution was to change the query from a query-of-queries to query the database directly. I changed the "dbtype=query" to datasource=#application.datasource#" and reference the table name in the FROM statement, as shown below, and I was able to add the space into the alias name as expected.

view plain print about
1<cfquery name="filterPlayer" datasource="#application.datasource#">
2SELECT     firstname     AS "First Name",
3    lastname     AS "Last Name",
4    homephone     AS "Home Phone",
5    cellphone     AS "Cell Phone",
6    dadphone     AS "Dad Phone",
7    momphone     AS "Mom Phone",
8    email         AS "Email",
9    dademail     AS "Dad Email",
10    momemail     AS "Mom Email"
11FROM     tblplayerinfo
12ORDER BY lastname
13</cfquery>

Railo MySQL Error with last_insert_id()

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT last_insert_id() as newplayerid' at line ##.

Using Railo, MySQL and a SELECT last_insert_id() just after an INSERT query threw an error. It's not a problem with last_insert_id().

First, to explain what LAST_INSERT_ID() is in MySQL. If you insert a record into a table that contains an AUTO_INCREMENT column you can obtain the value stored in that column for the most recently inserted row. Instead of running an INSERT query and than attempting to find out the newly generated ID by following up with a SELECT query using the same WHERE values from the INSERT query, LAST_INSERT_ID() will return it for you.

Example:

view plain print about
1<cfquery datasource="#application.datasource#" name="registrationInsert">
2INSERT INTO tblplayerinfo (firstname,lastname,birthdate,region,
3email,cellphone,homephone)
4VALUES (    
5 <cfqueryparam value="#form.firstname#" cfsqltype="cf_sql_varchar"/>,
6 <cfqueryparam value="#form.lastname#" cfsqltype="cf_sql_varchar" />,
7 <cfqueryparam value="#form.birthdate#" cfsqltype="cf_sql_date" />,
8 <cfqueryparam value="#form.region#" cfsqltype="cf_sql_varchar" />,
9 <cfqueryparam value="#form.email#" cfsqltype="cf_sql_varchar" />,
10 <cfqueryparam value="#form.cellphone#" cfsqltype="cf_sql_varchar" />,
11 <cfqueryparam value="#form.homephone#" cfsqltype="cf_sql_varchar" />
12);
13SELECT last_insert_id() as newplayerid;
14</cfquery>

The select query at the bottom will return the the newly generated auto incremented ID as "newplayerid" referenced in ColdFusion or CFML as the variable "registrationInsert.newplayerid", in this case.

This variable can now be referenced for other purposes, such as:

view plain print about
1<cfset session.playerid = registrationInsert.newplayerid />

or with <cflogin> which, in this case, allowed the user to come back and edit their player information.

OK, so I made you read a whole bunch of stuff about last_insert_id() without giving the answer to the Railo error, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT last_insert_id() as newplayerid' at line XX"/

The Answer:
Make sure that "Allow multiple Queries" is set to TRUE in the Railo admin for your datasource and that you actually seperate your queries with a semicolon(";") in your coded CFML query, <cfquery>.

The answer is a simple as that.

Preventing Browser Back Button Resubmissions

How do you prevent a form resubmission using the back browser button?

This problem came up for me on some old legacy code, a shopping cart. A user would go through the view cart form, the shipping section and then click the checkout button. If the user would then click on the browser back button, the same checkout form and checkout button would display. The user could then click the checkout button again and reorder, submitting the exact same information.

There's all kinds of things wrong with this scenario but I will just offer a couple of solutions.

First off the best way to prevent this browser back button resubmission is to have a 3 template process.

  1. The form template
  2. The action template where the form is processed, query inserts, cfmail, etc.
  3. The redirection page or thank you page.
The end of your action template would have a redirection to the thank you page. After all the code to process the submitted form variables, down at the bottom, have a to the thank you template. When the user attempts to hit the back browser button, the page will have expired. It would be best if you had code accepting submissions only from the original form template, with a redirection to a 404 or some other page.

Another solution could be to attempt to disable the browser back button with JavaScript. A little research revealed that this was not the proper methodology, interfering with the user's experience, and other ethical or touch feely rationale. Plus it occurred to me that this would probably not work on all browsers and probably take a while to come up with a thoroughly safeguarded JavaScript. Pass.

In my case, I didn't want to rewrite a whole bunch of existing and mostly operating code, so I came up with another solution. The code with which I was working had the thank you template included in the action template. It could not easily have been broken out, there were too many variables set within the action template that were required within the thank you page. The thank you template was a complete order review for the transaction.

The minimalistic approach that I took was to create and add this bit of code:

view plain print about
1<!--- to prevent resubmission using browser back button --->
2<cfif structKeyExists(session,"submittedAlready")>
3    <cfset StructDelete(session,"submittedAlready") />
4    <cflocation url="viewCart.cfm" addtoken="false" />
5<cfelse>
6    <cfset session.submittedAlready = "true" />
7</cfif>

Let's go over this snippet starting with the 5th line.

view plain print about
1<cfset session.submittedAlready = "true" />

We are setting a session variable that tells us the form has been submitted and processed already. If the user attempts to go back using the browser back button and resubmit the same form, we catch it with our check for the existence of that specific session variable.

view plain print about
1<cfif structKeyExists(session,"submittedAlready")>

If it has been submitted, we redirect, in this case, back to their empty cart. You could redirect to a notification of attempted resubmission too. That's up to you.

I threw in the StructDelete, deleting the existence of the session variable because:

  1. We don't need the session variable anymore, and
  2. It would block the user from using the form again. The user may have to go back and order something else they had forgotten, or submit different information using the same form. If we do not clear out this session variable, it will prevent them from filling out the form with new information.

One more thing. Where do we place this code?
It goes on your action template before you do any form processing.

And there you have the quick and easy way to prevent users browsing backwards to the same form and resubmitting the same information – repeating submissions.

Mura on Railo and BlueOnyx

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

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

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

I received this error:

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

We need to adjust permissions

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

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

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

This will allow site members to FTP files.

This will fix the permission denied for the config stuff

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

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

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

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

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

add the following lines:

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

Restart tomcat.

view plain print about
1/sbin/service tomcat5 restart

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

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

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

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

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

Mura on Ubuntu, Railo and MySQL.

Error:

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

Mura Railo ErrorCode 0 Page not Found

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

More Entries

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