HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
select my_brands.idBrand, linkBrand, brand_index.brand from  brand_index, my_brands where brand_index.brand=my_brands.brand and brand_index.idCategory<>1169 group by brand order by brand

: Column 'linkBrand' in field list is ambiguous
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:844)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
	org.apache.jsp.store.listBrandTree_jsp._jspService(org.apache.jsp.store.listBrandTree_jsp:534)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: Column 'linkBrand' in field list is ambiguous
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:216)
	org.apache.jsp.store.listBrandTree_jsp._jspx_meth_sql_query_13(org.apache.jsp.store.listBrandTree_jsp:2682)
	org.apache.jsp.store.listBrandTree_jsp._jspService(org.apache.jsp.store.listBrandTree_jsp:441)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.

Apache Tomcat/5.5.9