Cart: USD $0.00   

Navigation

Product Search

Categories

    All Categories
    Products  
       Acrylic Awards  
       Glass Awards  
       Plaques  
       Trophies & Cups  
       Desk Items  
       Plates & Badges  
       Clocks  
       Frames  
       Metal Binders  
       Pens  
       Sterling Silver  
       Props  
       Pocket Items  
       Custom  
       Medals  
    Gifts For  
       Fun  
       Men  
       Women  
       Wedding  
       Baby  
       New Home  
       New Job  
       Retirement  
       Graduation  
       sports  
       Pet  
    Services  
       Logo  

Other Links

    Font Sample Page
  
    Engraving Samples
  
    Medal Engraving
  
    Digital Kiosk
  
    Home Page
  
    View Cart
  
    Checkout
  
    About Us
  
    Contact Us
  
    My Account
  
    Site Map
  
    The Trick To Engraving
  
    Alpha Engraving Other Links
  
    Quotes Samples
  
    Privacy Policy
  




Email List


Join Our Email List!

Name:
Email:

 
 
  

Lucee 4.5.4.017 Error (database)
Message
Detail Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
SQL
SELECT *
FROM productlangs
WHERE LangID = '1'
AND ItemID = '220⊂mit=fast'
DatabaseName MySQL
DatabaseVersion 5.1.73
DriverName MySQL-AB JDBC Driver
DriverVersion mysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasource alphaengraving_dbase
Stacktrace The Error Occurred in
/Queries/qryProductLangs.cfm: line 6
4: WHERE LangID = '#Application_Lang#'
5: <cfif IsDefined('ItemID')>AND ItemID = '#ItemID#'</cfif>
6: </cfquery>

called from /Standard_temp_top_item.cfm: line 48
called from /temp_top_item.cfm: line 4
called from /Catalog/CatalogDetails.cfm: line 4
called from /index.cfm: line 89
Java Stacktrace
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073):1073
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096):4096
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028):4028
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490):2490
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651):2651
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677):2677
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627):2627
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:841):841
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681):681
  at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:37):37
  at lucee.runtime.db.driver.state.StateStatement.execute(StateStatement.java:43):43
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:232):232
  at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243):243
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:802):802
  at lucee.runtime.tag.Query.doEndTag(Query.java:604):604
  at queries.qryproductlangs_cfm$cf.call(/Queries/qryProductLangs.cfm:6):6
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925):925
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858
  at standard_temp_top_item_cfm$cf.call(/Standard_temp_top_item.cfm:48):48
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925):925
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858
  at temp_top_item_cfm$cf.call(/temp_top_item.cfm:4):4
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925):925
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858
  at catalog.catalogdetails_cfm$cf.call(/Catalog/CatalogDetails.cfm:4):4
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925):925
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858
  at index_cfm$cf.call(/index.cfm:89):89
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925):925
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:58):58
  at lucee.runtime.listener.ClassicAppListener.onRequest(ClassicAppListener.java:42):42
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2268):2268
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2231):2231
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219):219
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518):518
  at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844):844
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668):668
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1527):1527
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1484):1484
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
  at java.lang.Thread.run(Thread.java:745):745
 
Timestamp 7/16/19 10:27:54 AM PDT