<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">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.<br>
<br>
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:<br>
<br>
<br>
CREATE TABLE IF NOT EXISTS `blocked_ips` (<br>
`iid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary
Key: unique ID for IP addresses.',<br>
`ip` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP address',<br>
PRIMARY KEY (`iid`),<br>
KEY `blocked_ip` (`ip`)<br>
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP
addresses.' AUTO_INCREMENT=1 ;<br>
<br>
<br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://www.intoxination.net">http://www.intoxination.net</a>
<a class="moz-txt-link-freetext" href="http://www.hollyit.net">http://www.hollyit.net</a></pre>
On 3/27/2013 7:27 PM, John Tate wrote:<br>
</div>
<blockquote
cite="mid:CAHnfuAu+iKKbU8i9+Ax-38AobO4KYVgJAZ=6mQAHBW=v5sPhEA@mail.gmail.com"
type="cite">
<div dir="ltr">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.</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, Mar 28, 2013 at 10:19 AM, John
Tate <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:john@johntate.org" target="_blank">john@johntate.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">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.</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
<div class="im">
On Thu, Mar 28, 2013 at 10:09 AM, Jamie Holly <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:hovercrafter@earthlink.net"
target="_blank">hovercrafter@earthlink.net</a>></span>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">
<div text="#000000" bgcolor="#FFFFFF">
<div>
<div>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/<a
moz-do-not-send="true"
href="http://johntate.org/includes/bootstrap.inc"
target="_blank">johntate.org/includes/bootstrap.inc</a>).<br>
<br>
</div>
By looks of it all the tables didn't copy over.
<br>
<span><font color="#888888">
<pre cols="72">Jamie Holly
<a moz-do-not-send="true" href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a moz-do-not-send="true" href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre>
</font></span>
<div> On 3/27/2013 6:54 PM, John Tate wrote:<br>
</div>
</div>
<div>
<blockquote type="cite">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/<a
moz-do-not-send="true"
href="http://johntate.org/includes/bootstrap.inc"
target="_blank">johntate.org/includes/bootstrap.inc</a>).</blockquote>
<br>
</div>
</div>
<br>
</div>
<span class="HOEnZb"><font color="#888888">--<br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</font></span></blockquote>
</div>
<span class="HOEnZb"><font color="#888888"><br>
<br clear="all">
<div><br>
</div>
-- <br>
<a moz-do-not-send="true"
href="http://www.johntate.org" target="_blank">www.johntate.org</a>
</font></span></div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<a moz-do-not-send="true" href="http://www.johntate.org"
target="_blank">www.johntate.org</a>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</body>
</html>