<div dir="ltr">I would but dreamhost isn't very flexible and I thought I had everything and could move the domain. As it was I had to find the IP of Dreamhosts mysql server which wasn't easy because it was just <a href="http://mysql.johntate.org">mysql.johntate.org</a>. If I had noticed my error in the first place I wouldn't have had to go to so much effort, so adding to my stupidity part of me just really wanted drupal to be at fault and it was bending my vision. </div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Mar 28, 2013 at 11:12 PM, Jim Ruby <span dir="ltr"><<a href="mailto:jim@v-community.com" target="_blank">jim@v-community.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Just a thought, but why not try using the backup and migrate module along<br>
with the pathologic module. I have moves sites and use these two modules and<br>
have had good success.<br>
<div><div class="h5"><br>
<br>
-----Original Message-----<br>
From: <a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a> [mailto:<a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>] On<br>
Behalf Of John Tate<br>
Sent: Thursday, March 28, 2013 4:03 AM<br>
To: <a href="mailto:support@drupal.org">support@drupal.org</a><br>
Subject: Re: [support] Moving hosting, site no longer works<br>
<br>
I forgot to mention I tried update.php at some point. I just dropped the<br>
database, created it, and executed the SQL backup on it and then created<br>
blocked_ips again.<br>
<br>
Now I get this...<br>
<br>
Uncaught exception thrown in session handler.<br>
<br>
<br>
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column<br>
&#039;ssid&#039; in &#039;where clause&#039;: SELECT 1 AS expression FROM<br>
{sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid =<br>
:db_condition_placeholder_1) ) FOR UPDATE; Array (<br>
[:db_condition_placeholder_0] =&gt;<br>
xwZt4FqBjh9Hf4T6qAm-1TJrfLHznoC6mXfiOeNbAMU [:db_condition_placeholder_1]<br>
=&gt; ) in _drupal_session_write() (line 209 of<br>
/sites/<a href="http://johntate.org/includes/session.inc" target="_blank">johntate.org/includes/session.inc</a>).<br>
<br>
<br>
<br>
On Thu, Mar 28, 2013 at 7:14 PM, John Tate <<a href="mailto:john@johntate.org">john@johntate.org</a>> wrote:<br>
<br>
<br>
There is stuff in the table cache on dreamhost, mysqldump isn't<br>
working or something.<br>
<br>
<br>
On Thu, Mar 28, 2013 at 7:12 PM, John Tate <<a href="mailto:john@johntate.org">john@johntate.org</a>><br>
wrote:<br>
<br>
<br>
There was nothing in those tables, problem persists.<br>
<br>
<br>
On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly<br>
<<a href="mailto:hovercrafter@earthlink.net">hovercrafter@earthlink.net</a>> wrote:<br>
<br>
<br>
Truncate all your cache_ tables and sessions table.<br>
Also, if you're running APC or any other op-code cache, I would disable that<br>
temporarily in php.ini just to rule out it being something there.<br>
<br>
Jamie Holly<br>
<a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a><br>
<a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a><br>
On 3/27/2013 8:32 PM, John Tate wrote:<br>
<br>
<br>
I moved the source with tar czf, it should<br>
have copied. Though I just extracted Drupal 7.21 and found I get a<br>
completely different error now...<br>
<br>
[Wed Mar 27 17:30:48 2013] [error] PHP Fatal<br>
error: Call to undefined function field_attach_load() in<br>
/sites/<a href="http://johntate.org/includes/entity.inc" target="_blank">johntate.org/includes/entity.inc</a> on line 321<br>
<br>
<br>
I still don't understand why this is<br>
happening.<br>
<br>
<br>
On Thu, Mar 28, 2013 at 11:14 AM, Jamie<br>
Holly <<a href="mailto:hovercrafter@earthlink.net">hovercrafter@earthlink.net</a>> wrote:<br>
<br>
<br>
I move sites all the time with a<br>
full mysqldump, including some that are 3-4gb in size.<br>
<br>
Are you sure the full source code<br>
got copied? That class is defined in includes/database/select.inc<br>
<br>
Jamie Holly<br>
<a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a><br>
<a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a><br>
On 3/27/2013 8:05 PM, John Tate<br>
wrote:<br>
<br>
<br>
[Wed Mar 27 16:59:<a href="tel:13%202013" value="+61132013">13 2013</a><br>
</div></div><tel:13%202013> ] [error] PHP Fatal error: Class 'SelectQueryExtender' not<br>
<div class="HOEnZb"><div class="h5">found in /sites/<a href="http://johntate.org/includes/pager.inc" target="_blank">johntate.org/includes/pager.inc</a> on line 15<br>
<br>
<br>
Now I'm getting that error.<br>
None of this makes sense anymore. I looked up a solution and it says<br>
"Conclusion: when migrating or restoring a site, do and use a full database<br>
backup, containing tables' creation and their data."<br>
<br>
<br>
How much more full can you<br>
get than a mysqldump? It just makes no sense. I might have to start over.<br>
<br>
<br>
On Thu, Mar 28, 2013 at<br>
10:37 AM, Jamie Holly <<a href="mailto:hovercrafter@earthlink.net">hovercrafter@earthlink.net</a>> wrote:<br>
<br>
<br>
Nope, it's looking<br>
for the table (Table 'johntate.blocked_ips' doesn't exist). That table is<br>
part of Drupal core. It does the check in drupal_is_denied in bootstrap.inc.<br>
It does check for a variable first, but that isn't a standard DB variable.<br>
That's one you can define via $conf in settings.php.<br>
<br>
Not sure why your<br>
other installation doesn't have that table in there and why it isn't<br>
throwing an error, but that table must be there in order for Drupal to run.<br>
I would just manually recreate the table via the MySQL command line or in<br>
PHPMyAdmin:<br>
<br>
<br>
CREATE TABLE IF NOT<br>
EXISTS `blocked_ips` (<br>
`iid` int(10)<br>
unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: unique ID for IP<br>
addresses.',<br>
`ip` varchar(40)<br>
NOT NULL DEFAULT '' COMMENT 'IP address',<br>
PRIMARY KEY<br>
(`iid`),<br>
KEY `blocked_ip`<br>
(`ip`)<br>
) ENGINE=InnoDB<br>
DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP addresses.' AUTO_INCREMENT=1<br>
;<br>
<br>
<br>
<br>
Jamie Holly<br>
<br>
<a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a><br>
<br>
<a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a><br>
On 3/27/2013 7:27<br>
PM, John Tate wrote:<br>
<br>
<br>
Sorry I just<br>
realized it's looking for a setting called blocked_ips in the table<br>
variable, but it is not there on the original server. The tables have copied<br>
exactly, otherwise mysqldump would be what is at fault.<br>
<br>
<br>
On Thu, Mar<br>
28, 2013 at 10:19 AM, John Tate <<a href="mailto:john@johntate.org">john@johntate.org</a>> wrote:<br>
<br>
<br>
They<br>
all copied over, I just checked lists on both servers. There is no<br>
blocked_ips table on the original server. It should have had this problem<br>
there.<br>
<br>
<br>
On<br>
Thu, Mar 28, 2013 at 10:09 AM, Jamie Holly <<a href="mailto:hovercrafter@earthlink.net">hovercrafter@earthlink.net</a>><br>
wrote:<br>
<br>
<br>
<br>
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table<br>
'johntate.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip =<br>
:ip; Array ( [:ip] => 220.245.128.9 ) in drupal_is_denied() (line 1895 of<br>
/sites/<a href="http://johntate.org/includes/bootstrap.inc" target="_blank">johntate.org/includes/bootstrap.inc</a>).<br>
<br>
<br>
<br>
<br>
<br>
By looks of it all the tables didn't copy over.<br>
<br>
<br>
<br>
Jamie Holly<br>
<br>
<a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a><br>
<br>
<a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a><br>
<br>
On 3/27/2013 6:54 PM, John Tate wrote:<br>
<br>
<br>
<br>
<br>
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table<br>
'johntate.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip =<br>
:ip; Array ( [:ip] => 220.245.128.9 ) in drupal_is_denied() (line 1895 of<br>
/sites/<a href="http://johntate.org/includes/bootstrap.inc" target="_blank">johntate.org/includes/bootstrap.inc</a>).<br>
<br>
<br>
<br>
<br>
--<br>
<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
--<br>
<br>
<a href="http://www.johntate.org" target="_blank">www.johntate.org</a><br>
<br>
<br>
<br>
<br>
--<br>
<br>
<a href="http://www.johntate.org" target="_blank">www.johntate.org</a><br>
<br>
<br>
<br>
<br>
<br>
<br>
--<br>
[ Drupal support<br>
list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
<br>
<br>
<br>
<br>
<br>
--<br>
<a href="http://www.johntate.org" target="_blank">www.johntate.org</a><br>
<br>
<br>
<br>
<br>
<br>
<br>
--<br>
[ Drupal support list |<br>
<a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
<br>
<br>
<br>
<br>
<br>
--<br>
<a href="http://www.johntate.org" target="_blank">www.johntate.org</a><br>
<br>
<br>
<br>
<br>
<br>
<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
<br>
<br>
<br>
<br>
<br>
--<br>
<a href="http://www.johntate.org" target="_blank">www.johntate.org</a><br>
<br>
<br>
<br>
<br>
--<br>
<a href="http://www.johntate.org" target="_blank">www.johntate.org</a><br>
<br>
<br>
<br>
<br>
--<br>
<a href="http://www.johntate.org" target="_blank">www.johntate.org</a><br>
<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</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>