Log Messages (65)
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [Logger.class.php] - Logger created.
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [Logger.class.php] - Logger thinks SITE_ID is 45
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [Mysql.class.php] - Established connection to db 'orchidsu_demos' on topaz.orchidsuites.net:3306
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select sk.* from demos_skin sk where sk.id = 1 limit 1'
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [Request.class.php] - Creating request object from POST and GET information...
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [Request.class.php] - ...precedence is 'get'...
2008-07-24 18:13:25 (INFO) 38.103.63.16:48785 [Request.class.php] - ...request created. URI is '/tutorial/ht/display/Login'
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [TemplateEngine.class.php] - Created instance of 'smarty' template engine.
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [SessionHandler.class.php] - SessionHandler created:
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [SessionHandler.class.php] - - session name is 'demossession'
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [SessionHandler.class.php] - - session id is ''
2008-07-24 18:13:25 (DEBUG) 38.103.63.16:48785 [OrchidUser.class.php] - Anonymous user created.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Context.class.php] - Context object created.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [orchid.php] - No action requested.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [orchid.php] - Using display class "Login.class.php"
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select * from demos_stafferrole sr where staffer_id=1 limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [BaseDisplay.class.php] - Rendering display 'Login'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select p.id, p.survey_id from demos_page p left join demos_bead b on (p.bead_id = b.id) left join demos_dataset ds on (ds.id = p.id) where (public_display = 'Login') and ds.site_id = 45 and p.survey_id is not null limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [TemplateDisplay.class.php] - ++++++++++++++ BEGIN TPLVARS +++++++++++++++++++++++
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select name url from demos_personpersonalization where display='AdminTabs' and value='Y' and person_id=1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select id from demos_page where site_id=45 limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - Checking for administrator rights for 'anonymous'...
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - ...anonymous user - administrator rights NOT granted.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - Checking for technician rights for 'anonymous'...
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - ...anonymous user - technician rights NOT granted.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - Checking if 'anonymous' is a staffer for THIS site...
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - ...anonymous user - not a staffer user for THIS site.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - Checking if 'anonymous' is a client for THIS site...
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - ...anonymous user - not a client user for THIS site.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - Checking if 'anonymous' is a student for THIS site...
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - ...anonymous user - not a student user for THIS site.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - Checking if 'anonymous' is a caregiver for THIS site...
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - ...anonymous user - not a caregiver user for THIS site.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - Checking if 'anonymous' is an organizational user...
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [OrchidUser.class.php] - ...anonymous user - not an organization user.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select singular_linktext, plural_linktext from demos_theme where id = 5 limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [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-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [TemplateDisplay.class.php] - ++++++++++++++ END TPLVARS +++++++++++++++++++++++
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select p.email from demos_staffer s left join demos_person p on (p.id = s.id) left join demos_dataset ds on (ds.id = p.id) where ds.site_id=45 and s.maincontact='Y' limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select tag,visible,verbiage,editable from demos_pagecontrol where site_id=45 and page='Login''
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select * from demos_signup where site_id=45 and subscriber='Y' and member<>'Y' and volunteer<>'Y' limit 1'
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [TemplateEngine.class.php] - Caching ***OFF*** for template 'screen-header-1.tpl'.
2008-07-24 18:13:25 (DEBUG) [1] 38.103.63.16:48785 [Mysql.class.php] - Executing SQL select: 'select p.bead_id, p.singular, p.plural from demos_page p where p.id=null limit 1'
