Powered by Orchid Suites
Orchid ver. 4.7.5.

2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [Logger.class.php] - Logger created.
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [Logger.class.php] - Logger thinks SITE_ID is 1
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [Mysql.class.php] - Established connection to db 'massist_orchid2' on topaz.orchidsuites.net:3306
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [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:25:26 (DEBUG) 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select sk.* from mass_skin sk where sk.id = 1 limit 1'
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [Request.class.php] - Creating request object from POST and GET information...
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [Request.class.php] - ...precedence is 'get'...
2008-11-23 08:25:26 (INFO) 38.103.63.58:41931 [Request.class.php] - ...request created. URI is '/ht/d/Contents/contenttype_id/1/pid/512'
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [TemplateEngine.class.php] - Created instance of 'smarty' template engine.
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [SessionHandler.class.php] - SessionHandler created:
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [SessionHandler.class.php] - - session name is 'masssession'
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [SessionHandler.class.php] - - session id is ''
2008-11-23 08:25:26 (DEBUG) 38.103.63.58:41931 [OrchidUser.class.php] - Anonymous user created.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Context.class.php] - Context object created.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [orchid.php] - No action requested.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [orchid.php] - Using display class "Contents.class.php"
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select section_id from mass_sectiondisplay where displayname='Contents''
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_stafferrole sr where staffer_id=1 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [BaseDisplay.class.php] - Rendering display 'Contents'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select p.survey_id from mass_page p where id = 512 and p.survey_id is not null limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateEngine.class.php] - *** Trying to determine if '/home/orchid/managementassistance.org/templates/raw/Contents.tpl' is cached with id mass|1|Contents|067d08f1577919be0c0f357f9bd19910.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateEngine.class.php] - *** Touching: /usr/local/orchid/templates/cached/mass_/mass/1/Contents/timestamp
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateEngine.class.php] - *** Clearing GROUP DISPLAY cache for mass|1|Contents|067d08f1577919be0c0f357f9bd19910
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateEngine.class.php] - *** Explicitly clearing cache for template with id mass|1|Contents
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateEngine.class.php] - *** Orchid says /home/orchid/managementassistance.org/templates/raw/Contents.tpl is NOT cached.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateDisplay.class.php] - ++++++++++++++ BEGIN TPLVARS +++++++++++++++++++++++
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select id from mass_page where site_id=1 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - Checking for administrator rights for 'anonymous'...
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - ...anonymous user - administrator rights NOT granted.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - Checking for technician rights for 'anonymous'...
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - ...anonymous user - technician rights NOT granted.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - Checking if 'anonymous' is a staffer for THIS site...
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - ...anonymous user - not a staffer user for THIS site.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - Checking if 'anonymous' is a client for THIS site...
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - ...anonymous user - not a client user for THIS site.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - Checking if 'anonymous' is a student for THIS site...
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - ...anonymous user - not a student user for THIS site.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - Checking if 'anonymous' is a caregiver for THIS site...
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - ...anonymous user - not a caregiver user for THIS site.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - Checking if 'anonymous' is an organizational user...
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [OrchidUser.class.php] - ...anonymous user - not an organization user.
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='catproduct' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='catproduct' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='typeproduct' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from mass_cat where dataset='typeproduct' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select singular_linktext, plural_linktext from mass_theme where id = 5 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select ct.name,ct.id from mass_contenttype ct left join mass_content c on c.contenttype_id=ct.id where c.id= limit 1'
2008-11-23 08:25:26 (ERROR) [1] 38.103.63.58:41931 [Mysql.class.php, Mysql.class.php, line 817] - #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 1' at line 1 SQL was: select ct.name,ct.id from mass_contenttype ct left join mass_content c on c.contenttype_id=ct.id where c.id=
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select name from mass_contenttype where id=1 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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=512) order by si.rank'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [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:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_datasetdetails where dataset='content' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateDisplay.class.php] - ++++++++++++++ END TPLVARS +++++++++++++++++++++++
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_contenttype where id=1 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_customfield where contenttype_id=1 and public='Y' order by rank'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_datatype where id=34 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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='content' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL: 'delete from mass_ustate where person_id=1 and sessionid='095qdotm5mukkge5bve2o3hpn3' and dataset_id is null and display='listingcontent' and action='' and name='contenttype_id''
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL: 'insert into mass_ustate (createdon,person_id,sessionid,dataset_id,display,action,name,value) values (now(),1,'095qdotm5mukkge5bve2o3hpn3',null,'listingcontent','','contenttype_id','1')'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select value from mass_ustate where person_id=1 and sessionid='095qdotm5mukkge5bve2o3hpn3' and dataset_id is null and display='listingcontent' and action='' and name='contenttype_id' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_contenttype where id=1 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select value from mass_ustate where person_id=1 and sessionid='095qdotm5mukkge5bve2o3hpn3' and dataset_id is null and display='listingcontent' and action='' and name='cat_id' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select verbiage from mass_pagecontrol where site_id=1 and page='Contents' and tag='content_sorting' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_datatype where id=34 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [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='content' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL: 'delete from mass_ustate where person_id=1 and sessionid='095qdotm5mukkge5bve2o3hpn3' and dataset_id is null and display='listingcontent' and action='' and name='contenttype_id''
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL: 'insert into mass_ustate (createdon,person_id,sessionid,dataset_id,display,action,name,value) values (now(),1,'095qdotm5mukkge5bve2o3hpn3',null,'listingcontent','','contenttype_id','1')'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select value from mass_ustate where person_id=1 and sessionid='095qdotm5mukkge5bve2o3hpn3' and dataset_id is null and display='listingcontent' and action='' and name='contenttype_id' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_contenttype where id=1 limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select value from mass_ustate where person_id=1 and sessionid='095qdotm5mukkge5bve2o3hpn3' and dataset_id is null and display='listingcontent' and action='' and name='cat_id' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select verbiage from mass_pagecontrol where site_id=1 and page='Contents' and tag='content_sorting' limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select distinct n.*, 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 from mass_content n left join mass_image i on (i.dataset_id = n.id) left join mass_sitecontent sn on (n.id = sn.content_id) left join mass_sitedatasetmemtype sdm on (n.id = sdm.dataset_id and sdm.site_id=1) where (n.removedon is null) and (n.site_id=1 or n.shared='Y') and ((n.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and n.membersonly = '') or n.pubblurb = 'Y') and (n.publishon is null or (n.publishon is not null and n.publishon <= now())) and (n.publishon is null or (n.publishon is not null and n.publishon <= now())) and (n.expireson is null or (n.expireson is not null and n.expireson >= now())) and n.contenttype_id=1 and ( sn.site_id=1 and sn.publish='Y' ) order by title asc limit 0,500'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select count(*) as count from mass_content n left join mass_image i on (i.dataset_id = n.id) left join mass_sitecontent sn on (n.id = sn.content_id) left join mass_sitedatasetmemtype sdm on (n.id = sdm.dataset_id and sdm.site_id=1) where (n.removedon is null) and (n.site_id=1 or n.shared='Y') and ((n.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and n.membersonly = '') or n.pubblurb = 'Y') and (n.publishon is null or (n.publishon is not null and n.publishon <= now())) and (n.publishon is null or (n.publishon is not null and n.publishon <= now())) and (n.expireson is null or (n.expireson is not null and n.expireson >= now())) and n.contenttype_id=1 and ( sn.site_id=1 and sn.publish='Y' ) limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select distinct n.*, 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 from mass_content n left join mass_image i on (i.dataset_id = n.id) left join mass_sitecontent sn on (n.id = sn.content_id) left join mass_sitedatasetmemtype sdm on (n.id = sdm.dataset_id and sdm.site_id=1) where (n.removedon is null) and (n.site_id=1 or n.shared='Y') and ((n.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and n.membersonly = '') or n.pubblurb = 'Y') and (n.publishon is null or (n.publishon is not null and n.publishon <= now())) and (n.publishon is null or (n.publishon is not null and n.publishon <= now())) and (n.expireson is null or (n.expireson is not null and n.expireson >= now())) and n.contenttype_id=1 and ( sn.site_id=1 and sn.publish='Y' ) order by title asc limit 1'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select distinct d.* from mass_document d left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = d.id and sdm.dataset = 'document' ) where ((d.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and d.membersonly = '')) and d.dataset_id = 422 and d.dataset = 'content' order by title'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select distinct d.* from mass_document d left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = d.id and sdm.dataset = 'document' ) where ((d.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and d.membersonly = '')) and d.dataset_id = 432 and d.dataset = 'content' order by title'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select distinct d.* from mass_document d left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = d.id and sdm.dataset = 'document' ) where ((d.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and d.membersonly = '')) and d.dataset_id = 430 and d.dataset = 'content' order by title'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select distinct d.* from mass_document d left join mass_sitedatasetmemtype sdm on (sdm.dataset_id = d.id and sdm.dataset = 'document' ) where ((d.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and d.membersonly = '')) and d.dataset_id = 422 and d.dataset = 'content' order by title'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select * from mass_contenttype'
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [Mysql.class.php] - Executing SQL select: 'select tag,visible,verbiage,editable from mass_pagecontrol where site_id=1 and page='Contents''
2008-11-23 08:25:26 (DEBUG) [1] 38.103.63.58:41931 [TemplateEngine.class.php] - Caching ***ON*** for template '/home/orchid/managementassistance.org/templates/raw/screen-header-1.tpl', id is mass|1|Contents|067d08f1577919be0c0f357f9bd19910.