I moved from Dreamhost to my own server and all the files are in tact and the MySQL database has been copied exactly but it doesn't work...
Error message: Notice: Undefined index: cti_flex in _drupal_maintenance_theme() (line 74 of /sites/johntate.org/includes/theme.maintenance.inc). Notice: Trying to get property of non-object in _drupal_theme_initialize() (line 145 of /sites/johntate.org/includes/theme.inc). 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). Notice: Trying to get property of non-object in _theme_build_registry() (line 710 of /sites/johntate.org/includes/theme.inc). Notice: Trying to get property of non-object in _theme_build_registry() (line 710 of /sites/johntate.org/includes/theme.inc). Notice: Trying to get property of non-object in _theme_build_registry() (line 710 of /sites/johntate.org/includes/theme.inc). Notice: Undefined index: cti_flex in theme_get_setting() (line 1414 of /sites/johntate.org/includes/theme.inc). Notice: Trying to get property of non-object in theme_get_setting() (line 1461 of /sites/johntate.org/includes/theme.inc). Notice: Undefined index: cti_flex in template_preprocess_maintenance_page() (line 2704 of /sites/johntate.org/includes/theme.inc). Notice: Trying to get property of non-object in template_preprocess_maintenance_page() (line 2704 of /sites/ johntate.org/includes/theme.inc). Warning: array_keys() expects parameter 1 to be array, null given in template_preprocess_maintenance_page() (line 2707 of /sites/ johntate.org/includes/theme.inc). Warning: Invalid argument supplied for foreach() in template_preprocess_maintenance_page() (line 2707 of /sites/ johntate.org/includes/theme.inc).
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).
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@earthlink.netwrote:
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/ ]
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@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@earthlink.netwrote:
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
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@johntate.org mailto:john@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@earthlink.net <mailto:hovercrafter@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
[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@earthlink.netwrote:
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@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@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/ ]
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@earthlink.net mailto:hovercrafter@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@johntate.org <mailto:john@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@earthlink.net <mailto:hovercrafter@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
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@earthlink.netwrote:
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@earthlink.netwrote:
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@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@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/ ]
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@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@earthlink.netwrote:
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@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@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@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
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@earthlink.net mailto:hovercrafter@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@earthlink.net <mailto:hovercrafter@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@johntate.org <mailto:john@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@earthlink.net <mailto:hovercrafter@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
There was nothing in those tables, problem persists.
On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly hovercrafter@earthlink.netwrote:
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.incon line 321
I still don't understand why this is happening.
On Thu, Mar 28, 2013 at 11:14 AM, Jamie Holly hovercrafter@earthlink.netwrote:
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@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@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@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/ ]
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@johntate.org wrote:
There was nothing in those tables, problem persists.
On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly hovercrafter@earthlink.netwrote:
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.incon line 321
I still don't understand why this is happening.
On Thu, Mar 28, 2013 at 11:14 AM, Jamie Holly <hovercrafter@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@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@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@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
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).
On Thu, Mar 28, 2013 at 7:14 PM, John Tate john@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@johntate.org wrote:
There was nothing in those tables, problem persists.
On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly <hovercrafter@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.incon line 321
I still don't understand why this is happening.
On Thu, Mar 28, 2013 at 11:14 AM, Jamie Holly < hovercrafter@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@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@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@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
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@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).
On Thu, Mar 28, 2013 at 7:14 PM, John Tate john@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@johntate.org wrote:
There was nothing in those tables, problem persists.
On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly < hovercrafter@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@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@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@johntate.orgwrote:
> 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@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
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@johntate.org mailto:john@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@johntate.org <mailto:john@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@johntate.org <mailto:john@johntate.org>> wrote: There was nothing in those tables, problem persists. On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly <hovercrafter@earthlink.net <mailto:hovercrafter@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@earthlink.net <mailto:hovercrafter@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@earthlink.net <mailto:hovercrafter@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@johntate.org <mailto:john@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@earthlink.net <mailto:hovercrafter@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
Just a thought, but why not try using the backup and migrate module along with the pathologic module. I have moves sites and use these two modules and have had good success.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of John Tate Sent: Thursday, March 28, 2013 4:03 AM To: support@drupal.org Subject: Re: [support] Moving hosting, site no longer works
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).
On Thu, Mar 28, 2013 at 7:14 PM, John Tate john@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@johntate.org wrote:
There was nothing in those tables, problem persists.
On Thu, Mar 28, 2013 at 12:03 PM, Jamie Holly hovercrafter@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 on line 321
I still don't understand why this is happening.
On Thu, Mar 28, 2013 at 11:14 AM, Jamie Holly hovercrafter@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 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@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@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@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 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).
-- [ 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
I would but dreamhost isn't very flexible and I thought I had everything and could move the domain. As it was I had to find the IP of Dreamhosts mysql server which wasn't easy because it was just mysql.johntate.org. If I had noticed my error in the first place I wouldn't have had to go to so much effort, so adding to my stupidity part of me just really wanted drupal to be at fault and it was bending my vision.
On Thu, Mar 28, 2013 at 11:12 PM, Jim Ruby jim@v-community.com wrote:
Just a thought, but why not try using the backup and migrate module along with the pathologic module. I have moves sites and use these two modules and have had good success.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of John Tate Sent: Thursday, March 28, 2013 4:03 AM To: support@drupal.org Subject: Re: [support] Moving hosting, site no longer works
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).
On Thu, Mar 28, 2013 at 7:14 PM, John Tate john@johntate.org wrote:
There is stuff in the table cache on dreamhost, mysqldump isn'tworking or something.
On Thu, Mar 28, 2013 at 7:12 PM, John Tate <john@johntate.org>wrote:
There was nothing in those tables, problem persists. On Thu, Mar 28, 2013 at 12:03 PM, Jamie Hollyhovercrafter@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 shouldhave 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] PHPFatal 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 ishappening.
On Thu, Mar 28, 2013 at 11:14 AM, JamieHolly hovercrafter@earthlink.net wrote:
I move sites all the time with afull mysqldump, including some that are 3-4gb in size.
Are you sure the full source codegot 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 Tatewrote:
[Wed Mar 27 16:59:13 2013tel:13%202013 ] [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 youget than a mysqldump? It just makes no sense. I might have to start over.
On Thu, Mar 28, 2013 at10:37 AM, Jamie Holly hovercrafter@earthlink.net wrote:
Nope, it's lookingfor 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 yourother 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 NOTEXISTS `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.hollyit.net On 3/27/2013 7:27 PM, John Tate wrote:
Sorry Ijust 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, Mar28, 2013 at 10:19 AM, John Tate john@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.
OnThu, Mar 28, 2013 at 10:09 AM, Jamie Holly hovercrafter@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 Holly
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 supportlist | http://lists.drupal.org/ ]
-- www.johntate.org -- [ Drupal support list |-- www.johntate.org -- [ Drupal support list | http://lists.drupal.org/ ] -- www.johntate.org -- www.johntate.org-- www.johntate.org
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Jamie Holly -
Jim Ruby -
John Tate