<div dir="ltr">[Wed Mar 27 16:59:13 2013] [error] PHP Fatal error: Class 'SelectQueryExtender' not found in /sites/<a href="http://johntate.org/includes/pager.inc">johntate.org/includes/pager.inc</a> on line 15<br>
<div><br></div><div style>Now I'm getting that error. None of this makes sense anymore. I looked up a solution and it says "<span style="font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;font-size:13px;line-height:17.984375px">Conclusion: when migrating or restoring a site, do and use a full database backup, containing tables' creation and their data."</span></div>
<div style><span style="font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;font-size:13px;line-height:17.984375px"><br></span></div><div style><span style="font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;font-size:13px;line-height:17.984375px">How much more full can you get than a mysqldump? It just makes no sense. I might have to start over.</span></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Mar 28, 2013 at 10:37 AM, Jamie Holly <span dir="ltr"><<a href="mailto:hovercrafter@earthlink.net" target="_blank">hovercrafter@earthlink.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>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 ;<div class="im"><br>
<br>
<br>
<pre cols="72">Jamie Holly
<a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre></div><div><div class="h5">
On 3/27/2013 7:27 PM, John Tate wrote:<br>
</div></div></div><div><div class="h5">
<blockquote 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 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>
On Thu, Mar 28, 2013 at 10:09 AM, Jamie Holly <span dir="ltr"><<a 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>
<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 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 href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a 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 href="http://johntate.org/includes/bootstrap.inc" target="_blank">johntate.org/includes/bootstrap.inc</a>).</blockquote>
<br>
</div>
</div>
<br>
</div>
<span><font color="#888888">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</font></span></blockquote>
</div>
<span><font color="#888888"><br>
<br clear="all">
<div><br>
</div>
-- <br>
<a 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 href="http://www.johntate.org" target="_blank">www.johntate.org</a>
</div>
<br>
<fieldset></fieldset>
<br>
</blockquote>
<br>
</div></div></div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><a href="http://www.johntate.org" target="_blank">www.johntate.org</a>
</div>