cfml

Hello.  I have a strange problem.  I just moved servers as well as upgraded to CF2023/MySQL 8.  I've got a production environment and a staging environment.  As far as I can tell they are identical.

I have some cfquery tags (not script) where I have &lt;cfif&gt; statements inside the SQL.  It works fine on production but throws a DB error in staging.  The DB error throws an access denied error even though all other queries work for the same credentials.  For the line, it gives the line that the &lt;cfif&gt; is on.  Any ideas?

Exact same code in both environments.

Okay, finally figured it out.  The staging server had an incorrect DEFINER statement in one of the defined views.  It was a different user.