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 5.3.10.120 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\appliancescheduler.com\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(SQLError.java:129)