Log In

To access our some of our exclusive contents and features, we'll need you to login so we can verify who you are! If you've been here before or we've sent you an email, you've got an account. New to our awesomeness? Then you probably need to create a profile and tell us a little bit about yourself. ...

Already have a login?

Username:


Password:


Show password:

I'm New Here

First Name: *
Last Name: *
Email: *
Pssst. Having issues? Need to talk to a real human for some help? Call us at 555-555-5555!
Debugging Info
pagedictsize=0
sqltime = 0.037 s
cpu time = 0.250 s
real time = 0.523 s
memory increase = 12484 kB
fields = service: '/users_only/IndividualFormPublic/view'
templates =
/data/demo/current/generic/themes/shared/mako/login/caslogin
scrapeAndDrape (CACHED) stub: https://www.demo.matrixmaxx.com/default-mx-stub/ (/data/demo/current/demo_org/cachedFiles//cachedStub___forms__cas__login)
dg = [] | []
extra debug info =
queries = 30 queries

Total TimeCountAvg TimeQuery
0.0051 call
1 row
0.005 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText_bottom' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hideNewUser' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0041 call
0 rows
0.004 INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 22:56:58',`mxxCreatedBy`=NULL, `PageRequestId`=0x1F4EE100000002, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='DEMO', `pid`='2998464', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655500', `startTime`='2025-08-21 22:56:58', `sessionId`=0x63D60CFC8FEAF981, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'/users_only/IndividualFormPublic/view\\'}', `clientIPAddr`='216.73.216.122'
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hasShowPassword' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='forgotPasswordLinkText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0032 calls
0 rows
0.001 COMMIT
0.0022 calls
0 rows
0.001 START TRANSACTION
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0011 call
11 rows
0.001 DESCRIBE Ticket
0.0011 call
6 rows
0.001 SELECT DISTINCT hex(`MicrositeTab`.`MicrositeTabId`) AS `MicrositeTabId`, `MicrositeTab`.`title`, `MicrositeTab`.`orderindex`, `MicrositeTab`.`enabled`, `MicrositeTab`.`isInSite` FROM (Meeting, MicrositeTab) WHERE `MicrositeTab`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x71720000000D
0.0011 call
1 row
0.001 SELECT DISTINCT `CalendarItem`.`type`, `CalendarItem`.`startDate`, `CalendarItem`.`endDate`, `CalendarItem`.`location`, hex(`CalendarItem`.`CalendarItemId`) AS `CalendarItemId`, `CalendarItem`.`name`, `CalendarItem`.`status`, `CalendarItem`.`contactName`, `CalendarItem`.`contactPhone`, `CalendarItem`.`contactEmail`, `CalendarItem`.`description`, `CalendarItem`.`URL`, `CalendarItem`.`URLDescription`, `CalendarItem`.`handOut`, `CalendarItem`.`handOutDescription`, `CalendarItem`.`minutesUpload`, `CalendarItem`.`minutes`, `CalendarItem`.`phone`, `CalendarItem`.`fax`, `CalendarItem`.`line1`, `CalendarItem`.`line2`, `CalendarItem`.`city`, `CalendarItem`.`province`, `CalendarItem`.`zip`, `CalendarItem`.`state`, `CalendarItem`.`country`, `CalendarItem`.`attendeeNames` FROM (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x71720000000D ORDER BY `CalendarItem`.`startDate`
0.0013 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
155 rows
0.001 SELECT * FROM webselect
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x71720000000D AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Meeting`.`MeetingId`) AS `MeetingId`, `Meeting`.`name`, `Meeting`.`hostName`, `Meeting`.`description`, `Meeting`.`audienceDescription`, `Meeting`.`cosponsors`, `Meeting`.`includes`, `Meeting`.`attire`, `Meeting`.`cancellationPolicy`, `Meeting`.`thankYouText`, `Meeting`.`registrationStarts`, `Meeting`.`registrationEnds`, `Meeting`.`earlybirdCutoff`, `Meeting`.`onlineRegistrationsEnabled`, `Meeting`.`selectSessionsOnRegForm`, `Meeting`.`accountingCode`, `Meeting`.`maximumNumAttendees`, `Meeting`.`type`, `Meeting`.`showPublicSessionSearch`, `Meeting`.`allowSpouseReg`, `Meeting`.`continuingEdUnits`, `Meeting`.`mediaAllowed`, `Meeting`.`travelInfo`, `Meeting`.`hotelBlurb`, `Meeting`.`dateClosed`, `Meeting`.`showFeesOnPublicView`, `Meeting`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `Meeting`.`eventId`, `Meeting`.`staffNotificationEmail`, `Meeting`.`paymentInstructions`, `Meeting`.`staffCancellationEmail`, `Meeting`.`lowRoomTrigger`, `Meeting`.`continuingEdNumber`, `Meeting`.`enableRSVP`, `Meeting`.`micrositePath`, `Meeting`.`bgcolor`, `Meeting`.`accentColor`, `Meeting`.`tabTitleColor`, `Meeting`.`bodyTextColor`, `Meeting`.`linkTextColor`, `Meeting`.`rightNavTextColor`, `Meeting`.`fontTitleSize`, `Meeting`.`fontBodySize`, `Meeting`.`fontName`, `Meeting`.`navbarColor`, `Meeting`.`sidebarColor`, `Meeting`.`highlightedTabTextColor`, `Meeting`.`headlineColor`, `Meeting`.`highlightedTabColor`, `Meeting`.`inSiteAccentColor`, `Meeting`.`inSiteBodyTextColor`, `Meeting`.`inSiteHeadlineColor`, `Meeting`.`inSiteHighlightedTabColor`, `Meeting`.`inSiteHighlightedTabTextColor`, `Meeting`.`inSiteLinkTextColor`, `Meeting`.`inSiteNavbarColor`, `Meeting`.`inSiteRightNavTextColor`, `Meeting`.`inSiteSidebarColor`, `Meeting`.`inSiteTabTitleColor`, `Meeting`.`inSiteFontBodySize`, `Meeting`.`inSiteFontName`, `Meeting`.`inSiteFontTitleSize`, `Meeting`.`useBadges`, `Meeting`.`staffNotificationRevisitedEmail`, `Meeting`.`anticipatedRegistrations`, `Meeting`.`_budgetedRevenue`, `Meeting`.`groupRegistrationOn`, `Meeting`.`allowPlaceholders`, `Meeting`.`feesPageTopText`, `Meeting`.`badgesPageTopText`, `Meeting`.`questionsPageTopText`, `Meeting`.`eventsPageTopText`, `Meeting`.`reviewPageTopText`, `Meeting`.`paymentPageTopText`, `Meeting`.`micrositeTemplate`, `Meeting`.`inSiteTemplate`, `Meeting`.`isWebinar`, `Meeting`.`housingPageTopText`, `Meeting`.`attendeesPageTopText`, `Meeting`.`shortCalDescription`, `Meeting`.`allowAddToCalendar`, `Meeting`.`campaignCode`, `Meeting`.`recordOrigin`, `Meeting`.`additionalFeesPageTopText`, `Meeting`.`referralText`, `Meeting`.`hasReferrals`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`CEU_frac`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived` FROM (Meeting) WHERE `Meeting`.`MeetingId`=0x71720000000D
0.0001 call
0 rows
0.000 INSERT INTO `Ticket` SET `mxxCreated`='2025-08-21 22:56:58',`mxxCreatedBy`=NULL, `TicketId`=0x1F4EE100000003, `type`='2', `value`='LT-1755831418-UAD6Z4AKOdbyhBNXHuNSWVN5l05A86zy', `expires`='2025/08/22 00:26:58.0493 US/Eastern', `username`=NULL, `service`='/users_only/IndividualFormPublic/view', `isPrimary`='2'
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x717200000019 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x71720000001B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 22:56:57',`mxxCreatedBy`=NULL, `PageRequestId`=0x1F4EE100000001, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='DEMO', `pid`='2998464', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655500', `startTime`='2025-08-21 22:56:57', `sessionId`=0x63D60CFC8FEAF981, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=1DC0000003B\\'}', `clientIPAddr`='216.73.216.122'
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-08-21 22:56:57',`mxxUpdatedBy`=NULL, `PageRequestId`=0x1F4EE100000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='DEMO', `pid`='2998464', `requestNum`='1', `objectId`='71720000000D', `growth`='0', `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655500', `startTime`='2025-08-21 22:56:57', `sessionId`=0x63D60CFC8FEAF981, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.006960630416870117', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'71720000000D\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.122' WHERE `PageRequestId`=0x1F4EE100000000
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 22:56:57',`mxxCreatedBy`=NULL, `PageRequestId`=0x1F4EE100000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='DEMO', `pid`='2998464', `requestNum`='1', `pageDictSize`=NULL, `objectId`='71720000000D', `templateMethod`=NULL, `growth`=NULL, `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655500', `startTime`='2025-08-21 22:56:57', `sessionId`=0x63D60CFC8FEAF981, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'71720000000D\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.122'
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-08-21 22:56:57',`mxxUpdatedBy`=NULL, `PageRequestId`=0x1F4EE100000001, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='DEMO', `pid`='2998464', `requestNum`='2', `growth`='0', `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655500', `startTime`='2025-08-21 22:56:57', `sessionId`=0x63D60CFC8FEAF981, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.00035643577575683594', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=1DC0000003B\\'}', `clientIPAddr`='216.73.216.122' WHERE `PageRequestId`=0x1F4EE100000001
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE