Skip to main content
WolfShade
Legend
March 5, 2019
Question

CF11 u18 issue

  • March 5, 2019
  • 1 reply
  • 2847 views

Hello, all,

While still hoping for a fix from u15, we have applied u18 to one of our servers in production and are now getting the following:

"Diagnostics: The ValueList() function has an invalid parameter: getarchiveyears.articleYears. Parameter 1 of function ValueList which is now getarchiveyears.articleYears must be pointing to a valid query name.

The error occurred on line 323."

Earlier in this document, we have:

<cfquery name="getarchiveyears" datasource="#application.newsdsn#" cachedwithin="#CreateTimeSpan(0,0,10,0)#">
    SELECT
        DISTINCT TO_CHAR(TitleDATE,'YYYY') articleYears
    FROM
        news_2016
    WHERE
        TO_CHAR(TitleDATE,'YYYY') > '2009'
    ORDER BY
        articleYears DESC
</cfquery>

So, there's a valid query, named (oddly enough) getarchiveyears.

The line triggering the error is:

<cfset newsyears = ValueList(getarchiveyears.articleYears,',') />

So, why is it now suddenly not seeing the valid query named getarchiveyears???  Again, if I remove the cache attribute, then it errs once in a few tries.  But keeping the cache attribute, it errs EVERY TIME!  wtf???

And as with the u15, if we roll it back it's never an issue.  PLEASE FIX THIS!  We have top brass breathing down our necks because we are three updates behind.

V/r,

^ _ ^

    This topic has been closed for replies.

    1 reply

    EddieLotter
    Inspiring
    March 5, 2019

    Have you cfdumped the query name before the line that gives an error? If that also causes an error, cfdump the variables scope.

    It would be very interesting to see the state of the variables scope before the line that causes the error.

    WolfShade
    WolfShadeAuthor
    Legend
    March 5, 2019

    Hi, Eddie,

    I'll give that a shot.  I just added two CFDUMPs to the file and emailed our SA.  Once he's got that in place, I'll test it and report back.

    V/r,

    ^ _ ^