[support] Moving hosting, site no longer works

[Jamie Holly]

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 at earthlink.net <mailto: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
>>     <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 at earthlink.net <mailto: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 <mailto: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
>>>             <mailto: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
>>>                 <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>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130327/bf6bd02d/attachment-0001.html