[support] Moving hosting, site no longer works

John Tate john at johntate.org
Thu Mar 28 09:08:22 UTC 2013 

I've just realized I've backed up johntate_dropdb which is my old drupal 6
database, I wanted to back up johntate_drupal7db

Sorry I've just wasted everyones time!


On Thu, Mar 28, 2013 at 8:03 PM, John Tate <john at johntate.org> wrote:

> I forgot to mention I tried update.php at some point. I just dropped the
> database, created it, and executed the SQL backup on it and then created
> blocked_ips again.
>
> Now I get this...
> Uncaught exception thrown in session handler.
>
> PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column
> &#039;ssid&#039; in &#039;where clause&#039;: SELECT 1 AS expression FROM
> {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid =
> :db_condition_placeholder_1) ) FOR UPDATE; Array (
> [:db_condition_placeholder_0] =&gt;
> xwZt4FqBjh9Hf4T6qAm-1TJrfLHznoC6mXfiOeNbAMU [:db_condition_placeholder_1]
> =&gt; ) in _drupal_session_write() (line 209 of /sites/
> johntate.org/includes/session.inc).
>
>
> On Thu, Mar 28, 2013 at 7:14 PM, John Tate <john at johntate.org> wrote:
>
>> There is stuff in the table cache on dreamhost, mysqldump isn't working
>> or something.
>>
>>
>> On Thu, Mar 28, 2013 at 7:12 PM, John Tate <john at johntate.org> wrote:
>>
>>> There was nothing in those tables, problem persists.
>>>
>>>
>>> On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly <
>>> hovercrafter at earthlink.net> wrote:
>>>
>>>>  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 Hollyhttp://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 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> 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.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> 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
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>
>>>
>>>
>>>
>>> --
>>> www.johntate.org
>>>
>>
>>
>>
>> --
>> www.johntate.org
>>
>
>
>
> --
> www.johntate.org
>



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

More information about the support mailing list