主题 : Table 'jeecms.cms_topic' doesn't exist
级别: 秀才
UID: 2371
积分:19 加为好友
威望: 0 精华: 0
主题:2 回复:7
注册时间:2010-01-27
在线时长:0
1#   发表于:2010-01-30 13:10:12  IP:121.29.*.*
具体操作是:点击文章详情页面的时候

2010-01-30 01:02 WARN  o.h.u.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
2010-01-30 01:02 ERROR o.h.u.JDBCExceptionReporter - Table 'jeecms.cms_topic' doesn't exist
2010-01-30 01:02 WARN  c.o.x.i.ExceptionMappingInterceptor - could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.loader.Loader.doList(Loader.java:2231) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.loader.Loader.list(Loader.java:2120) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) [hibernate-core-3.3.1.jar:3.3.1.GA]
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [hibernate-core-3.3.1.jar:3.3.1.GA]
at com.jeecms.common.hibernate3.BaseDaoImpl.find(BaseDaoImpl.java:218) [BaseDaoImpl.class:na]
at com.jeecms.cms.dao.impl.CmsTopicDaoImpl.getForTag(CmsTopicDaoImpl.java:27) [CmsTopicDaoImpl.class:na]
at com.jeecms.cms.manager.impl.CmsTopicMngImpl.getForTag(CmsTopicMngImpl.java:26) [CmsTopicMngImpl.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_10]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [na:1.6.0_10]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_10]
at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_10]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) [spring-aop-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) [spring-aop-2.5.6.jar:2.5.6]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) [spring-aop-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) [spring-aop-2.5.6.jar:2.5.6]
at $Proxy34.getForTag(Unknown Source) [na:na]
at com.jeecms.cms.action.front.TopicPartAct.tagTopicList(TopicPartAct.java:27) [TopicPartAct.class:na]
at com.jeecms.cms.action.front.TopicPartAct.topicListInner(TopicPartAct.java:21) [TopicPartAct.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_10]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [na:1.6.0_10]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_10]
at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_10]
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.jeecms.common.struts2.interceptor.UrlInterceptor.doIntercept(UrlInterceptor.java:91) [UrlInterceptor.class:na]
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.jeecms.common.struts2.interceptor.ProcessingStartInterceptor.intercept(ProcessingStartInterceptor.java:32) [ProcessingStartInterceptor.class:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) [struts-core-2.1.6.jar:na]
at org.apache.struts2.components.ActionComponent.executeAction(ActionComponent.java:289) [struts-core-2.1.6.jar:na]
at org.apache.struts2.components.ActionComponent.end(ActionComponent.java:172) [struts-core-2.1.6.jar:na]
at org.apache.struts2.views.freemarker.tags.CallbackWriter.afterBody(CallbackWriter.java:84) [struts-core-2.1.6.jar:na]
at freemarker.core.Environment.visit(Environment.java:300) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:130) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.MixedContent.accept(MixedContent.java:92) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Macro$Context.runMacro(Macro.java:168) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:602) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:106) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.MixedContent.accept(MixedContent.java:92) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.include(Environment.java:1482) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Include.accept(Include.java:169) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.IfBlock.accept(IfBlock.java:82) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.IfBlock.accept(IfBlock.java:82) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Macro$Context.runMacro(Macro.java:168) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:602) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:106) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.MixedContent.accept(MixedContent.java:92) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.process(Environment.java:189) [freemarker-2.3.15.jar:2.3.15]
at freemarker.template.Template.process(Template.java:237) [freemarker-2.3.15.jar:2.3.15]
at org.apache.struts2.views.freemarker.FreemarkerResult.doExecute(FreemarkerResult.java:187) [struts-core-2.1.6.jar:na]
级别: 白丁
UID: 31
积分:209 加为好友
威望: 0 精华: 0
主题:2 回复:167
注册时间:2009-06-03
在线时长:0
2#   发表于:2010-01-30 16:17:31  IP:59.138.*.*
谢谢您的报告,这确实是一个bug。会在以后的版本中修复。
你可能是用的linux系统,linux中的mysql区别大小写。
临时的处理办法是:
找到com/jeecms/cms/entity/CmsTopic.hbm.xml文件,
修改这段代码<class name="CmsTopic" table="CMS_TOPIC">,其中cms_topic为小写,改为大写即可。
级别: 秀才
UID: 2371
积分:19 加为好友
威望: 0 精华: 0
主题:2 回复:7
注册时间:2010-01-27
在线时长:0
3#   发表于:2010-01-30 18:18:29  IP:121.29.*.*
谢谢您的报告,这确实是一个bug。会在以后的版本中修复。
你可能是用的linux系统,linux中的mysql区别大小写。
临时的处理办法是:
找到com/jeecms/cms/entity/CmsTopic.hbm.xml文件,
修改这段代码<class name="CmsTopic" table="CMS_TOPIC">,其中cms_topic为小写,改为大写即可。


谢谢
1 共1页