[support] Moving hosting, site no longer works
John Tate
john at johntate.org
Thu Mar 28 18:04:12 UTC 2013
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 mysql.johntate.org. 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.
On Thu, Mar 28, 2013 at 11:12 PM, Jim Ruby <jim at v-community.com> wrote:
> Just a thought, but why not try using the backup and migrate module along
> with the pathologic module. I have moves sites and use these two modules
> and
> have had good success.
>
>
> -----Original Message-----
> From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
> Behalf Of John Tate
> Sent: Thursday, March 28, 2013 4:03 AM
> To: support at drupal.org
> Subject: Re: [support] Moving hosting, site no longer works
>
> I forgot to mention I tried update.php at some point. I just dropped the
> database, created it, and executed the SQL backup on it and then created
> blocked_ips again.
>
> Now I get this...
>
> Uncaught exception thrown in session handler.
>
>
> PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column
> 'ssid' in 'where clause': SELECT 1 AS expression FROM
> {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid =
> :db_condition_placeholder_1) ) FOR UPDATE; Array (
> [:db_condition_placeholder_0] =>
> xwZt4FqBjh9Hf4T6qAm-1TJrfLHznoC6mXfiOeNbAMU [:db_condition_placeholder_1]
> => ) in _drupal_session_write() (line 209 of
> /sites/johntate.org/includes/session.inc).
>
>
>
> On Thu, Mar 28, 2013 at 7:14 PM, John Tate <john at johntate.org> wrote:
>
>
> There is stuff in the table cache on dreamhost, mysqldump isn't
> working or something.
>
>
> On Thu, Mar 28, 2013 at 7:12 PM, John Tate <john at johntate.org>
> wrote:
>
>
> There was nothing in those tables, problem persists.
>
>
> On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly
> <hovercrafter at earthlink.net> wrote:
>
>
> 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.
>
> Jamie Holly
> http://www.intoxination.net
> http://www.hollyit.net
> On 3/27/2013 8:32 PM, John Tate wrote:
>
>
> 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...
>
> [Wed Mar 27 17:30:48 2013] [error] PHP
> Fatal
> error: Call to undefined function field_attach_load() in
> /sites/johntate.org/includes/entity.inc on line 321
>
>
> I still don't understand why this is
> happening.
>
>
> On Thu, Mar 28, 2013 at 11:14 AM, Jamie
> Holly <hovercrafter at earthlink.net> wrote:
>
>
> I move sites all the time with a
> full mysqldump, including some that are 3-4gb in size.
>
> Are you sure the full source code
> got copied? That class is defined in includes/database/select.inc
>
> Jamie Holly
> http://www.intoxination.net
> http://www.hollyit.net
> On 3/27/2013 8:05 PM, John Tate
> wrote:
>
>
> [Wed Mar 27 16:59:13 2013
> <tel:13%202013> ] [error] PHP Fatal error: Class 'SelectQueryExtender' not
> found in /sites/johntate.org/includes/pager.inc on line 15
>
>
> Now I'm getting that error.
> None of this makes sense anymore. I looked up a solution and it says
> "Conclusion: when migrating or restoring a site, do and use a full database
> backup, containing tables' creation and their data."
>
>
> How much more full can you
> get than a mysqldump? It just makes no sense. I might have to start over.
>
>
> On Thu, Mar 28, 2013 at
> 10:37 AM, Jamie Holly <hovercrafter at earthlink.net> wrote:
>
>
> 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.
>
> 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:
>
>
> CREATE TABLE IF NOT
> EXISTS `blocked_ips` (
> `iid` int(10)
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: unique ID for IP
> addresses.',
> `ip` varchar(40)
> NOT NULL DEFAULT '' COMMENT 'IP address',
> PRIMARY KEY
> (`iid`),
> KEY `blocked_ip`
> (`ip`)
> ) ENGINE=InnoDB
> DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP addresses.'
> AUTO_INCREMENT=1
> ;
>
>
>
> Jamie Holly
>
> http://www.intoxination.net
>
> http://www.hollyit.net
> On 3/27/2013 7:27
> PM, John Tate wrote:
>
>
> 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.
>
>
> On Thu, Mar
> 28, 2013 at 10:19 AM, John Tate <john at johntate.org> wrote:
>
>
>
> 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.
>
>
> On
> Thu, Mar 28, 2013 at 10:09 AM, Jamie Holly <hovercrafter at earthlink.net>
> wrote:
>
>
>
> 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/johntate.org/includes/bootstrap.inc).
>
>
>
>
>
> By looks of it all the tables didn't copy over.
>
>
>
> Jamie Holly
>
> http://www.intoxination.net
>
> http://www.hollyit.net
>
> On 3/27/2013 6:54 PM, John Tate wrote:
>
>
>
>
> 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/johntate.org/includes/bootstrap.inc).
>
>
>
>
> --
>
> [ Drupal support list | http://lists.drupal.org/ ]
>
>
>
>
>
>
>
> --
>
> www.johntate.org
>
>
>
>
> --
>
> www.johntate.org
>
>
>
>
>
>
> --
> [ Drupal support
> list | http://lists.drupal.org/ ]
>
>
>
>
>
> --
> www.johntate.org
>
>
>
>
>
>
> --
> [ Drupal support list |
> http://lists.drupal.org/ ]
>
>
>
>
>
> --
> www.johntate.org
>
>
>
>
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
>
>
>
>
> --
> www.johntate.org
>
>
>
>
> --
> www.johntate.org
>
>
>
>
> --
> www.johntate.org
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
--
www.johntate.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130329/ddd40e3e/attachment.html
More information about the support
mailing list