<div dir="ltr">There was nothing in those tables, problem persists.</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Mar 28, 2013 at 12:03 PM, 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>Truncate all your cache_ tables and
sessions table. Also, if you're running APC or any other op-code
cache, I would disable that temporarily in php.ini just to rule
out it being something there.<div class="im"><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 8:32 PM, John Tate wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">I moved the source with tar czf, it should have
copied. Though I just extracted Drupal 7.21 and found I get a
completely different error now...
<div><br>
</div>
<div>[Wed Mar 27 17:30:48 2013] [error] PHP Fatal error: Call
to undefined function field_attach_load() in /sites/<a href="http://johntate.org/includes/entity.inc" target="_blank">johntate.org/includes/entity.inc</a>
on line 321<br>
</div>
<div><br>
</div>
<div>I still don't understand why this is happening.</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, Mar 28, 2013 at 11:14 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>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
<div><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> On 3/27/2013 8:05 PM, John Tate
wrote:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote type="cite">
<div dir="ltr">[Wed Mar 27 16:59:<a href="tel:13%202013" value="+61132013" target="_blank">13 2013</a>]
[error] PHP Fatal error: Class
'SelectQueryExtender' not found in /sites/<a href="http://johntate.org/includes/pager.inc" target="_blank">johntate.org/includes/pager.inc</a>
on line 15<br>
<div><br>
</div>
<div>Now I'm getting that error. None of this
makes sense anymore. I looked up a solution and
it says "<span>Conclusion: when migrating or
restoring a site, do and use a full database
backup, containing tables' creation and their
data."</span></div>
<div><span><br>
</span></div>
<div><span>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><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> On 3/27/2013 7:27 PM, John Tate
wrote:<br>
</div>
</div>
</div>
<div>
<div>
<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>
<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>
<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>