主题 : 数据库导入问题 |
级别: 解元
![]() |
31# 发表于:2014-06-09 17:05:59 IP:119.52.*.*
|
||||
---|---|---|---|---|---|
级别: 状元
![]() |
32# 发表于:2014-06-09 17:09:17 IP:182.5.*.*
系统sql文件不会有错的,这我们和很多客户都导入过怎么可能有问题,你那是不是数据库是什么版本啊
|
||
---|---|---|---|
级别: 解元
![]() |
33# 发表于:2014-06-09 17:31:28 IP:119.52.*.*
回复第32楼 这是我导出的文件
-- MySQL dump 10.13 Distrib *.35, for Win32 (x86) -- -- Host: localhost Database: jeecmsv5 -- ------------------------------------------------------ -- Server version *.35 |
||
---|---|---|---|
级别: 解元
![]() |
35# 发表于:2014-06-10 10:50:06 IP:111.255.*.*
回复第34楼 我用安装包自动创建一个数据库 改名字 我想要的吗,比如把jeecmsv5改成test数据库
|
||
---|---|---|---|
级别: 解元
![]() |
37# 发表于:2014-06-10 10:54:44 IP:111.255.*.*
回复第36楼 我是说按照你说的,是不是要用安装包,安装的时候,创建一个自己要的数据库名称,然后在导入之前导出的sql文件(把数据库里内容导入)
|
||
---|---|---|---|
级别: 解元
![]() |
38# 发表于:2014-06-10 10:55:39 IP:111.255.*.*
回复第36楼 看下 这个登录日志,所有的栏目的栏目下面 点击修改页面 全是 500 的错误
2014-6-10 0:00:21 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet JeeCmsAdmin threw exception java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2475) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2927) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2916) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3459) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5036) at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:91) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:555) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy17.getListFromCache(Unknown Source) at com.jeecms.cms.web.AdminContextInterceptor.getByDefault(AdminContextInterceptor.java:230) at com.jeecms.cms.web.AdminContextInterceptor.getSite(AdminContextInterceptor.java:176) at com.jeecms.cms.web.AdminContextInterceptor.preHandle(AdminContextInterceptor.java:46) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:781) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:311) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:619) |
||
---|---|---|---|
级别: 状元
![]() |
39# 发表于:2014-06-10 10:57:37 IP:182.5.*.*
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2475) 你这不还是数据库连接不上吗?数据库问题自己看看,你数据库是不是哪里改动了什么,是不是默认数据库
|
||
---|---|---|---|
级别: 解元
![]() |
40# 发表于:2014-06-10 11:48:17 IP:111.255.*.*
回复第39楼 要是说 数据库连接不上,但是我的确能访问后台,唯一错误就是 栏目 下面的 所有页面 点击修改的是 报500 错误,如果是数据库连接不了,那我也应该 登陆不了后台的
|
||
---|---|---|---|