Re: [support] Moving hosting, site no longer works

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 http://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@earthlink.net mailto:hovercrafter@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
<http://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@earthlink.net <mailto:hovercrafter@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@johntate.org <mailto:john@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@earthlink.net
        <mailto:hovercrafter@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
            <http://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
            <http://johntate.org/includes/bootstrap.inc>).

            --
            [ Drupal support list | http://lists.drupal.org/ ]




        -- 
        www.johntate.org <http://www.johntate.org>




    -- 
    www.johntate.org <http://www.johntate.org>

    --
    [ Drupal support list | http://lists.drupal.org/ ]




-- 
www.johntate.org <http://www.johntate.org>

--
[ Drupal support list | http://lists.drupal.org/ ]

-- www.johntate.org http://www.johntate.org