<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">I move sites all the time with a full
mysqldump, including some that are 3-4gb in size. <br>
<br>
Are you sure the full source code got copied? That class is
defined in includes/database/select.inc<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 8:05 PM, John Tate wrote:<br>
</div>
<blockquote
cite="mid:CAHnfuAtbO1kvuDomn3JuamRpm=roUhcgtK5Ow6qbdUPWkpxv6w@mail.gmail.com"
type="cite">
<div dir="ltr">[Wed Mar 27 16:59:13 2013] [error] PHP Fatal error:
Class 'SelectQueryExtender' not found in /sites/<a
moz-do-not-send="true"
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 moz-do-not-send="true"
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 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>
</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
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> 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>
<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><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><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></fieldset>
<br>
</blockquote>
<br>
</div>
</div>
</div>
<br>
--<br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</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>