[support] Moving hosting, site no longer works

[Jamie Holly]

Nope, it's looking for the table (Table 'johntate.blocked_ips' doesn't 
exist). That table is part of Drupal core. It does the check in 
drupal_is_denied in bootstrap.inc. It does check for a variable first, 
but that isn't a standard DB variable. That's one you can define via 
$conf in settings.php.

Not sure why your other installation doesn't have that table in there 
and why it isn't throwing an error, but that table must be there in 
order for Drupal to run. I would just manually recreate the table via 
the MySQL command line or in PHPMyAdmin:


CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP 
addresses.' AUTO_INCREMENT=1 ;


Jamie Holly
http://www.intoxination.net
http://www.hollyit.net

On 3/27/2013 7:27 PM, John Tate wrote:
> Sorry I just realized it's looking for a setting called blocked_ips in 
> the table variable, but it is not there on the original server. The 
> tables have copied exactly, otherwise mysqldump would be what is at fault.
>
>
> On Thu, Mar 28, 2013 at 10:19 AM, John Tate <john at johntate.org 
> <mailto:john at johntate.org>> wrote:
>
>     They all copied over, I just checked lists on both servers. There
>     is no blocked_ips table on the original server. It should have had
>     this problem there.
>
>
>     On Thu, Mar 28, 2013 at 10:09 AM, Jamie Holly
>     <hovercrafter at earthlink.net <mailto:hovercrafter at earthlink.net>>
>     wrote:
>
>         PDOException: SQLSTATE[42S02]: Base table or view not found:
>         1146 Table 'johntate.blocked_ips' doesn't exist: SELECT 1 FROM
>         {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 220.245.128.9 )
>         in drupal_is_denied() (line 1895 of
>         /sites/johntate.org/includes/bootstrap.inc
>         <http://johntate.org/includes/bootstrap.inc>).
>
>         By looks of it all the tables didn't copy over.
>
>         Jamie Holly
>         http://www.intoxination.net  
>         http://www.hollyit.net
>
>         On 3/27/2013 6:54 PM, John Tate wrote:
>>         PDOException: SQLSTATE[42S02]: Base table or view not found:
>>         1146 Table 'johntate.blocked_ips' doesn't exist: SELECT 1
>>         FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] =>
>>         220.245.128.9 ) in drupal_is_denied() (line 1895 of
>>         /sites/johntate.org/includes/bootstrap.inc
>>         <http://johntate.org/includes/bootstrap.inc>).
>
>
>         --
>         [ Drupal support list | http://lists.drupal.org/ ]
>
>
>
>
>     -- 
>     www.johntate.org <http://www.johntate.org>
>
>
>
>
> -- 
> www.johntate.org <http://www.johntate.org>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130327/f067899a/attachment.html