Welcome to the Orchid Suites Tutorial Online!
Hope you enjoy this mini
tutorial. It is designed to give you
a better understanding of how to use our
dynamic and powerful Orchid software.
Please make sure you hit play on your video player
if the tutorial has not already started.
Remember you can hit pause at any time if you
wish to follow along on your own site.
If you still have questions please take
time to check out helpdesk.orchidsuites.net for
more tutorials, FAQs or to submit a trouble
ticket.
Log Messages (90)
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [Logger.class.php] - Logger created.
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [Logger.class.php] - Logger thinks SITE_ID is 45
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [Mysql.class.php] - Established connection to db 'orchidsu_demos' on topaz.orchidsuites.net:3306
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select s.*, t.dataset, sc.county_id from demos_site s left join demos_theme t on (t.id = s.theme_id) left join demos_sitecounty sc on s.id = sc.site_id where s.id = 45 limit 1'
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select sk.* from demos_skin sk where sk.id = 1 limit 1'
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [Request.class.php] - Creating request object from POST and GET information...
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [Request.class.php] - ...precedence is 'get'...
2008-10-06 10:04:32 (INFO) 38.103.63.61:46404 [Request.class.php] - ...request created. URI is '/tutorial/ht/display/Home/pid/838'
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [TemplateEngine.class.php] - Created instance of 'smarty' template engine.
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [SessionHandler.class.php] - SessionHandler created:
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [SessionHandler.class.php] - - session name is 'demossession'
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [SessionHandler.class.php] - - session id is ''
2008-10-06 10:04:32 (DEBUG) 38.103.63.61:46404 [OrchidUser.class.php] - Anonymous user created.
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Context.class.php] - Context object created.
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [orchid.php] - No action requested.
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [orchid.php] - Using display class "Home.class.php"
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_stafferrole sr where staffer_id=1 limit 1'
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [BaseDisplay.class.php] - Rendering display 'Home'
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select p.survey_id from demos_page p where id = 838 and p.survey_id is not null limit 1'
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [TemplateEngine.class.php] - *** Trying to determine if 'Home.tpl' is cached with id demos|45|Home|281eba802bb97c656a90e9b190eb1249.
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [TemplateEngine.class.php] - *** Touching: /usr/local/orchid-4-7-0/templates/cached/demos_/demos/45/Home/timestamp
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [TemplateEngine.class.php] - *** Smarty says Home.tpl is NOT cached.
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [TemplateDisplay.class.php] - ++++++++++++++ BEGIN TPLVARS +++++++++++++++++++++++
2008-10-06 10:04:32 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select name url from demos_personpersonalization where display='AdminTabs' and value='Y' and person_id=1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select id from demos_page where site_id=45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - Checking for administrator rights for 'anonymous'...
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - ...anonymous user - administrator rights NOT granted.
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - Checking for technician rights for 'anonymous'...
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - ...anonymous user - technician rights NOT granted.
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - Checking if 'anonymous' is a staffer for THIS site...
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - ...anonymous user - not a staffer user for THIS site.
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - Checking if 'anonymous' is a client for THIS site...
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - ...anonymous user - not a client user for THIS site.
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - Checking if 'anonymous' is a student for THIS site...
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - ...anonymous user - not a student user for THIS site.
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - Checking if 'anonymous' is a caregiver for THIS site...
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - ...anonymous user - not a caregiver user for THIS site.
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - Checking if 'anonymous' is an organizational user...
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [OrchidUser.class.php] - ...anonymous user - not an organization user.
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [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 demos_cat c left join demos_sitecat sc on ( sc.cat_id = c.id ) left join demos_datasetcat pc on (pc.cat_id = c.id) left join demos_product p on (pc.dataset_id = p.id) left join demos_catcomponent cc on (c.id = cc.cat_id_in) left join demos_catcomponent cp on (c.id = cp.cat_id_for) left join demos_siteprod sp on (p.id = sp.prod_id) left join demos_image i on (i.dataset_id = c.id) where cc.cat_id_for = '9' and (c.id = 9 or sc.site_id = 45 or sc.site_id = 1 ) and (c.dataset='catproduct') and sc.publish = 'Y' order by c.title'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [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 demos_cat c left join demos_sitecat sc on ( sc.cat_id = c.id ) left join demos_datasetcat pc on (pc.cat_id = c.id) left join demos_product p on (pc.dataset_id = p.id) left join demos_catcomponent cc on (c.id = cc.cat_id_in) left join demos_catcomponent cp on (c.id = cp.cat_id_for) left join demos_siteprod sp on (p.id = sp.prod_id) left join demos_image i on (i.dataset_id = c.id) where cc.cat_id_for = '10' and (c.id = 10 or sc.site_id = 45 or sc.site_id = 1 ) and (c.dataset='typeproduct') and sc.publish = 'Y' order by c.title'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select singular_linktext, plural_linktext from demos_theme where id = 5 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [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 demos_location l left join demos_state s on (s.id = l.state_id) left join demos_dataset ds on (ds.id = l.id) where ds.site_id=45 and l.main='Y' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select c.id, c.name,c.email,c.website from demos_organization c left join demos_dataset ds on (ds.id = c.id) where ds.site_id=45 order by c.id desc limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_progressbar pb left join demos_dataset ds on pb.id=ds.id where ds.site_id = 45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [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 demos_page p left join demos_bead b on (p.bead_id = b.id) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id=p.id and sdm.site_id=45) 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=45 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 =45 ) order by p.navloc, p.parent_id, p.rank'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id = h.id) where ds.site_id=45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from demos_sitesidebar si left join demos_sidebar sb on (si.sidebar_id = sb.id) left join demos_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join demos_image i on (i.dataset_id = sb.id) where si.site_id = 45 and si.publish = 'Y' and si.homepage = 'Y' order by si.rank'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from demos_sitesidebar si left join demos_sidebar sb on (si.sidebar_id = sb.id) left join demos_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join demos_image i on (i.dataset_id = sb.id) where si.site_id = 45 and si.publish = 'Y' and sp.page_id is null order by si.rank'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from demos_sitesidebar si left join demos_sidebar sb on (si.sidebar_id = sb.id) left join demos_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join demos_image i on (i.dataset_id = sb.id) where si.site_id = 45 and si.publish = 'Y' and sp.page_id is not null limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select count(ht.id) as count from demos_hottip ht left join demos_dataset ds on (ht.id = ds.id) where ds.site_id=45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select ht.* from demos_hottip ht left join demos_dataset ds on (ht.id = ds.id) WHERE ds.site_id = 45 order by rand() limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select count(q.id) as count from demos_quote q left join demos_dataset ds on (q.id = ds.id) where ds.site_id=45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select q.* from demos_quote q left join demos_dataset ds on (q.id = ds.id) WHERE ds.site_id = 45 order by date desc limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_faq f left join demos_faqcat fc on (fc.id = f.faqcat_id) left join demos_dataset ds on (ds.id = f.id and ds.site_id = 45) where fc.publish='Y' and f.publish='Y' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select distinct fc.id, fc.name from demos_faq f left join demos_faqcat fc on (fc.id = f.faqcat_id) left join demos_dataset ds on (ds.id = fc.id and ds.site_id = 45) where fc.publish='Y' and fc.parent_id is null and f.publish='Y' order by fc.name'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select distinct tc.id, tc.name, 'programcats' as thing from demos_siteprogram si left join demos_program tb on (tb.id = si.program_id) left join demos_issuecat tc on (tc.id = tb.issuecat_id) left join demos_siteissuecat sic on sic.issuecat_id = tc.id and (sic.site_id=45 or sic.site_id=1) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'program' ) where sic.publish='Y' and (sic.site_id=45 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 demos_sitelink sl left join demos_link tb on (tb.id = sl.link_id) left join demos_linkcat tc on (tc.id = tb.linkcat_id) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'link' ) where sl.site_id=45 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 demos_siteissue si left join demos_issue tb on (tb.id = si.issue_id) left join demos_issuecat tc on (tc.id = tb.issuecat_id) left join demos_siteissuecat stc on stc.issuecat_id = tc.id and (stc.site_id=45 or stc.site_id=1) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'issue' ) where stc.publish='Y' and (si.site_id=45 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 demos_event tb left join demos_eventcat tc on (tc.id = tb.eventcat_id) left join demos_siteevent se on tb.id = se.event_id left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'event' ) where se.site_id=45 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-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select distinct s.id from demos_site s left join demos_sitecounty sc on sc.site_id = s.id left join demos_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-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_registertovote rtv left join demos_dataset ds on (ds.id=rtv.id) where ds.site_id=45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_votebymail vbm left join demos_dataset ds on (ds.id=vbm.id) where ds.site_id=45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [TemplateDisplay.class.php] - ++++++++++++++ END TPLVARS +++++++++++++++++++++++
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id=h.id) where ds.site_id=45'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id=h.id) where ds.site_id=45 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'SELECT e.id, EXTRACT(DAY FROM e.start_date) AS day_of_event FROM demos_event e left join demos_siteevent se on (se.event_id = e.id) left join demos_sitedatasetmemtype sdm on (e.id = sdm.dataset_id and sdm.site_id=45) where e.convention<>'Y' and e.convention_id is null and e.start_date >= '2008-10-01' AND e.start_date < '2008-11-01' AND se.site_id = 45 and se.publish = 'Y' and ((e.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and e.membersonly = '')) '
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_homepage where site_id=45 and dataset='event' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select t.*, st.homepage, i.id as image_id, i.imagebytes, i.thumbbytes, i.imageh, i.imagew, i.thumbh, i.thumbw from demos_event t left join demos_siteevent st on (st.event_id = t.id) left join demos_dataset ds on (ds.id = t.id) left join demos_sitedatasetmemtype sdm on (t.id = sdm.dataset_id and sdm.dataset = 'event') left join demos_image i on (i.dataset_id=t.id and i.dataset='event') where t.id=4933 and st.publish='Y' and ( t.end_date is null or now() <= date_add(t.end_date, interval 60 day) ) and ((t.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and t.membersonly = '')) limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'SELECT * FROM demos_homepage h WHERE h.site_id=45 and whichpage='H' order by h.rank'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_datatype where id=4 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id = h.id) where ds.site_id=45 and h.feature_dataset='article' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select s.id from demos_site s left join demos_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-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [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 demos_article a left join demos_dataset ds on (a.id = ds.id) left join demos_image i on (i.dataset_id = a.id) left join demos_sitearticle sa on (a.id = sa.article_id) left join demos_sitedatasetmemtype sdm on (a.id = sdm.dataset_id and sdm.site_id=45) left join demos_issuecat ic on (a.issuecat_id = ic.id) WHERE (ds.removedon is null) AND (ds.site_id=45 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 (( sa.site_id=45 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-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select sf.*, f.*, ft.type as feedtype from demos_sitefeed sf left join demos_feed f on (f.id = sf.feed_id) left join demos_feedtype ft on (ft.id = f.feedtype_id) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = f.id) where sf.site_id=45 and sf.homepage_count > 0 and sf.publish = 'Y''
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select * from demos_datatype where id=16 limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id = h.id) where ds.site_id=45 and h.feature_dataset='event' limit 1'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select s.id from demos_site s left join demos_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-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [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 demos_event e left join demos_dataset ds on (e.id = ds.id) left join demos_image i on (i.dataset_id = e.id) left join demos_siteevent se on (e.id = se.event_id) left join demos_location l on (e.location_id = l.id) left join demos_sitedatasetmemtype sdm on (e.id = sdm.dataset_id and sdm.site_id=45) left join demos_eventcat ec on (e.eventcat_id = ec.id) where (ds.removedon is null) and e.convention_id is null and (ds.site_id=45 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) <= 60 and ( se.site_id=45 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,4'
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [Mysql.class.php] - Executing SQL select: 'select tag,visible,verbiage,editable from demos_pagecontrol where site_id=45 and page='Home''
2008-10-06 10:04:33 (DEBUG) [1] 38.103.63.61:46404 [TemplateEngine.class.php] - Caching ***ON*** for template 'screen-header-1.tpl', id is demos|45|Home|281eba802bb97c656a90e9b190eb1249.
