<div dir="ltr">I'm thinking the easiest way to solve this will be to just start a fresh drupal site. Nobody is having this problem moving sites, it seems somehow my original site got corrupted, probably by Dreamhost for leaving or something. I started transferring the site after the domain so that is plausible. I can't see if the original site even works for that reason. It should still have all my blogs in the database, can I migrate just the blog posts to a new install?<div>
<br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Mar 28, 2013 at 11:32 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">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="HOEnZb"><div class="h5"><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>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><a href="http://www.johntate.org" target="_blank">www.johntate.org</a>
</div>