迁移的Joomla网站显示表不存在 [英] Migrated Joomla Site shows Table doesn't exist

问题描述

我在计算机上本地创建了一个joomla 2.5站点，该站点已迁移到运行nginx，php和mysql的vps.这是我按顺序所做的:

I have a joomla 2.5 site created locally on my machine, that I've migrated to a vps running nginx, php and mysql. Here is what i did in order:

 1. Uploaded all the joomla files in the public_html
 2. Changed all the files permission to 644 and all the folders to 755
 3. Imported the database.sql to mysql using these commands: 

--> mysql> create database databasename;    
--> mysql> GRANT ALL PRIVILEGES ON
databasename.* TO username@localhost IDENTIFIED BY 'password';   
--> mysql> flush privileges;    
--> mysql> exit    
--> user@vps:~$ mysql -p -u username database_name < file.sql

我已经可以在数据库中看到我的所有表，并在joomla configuration.php上更改了所有必需的信息，但是当我打开网站时，出现此错误:

I can see all my tables inside the database already, and changed all the needed information on my joomla configuration.php but when i open my site, i get this error:

Table 'databasename.s1t3j0s_session' doesn't exist SQL=INSERT INTO `s1t3j0s_session` (`session_id`, `client_id`, `time`) VALUES ('rh249ehb2tbsqkdff34v177d76', 0, '1357339991')

我在哪里弄错了?

我已将wordpress网站迁移到同一服务器，没有错误.

I have migrated wordpress site to the same server with no error.

推荐答案

通过对照使用的实际数据库前缀(打开phpMyAdmin并选择Joomla数据库进行检查).

Make sure the value of $dbprefix in configuration.php under the Joomla directory has the correct value by checking it against the actual db prefix used (open phpMyAdmin and choose the Joomla database to check for this).

这篇关于迁移的Joomla网站显示表不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！