Copy link to clipboard
Copied
I just upgraded a server from ACF 2016 to ACF 2018 and I started receiving a strange java.lang.ArrayIndexOutOfBoundsException error message on some Query of Query (QofQ) statements. What's strange is that the exception only occurs when I have SELECT * in the statement. When I actually specify the columns by name, the exception goes away.
Unfortunately I can't replace the issue on www.trycf.com because I need an actual database query to start from.
Here's a simplified example of a query that throws the exception:
<cfquery dbtype="query" name="tempInvoices">
SELECT *
FROM invoices
</cfquery>
<cfquery dbtype="query" name="tempInvoices">
SELECT #invoices.columnList# <!--- I can also list out the columns and it works --->
FROM invoices
</cfquery>
The exception looks like this:
Has anyone else encountered this before? This feels like a bug in ACF 2018 since it worked in ACF 2016 and earlier.
Edit: This may be the result of a bug introduced in ACF 2018 Update 12 as noted here:
https://tracker.adobe.com/#/view/CF-4212389
My example doesn't have the ORDER BY column like the example in the bug report, but it sounds like similar behavior. Hopefully the fix will be included in the next update.
Update: This appears to be the same issue as discussed here:
Copy link to clipboard
Copied
Update: This appears to be the same issue as discussed here:
Find more inspiration, events, and resources on the new Adobe Community
Explore Now