Hello @howie ,
Any news?
In case do you have a way to remove the old network-weathermap? I suspect it hangs due the old installation. Here the SQL debug when I try to install the new, look if it’s ok:
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'TRADITIONAL', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_ZERO_DATE', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_ZERO_IN_DATE', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY', ''))
5591688 Query SELECT value FROM settings WHERE name = 'selective_debug'
5591688 Query SELECT value FROM settings WHERE name = 'log_verbosity'
5591688 Query SELECT cacti FROM version LIMIT 1
5591688 Query SELECT cacti FROM version
5591688 Query SHOW TABLES LIKE 'settings_user'
5591688 Query SELECT value FROM settings_user WHERE name = 'user_language' AND user_id = '1'
5591688 Query SHOW TABLES LIKE 'external_links'
5591688 Query SELECT id, title, extendedstyle FROM external_links WHERE style="CONSOLE" AND enabled="on" ORDER BY extendedstyle, sortorder, id
5591688 Query SELECT reset_perms FROM user_auth WHERE id = '1'
5591688 Query SELECT value FROM settings WHERE name = 'auth_method'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '22' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '22' AND uagm.user_id = '1'
5591688 Query SELECT value FROM settings WHERE name = 'reports_allow_ln'
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_arrays' ORDER BY id ASC
5591688 Query SELECT * FROM plugin_realms ORDER BY plugin, display
5591688 Query SELECT DISTINCT gt.id, gt.name FROM graph_templates AS gt INNER JOIN graph_templates_item AS gti ON gt.id=gti.graph_template_id INNER JOIN data_template_rrd AS dtr ON gti.task_item_id=dtr.id WHERE gti.local_graph_id=0 AND data_source_type_id IN (3,2) ORDER BY name
5591688 Query SELECT directory AS id, name FROM plugin_config WHERE status=1
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_settings' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' ORDER BY id ASC
5591688 Query SELECT value FROM settings WHERE name = 'poller_interval'
5591688 Query SELECT value FROM settings WHERE name = 'default_image_format'
5591688 Query SELECT value FROM settings WHERE name = 'default_graph_height'
5591688 Query SELECT value FROM settings WHERE name = 'default_graph_width'
5591688 Query SELECT value FROM settings WHERE name = 'default_poller'
5591688 Query SELECT value FROM settings WHERE name = 'default_site'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_ver'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_community'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_username'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_password'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_auth_protocol'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_priv_passphrase'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_priv_protocol'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_port'
5591688 Query SELECT value FROM settings WHERE name = 'snmp_timeout'
5591688 Query SELECT value FROM settings WHERE name = 'max_get_size'
5591688 Query SELECT value FROM settings WHERE name = 'availability_method'
5591688 Query SELECT value FROM settings WHERE name = 'ping_method'
5591688 Query SELECT value FROM settings WHERE name = 'ping_port'
5591688 Query SELECT value FROM settings WHERE name = 'ping_timeout'
5591688 Query SELECT value FROM settings WHERE name = 'ping_retries'
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_form' ORDER BY id ASC
5591688 Query SELECT value FROM settings WHERE name = 'force_https'
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_insert' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' ORDER BY id ASC
5591688 Query SELECT value FROM settings WHERE name = 'guest_user'
5591688 Query SELECT id FROM user_auth WHERE username = '0'
5591688 Query SELECT COUNT(*) FROM ( SELECT realm_id FROM user_auth_realm AS uar WHERE uar.user_id = '1' AND uar.realm_id = '101' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group_members AS uagm ON uagr.group_id=uagm.group_id INNER JOIN user_auth_group AS uag ON uag.id=uagr.group_id WHERE uag.enabled="on" AND uagm.user_id = '1' AND uagr.realm_id = '101' ) AS authorized
5591688 Query SELECT * FROM user_auth WHERE id = '1'
5591688 Query SELECT directory FROM plugin_config ORDER BY name
5591688 Query SELECT value FROM settings WHERE name = 'developer_mode'
5591688 Query SELECT id FROM plugin_config WHERE directory = 'weathermap'
5591688 Query DELETE FROM plugin_config WHERE directory = 'weathermap'
5591688 Query INSERT INTO plugin_config (directory, name, author, webpage, version) VALUES ('weathermap', '', '', '', '')
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'TRADITIONAL', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_ZERO_DATE', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_ZERO_IN_DATE', ''))
5591688 Query SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY', ''))
5591688 Query SELECT value FROM settings WHERE name = 'selective_debug'
5591688 Query SELECT value FROM settings WHERE name = 'log_verbosity'
5591688 Query SELECT cacti FROM version LIMIT 1
5591688 Query SELECT cacti FROM version
5591688 Query SELECT value FROM settings WHERE name = 'i18n_language_support'
5591688 Query SHOW TABLES LIKE 'settings_user'
5591688 Query SELECT value FROM settings_user WHERE name = 'user_language' AND user_id = '1'
5591688 Query SELECT value FROM settings WHERE name = 'i18n_auto_detection'
5591688 Query SHOW TABLES LIKE 'external_links'
5591688 Query SELECT id, title, extendedstyle FROM external_links WHERE style="CONSOLE" AND enabled="on" ORDER BY extendedstyle, sortorder, id
5591688 Query SELECT reset_perms FROM user_auth WHERE id = '1'
5591688 Query SELECT value FROM settings WHERE name = 'reports_allow_ln'
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_arrays' ORDER BY id ASC
5591688 Query SELECT * FROM plugin_realms ORDER BY plugin, display
5591688 Query SELECT DISTINCT gt.id, gt.name FROM graph_templates AS gt INNER JOIN graph_templates_item AS gti ON gt.id=gti.graph_template_id INNER JOIN data_template_rrd AS dtr ON gti.task_item_id=dtr.id WHERE gti.local_graph_id=0 AND data_source_type_id IN (3,2) ORDER BY name
5591688 Query SELECT directory AS id, name FROM plugin_config WHERE status=1
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_settings' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_form' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'config_insert' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' ORDER BY id ASC
5591688 Query SELECT id FROM user_auth WHERE username = '0'
5591688 Query SELECT COUNT(*) FROM ( SELECT realm_id FROM user_auth_realm AS uar WHERE uar.user_id = '1' AND uar.realm_id = '101' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group_members AS uagm ON uagr.group_id=uagm.group_id INNER JOIN user_auth_group AS uag ON uag.id=uagr.group_id WHERE uag.enabled="on" AND uagm.user_id = '1' AND uagr.realm_id = '101' ) AS authorized
5591688 Query SELECT * FROM user_auth WHERE id = '1'
5591688 Query SELECT directory FROM plugin_config ORDER BY name
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'top_header' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'draw_navigation_text' ORDER BY id ASC
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'page_title' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'page_head' ORDER BY id ASC
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '8' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '8' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '21' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '21' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '18' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '18' AND uagm.user_id = '1'
5591688 Query SELECT id, title FROM external_links WHERE style="TAB" AND enabled="on" ORDER BY sortorder
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'top_graph_header_tabs' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'is_console_page' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'draw_navigation_text' ORDER BY id ASC
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title FROM (graph_templates_graph, graph_local) WHERE graph_templates_graph.local_graph_id = graph_local.id AND graph_local.id = NULL
5591688 Query SELECT id FROM user_auth WHERE username = '0'
5591688 Query SELECT username, password_change, realm FROM user_auth WHERE id = '1'
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'nav_login_before' ORDER BY id ASC
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '20' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '20' AND uagm.user_id = '1'
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'nav_login_after' ORDER BY id ASC
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '5' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '5' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '3' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '3' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '4' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '4' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '13' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '13' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '2' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '2' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '12' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '12' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '10' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '10' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '11' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '11' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '23' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '23' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '9' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '9' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '14' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '14' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '17' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '17' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '16' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '16' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '15' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '15' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '1' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '1' AND uagm.user_id = '1'
5591688 Query SELECT realm_id FROM user_auth_realm WHERE user_id = '1' AND realm_id = '101' UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group AS uag ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = '101' AND uagm.user_id = '1'
5591688 Query SELECT directory FROM plugin_config ORDER BY name
5591688 Query SHOW TABLES LIKE 'plugin_temp_table_702220792'
5591688 Query CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table_702220792 LIKE plugin_config
5591688 Query TRUNCATE plugin_temp_table_702220792
5591688 Query INSERT INTO plugin_temp_table_702220792 SELECT * FROM plugin_config
5591688 Query SELECT value FROM settings WHERE name = 'num_rows_table'
5591688 Query SELECT count(*) FROM plugin_temp_table_702220792
5591688 Query SELECT * FROM plugin_temp_table_702220792 ORDER BY name ASC LIMIT 0,30
5591688 Query DROP TABLE plugin_temp_table_702220792
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'top_graph_refresh' ORDER BY id ASC
5591688 Query SELECT value FROM settings WHERE name = 'auth_cache_enabled'
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'bottom_footer' ORDER BY id ASC
5591688 Query SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = 'page_bottom' ORDER BY id ASC
Thanks,
Simon