[support] Moving hosting, site no longer works

[John Tate]

[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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130328/10946122/attachment-0001.html