[support] Moving hosting, site no longer works
Jamie Holly
hovercrafter at earthlink.net
Thu Mar 28 17:24:21 UTC 2013
LOL not a problem! That happens to the best of us. Glad you got it
figured out.
Jamie Holly
http://www.intoxination.net
http://www.hollyit.net
On 3/28/2013 5:08 AM, John Tate wrote:
> 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
> <mailto: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 'ssid' in 'where clause': 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] =>
> xwZt4FqBjh9Hf4T6qAm-1TJrfLHznoC6mXfiOeNbAMU
> [:db_condition_placeholder_1] => ) in _drupal_session_write()
> (line 209 of /sites/johntate.org/includes/session.inc
> <http://johntate.org/includes/session.inc>).
>
>
>
> On Thu, Mar 28, 2013 at 7:14 PM, John Tate <john at johntate.org
> <mailto: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
> <mailto: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
> <mailto: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 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>
>>
>>
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
>
>
>
> --
> www.johntate.org <http://www.johntate.org>
>
>
>
>
> --
> www.johntate.org <http://www.johntate.org>
>
>
>
>
> --
> www.johntate.org <http://www.johntate.org>
>
>
>
>
> --
> www.johntate.org <http://www.johntate.org>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130328/29f6dcd4/attachment-0001.html
More information about the support
mailing list