by tshore » Thu May 13, 2010 10:52 am
debug = On:
(mysql): SELECT * FROM sessions WHERE session_id = 'f6js9tqjk59nb5jgb4ib1ssbv0'
(mysql): SELECT * FROM users WHERE user_id = 1
(mysql): SELECT * FROM user_settings WHERE user_id = '1'
(mysql): UPDATE sessions SET user_id = 1, ip_address = '24.141.64.157', user_agent = 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8; en-us) AppleWebKit/530.19.2 (KHTML, like Gecko) Version/4.0.2 Safari/530.19', created = 1273688137, last_used = 1273772168, remember = 0, data = 'userId|s:1:\"1\";username|s:5:\"admin\";' WHERE session_id = 'f6js9tqjk59nb5jgb4ib1ssbv0'
(mysql): SELECT * FROM conferences WHERE path = 'bbcs'
(mysql): SELECT * FROM site
(mysql): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND setting_name = 'crontab' AND conference_id = 0 AND sched_conf_id = 0
(mysql): UPDATE plugin_settings SET setting_value = 'a:2:{i:0;a:3:{s:9:\"className\";s:20:\"tasks.ReviewReminder\";s:9:\"frequency\";a:1:{s:4:\"hour\";s:1:\"0\";}s:4:\"args\";a:0:{}}i:1;a:3:{s:9:\"className\";s:32:\"tasks.RegistrationExpiryReminder\";s:9:\"frequency\";a:1:{s:4:\"hour\";s:1:\"0\";}s:4:\"args\";a:0:{}}}', setting_type = 'object' WHERE plugin_name = 'AcronPlugin' AND setting_name = 'crontab' AND conference_id = 0 AND sched_conf_id = 0
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AnnouncementFeedPlugin' AND conference_id = '1' AND sched_conf_id = '0'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'CustomBlockManagerPlugin' AND conference_id = '1' AND sched_conf_id = '0'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'CustomLocalePlugin' AND conference_id = '1' AND sched_conf_id = '0'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'JQueryPlugin' AND conference_id = '1' AND sched_conf_id = '0'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'TranslatorPlugin' AND conference_id = '0' AND sched_conf_id = '0'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND conference_id = '0' AND sched_conf_id = '0'
(mysql): SELECT * FROM versions WHERE current = 1
(mysql): SELECT * FROM versions WHERE current = 1 AND product = 'ocs2'
(mysql): SELECT * FROM sched_confs WHERE path = '2010' and conference_id = '1'
(mysql): SELECT * FROM site
(mysql): SELECT COUNT(*) FROM sched_confs WHERE conference_id = '1' AND end_date < now()
(mysql): SELECT COUNT(*) FROM sched_confs WHERE conference_id = '1' AND start_date < now() AND end_date > now()
(mysql): SELECT * FROM sched_confs WHERE sched_conf_id = '1'
(mysql): SELECT registration_id FROM registrations WHERE user_id = '1' AND sched_conf_id = '1'
(mysql): SELECT * FROM registrations WHERE registration_id = '410'
(mysql): SELECT COUNT(*) FROM roles WHERE conference_id = 1 AND sched_conf_id = 1 AND user_id = 1 AND role_id = 64
(mysql): SELECT COUNT(*) FROM roles WHERE conference_id = 1 AND sched_conf_id = 1 AND user_id = 1 AND role_id = 64
(mysql): SELECT COUNT(*) FROM roles WHERE conference_id = 1 AND sched_conf_id = 1 AND user_id = 1 AND role_id = 64
(mysql): SELECT COALESCE(edl.subject, ddl.subject, edpl.subject, ddpl.subject) AS subject, COALESCE(edl.body, ddl.body, edpl.body, ddpl.body) AS body, COALESCE(e.enabled, 1) AS enabled, d.email_key, d.can_edit, d.can_disable, e.assoc_type, e.assoc_id, e.email_id, COALESCE(ddl.locale, ddpl.locale) AS locale, d.from_role_id, d.to_role_id FROM email_templates_default d LEFT JOIN email_templates_default_data ddpl ON (ddpl.email_key = d.email_key AND ddpl.locale = 'en_US') LEFT JOIN email_templates_default_data ddl ON (ddl.email_key = d.email_key AND ddl.locale = 'en_US') LEFT JOIN email_templates e ON (d.email_key = e.email_key AND e.assoc_type = 256 AND e.assoc_id = '1') LEFT JOIN email_templates_data edpl ON (edpl.email_key = e.email_key AND edpl.assoc_type = e.assoc_type AND edpl.assoc_id = e.assoc_id AND edpl.locale = 'en_US') LEFT JOIN email_templates_data edl ON (edl.email_key = e.email_key AND edl.assoc_type = e.assoc_type AND edl.assoc_id = e.assoc_id AND edl.locale = 'en_US') WHERE d.email_key = 'PUBLISH_NOTIFY'
(mysql): SELECT ed.subject, ed.body, 1 AS enabled, e.email_key, 1 AS can_edit, 0 AS can_disable, e.assoc_type, e.assoc_id, e.email_id, ed.locale, NULL AS from_role_id, NULL AS to_role_id FROM email_templates e LEFT JOIN email_templates_data ed ON (ed.email_key = e.email_key AND ed.assoc_type = e.assoc_type AND ed.assoc_id = e.assoc_id) LEFT JOIN email_templates_default d ON (e.email_key = d.email_key) WHERE d.email_key IS NULL AND e.assoc_type = 256 AND e.assoc_id = '1' AND e.email_key = 'PUBLISH_NOTIFY' AND ed.locale = 'en_US'
(mysql): SELECT * FROM site
(mysql): SELECT DISTINCT u.* FROM users u, registrations r WHERE u.user_id = r.user_id AND r.sched_conf_id = 1
(mysql): UPDATE sessions SET user_id = 1, ip_address = '24.141.64.157', user_agent = 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8; en-us) AppleWebKit/530.19.2 (KHTML, like Gecko) Version/4.0.2 Safari/530.19', created = 1273688137, last_used = 1273772168, remember = 0, data = 'userId|s:1:\"1\";username|s:5:\"admin\";' WHERE session_id = 'f6js9tqjk59nb5jgb4ib1ssbv0'
Trudy Shore
MohSho Interactive
http://www.MohSho.ca/Web Development for the Academic Community
Hamilton, ON, Canada