By ycc on

Hi,

I just tried upgrading a 6.20 install to 7.0 but encountered this on running the update script.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'MYDBNAME.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 123.123.123.123 ) in drupal_is_denied() (line 1779 of /PATH/PATH/PATH/PATH/html/drupal/includes/bootstrap.inc).

Please give advice.

Thanks.

⋅ Categories: Drupal 7.x

Comments

ycc’s picture

ycc commented

continuing my question ...

I am trying to upgrade of 6.20 -> 7.0. I have made a copy of the database. (and changed database login information in settings.php accordingly)

The update script halts rather immediately with the message above. No upgrade is made and the site cannot be used, the same error message then appears.

I am checking the databases. The old database and the copied seem identical. (At least having the same number of tables and there are data in the tables)

Any table blocked_ips (asked for in the error message) does not exist in neither the old database nor in the copy of the database that the update script started working on.

I am at a loss here. The update scripts halts rather immediately and leaves an installation that does not work.

EDIT:
Better add that I run on GoDaddy.

antoniobusrod’s picture

antoniobusrod commented

Same problem... I am thinking about comment the function which checks ip blocked. Does anyone know something??

aussierod’s picture

aussierod commented

bump

Same problem.

eileenmcnaughton’s picture

eileenmcnaughton commented

subscribing

AndrzejG’s picture

AndrzejG commented

I just solved the same problem.

The problem appears if You miss to revert to $update_free_access = TRUE; in settings.php, and make this file writable only.

HTH

firstmanifold’s picture

firstmanifold commented

hi. what exactly do I have to do to get rid of that error?

brad.mrumlinski’s picture

brad.mrumlinski commented

Make sure you have disabled all your modules and put the site into maintenance mode before upgrading.

boran’s picture

boran commented

Has this issue been solved?
There is no blocked_ips table in my DB after the upgrade, although this table does existing on a fresh D7 install.

See several related posts #1051116: 6.20 to 7.0, PDOException & 'drupal.blocked_ips' error, #517742: Upgrade failing if blocked_ips doesn't exist, but no solution found yet?
For now I manually create the missing table:

CREATE TABLE `blocked_ips` (
  `iid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: unique ID for IP addresses.',
  `ip` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP address',
  PRIMARY KEY (`iid`),
  KEY `blocked_ip` (`ip`)
) COMMENT='Stores blocked IP addresses.'
clawki’s picture

clawki commented

The solution that worked for me was to run the update.php script again, not try to check if I was actually operating offline (I was pretty sure I was, but when I clicked it that is when I got the nasty drupi-gram), I set the settings file to TRUE and ran the script. Everything upgraded fine from there on out. Hopefully mine was not an isolated case and this will work for others.

Good Luck and happy Drupaling

danieljulia’s picture

danieljulia commented

I'm running in the same problem, and no solution so far. Tried previous tricks, but none is working :(

OK, finally i fixed by copying the default.settings.php from version 7 , renaming as settings.php and editing the database array by hand.....

Hope this helps somebody, big FAIL drupal 7 having this problem, i think upgrading from 6 to 7 will be a very often task, and having so huge problems doesn't help.

andyscotuk’s picture

andyscotuk commented

same problem here. Went through 4 rebuilds of drupal 6 and upgrade to 7 as I tried to troubleshoot the problem. All modules were patched to latest version of Drupal 6

tried changing settings file as noted above

site in offline mode

all extra modules disabled and uninstalled where possible

used sql script to create blocked_ips table ( just got another error once I got past that)

It seems the upgrade process is failing as the new drupal 7 database has most of the data from the old site but I can't see it through content manager just phpmyadmin. All the testing has been done through a WAMP install. There are plenty threads on this problem, some going back to 2008, but no solution. I'm a bit disappointed really

mgifford’s picture

mgifford
he/him
Primary language English
commented

See #517742: Upgrade failing if blocked_ips doesn't exist

richard2233’s picture

richard2233 commented

I had the same issue, think I found out why though. In the upgrade text its says to delete to all the core files except the sites directory. I hadn't done this.

After I deleted these and re-created the structure it worked well. Well I say that, before I done the upgrade I didnt set the default theme to garland, instead I had garland_dropdown set as my default. As a result I cant even log in now as I am getting errors similar to

#Notice: Undefined variable: left in include() (line 26 of #/srv/vhosts/cict/www.website.org.uk/public_html/sites/all/themes/garland_dropmenu/mainten...).

But thats a different story, I'm hoping by changing the sql database table to drupal 7 default theme might rectify the issue.

Wish me luck!

Big Rich

kumarprince’s picture

kumarprince commented

I am facing the same problem. Did you find any solution?. If yes, Please help me .

I am stuck in updating my website and facing this error

hanksterr7’s picture

hanksterr7 commented

Found that the settings.php file I was using had this line:

include './sites/all/modules/domain/settings.inc';

(related to domain access module)

When I commented out this line, the update.php page would open :)