[support] Moving hosting, site no longer works

[John Tate]

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?



On Thu, Mar 28, 2013 at 11:32 AM, John Tate <john at johntate.org> 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.incon 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 Hollyhttp://www.intoxination.net http://www.hollyit.net
>>
>> On 3/27/2013 8:05 PM, John Tate wrote:
>>
>> [Wed Mar 27 16:59:13 2013] [error] PHP Fatal error:  Class
>> 'SelectQueryExtender' not found in /sites/johntate.org/includes/pager.incon 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 Hollyhttp://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 Hollyhttp://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
>



-- 
www.johntate.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130328/bd0aaf55/attachment.html