Confused MySQL connections in web page error

Somewhere within Catalina, Tomcat or the MySQL connection something got mixed up…?

I tried uninstalling and reinstalling Lucee but have not been able to clear this error. It references a user (applianc_DBA1) that is not tied to the database nor the datasource I’m referencing in my code. But is referencing another user that I used prior with another datasource connection that is not even listed in any of the current datasources. I removed all of them when reinstalling Lucee. I only have one datasource listed and the user for this connection is (admin), not applianc_DBA1.

How can I clear the old info that’s causing this confusion so I can get the correct info from my datasource to get applied? Any ideas would be very much appreciated!

Lucee Error (database)
Message The user specified as a definer (‘appliancDBA1’@‘%’) does not exist…

DatabaseName MySQL
DatabaseVersion 5.7.10
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.30 (Revision: 1de2fe873fe26189564c030a343885011412976a)
Datasource cstone3
Stacktrace The Error Occurred in
C:\inetpub\wwwroot\\cstone\includes\invoicequeries.cfm: line 29

Java Stacktrace lucee.runtime.exp.DatabaseException: The user specified as a definer (‘appliancDBA1’@‘%’) does not exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(

I found the culprit!

For some reason user-defined functions in my queries cause this issue to happen…any idea why?

Interested readers will find this issue was raised by the OP in another thread today, with more detail, and where Dom has offered the seeming answer.

1 Like