Excitron Logo
    Cart: US $0.00   

make it a Great day!



Product Search

Categories

    All Categories
    X Controller-
     motors
  
    Controller-motor-
     gearhead kits
  
    Stepper Motors  
    Bearings  
    Custom hardware  
    Accessories  
    Arbor Presses  
    Cables & Adaptors  
    Computers  
    CNC Machines/kits  
    DRO  
    Encoders  
    Gears and Racks  
    Grippers & Rovers  
    Leadscrews  
    Planetary Gears  
    Power Supplies  
    Pulleys and Belts  
    Rotary Chucks  
    Rotary Tables  
    Shaft Couplers  
    Sliders  
    USB Products  
    XY & XZ Robots  
    XYZ Robots  
    Z-Lifts  
    Previous Products  
    Coming soon  
    Donations  

Other Links

    Documentation
  
    Motor Information
  
    CNC and Gcode help
  
    How to Buy
  
    FAQ
  
    Testimonials
  
    Serial programs
  
    US Postal rates
  
    Checkout
  
    My Account
  
    Site Map
  
    Add item/adjust
  


 
  

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 = '244⊂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 excitron_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/22/19 3:24:14 AM PDT