not equal to null not working

In MSSQL, looking for rows that are not equal to a certain value does not return rows with null values. To retrieve all values that are not equal and are null, you have to add both clauses "not equal" and "is null" to return all values not equal.

In SQL checking for NOT EQUAL ("!=" or "<>") will not return NULL values. NULL has no value and cannot be compared using scalar value operators.

I had to change my WHERE clause from:

view plain print about
1[whatever] != 1
To
view plain print about
1([whatever] != 1 OR [whatever] is null)

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.

MS SQL Select Yesterdays Date

How do you find MS SQL now() minus one day? Select today minus one day? Select today only?

MS SQL uses GETDATE() instead of MySQL NOW() to retrieve the current date time stamp.

Backing out mistakes....
Playing around with data in MS SQL Server, I inadvertently added some duplicate rows. Wanting to back out the changes just made, my erroneous creation of duplicate rows. I thought about using:

view plain print about
1select distinct

but that only helped me see the differences between the duplicate records which had a CreateDate column.

To find the records that I had created today:

view plain print about
1select * from [dev].[dbo].[User] where UserId = 713 and createddate > (getdate() - 1)

To find all previous entries, before today, flip the Greater Than Sign (>) to Less Than (<):

view plain print about
1select * from [dev].[dbo].[User] where UserId = 713 and createddate < (getdate() - 1)

To remove my changes from today:

view plain print about
1delete from [dev].[dbo].[User] where UserId = 713 and createddate > (getdate() - 1)

No need to freak out!

BlogCFC tblblogpagescategories' doesn't exist

Table 'tblblogpagescategories' doesn't exist

Trying to add pages in BlogCFC 5.9.8.012 throws the error.

The reason is there was a table added in 5.9.8.11, but the readme.txt doesn't tell you which table was added. It also says the SQL files were updated for the new table BUT it fails to mention the installer was not updated. This means you have to get the error before you know to fix it. Once you figure all that out....

Just run the SQL for the new table, tblblogpagescategories:

view plain print about
1CREATE TABLE tblblogpagescategories (
2 categoryidfk varchar(35) NOT NULL,
3 pageidfk varchar(35) NOT NULL
4 )

Now you can add pages!

MySQL Workbench on LinuxMint 12

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

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

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

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

Backup and Restore MySQL Databases

Use the mysqldump command to back up your MySQL databases.

view plain print about
1mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

You cannot use the mysqldump command to restore the database. Use the mysql command instead.

view plain print about
1mysql -u root -p[root_password] [database_name] < dumpfilename.sql

To backup multiple databases:

view plain print about
1mysqldump -u root -p[root_password] --databases [database1_name] [database2_name] > dumpfilename.sql

To back up all of your databases:

view plain print about
1mysqldump -u root -p[root_password] --all-databases > all-databases.sql

And to restore all of your databases just omit the database name:

view plain print about
1mysql -u root -p[root_password] < all-databases.sql

This will work if you have multiple databases in your mysqldump file too.

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  
 

Duplicate entry '0' for key 'PRIMARY'

MySQL and Railo. The application was a port from MSSQL Server ColdFusion to MySQL. I was running custom 404 pages. When attempting to update the database with the CFM code, I was redirected to my custom 404 page with a ton of cfdumps. I debugged and narrowed it down to an INSERT statement.

The key is to debug with the standard Railo error templates. As soon as I switched back to the error.cfm in the Railo Web Admin and tried the application again, the following error resulted:

Duplicate entry '0' for key 'PRIMARY'

This makes sense. The primary key of the application's table was not set to auto increment when converted from MSSQL.

Take a look at your table:

view plain print about
1Mysql> describe tablename
2
3| Field | Type | Null | Key | Default | Extra |
4+------------+-----------+------+-----+---------+-------+
5| redirectID | int(10) | NO | PRI | NULL

This resolved that situation:

view plain print about
1Mysql> alter table tablename change column tablenameID tablenameID int(10) unsigned not null auto_increment;
2
3Mysql>describe tablename
4| Field | Type | Null | Key | Default | Extra |
5+------------+------------------+------+-----+---------+----------------+
6| redirectID | int(10) unsigned | NO | PRI | NULL | auto_increment

Now the application works as it was designed.

More Entries

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