CORP & INT’L ORDERS | Wine & Spirits Clubs

Facebook Twitter Instagram | Contact | Track Orders | Sign In
Home Page
view your cart
  • Custom Engraving
  • Glam • Lux • Ltd
    • Glam
    • Lux
    • Ltd
  • On Sale
  • New
  • Top Gifts
  • eCatalog
  • Newsletter
Home Page
  • Must See
      • All Must See
      • Limited Releases
      • Celebrity Spirits
      • Pre-Sales
      • Staff Picks
      • New & Trending
      • Halloween
    • Featured

       

      Must See

      Johnnie Walker Blue Year Of The Tiger

      Johnnie Walker Blue Year of the Tiger

  • Spirits
      • All Spirits
      • Whiskey
        • Staff Picks
        • Scotch
        • Bourbon
        • Rye
        • Single Malts
        • Irish
        • Flavored Whiskies
      • Tequila & Mezcal
        • Staff Picks
        • Blanco
        • Reposado
        • Añejo
        • Extra Añejo
        • Mezcal
      • Cognac & Brandy
        • Staff Picks
        • Cognac
        • Armagnac
        • Calvados
        • Pisco
        • Grappa
        • Brandy & Eau de Vie
      • Vodka
        • Staff Picks
        • Domestic Vodka
        • Imported Vodka
        • Specialty Flavors
      • Gin
        • Staff Picks
        • Domestic Gin
        • Imported Gin
        • Specialty Flavors
      • Rum
        • Staff Picks
        • White
        • Gold
        • Spiced
        • Dark
        • Aged
      • Liqueurs & Mixology
        • Fruit Liqueurs
        • Cream Liqueurs
        • Spice & Coffee Liqueurs
        • Vermouth & Amaro
        • Aperitif & Digestif
        • Craft Cocktail Ingredients
      • Other Spirits
        • Absinthe
        • Cachaca
        • Sotol
        • Sochu & Soju
        • Alcohol-Free
    • Featured

       

      Spirits

      Don Julio Primavera

      Don Julio Primavera

  • Wine
      • All Wine
      • Staff Picks
      • Rosé
      • Port & Dessert Wines
      • Certified Organic
      • Specialty Wines
      • Rare & Exceptional
      • Red     
        • Cabernet Sauvignon
        • Pinot Noir
        • Merlot
        • Malbec
        • Red Blends
        • All Red Wines
      • White
        • Chardonnay
        • Sauvignon Blanc
        • Pinot Grigio
        • All White Wines
    • Featured

       

      Wine

      caymus cabernet sauvignon 2021

      Caymus Cab Sauv 2022

    •  

       

      Wine

      La Poussie Sancerre 2022

      La Poussie Sancerre 2022

  • CHAMPAGNE
      • All Champagne
      • Staff Picks
      • Champagne
      • Sparkling Wines
    • Featured

       

      Champagne

      Dom Perignon Champagne 2015 750ml

      2015 Dom Perignon

    •  

       

       

      La Marca Prosecco NV

      La Marca Prosecco NV

    •  

       

       

      Louis Roederer Collection 242 NV

      Louis Roederer Collection 243 NV

  • Beer & More
      • All Beer & More
      • Staff Picks
      • Beer
      • Cider
      • Hard Seltzer
      • Ready-to-Drink Cocktails
    •  

       

      Beer & More

      Stella Artois 12-pack

      Stella Artois 12-pk

    • Featured

       

      Beer & More

      Hella Pineapple Margarita 4pk

      Hella Pineapple Margarita 4pk

    •  

       

      Beer & More

      White Claw Hard Seltzer Variety 12 Pack No 2

      White Claw Variety No 2

  • SAKE
      • All Sake
      • Junmai
      • Junmai Ginjo
      • Junmai Daiginjo
      • Plum Wine
      • Nigori
      • Shochu
    • Featured

       

      Junmai Daigingo

      Dassai 45 Junmai Daiginjo

      Dassai 45 Junmai Daiginjo Sake

  • Gift Baskets
      • All Gift Baskets
      • Spirits Baskets
      • Wine Baskets
      • Champagne Baskets
      • Beer Baskets
      • Gourmet Snack Baskets
      • Create a Custom Basket
      • Specialty Baskets
        • Floral Baskets
        • Fresh Fruit
        • Spa & Relaxation
        • Kosher
        • Sympathy Baskets
        • Baby Baskets
        • Holidays & Other Themes
    • Featured

       

      Gift Baskets

      Glenmorangie Journey

      Glenmorangie Journey

    •  

       

      Gift Baskets

      Something Savory

      Something Savory

    •  

       

      Gift Baskets

      A Native Californian

      A Native Californian

  • Beverages & Mixers
      • All Beverages & Mixers
      • Sparkling Water
      • Still Water
      • Soda & Juice
      • Coffee & Tea
      • Ginger Beer & Tonics
      • Cocktail Mixes & Syrups
      • Specialty Alcohol-Free Options
    • Featured

       

      Beverage & Mixers

      Stirrings Margarita Mix

      Stirrings Margarita Mix

    •  

       

       

      Fever-Tree Indian Tonic Water

      Fever-Tree Tonic Water

    •  

       

       

      Pellegrino Mineral Water

      Pellegrino Mineral Water

  • Gourmet
      • All Gourmet
      • Savory Delights
        • Crackers
        • Chips, Popcorn, Pretzels
        • Spreads, Dips, Salsas
        • Cheese & Charcuterie
        • Fruit, Nuts & Bars
        • Caviar, Seafood, Appetizers
        • Olives, Onions, Antipasti
        • Oils & Vinegars
        • Spices, Seasoning, Condiments
        • Pasta, Rice, Grains
      • Sweet Treats
        • Chocolate
        • Candy
        • Honey, Preserves, Jams
        • Cookies, Biscuits, Cakes
      • Gluten-Free & Vegan
        • Gluten-Free
        • Vegan
    • Featured

       

      Grocery

      Goossens Mixed Chocolate Assorted 9pc

      Goossens Assorted Chocolates

  • Cafe
      • All Cafe
    • Featured

       

      Cafe

      Large Wrap Platter

      Large Wrap Platter

    •  

       

      Cafe

      Large Wrap Platter

      Deli Platter

      • Deli Menu
      • Catering
  • Accessories
      • All Accessories
      • Glassware/Barware
      • Specialty Goods & Services
      • Candles
      • Bath & Body
    • Featured

       

      Accessories

      Riedel Amadeo Decanter

      Riedel Amadeo Decanter

    •  

       

      Accessories

      Riedel Vinum Xl Champagne Flutes

      Riedel Vinum Flutes

    •  

       

      Accessories

      True Cherry 4-Piece Accessory Wine Box

      True Cherry 4-Piece Wine Box

red-spot,yellow-spot,bodegas-mauro,nevio-scala,dovinto,loimer,fossil-point Products

Shop by

1 RESULTS Wine xBrand: Red Spot xBrand: Yellow Spot xBrand: Bodegas Mauro xBrand: Nevio Scala xBrand: Dovinto xBrand: Loimer xBrand: Fossil Point xIn Stock: Yes x Clear All
Wine
  • Staff Picks
  • Orange Wines
  • Red
  • White
  • Rosé
  • Port & Dessert Wines
  • Certified Organic
  • Natural Wines
  • Rare & Exceptional
  • Kosher Wines
Load More
Stock Status
  • Pick Up Today
Brand
  • Accendo
  • Alain Chavy
  • Allan Scott
  • Altesino
  • Andrew Murray Vineyards
  • Antinori
  • Badenhorst
  • Banfi
  • Banshee Wines
  • Basa Lore
  • Bella Union
  • Belle Glos
  • Beringer
  • Biokult
  • Bodegas Mauro
  • Boen
  • Bouchard Pere & Fils
  • Brassfield
  • Brown Estate
  • Cakebread
  • Calera
  • Cantina Di Lana
  • Carpe Diem
  • Casanova Di Neri
  • Casillero Del Diablo
  • Castellare
  • Castello Colle Massari
  • Catena
  • Catena Zapata
  • Caymus
  • Ceretto
  • Chappellet
  • Chateau Batailley
  • Chateau Beau Site
  • Chateau Cantenac Brown
  • Chateau D'esclans
  • Chateau Dayrem Valentin
  • Chateau De Fontenille
  • Chateau De La Tour
  • Chateau De Meursault
  • Chateau De Pez
  • Chateau De Saint Cosme
  • Chateau Ducru Beaucaillou
  • Chateau Haut Brion
  • Chateau Hosanna
  • Chateau L'ecuyer
  • Chateau La Canorgue
  • Chateau La Tour De L'eveque
  • Chateau Lafite Rothschild
  • Chateau Lalande Borie
  • Chateau Leoville Las Cases
  • Chateau Lynch Bages
  • Chateau Monbousquet
  • Chateau Montelena
  • Chateau Montrose
  • Chateau Mouton Rothschild
  • Chateau Pascaud
  • Chateau Pichon Baron
  • Chateau Picque Caillou
  • Chateau Rauzan Segla
  • Chateau Rieussec
  • Chateau Sociando Mallet
  • Chateau Vieux Chevrol
  • Ciavolich
  • Clos De Los Siete
  • Clos Lunelles
  • Cloudy Bay
  • Club 44
  • Comte Lafond
  • Cos D'estournel
  • Cune
  • Damilano
  • Daniel Conterno
  • Daou
  • Darioush
  • De Martino
  • Decoy
  • Delas
  • Deloach
  • Domaine Armand Rousseau
  • Domaine Castagnier
  • Domaine De Beaurenard
  • Domaine De Bellene
  • Domaine De Fa
  • Domaine De Menard
  • Domaine De Rochebin
  • Domaine Du Castel
  • Domaine Jean Francois
  • Domaine Jean Grivot
  • Domaine Mont Bessay
  • Domaine Romy
  • Domaine Tempier
  • Domaine Tollot Beaut
  • Domaine William Fevre
  • Domaines Ott
  • Dominus
  • Dr. Crusius
  • Dragonette
  • Dry Creek
  • Duckhorn
  • Dumol
  • E. Guigal
  • E11even
  • Eisele Vineyard
  • El Enemigo
  • Emilio Moro
  • Emmolo
  • Enroute
  • Far Niente
  • Faust
  • Fess Parker
  • Field Recordings
  • Flowers
  • Franck Et Sylvain Godon
  • Frank Family
  • Frog's Leap
  • Gagnard Delagrange
  • Gaia
  • Gaja
  • Galil Mountain Winery
  • Girard
  • Giuseppe Quintarelli
  • Golan Heights
  • Goldeneye
  • Graham's
  • Hanzell
  • Heitz Cellar
  • Hugel
  • Italo Cescon
  • Jadix
  • Jean Louis Chavy
  • Jean Max Roger
  • Joel Gott
  • Jordan
  • Joseph Drouhin
  • Joseph Phelps
  • Josh Cellars
  • Jurtschitsch
  • Justin
  • Kenzo Estate
  • Kim Crawford
  • Kistler
  • Kopke
  • Kracher
  • Kylie
  • La Barroche
  • La Poussie
  • La Rioja Alta
  • La Scolca
  • Ladoucette
  • Lapostolle
  • Las Jaras
  • Le Pupille
  • Leonetti Cellar
  • Los Angeles River
  • Louis M. Martini
  • Lumen
  • Lunaria
  • Lustau
  • Manolis Garalis
  • Marc Bredif
  • Marchesi Di Barolo
  • Marenco
  • Masseria Li Veli
  • Massey Dacta
  • Massican
  • Matthews
  • Meerlust
  • Meiomi
  • Melville
  • Mer Soleil
  • Michael Mondavi
  • Michel Magnien
  • Minuty
  • Mirabeau
  • Movia
  • Numanthia
  • O'shaughnessy
  • Oliver Leflaive
  • Opus One
  • Orin Swift
  • Ornellaia
  • Pahlmeyer
  • Peju
  • Penfolds
  • Peter Michael
  • Petit Manou
  • Pio Cesare
  • Podere Poggio Scalette
  • Poderi Aldo Conterno
  • Poliziano
  • Pratsch
  • Produttori Del Barbaresco
  • Quilceda Creek
  • Quilt
  • Quintessa
  • Ramos Pinto
  • Renzo Seghesio
  • Ridge Vineyards
  • Robert Mondavi
  • Rocca Di Frassinello
  • Rombauer
  • Roumier
  • San Felice
  • San Simeon
  • Sandara
  • Sandeman
  • Santa Julia
  • Santa Margherita
  • Schmitt Sohne
  • Schrader
  • Sea Smoke
  • Sean Minor Wines
  • Sequoia Grove
  • Shafer
  • Shokrian
  • Silk & Spice
  • Silver Oak
  • Sine Qua Non
  • Skyside
  • Sonoma Cutrer
  • Stags Leap Wine Cellars
  • Stags' Leap
  • Stephan Aviron
  • Tabor
  • Tenuta San Giorgio
  • Tenuta San Guido
  • Textbook
  • The Prisoner Wine Company
  • The Vice
  • Tinto Pesquera
  • Tommasi
  • Tramin
  • Trefethen
  • Tres Chic
  • Tua Rita
  • Turley
  • Twomey
  • Vietti
  • Whitehall Lane
  • Xavier Monnot
  • Zenato
  • Zephyr
  • Zuccardi
Load More
struct
EVENTNAME onRequest
EXCEPTION
struct
Cause
struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1620) at coldfusion.sql.Executive.executeQuery(Executive.java:1362) at coldfusion.sql.Executive.executeQuery(Executive.java:1292) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213) at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:663) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:593) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:556) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CFQUERY
LINE 449
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
15
struct
COLUMN 0
ID CFINCLUDE
LINE 213
RAW_TRACE at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
16
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
17
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
18
struct
COLUMN 0
ID CFINCLUDE
LINE 262
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource koalasql
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1620) at coldfusion.sql.Executive.executeQuery(Executive.java:1362) at coldfusion.sql.Executive.executeQuery(Executive.java:1292) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213) at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:663) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:593) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:556) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CFQUERY
LINE 449
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
15
struct
COLUMN 0
ID CFINCLUDE
LINE 213
RAW_TRACE at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
16
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
17
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
18
struct
COLUMN 0
ID CFINCLUDE
LINE 262
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT DISTINCT a.siz as filter_item , max(a.size_order) as theOrder , count(DISTINCT b.style_id) as itemCount FROM tb_size_entries a INNER JOIN tb_skus b WITH (NOLOCK) ON (a.scale_entry_id = b.scale_entry_id) WHERE 1=2 OR b.style_id IN ( ) GROUP BY a.siz ORDER BY max(a.size_order)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213) at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:663) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:593) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:556) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1620) at coldfusion.sql.Executive.executeQuery(Executive.java:1362) at coldfusion.sql.Executive.executeQuery(Executive.java:1292) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 63 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 449
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 213
RAW_TRACE at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 262
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
6
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
18
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
where [empty string]
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1620) at coldfusion.sql.Executive.executeQuery(Executive.java:1362) at coldfusion.sql.Executive.executeQuery(Executive.java:1292) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213) at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:663) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:593) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:556) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CFQUERY
LINE 449
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
15
struct
COLUMN 0
ID CFINCLUDE
LINE 213
RAW_TRACE at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
16
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
17
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
18
struct
COLUMN 0
ID CFINCLUDE
LINE 262
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource koalasql
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1620) at coldfusion.sql.Executive.executeQuery(Executive.java:1362) at coldfusion.sql.Executive.executeQuery(Executive.java:1292) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213) at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:663) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:593) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:556) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CFQUERY
LINE 449
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
15
struct
COLUMN 0
ID CFINCLUDE
LINE 213
RAW_TRACE at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
16
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
17
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
18
struct
COLUMN 0
ID CFINCLUDE
LINE 262
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT DISTINCT a.siz as filter_item , max(a.size_order) as theOrder , count(DISTINCT b.style_id) as itemCount FROM tb_size_entries a INNER JOIN tb_skus b WITH (NOLOCK) ON (a.scale_entry_id = b.scale_entry_id) WHERE 1=2 OR b.style_id IN ( ) GROUP BY a.siz ORDER BY max(a.size_order)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213) at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:663) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:593) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:556) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1620) at coldfusion.sql.Executive.executeQuery(Executive.java:1362) at coldfusion.sql.Executive.executeQuery(Executive.java:1292) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 63 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 449
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 213
RAW_TRACE at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 262
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
6
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
18
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
where [empty string]
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213) at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:663) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:593) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:556) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 37 more Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1620) at coldfusion.sql.Executive.executeQuery(Executive.java:1362) at coldfusion.sql.Executive.executeQuery(Executive.java:1292) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 63 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 449
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:449)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 213
RAW_TRACE at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:213)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752._factor10(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 262
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:262)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
6
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
18
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
Type Database
name onRequest