douduan7295 2016-12-10 00:21
浏览 95
已采纳

Drupal 7创建泛滥表PHP

Because of a long series of events, I thought I lost a site completely due to my hosting company losing a server. Anyway, I'm trying to get back into a site sitting on a server with a cpanel I cant get to and a WHM I cant get to. I only have access to the root dir via ftp. I was able to reset my admin password using the method here https://www.drupal.org/node/1556488

I meant to also clear the flood table, but deleted it instead with db_drop_table('flood');

So, now I am getting a MYSQL error when I try to login. So, given I only have access to running php scripts to interact with the SQL database, can anyone help me figure out how to rebuild the flood table via the drupal db_create_table() method?

Much appreciated! This has been a nightmare.

  • 写回答

1条回答 默认 最新

  • douhuanbai6729 2016-12-10 05:39
    关注

    I was able to rebuild my flood table with a php file ran from the drupal install directory with this in it: Just type in the url mysite.com/myphpfile.php to run it.

    <?php 
    define('DRUPAL_ROOT', getcwd());
    require_once DRUPAL_ROOT . '/includes/bootstrap.inc';
    drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
    require_once DRUPAL_ROOT . '/includes/password.inc';
    
      $schema = array();
      $schema['flood'] = array(
        'fields' => array(
          'fid' => array(
            'type' => 'int',
            'length' => 11,
            'not null' => TRUE,
          ),
          'event' => array(
            'type' => 'varchar',
            'length' => 64,
            'not null' => TRUE,
            'default' => '',
          ),
          'identifier' => array(
            'type' => 'varchar',
            'length' => 128,
            'not null' => TRUE,
            'default' => '',
          ),
          'timestamp' => array(
            'type' => 'int',
            'length' => 11,
            'not null' => TRUE,
          ),
          'expiration' => array(
            'type' => 'int',
            'length' => 11,
            'not null' => TRUE,
          ),
        ),
        'primary key' => array('fid'),
      );
    
    db_create_table('flood', $schema['flood']);
    
    print "Done. Please delete this file immediately!";
    drupal_exit();
    
    
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 怎么在stm32门禁成品上增加记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
  • ¥50 NT4.0系统 STOP:0X0000007B
  • ¥15 想问一下stata17中这段代码哪里有问题呀
  • ¥15 flink cdc无法实时同步mysql数据
  • ¥100 有人会搭建GPT-J-6B框架吗?有偿
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号