Question

我正在研究第6博士,我已经将其从一个遥远的服务器迁移到了当地东道。我为数据库建立了备份档案,并输入了该数据库。现在,当我装上主页时,例如<编码>http:// localhost/abc。我收到以下错误:

警告:表存在问题: SlectT 1 from access WHERE category = Host and LOWER (1270.0.1 ) LIKE LOWER (mask) and status = 0MIT 0, 1 in C:wampwwwihlet1includesdatabase.mysqlic on line 128/

我感谢我提出解决办法。

Answer 1

This can happen for a couple of reasons:

You have the "drupal." table prefix configured in your settings.php for the remote server, and this may not work for your localhost. Remove the prefix or change it for something that works on your local MySQL installation.
You maybe need to run the update.php script, the DB dump may have skipped some tables and you need to make sure they re configured correctly.

问他们,告诉我,如果他们工作的话

Answer 2

Quite simply the access table is missing from the database. Either your backup or import hasn t worked properly and that table hasn t made it through. You can run the following MySQL command to create the (empty) table:

DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `mask` varchar(255) NOT NULL DEFAULT   ,
  `type` varchar(255) NOT NULL DEFAULT   ,
  `status` tinyint(4) NOT NULL DEFAULT  0 ,
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

友情链接