RE: [drupal-1] Urgent Newbie Help

I can give it a shot Wednesday.  Call me at work 217-333-3667.

I've been moving sites around recently and helping some others do so.

The most recent problems I've seen are:

- not disabling friendly urls before the move and not having the redirect setup correctly on the new server
- having the correct db connection username and password, but not
   -- the new correct hostname
   -- putting the db on the new mysql server, but not putting the user on the new mysql server
- having an incorrect folder structure and the same url and configuration.  Sites/default sites/

- taking an old db with a newer version of drupal and contrib  modules and not running update.php first.


Below is some SQL I run before I start debugging a recently moved site.  Use at your own risk. 

John Barclay, College of Education, UIUC 


-- queries to set drupal to a good debugging state
-- flushing caches, turning off problematic modules, turning off contrib themes, etc.
-- uncomment as needed.  could be turned into a parameterized function

-- 1.  turn off possible problem modules. put your usual suspects in here as needed

-- update system set status = 0 where type = 'module' and status = 1 and name in ('accessible','devel');
-- update system set status = 0 where  type = 'module' and name in  ('civicrm','logintoboggan','accessible','coe','coeauth','pathauto');


-- check for domain in variables that may be off from dev and production moves
-- select * from variable where value like '%webmasters%';

-- reset civicrm settings
-- UPDATE civicrm_domain SET config_backend = NULL WHERE id = 1 LIMIT 1 ;


-- flush caches
truncate table cache_block;
truncate table cache;
truncate table cache_content;
truncate table cache_filter;
truncate table cache_form;
truncate table cache_menu;
truncate table cache_views;
truncate table sessions;
-- truncate table watchdog; -- this is more of performance issue.  won't help with debugging. may lose critical info to debugging process.


-- turn off all the themes and turn on garland

update system set status = 0 where type = 'theme'; 
update system set status = 1 where type = 'theme' and name = 'garland';
update variable set value = 's:12:"garland";' where name = 'theme_default';



-- turn off clean urls
update variable set value = 's:1:"0"' WHERE name = 'clean_url';

-- fix any changes in module locations, if they are off
-- update menu_router set file = replace(file,'modules/modules/','modules/');

-- fix temp path for files and turn off some aggregation
-- update variable set value = 's:4:"/inetpub/tmp";' where name = 'file_directory_temp';

-- turn off compression.  can bother designers

update variable set value = 's:1:"0";' where name = 'preprocess_css';
update variable set value = 's:1:"0";' where name = 'preprocess_js';
update variable set value = 's:1:"0";' where name = 'page_compression';

DROP PROCEDURE IF EXISTS Drupal_Find;

DELIMITER |
CREATE PROCEDURE Drupal_Find (IN find varchar(255), OUT rs Text)
BEGIN
  DECLARE LIKE_ARG varchar(255);
  SET @LIKE_ARG =  CONCAT('%',find,'%');
  SELECT  'node' as  table_name, 'title' as field_name, title as field_value, nid as id, 
	  concat("/node/",CAST(nid AS CHAR),"/edit") as edit_url , NULL as comment
	  FROM node WHERE title like @LIKE_ARG
  UNION 
	SELECT  'node_revisions' as  table_name, 'title' as field_name, title as field_value, nid as id, 
	  concat("/node/",CAST(nid AS CHAR),"/edit") as url, 'url only edits most recent revision' as comment
		FROM node_revisions WHERE title like @LIKE_ARG
  UNION
	SELECT  'node_revisions' as  table_name, 'body' as field_name, body as field_value, nid as id, 
	  concat("/node/",CAST(nid AS CHAR),"/edit") as url, 'url only edits most recent revision' as comment 
		FROM node_revisions WHERE body like @LIKE_ARG
  UNION
	SELECT  'node_revisions' as  table_name, 'teaser' as field_name, teaser as field_value, nid as id, 
	  concat("/node/",CAST(nid AS CHAR),"/edit") as url, 'url only edits most recent revision' as comment 
		FROM node_revisions WHERE teaser like @LIKE_ARG

  UNION
	SELECT  'blocks' as  table_name, 'title' as field_name, title as field_value, bid as id, 
	  concat("/block/",CAST(bid AS CHAR),"/edit") as url, NULL as comment 
		FROM blocks WHERE title like @LIKE_ARG
  UNION
	SELECT  'variable' as  table_name, 'value' as field_name, 
	concat('name=',name,',value=',value) as field_value, 0 as id, 
	  'none' as url, NULL as comment 
		FROM variable WHERE value like @LIKE_ARG
		;
END;
|
DELIMITER ;

-- see if any hard coded references to old domain are in critical spots in the db such as menu or module paths
CALL Drupal_Find('illini',@discardme);
















-----Original Message-----
From: [address removed] [mailto:[address removed]] On Behalf Of kelly thomas
Sent: Tuesday, June 23, 2009 11:55 PM
To: [address removed]
Subject: [drupal-1] Urgent Newbie Help

Hi, Kelly Thomas of the Southern Illinois University Daily Egyptian  
(DE) newspaper here. We're wanting to bring our web site back in- 
house  and looking to Drupal as a very likely solution. Our problem  
is that the Daily Illini (DI)  at U of I gave us their "template" &  
frameworks to use as a starting point and I can't get it to load on  
my server. Neither can the DI programmer. I've been through all the  
config files, spent hours on google reading "moving a Drupal Site",  
and whatever it is, I'm not seeing it. A basic Core install does work  
on this server.

I'm looking for someone with mojo who's willing to give a little help  
to a non-profit.

oh, I'm supposed to demo this on THURS, June 25th...

Thank you.
/kelly thomas
SIUDE.com
618-536-3308

site: http://illini.rhi...

test of core: http://drutest.rh...



--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
http://drupal.mee...
This message was sent by kelly thomas ([address removed]) from Chicago Drupal Meet Up Group.
To learn more about kelly thomas, visit his/her member profile: http://drupal.mee...
To unsubscribe or to update your mailing list settings, click here: http://www.meetup...
Meetup Support: [address removed]
632 Broadway, New York, NY 10012 USA