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/productoscat.cfm: line 55
Called from D:/Plesk/Vhosts/hanspeter.es/httpdocs/productoscat.cfm: line 1
Called from D:/Plesk/Vhosts/hanspeter.es/httpdocs/productoscat.cfm: line 55
Called from D:/Plesk/Vhosts/hanspeter.es/httpdocs/productoscat.cfm: line 1
53 : 		select p.id, p.clave, p.descr_es, p.envasekk, p.envaseuk, p.disponible, p.prevision_compra, p.prevision_fecha, p.precio 
54 : 		from bh_prod_producto as p, bh_cat_producto as c 
55 : 		where p.id = c.producto and c.catalogo = #tmp.cat_id# 
56 : 		and p.inactivo = 0 and p.web = 1 
57 : 		order by p.descr_es

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 from bh_prod_producto as p, bh_cat_producto as c where p.id = c.producto and c.catalogo = and p.inactivo = 0 and p.web = 1 order by p.descr_es
DATASOURCE   erp
Resources:

Browser   claudebot
Remote Address   54.165.122.173
Referrer   http://hanspeter.es/productoscat.cfm?page=2&catid=33
Date/Time   28-Mar-24 06:50 PM
Stack Trace
at cfproductoscat2ecfm706022206._factor8(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productoscat.cfm:55) at cfproductoscat2ecfm706022206.runPage(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productoscat.cfm:1) at cfproductoscat2ecfm706022206._factor8(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productoscat.cfm:55) at cfproductoscat2ecfm706022206.runPage(D:/Plesk/Vhosts/hanspeter.es/httpdocs/productoscat.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 cfproductoscat2ecfm706022206._factor8(D:\Plesk\Vhosts\hanspeter.es\httpdocs\productoscat.cfm:55)
	at cfproductoscat2ecfm706022206.runPage(D:\Plesk\Vhosts\hanspeter.es\httpdocs\productoscat.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)