Submitting new helpdesk ticket.
If you do not wish to login to the helpdesk
system to submit a ticket, you can just click
on submit ticket and send anyways. Once
the software gets your ticket it will match
your email with the rest of your tickets.
Log Messages (73)
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [Logger.class.php] - Logger created.
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [Logger.class.php] - Logger thinks SITE_ID is 45
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [Mysql.class.php] - Established connection to db 'orchidsu_demos' on topaz.orchidsuites.net:3306
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [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:12:29 (DEBUG) 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select sk.* from demos_skin sk where sk.id = 1 limit 1'
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [Request.class.php] - Creating request object from POST and GET information...
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [Request.class.php] - ...precedence is 'get'...
2008-07-24 18:12:29 (INFO) 38.103.63.16:35808 [Request.class.php] - ...request created. URI is '/tutorial/ht/d/HotTipDetails/i/956'
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [TemplateEngine.class.php] - Created instance of 'smarty' template engine.
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [SessionHandler.class.php] - SessionHandler created:
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [SessionHandler.class.php] - - session name is 'demossession'
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [SessionHandler.class.php] - - session id is ''
2008-07-24 18:12:29 (DEBUG) 38.103.63.16:35808 [OrchidUser.class.php] - Anonymous user created.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Context.class.php] - Context object created.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [orchid.php] - No action requested.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [orchid.php] - Using display class "HotTipDetails.class.php"
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select section_id from demos_sectiondisplay where displayname='HotTipDetails''
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select * from demos_stafferrole sr where staffer_id=1 limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [BaseDisplay.class.php] - Rendering display 'HotTipDetails'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [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 = 'HotTipDetails') and ds.site_id = 45 and p.survey_id is not null limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select * from demos_datasetsurvey where dataset = 'hotTip' and dataset_id = 956 limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [TemplateEngine.class.php] - *** Trying to determine if 'HotTipDetails.tpl' is cached with id demos|45|HotTipDetails|182ea54074d3b0677f97cac12062f85a.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [TemplateEngine.class.php] - *** Touching: /usr/local/orchid-4-7-0/templates/cached/demos_/demos/45/HotTipDetails/timestamp
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [TemplateEngine.class.php] - *** Smarty says HotTipDetails.tpl is NOT cached.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [TemplateDisplay.class.php] - ++++++++++++++ BEGIN TPLVARS +++++++++++++++++++++++
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select id from demos_page where site_id=45 limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - Checking for administrator rights for 'anonymous'...
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - ...anonymous user - administrator rights NOT granted.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - Checking for technician rights for 'anonymous'...
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - ...anonymous user - technician rights NOT granted.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - Checking if 'anonymous' is a staffer for THIS site...
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - ...anonymous user - not a staffer user for THIS site.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - Checking if 'anonymous' is a client for THIS site...
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - ...anonymous user - not a client user for THIS site.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - Checking if 'anonymous' is a student for THIS site...
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - ...anonymous user - not a student user for THIS site.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - Checking if 'anonymous' is a caregiver for THIS site...
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - ...anonymous user - not a caregiver user for THIS site.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - Checking if 'anonymous' is an organizational user...
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [OrchidUser.class.php] - ...anonymous user - not an organization user.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select singular_linktext, plural_linktext from demos_theme where id = 5 limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [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:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select * from demos_datasetdetails where dataset='hotTip' limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [TemplateDisplay.class.php] - ++++++++++++++ END TPLVARS +++++++++++++++++++++++
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select ht.* from demos_hottip ht left join demos_dataset ds on (ht.id = ds.id) WHERE ht.id = 956 and ds.site_id = 45'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select ht.* from demos_hottip ht left join demos_dataset ds on (ht.id = ds.id) WHERE ht.id = 956 and ds.site_id = 45 limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select distinct i.* from demos_image i left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = i.id and sdm.dataset = 'image' ) where ((i.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and i.membersonly = '')) and i.dataset_id = 956 and i.dataset = 'article' limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select distinct i.* from demos_image i left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = i.id and sdm.dataset = 'image' ) where ((i.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and i.membersonly = '')) and i.dataset_id = 956 and i.dataset = 'article' limit 1'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select distinct d.* from demos_document d left join demos_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 = 956 and d.dataset = 'article' order by title'
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [TemplateEngine.class.php] - Caching ***ON*** for template 'screen-header-1.tpl', id is demos|45|HotTipDetails|182ea54074d3b0677f97cac12062f85a.
2008-07-24 18:12:29 (DEBUG) [1] 38.103.63.16:35808 [Mysql.class.php] - Executing SQL select: 'select p.bead_id, p.singular, p.plural from demos_page p where p.id=null limit 1'