Server Error

500

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error. More information about this error may be available in the server error log.


That's what you can do

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Sybase][ODBC Driver][SQL Anywhere]Syntax error near 'and' on line 4
 
The error occurred in D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm: line 69
Called from D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm: line 1
Called from D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm: line 69
Called from D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm: line 1
67 : 		select p.id, p.clave, p.descr_es, p.envasekk, p.envaseuk, p.disponible, p.prevision_compra, p.prevision_fecha, p.precio, isnull(n.producto, 0) nuevo 
68 : 		from bh_prod_producto as p left outer join bh_cat_producto as n on p.id = n.producto and n.catalogo = 1, bh_cat_producto as c 
69 : 		where p.id = c.producto and c.catalogo = #tmp.cat_id# 
70 : 		and p.inactivo = 0 and p.web = 1 
71 : 		order by p.clave

VENDORERRORCODE   -131
SQLSTATE   42000
SQL    select p.id, p.clave, p.descr_es, p.envasekk, p.envaseuk, p.disponible, p.prevision_compra, p.prevision_fecha, p.precio, isnull(n.producto, 0) nuevo from bh_prod_producto as p left outer join bh_cat_producto as n on p.id = n.producto and n.catalogo = 1, bh_cat_producto as c where p.id = c.producto and c.catalogo = and p.inactivo = 0 and p.web = 1 order by p.clave
DATASOURCE   erp
Resources:

Browser   claudebot
Remote Address   34.227.112.145
Referrer   http://hanspeter.es/productos.cfm?page=1&catid=76
Date/Time   28-Mar-24 09:43 AM
Stack Trace
at cfproductos2ecfm374583983._factor8(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm:69) at cfproductos2ecfm374583983.runPage(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm:1) at cfproductos2ecfm374583983._factor8(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm:69) at cfproductos2ecfm374583983.runPage(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productos.cfm:1)

java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Syntax error near 'and' on line 4
	at ianywhere.ml.jdbcodbc.IIStatement.execute(Native Method)
	at ianywhere.ml.jdbcodbc.IStatement.execute(IStatement.java:307)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:254)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1430)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfproductos2ecfm374583983._factor8(D:\Plesk\Vhosts\hanspeter.es\httpdocs\productos.cfm:69)
	at cfproductos2ecfm374583983.runPage(D:\Plesk\Vhosts\hanspeter.es\httpdocs\productos.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:360)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)