[support] Moving hosting, site no longer works

[Jamie Holly]

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] [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>
>
>

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