By Jacob on

Hi, guys

I'd like to ask you for advice - I'm upgrading from 5.7 to the latest so far 6.2 Drupal version and getting warnings about not existing table called "flood":

* user warning: Table 'mysite.flood' doesn't exist query: ALTER TABLE flood ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY in C:\Program Files\my_path\htdocs\drupal_62\modules\system\system.install on line 1438.
* user warning: Table 'mysite.flood' doesn't exist query: ALTER TABLE flood ADD INDEX allow (event, hostname, timestamp) in C:\Program Files\my_path\htdocs\drupal_62\includes\database.mysql-common.inc on line 434.

After that I see just "Site off-line" message and cannot take it online, even going directly to the /admin/settings/site-maintenance

What I did was:

A. prepared the original 5.7 installation:

1. Checked error log for errors in the original 5.7 installation - clean
2. Run status report - everything is ok
3. Disabled all the custom modules
4. Took the site to the off-line mode
5. Made backup of all the files
6. Made database backup

B. prepared new installation:

1. Downloaded the latest Drupal 6.2 to the drupal_62 folder
2. Copied my custom files on the top of the drupal_62 folder: /files, robots.txt etc. , so settings.php is in the \htdocs\drupal_62\sites\default\settings.php, including the DB connection info

C. Made the upgrade

1. Run update.php
2. Got warnings above

Any ideas are highly appreciated,
Jacob.

⋅ Categories: Drupal 6.x

Comments

Jacob’s picture

Jacob commented

I managed to get site back to life by going manually to /user/login page & logging in.
All settings and modules have been recreated & site looks ok with default Garland theme - at lest something to start from :)

The only thing "flood" table does not exists. So the only solution is to create it manually as described at http://drupal.org/node/169799
Not the most elegant solution though....

Thanks,
Jacob.