What's New
MAG releases easy-to-use guides
on boards, strategic planning, and managing
people. Download
now!
MAG's Inca Mohamed, Robin Katcher,
Susan Gross, and Mark Leach presented workshops
and panels at the Alliance for Nonprofit
Management's Annual Conference in Dearborn on
July 9-11. Learn
more.
MAG
is looking to hire a Senior
Consultant, and a Consulting Associate. Click
here for details and how to
apply.
1555 Connecticut Ave., NW, 3rd Floor Washington, DC 20036
Phone (202) 659-1963 | Fax (202)659-3105 |
mag@magmail.org
Log Messages (99)
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [Logger.class.php] - Logger created.
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [Logger.class.php] - Logger thinks SITE_ID is 1
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [Mysql.class.php] - Established connection to db 'massist_orchid2' on topaz.orchidsuites.net:3306
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select s.*, t.dataset, sc.county_id from mass_site s left join mass_theme t on (t.id = s.theme_id) left join mass_sitecounty sc on s.id = sc.site_id where s.id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select sk.* from mass_skin sk where sk.id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [Request.class.php] - Creating request object from POST and GET information...
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [Request.class.php] - ...precedence is 'get'...
2008-11-23 08:57:11 (INFO) 38.103.63.58:60012 [Request.class.php] - ...request created. URI is '/ht/d/Home/pid/221'
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [TemplateEngine.class.php] - Created instance of 'smarty' template engine.
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [SessionHandler.class.php] - SessionHandler created:
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [SessionHandler.class.php] - - session name is 'masssession'
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [SessionHandler.class.php] - - session id is ''
2008-11-23 08:57:11 (DEBUG) 38.103.63.58:60012 [OrchidUser.class.php] - Anonymous user created.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Context.class.php] - Context object created.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [orchid.php] - No action requested.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [orchid.php] - Using display class "Home.class.php"
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_stafferrole sr where staffer_id=1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [BaseDisplay.class.php] - Rendering display 'Home'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select p.survey_id from mass_page p where id = 221 and p.survey_id is not null limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [TemplateEngine.class.php] - *** Trying to determine if '/home/orchid/managementassistance.org/templates/raw/Home.tpl' is cached with id mass|1|Home|26e5ed60f995ca48acd5a8856d103ec8.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [TemplateEngine.class.php] - *** Touching: /usr/local/orchid/templates/cached/mass_/mass/1/Home/timestamp
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [TemplateEngine.class.php] - *** Clearing GROUP DISPLAY cache for mass|1|Home|26e5ed60f995ca48acd5a8856d103ec8
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [TemplateEngine.class.php] - *** Explicitly clearing cache for template with id mass|1|Home
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [TemplateEngine.class.php] - *** Orchid says /home/orchid/managementassistance.org/templates/raw/Home.tpl is NOT cached.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [TemplateDisplay.class.php] - ++++++++++++++ BEGIN TPLVARS +++++++++++++++++++++++
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select name url from mass_personpersonalization where display='AdminTabs' and value='Y' and person_id=1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select id from mass_page where site_id=1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - Checking for administrator rights for 'anonymous'...
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - ...anonymous user - administrator rights NOT granted.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - Checking for technician rights for 'anonymous'...
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - ...anonymous user - technician rights NOT granted.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - Checking if 'anonymous' is a staffer for THIS site...
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - ...anonymous user - not a staffer user for THIS site.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - Checking if 'anonymous' is a client for THIS site...
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - ...anonymous user - not a client user for THIS site.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - Checking if 'anonymous' is a student for THIS site...
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - ...anonymous user - not a student user for THIS site.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - Checking if 'anonymous' is a caregiver for THIS site...
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - ...anonymous user - not a caregiver user for THIS site.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - Checking if 'anonymous' is an organizational user...
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [OrchidUser.class.php] - ...anonymous user - not an organization user.
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='catproduct' limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='catproduct' limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct c.id, c.name, c.title, c.description, sc.publish, i.id as image_id, i.thumbbytes, i.imagebytes from mass_cat c left join mass_sitecat sc on ( sc.cat_id = c.id ) left join mass_datasetcat pc on (pc.cat_id = c.id) left join mass_product p on (pc.dataset_id = p.id) left join mass_catcomponent cc on (c.id = cc.cat_id_in) left join mass_catcomponent cp on (c.id = cp.cat_id_for) left join mass_siteprod sp on (p.id = sp.prod_id) left join mass_image i on (i.dataset_id = c.id) where cc.cat_id_for = '9' and (c.id = 9 or sc.site_id = 1 or sc.site_id = 1 ) and (c.dataset='catproduct') and sc.publish = 'Y' order by c.title'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='typeproduct' limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='typeproduct' limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct c.id, c.name, c.title, c.description, sc.publish, i.id as image_id, i.thumbbytes, i.imagebytes from mass_cat c left join mass_sitecat sc on ( sc.cat_id = c.id ) left join mass_datasetcat pc on (pc.cat_id = c.id) left join mass_product p on (pc.dataset_id = p.id) left join mass_catcomponent cc on (c.id = cc.cat_id_in) left join mass_catcomponent cp on (c.id = cp.cat_id_for) left join mass_siteprod sp on (p.id = sp.prod_id) left join mass_image i on (i.dataset_id = c.id) where cc.cat_id_for = '10' and (c.id = 10 or sc.site_id = 1 or sc.site_id = 1 ) and (c.dataset='typeproduct') and sc.publish = 'Y' order by c.title'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select singular_linktext, plural_linktext from mass_theme where id = 5 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select l.*, s.name as state, s.abbreviation as st, s.abbreviation as state_abbr, s.name as state_name from mass_location l left join mass_state s on (s.id = l.state_id) left join mass_dataset ds on (ds.id = l.id) where ds.site_id=1 and l.main='Y' limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select c.id, c.name,c.email,c.website from mass_organization c left join mass_dataset ds on (ds.id = c.id) where ds.site_id=1 order by c.id desc limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_progressbar pb left join mass_dataset ds on pb.id=ds.id where ds.site_id = 1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct p.*, if(b.public_display is null, b.details_display, b.public_display) public_display, b.details_display, b.public_cat_varname, b.parameters bead_parameters from mass_page p left join mass_bead b on (p.bead_id = b.id) left join mass_sitedatasetmemtype sdm on (sdm.dataset_id=p.id and sdm.site_id=1) where p.floating <> 'Y' and p.publish = 'Y' and (p.publishon is null or p.publishon < now()) and (p.expireson is null or p.expireson > now()) and p.site_id=1 and ((sdm.memtype_id is null and p.membersonly <> 'Y') or (sdm.memtype_id is null and p.membersonly = '')) and (sdm.site_id is null or sdm.site_id =1 ) order by p.navloc, p.parent_id, p.rank'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select h.* from mass_home h left join mass_dataset ds on (ds.id = h.id) where ds.site_id=1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from mass_sitesidebar si left join mass_sidebar sb on (si.sidebar_id = sb.id) left join mass_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join mass_image i on (i.dataset_id = sb.id) where si.site_id = 1 and si.publish = 'Y' and si.homepage = 'Y' order by si.rank'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from mass_sitesidebar si left join mass_sidebar sb on (si.sidebar_id = sb.id) left join mass_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join mass_image i on (i.dataset_id = sb.id) where si.site_id = 1 and si.publish = 'Y' and sp.page_id is null order by si.rank'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from mass_sitesidebar si left join mass_sidebar sb on (si.sidebar_id = sb.id) left join mass_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join mass_image i on (i.dataset_id = sb.id) where si.site_id = 1 and si.publish = 'Y' and sp.page_id is not null limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_faq f left join mass_faqcat fc on (fc.id = f.faqcat_id) left join mass_dataset ds on (ds.id = f.id and ds.site_id = 1) where fc.publish='Y' and f.publish='Y' limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct fc.id, fc.name from mass_faq f left join mass_faqcat fc on (fc.id = f.faqcat_id) left join mass_dataset ds on (ds.id = fc.id and ds.site_id = 1) where fc.publish='Y' and fc.parent_id is null and f.publish='Y' order by fc.name'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct tc.id, tc.name, 'programcats' as thing from mass_siteprogram si left join mass_program tb on (tb.id = si.program_id) left join mass_issuecat tc on (tc.id = tb.issuecat_id) left join mass_siteissuecat sic on sic.issuecat_id = tc.id and (sic.site_id=1 or sic.site_id=1) left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'program' ) where sic.publish='Y' and (sic.site_id=1 or sic.site_id=1) and tb.id is not null and tb.id <> 0 and si.publish='Y' and (tb.publishon is null or (tb.publishon is not null and tb.publishon <= now())) and (tb.expireson is null or (tb.expireson is not null and tb.expireson >= now())) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) union select distinct tc.id, tc.name, 'linkcats' as thing from mass_sitelink sl left join mass_link tb on (tb.id = sl.link_id) left join mass_linkcat tc on (tc.id = tb.linkcat_id) left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'link' ) where sl.site_id=1 and tb.id is not null and tb.id <> 0 and sl.publish='Y' and (tc.parent_id = 0 or tc.parent_id is null) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) union select distinct tc.id, tc.name, 'issuecats' as thing from mass_siteissue si left join mass_issue tb on (tb.id = si.issue_id) left join mass_issuecat tc on (tc.id = tb.issuecat_id) left join mass_siteissuecat stc on stc.issuecat_id = tc.id and (stc.site_id=1 or stc.site_id=1) left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'issue' ) where stc.publish='Y' and (si.site_id=1 or si.site_id=1) and tb.id is not null and tb.id <> 0 and si.publish='Y' and (tb.publishon is null or (tb.publishon is not null and tb.publishon <= now())) and (tb.expireson is null or (tb.expireson is not null and tb.expireson >= now())) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) union select distinct tc.id, tc.name, 'eventcats' as thing from mass_event tb left join mass_eventcat tc on (tc.id = tb.eventcat_id) left join mass_siteevent se on tb.id = se.event_id left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'event' ) where se.site_id=1 and tb.id is not null and tb.id <> 0 and se.publish='Y' and now() < date_add( tb.start_date, interval 2 day ) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) order by thing, name'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct s.id from mass_site s left join mass_sitecounty sc on sc.site_id = s.id left join mass_dataset ds on ds.site_id = s.id where s.state_id = 0 and s.theme_id = 1 and sc.id is null order by s.id desc limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_registertovote rtv left join mass_dataset ds on (ds.id=rtv.id) where ds.site_id=1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_votebymail vbm left join mass_dataset ds on (ds.id=vbm.id) where ds.site_id=1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [TemplateDisplay.class.php] - ++++++++++++++ END TPLVARS +++++++++++++++++++++++
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select h.* from mass_home h left join mass_dataset ds on (ds.id=h.id) where ds.site_id=1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select h.* from mass_home h left join mass_dataset ds on (ds.id=h.id) where ds.site_id=1 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'SELECT e.id, EXTRACT(DAY FROM e.start_date) AS day_of_event FROM mass_event e left join mass_siteevent se on (se.event_id = e.id) left join mass_sitedatasetmemtype sdm on (e.id = sdm.dataset_id and sdm.site_id=1) where e.convention<>'Y' and e.convention_id is null and e.start_date >= '2008-11-01' AND e.start_date < '2008-12-01' AND se.site_id = 1 and se.publish = 'Y' and ((e.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and e.membersonly = '')) '
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'SELECT * FROM mass_homepage h WHERE h.site_id=1 and whichpage='H' order by h.rank'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct ds.site_id, a.*, ct.firstname as contact_firstname, ct.lastname as contact_lastname, ct.organization as contact_organization, ct.title as contact_title, ct.email as contact_email, ct.ph_office as contact_ph_office, ct.ph_fax as contact_ph_fax, sf.nickname as staffer_nickname, sf.lastname as staffer_lastname, sf.title as staffer_title, sf.email as staffer_email, sf.ph_office as staffer_ph_office, sf.ph_fax as staffer_ph_fax from mass_alert a left join mass_dataset ds on (ds.id=a.id) left join mass_contact ct on (ct.id = a.contact_id) left join mass_person sf on (sf.id = a.staffer_id) left join mass_sitealert sa on (a.id = sa.alert_id) left join mass_sitedatasetmemtype sdm on (a.id = sdm.dataset_id and sdm.site_id=1) where ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = '')) aNd (a.deadline is null or NOW() < date_add(a.deadline, interval 30 day) ) aNd NOW() <= a.deadline aNd (a.publishon is null or NOW() >= a.publishon) aNd (a.expireson is null or NOW() < a.expireson) aNd (ds.site_id=1 or a.shared='Y') aNd sa.site_id=1 aNd sa.homepage='Y' order by a.deadline DESC limit 0,5'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_datatype where id=30 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select h.* from mass_home h left join mass_dataset ds on (ds.id = h.id) where ds.site_id=1 and h.feature_dataset='release' limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select s.id from mass_site s left join mass_sitecounty sc on (sc.site_id = s.id) where s.state_id is null and sc.county_id is null and s.theme_id=5 limit 1'
2008-11-23 08:57:11 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct r.*, ds.site_id, i.id as image_id, i.imagebytes as imagebytes, i.imagew as imagew, i.imageh as imageh, i.thumbbytes as thumbbytes, i.thumbw as thumbw, i.thumbh as thumbh, ic.name as catname from mass_release r left join mass_dataset ds on (r.id = ds.id) left join mass_image i on (i.dataset_id = r.id) left join mass_siterelease sr on (r.id = sr.release_id) left join mass_sitedatasetmemtype sdm on (r.id = sdm.dataset_id and sdm.site_id=1) left join mass_issuecat ic on (r.issuecat_id = ic.id) WHERE (ds.removedon is null) AND (ds.site_id=1 or r.shared='Y') AND ((r.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and r.membersonly = '') or r.pubblurb = 'Y') AND (r.publishon is null or (r.publishon is not null and r.publishon <= now())) AND (r.expireson is null or (r.expireson is not null and r.expireson >= now())) AND to_days(now()) - to_days(r.date) <= 30 AND (( sr.site_id=1 and sr.publish='Y' and sr.homepage='Y' ) or ( sr.site_id=1 and sr.publish='Y' and sr.homepage='Y' and (r.pushlocal = 'Y' or r.pushstate = 'Y') )) order by r.date DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_datatype where id=4 limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select h.* from mass_home h left join mass_dataset ds on (ds.id = h.id) where ds.site_id=1 and h.feature_dataset='article' limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select s.id from mass_site s left join mass_sitecounty sc on (sc.site_id = s.id) where s.state_id is null and sc.county_id is null and s.theme_id=5 limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct a.*, ds.site_id, i.id as image_id, i.imagebytes as imagebytes, i.imagew as imagew, i.imageh as imageh, i.thumbbytes as thumbbytes, i.thumbw as thumbw, i.thumbh as thumbh, ic.name as catname from mass_article a left join mass_dataset ds on (a.id = ds.id) left join mass_image i on (i.dataset_id = a.id) left join mass_sitearticle sa on (a.id = sa.article_id) left join mass_sitedatasetmemtype sdm on (a.id = sdm.dataset_id and sdm.site_id=1) left join mass_issuecat ic on (a.issuecat_id = ic.id) WHERE (ds.removedon is null) AND (ds.site_id=1 or a.shared='Y') AND ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = '') or a.pubblurb = 'Y') AND (a.publishon is null or (a.publishon is not null and a.publishon <= now())) AND (a.expireson is null or (a.expireson is not null and a.expireson >= now())) AND to_days(now()) - to_days(a.date) <= 30 AND (( sa.site_id=1 and sa.publish='Y' and sa.homepage='Y' ) or ( sa.site_id=1 and sa.publish='Y' and sa.homepage='Y' and (a.pushlocal = 'Y' or a.pushstate = 'Y') )) order by a.date DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select sf.*, f.*, ft.type as feedtype from mass_sitefeed sf left join mass_feed f on (f.id = sf.feed_id) left join mass_feedtype ft on (ft.id = f.feedtype_id) left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = f.id) where sf.site_id=1 and sf.homepage_count > 0 and sf.publish = 'Y''
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct ds.site_id, i.*, ic.name as category, si.stand from mass_siteissue si left join mass_issue i on (i.id = si.issue_id) left join mass_dataset ds on (ds.id = i.id) left join mass_issuecat ic on (ic.id = i.issuecat_id) left join mass_sitedatasetmemtype sdm on (i.id = sdm.dataset_id and sdm.dataset = 'issue') where ((i.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and i.membersonly = '')) aNd (i.publishon is null or NOW() >= i.publishon) aNd (i.expireson is null or NOW() < i.expireson) aNd (ds.site_id=1 or i.shared='Y') aNd si.site_id=1 aNd si.homepage='Y' order by si.rank DESC, i.title DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_datatype where id=16 limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select h.* from mass_home h left join mass_dataset ds on (ds.id = h.id) where ds.site_id=1 and h.feature_dataset='event' limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select s.id from mass_site s left join mass_sitecounty sc on (sc.site_id = s.id) where s.state_id is null and sc.county_id is null and s.theme_id=5 limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct e.*, ds.site_id, i.id as image_id, i.imagebytes as imagebytes, i.imagew as imagew, i.imageh as imageh, i.thumbbytes as thumbbytes, i.thumbw as thumbw, i.thumbh as thumbh, l.name as locationname, ec.name as catname from mass_event e left join mass_dataset ds on (e.id = ds.id) left join mass_image i on (i.dataset_id = e.id) left join mass_siteevent se on (e.id = se.event_id) left join mass_location l on (e.location_id = l.id) left join mass_sitedatasetmemtype sdm on (e.id = sdm.dataset_id and sdm.site_id=1) left join mass_eventcat ec on (e.eventcat_id = ec.id) where (ds.removedon is null) and e.convention_id is null and (ds.site_id=1 or e.shared='Y') and ((e.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and e.membersonly = '') or e.pubblurb = 'Y') and to_days(now()) - to_days(e.end_date) <= 30 and ( se.site_id=1 and se.publish='Y' and se.homepage='Y' ) or ( se.site_id=1 and se.publish='Y' and se.homepage='Y' and (e.pushlocal = 'Y' or e.pushstate = 'Y') ) order by e.start_date DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select * from mass_datatype where id=28 limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select h.* from mass_home h left join mass_dataset ds on (ds.id = h.id) where ds.site_id=1 and h.feature_dataset='program' limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select s.id from mass_site s left join mass_sitecounty sc on (sc.site_id = s.id) where s.state_id is null and sc.county_id is null and s.theme_id=5 limit 1'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct p.*, ds.site_id, i.id as image_id, i.imagebytes as imagebytes, i.imagew as imagew, i.imageh as imageh, i.thumbbytes as thumbbytes, i.thumbw as thumbw, i.thumbh as thumbh, ct.firstname as contact_firstname, ct.lastname as contact_lastname, ct.organization as contact_organization, ct.title as contact_title, ct.email as contact_email, ct.ph_office as contact_ph_office, ct.ph_fax as contact_ph_fax, sf.nickname as staffer_nickname, sf.lastname as staffer_lastname, sf.title as staffer_title, sf.email as staffer_email, sf.ph_office as staffer_ph_office, sf.ph_fax as staffer_ph_fax, ic.name as catname, ic.name as category, ic.name as cat_title from mass_program p left join mass_dataset ds on (p.id = ds.id) left join mass_image i on (i.dataset_id = p.id) left join mass_siteprogram sp on (p.id = sp.program_id) left join mass_sitedatasetmemtype sdm on (p.id = sdm.dataset_id and sdm.site_id=1) left join mass_person sf on (sf.id = p.staffer_id) left join mass_contact ct on ( ct.id = p.contact_id ) left join mass_issuecat ic on (p.issuecat_id = ic.id) WHERE (ds.removedon is null) AND (ds.site_id=1 or p.shared='Y') AND ((p.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and p.membersonly = '') or p.pubblurb = 'Y') AND (p.publishon is null or (p.publishon is not null and p.publishon <= now())) AND (p.expireson is null or (p.expireson is not null and p.expireson >= now())) AND (( sp.site_id=1 and sp.publish='Y' and sp.homepage='Y' ) or ( sp.site_id=1 and sp.publish='Y' and sp.homepage='Y' and (p.pushlocal = 'Y' or p.pushstate = 'Y') )) order by p.createdon DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct ds.site_id, a.* from mass_sitealbum sa left join mass_album a on (a.id = sa.album_id) left join mass_dataset ds on (ds.id = a.id) left join mass_sitedatasetmemtype sdm on (a.id = sdm.dataset_id and sdm.site_id=1) left join mass_datasetcat dc on (dc.dataset_id = a.id) left join mass_cat c on (c.id = dc.cat_id) where ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = '')) aNd (a.date is null or NOW() < date_add(a.date, interval 30 day) ) aNd (ds.site_id=1 or a.shared='Y') aNd sa.site_id=1 aNd sa.homepage='Y' order by a.date DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct ds.site_id, l.*, l.body as blurb, 1 deletable, c.title as cat_title, c.description as cat_description, c.id as cat_id, lc.name as category from mass_link l left join mass_sitelink sl on l.id = sl.link_id left join mass_linkcat lc on lc.id = l.linkcat_id left join mass_dataset ds on l.id = ds.id left join mass_site s on (ds.site_id = s.id) left join mass_borderingstate bs on (bs.state_id = s.state_id) left join mass_sitedatasetmemtype sdm on (sdm.dataset_id=l.id and sdm.site_id=1 and sdm.dataset='link') left join mass_datasetcat dc on (dc.dataset_id = l.id) left join mass_cat c on (c.id = dc.cat_id) where ((l.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and l.membersonly = '')) aNd (ds.site_id=1 or l.shared='Y') aNd sl.site_id=1 aNd sl.homepage='Y' order by l.title DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select distinct be.*, sb.publish, sb.homepage, p.nickname, p.lastname, concat(p.firstname, ' ', p.lastname) as author, p.email as authoremail, i.id as image_id, i.thumbbytes, i.thumbw, i.thumbh from mass_blogentry be left join mass_siteblogentry sb on (be.id = sb.blogentry_id and sb.site_id=1) left join mass_dataset ds on (ds.id = be.id) left join mass_person p on (p.id = be.createdby) left join mass_image i on (i.dataset_id=p.id) left join mass_sitedatasetmemtype sdm on (be.id = sdm.dataset_id and sdm.site_id=1) left join mass_site s on ds.site_id = s.id left join mass_borderingstate bs on s.state_id = bs.state_id where ((be.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and be.membersonly = '')) aNd (ds.site_id=1 or be.shared='Y') aNd sb.site_id=1 aNd sb.homepage='Y' order by be.createdon DESC limit 0,5'
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [Mysql.class.php] - Executing SQL select: 'select tag,visible,verbiage,editable from mass_pagecontrol where site_id=1 and page='Home''
2008-11-23 08:57:12 (DEBUG) [1] 38.103.63.58:60012 [TemplateEngine.class.php] - Caching ***ON*** for template '/home/orchid/managementassistance.org/templates/raw/screen-header-1.tpl', id is mass|1|Home|26e5ed60f995ca48acd5a8856d103ec8.
