Error 500 is there again. Now there es no connection to the super-user-account. I activated debug-mode. If the user tries to visit his own community site, he will see "SQL=SELECTÂ `id` FROM `akdvi_comprofiler_members` WHERE `memberid` = 518 AND `referenceid` = 514 AND `accepted` = 1 AND `pending` = 0" debug mode says:
Code:
SQL=SELECTÂ `id` FROM `akdvi_comprofiler_members` WHERE `memberid` = 518 AND `referenceid` = 514 AND `accepted` = 1 AND `pending` = 0
Call stack
#
Function
Location
1
JSite->dispatch()
JROOT/index.php:52
2
JError::raiseError()
JROOT/includes/application.php:216
3
JError::raise()
JROOT/libraries/legacy/error/error.php:242
Sitzung
__default
Profil zum Laufzeitverhalten
Application 0.000 seconds (+0.000); 0.88 MB (+0.882) - afterLoad
Application 0.113 seconds (+0.113); 6.45 MB (+5.567) - afterInitialise
Application 0.130 seconds (+0.017); 7.27 MB (+0.818) - afterRoute
Speichernutzung
29.6 MB (31,034,564 Bytes)
Datenbankabfragen
55 ausgeführte Abfragen
1.SELECTÂ `data`
FROM `akdvi_session`
WHERE `session_id` = '90q7r2tnc72c9511ngjhrqb191'
2.DELETE
FROM `akdvi_session`
WHERE `time` < '1359010315'
3.SELECTÂ `enabled`
FROM `akdvi_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
4.SELECTÂ `value`
FROM `akdvi_admintools_storage`
WHERE `key` = 'cparams'
5.SELECTÂ `query`
FROM `akdvi_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASC
6.SELECTÂ *
FROM `akdvi_admintools_ipautoban`
WHERE `ip` = '93.233.81.145'
7.SELECTÂ `value`
FROM `akdvi_admintools_storage`
WHERE `key` = 'cparams'
8.SELECTÂ `source`
FROM `akdvi_admintools_redirects`
WHERE (`dest` = 'community') OR (`dest` = 'community')
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 0, 1
9.SELECTÂ m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM akdvi_menu AS m
LEFT JOIN akdvi_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
10.SHOW FULL COLUMNS
FROM `akdvi_users`
11.SELECTÂ c.*, u.*
FROM akdvi_users AS u
LEFT JOIN akdvi_comprofiler AS c
ON c.id = u.id
WHERE u.id = 514
12.SELECTÂ a.id
FROM akdvi_user_usergroup_map AS map
LEFT JOIN akdvi_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 514
13.SELECTÂ id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM akdvi_comprofiler_plugin
WHERE published = 1
AND access IN (0,1)
AND type = 'user'
ORDER BY ordering
14.SELECTÂ id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM akdvi_comprofiler_plugin
WHERE published = 1
AND access IN (0,1)
AND type = 'user/plug_cbgroupjive/plugins'
ORDER BY ordering
15.SELECTÂ *
FROM `akdvi_groupjive_plugin_auto`
WHERE ( `published` = 1 )
ORDER BY `ordering` ASC
16.SELECTÂ *
FROM `akdvi_comprofiler_plugin`
WHERE `element` = 'cbgroupjive'
17.SELECTÂ *
FROM `akdvi_comprofiler_tabs`
WHERE `pluginid` = 512
18.SELECTÂ id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM akdvi_comprofiler_plugin
WHERE published = 1
AND access IN (0,1)
AND type = 'templates'
ORDER BY ordering
19.SELECTÂ *
FROM `akdvi_usergroups`
ORDER BY `lft`
20.SELECTÂ parent.id, parent.lft, parent.rgt
FROM akdvi_usergroups AS parent
ORDER BY parent.lft
21.SHOW FULL COLUMNS
FROM `akdvi_assets`
22.SELECTÂ id
FROM akdvi_assets
WHERE parent_id = 0
23.SELECTÂ b.rules
FROM akdvi_assets AS a
LEFT JOIN akdvi_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = '')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
24.SELECTÂ id
FROM akdvi_assets
WHERE parent_id = 0
25.SELECTÂ rules
FROM akdvi_assets
WHERE id = '1'
26.SELECTÂ b.id
FROM akdvi_user_usergroup_map AS map
LEFT JOIN akdvi_usergroups AS a
ON a.id = map.group_id
LEFT JOIN akdvi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 514
27.SELECTÂ id
FROM akdvi_assets
WHERE parent_id = 0
28.SELECTÂ a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
FROM `akdvi_usergroups` AS a
LEFT JOIN `akdvi_usergroups` AS b
ON a.`lft` > b.`lft`
AND a.`rgt` < b.`rgt`
GROUP BY a.`id`
ORDER BY a.`lft` ASC
29.SELECTÂ *
FROM akdvi_comprofiler_tabs t
WHERE t.enabled=1
AND t.viewaccesslevel IN (1,2)
AND t.useraccessgroupid IN (-2,-1,1,2,10)
ORDER BY t.position, t.ordering
30.SELECTÂ id
FROM akdvi_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published = 1
AND access IN (1,2)
AND `language` IN ( 'de-DE', '*', '' )
31.SELECTÂ id
FROM akdvi_assets
WHERE parent_id = 0
32.SELECTÂ b.rules
FROM akdvi_assets AS a
LEFT JOIN akdvi_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
33.SELECTÂ *
FROM `akdvi_comprofiler_plugin`
WHERE `element` = 'cbactivity'
34.SELECTÂ *
FROM `akdvi_comprofiler_tabs`
WHERE `pluginid` = 500
35.SELECTÂ a.*
FROM `akdvi_comprofiler_plugin_activity` AS a
LEFT JOIN `akdvi_comprofiler_members` AS b
ON b.`memberid` = a.`user_id`
WHERE ( ( a.`date` >= '2012-12-24 07:06:55' )
AND ( b.`referenceid` = 514 ) )
ORDER BY a.`date` DESC
36.SELECTÂ a.*
FROM `akdvi_groupjive_plugin_video` AS a
WHERE ( ( a.`id` = 9 )
AND ( a.`published` = 1 ) )
ORDER BY a.`date` DESC
37.SELECTÂ c.*, u.*
FROM akdvi_users AS u
LEFT JOIN akdvi_comprofiler AS c
ON c.id = u.id
WHERE u.id = 518
38.SELECTÂ a.id
FROM akdvi_user_usergroup_map AS map
LEFT JOIN akdvi_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 518
39.SELECTÂ a.*
FROM `akdvi_groupjive_groups` AS a
WHERE ( a.`id` = 16 )
ORDER BY a.`ordering` ASC
40.SELECTÂ a.*
FROM `akdvi_groupjive_categories` AS a
WHERE ( a.`id` = 11 )
ORDER BY a.`ordering` ASC
41.SELECTÂ a.*
FROM `akdvi_groupjive_groups` AS a
LEFT JOIN `akdvi_groupjive_categories` AS b
ON b.`id` = a.`category`
WHERE ( a.`user_id` = 514 )
AND ( ( a.`category` = '11' ) OR ( b.`parent` = '11' ) )
ORDER BY a.`ordering` ASC
42.SELECTÂ a.*
FROM `akdvi_groupjive_users` AS a
LEFT JOIN `akdvi_groupjive_groups` AS b
ON b.`id` = a.`
group`
LEFT JOIN `akdvi_groupjive_categories` AS c
ON c.`id` = b.`category`
WHERE ( a.`user_id` = 514 )
AND ( a.`status` >= 1 )
AND ( ( c.`id` = '11' ) OR ( c.`parent` = '11' ) )
ORDER BY (
CASE WHEN ( a.`status` = 0 ) THEN 1 WHEN ( a.`status` >= 1 ) THEN 2 ELSE 3 END ) ASC, a.`status` DESC, a.`date` DESC
43.SELECTÂ a.*
FROM `akdvi_groupjive_users` AS a
WHERE ( a.`user_id` = 514 )
ORDER BY (
CASE WHEN ( a.`status` = 0 ) THEN 1 WHEN ( a.`status` >= 1 ) THEN 2 ELSE 3 END ) ASC, a.`status` DESC, a.`date` DESC
44.SELECTÂ a.*
FROM `akdvi_groupjive_plugin_photo` AS a
WHERE ( ( a.`id` = 13 )
AND ( a.`published` = 1 ) )
ORDER BY a.`date` DESC
45.SELECTÂ a.*
FROM `akdvi_groupjive_groups` AS a
WHERE ( a.`id` = 11 )
ORDER BY a.`ordering` ASC
46.SELECTÂ a.*
FROM `akdvi_groupjive_categories` AS a
WHERE ( a.`id` = 10 )
ORDER BY a.`ordering` ASC
47.SELECTÂ a.*
FROM `akdvi_groupjive_groups` AS a
LEFT JOIN `akdvi_groupjive_categories` AS b
ON b.`id` = a.`category`
WHERE ( a.`user_id` = 514 )
AND ( ( a.`category` = '10' ) OR ( b.`parent` = '10' ) )
ORDER BY a.`ordering` ASC
48.SELECTÂ a.*
FROM `akdvi_groupjive_users` AS a
LEFT JOIN `akdvi_groupjive_groups` AS b
ON b.`id` = a.`
group`
LEFT JOIN `akdvi_groupjive_categories` AS c
ON c.`id` = b.`category`
WHERE ( a.`user_id` = 514 )
AND ( a.`status` >= 1 )
AND ( ( c.`id` = '10' ) OR ( c.`parent` = '10' ) )
ORDER BY (
CASE WHEN ( a.`status` = 0 ) THEN 1 WHEN ( a.`status` >= 1 ) THEN 2 ELSE 3 END ) ASC, a.`status` DESC, a.`date` DESC
49.SELECTÂ a.`userid`
FROM `akdvi_comprofiler_plug_profilebook` AS a
WHERE a.`id` = 74
AND a.`published` = 1
50.SELECTÂ c.*, u.*
FROM akdvi_users AS u
LEFT JOIN akdvi_comprofiler AS c
ON c.id = u.id
WHERE u.id = 473
51.SELECTÂ a.id
FROM akdvi_user_usergroup_map AS map
LEFT JOIN akdvi_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 473
52.SELECTÂ *
FROM akdvi_comprofiler_tabs t
WHERE t.enabled = 1
AND t.viewaccesslevel IN (1,2)
AND t.useraccessgroupid IN (-2,-1,1,2,10)
ORDER BY t.position, t.ordering
53.SELECTÂ `userid`
FROM `akdvi_comprofiler_plug_profilegallery`
WHERE `id` = 13
AND `pgitempublished` = 1
AND `pgitemapproved` = 1
54.SELECTÂ `id`
FROM `akdvi_comprofiler_members`
WHERE `memberid` = 518
AND `referenceid` = 514
AND `accepted` = 1
AND `pending` = 0
55.UPDATEÂ `akdvi_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:20;s:19:\"session.timer.start\";i:1359010755;s:18:\"session.timer.last\";i:1359011207;s:17:\"session.timer.now\";i:1359011215;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":2:{s:4:\"data\";a:0:{}s:6:\"return\";s:33:\"http://www.dev.burn-out-forum.de/\";}}}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";s:3:\"514\";s:4:\"name\";s:12:\"Max Mustermann\";s:8:\"username\";s:5:\"Metis\";s:5:\"email\";s:23:\"metis@burn-out-forum.de\";s:8:\"password\";s:65:\"61c7f756fa39cc955541d7d84742bf96:LD4bV7liprvrzFPTQdcwtVeFNsrz5G1R\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2013-01-23 07:15:12\";s:13:\"lastvisitDate\";s:19:\"2013-01-23 22:00:22\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:106:\"{\"language\":\"\",\"editor\":\"\",\"timezone\":\"Europe\\/Berlin\",\"admin_style\":\"\",\"admin_language\":\"\",\"helpsite\":\"\"}\";s:6:\"groups\";a:2:{i:2;s:1:\"2\";i:10;s:2:\"10\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"timezone\";s:13:\"Europe/Berlin\";s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:3:{i:0;i:1;i:1;i:2;i:4;i:10;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:2;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:5:\"phpbb\";a:78:{s:7:\"user_id\";s:4:\"6961\";s:9:\"user_type\";s:1:\"0\";s:8:\"group_id\";s:1:\"2\";s:16:\"user_permissions\";s:64:\"00000000006hjypwg0\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nzik0zi000000\";s:14:\"user_perm_from\";s:1:\"0\";s:7:\"user_ip\";s:13:\"217.246.9.139\";s:12:\"user_regdate\";s:10:\"1358925313\";s:8:\"username\";s:5:\"Metis\";s:14:\"username_clean\";s:5:\"metis\";s:13:\"user_password\";s:34:\"$H$9D11zG9nNzWgD6nTen6UwS.WNaOXwP/\";s:12:\"user_passchg\";s:10:\"1358925313\";s:17:\"user_pass_convert\";s:1:\"0\";s:10:\"user_email\";s:23:\"metis@burn-out-forum.de\";s:15:\"user_email_hash\";s:12:\"-16494690923\";s:13:\"user_birthday\";s:10:\" 0- 0- 0\";s:14:\"user_lastvisit\";s:10:\"1358978413\";s:13:\"user_lastmark\";s:10:\"1358925313\";s:18:\"user_lastpost_time\";s:10:\"1358965594\";s:13:\"user_lastpage\";s:20:\"ucp.php?i=pm&p=84866\";s:21:\"user_last_confirm_key\";s:0:\"\";s:16:\"user_last_search\";s:10:\"1358957500\";s:13:\"user_warnings\";s:1:\"0\";s:17:\"user_last_warning\";s:1:\"0\";s:19:\"user_login_attempts\";s:1:\"0\";s:20:\"user_inactive_reason\";s:1:\"0\";s:18:\"user_inactive_time\";s:1:\"0\";s:10:\"user_posts\";s:1:\"9\";s:9:\"user_lang\";s:2:\"de\";s:13:\"user_timezone\";s:4:\"1.00\";s:8:\"user_dst\";s:1:\"0\";s:15:\"user_dateformat\";s:13:\"D j. M Y, H:i\";s:10:\"user_style\";s:1:\"8\";s:9:\"user_rank\";s:1:\"0\";s:11:\"user_colour\";s:0:\"\";s:16:\"user_new_privmsg\";s:1:\"0\";s:19:\"user_unread_privmsg\";s:1:\"0\";s:17:\"user_last_privmsg\";s:10:\"1358964869\";s:18:\"user_message_rules\";s:1:\"0\";s:16:\"user_full_folder\";s:2:\"-3\";s:14:\"user_emailtime\";s:1:\"0\";s:20:\"user_topic_show_days\";s:1:\"0\";s:22:\"user_topic_sortby_type\";s:1:\"t\";s:21:\"user_topic_sortby_dir\";s:1:\"d\";s:19:\"user_post_show_days\";s:1:\"0\";s:21:\"user_post_sortby_type\";s:1:\"t\";s:20:\"user_post_sortby_dir\";s:1:\"a\";s:11:\"user_notify\";s:1:\"1\";s:14:\"user_notify_pm\";s:1:\"1\";s:16:\"user_notify_type\";s:1:\"0\";s:13:\"user_allow_pm\";s:1:\"1\";s:21:\"user_allow_viewonline\";s:1:\"1\";s:20:\"user_allow_viewemail\";s:1:\"1\";s:20:\"user_allow_massemail\";s:1:\"1\";s:12:\"user_options\";s:5:\"99199\";s:11:\"user_avatar\";s:19:\"6961_1358978290.jpg\";s:16:\"user_avatar_type\";s:1:\"1\";s:17:\"user_avatar_width\";s:3:\"130\";s:18:\"user_avatar_height\";s:2:\"97\";s:8:\"user_sig\";s:30:\"Blum, blum und wiedermal blum\";s:19:\"user_sig_bbcode_uid\";s:8:\"3cm9c7r3\";s:24:\"user_sig_bbcode_bitfield\";s:0:\"\";s:9:\"user_from\";s:14:\"GPS Freie Zone\";s:8:\"user_icq\";s:0:\"\";s:8:\"user_aim\";s:0:\"\";s:8:\"user_yim\";s:0:\"\";s:9:\"user_msnm\";s:0:\"\";s:11:\"user_jabber\";s:0:\"\";s:12:\"user_website\";s:0:\"\";s:8:\"user_occ\";s:0:\"\";s:14:\"user_interests\";s:0:\"\";s:11:\"user_actkey\";s:0:\"\";s:14:\"user_newpasswd\";s:0:\"\";s:14:\"user_form_salt\";s:16:\"501e518d0173ae55\";s:17:\"user_accept_rules\";s:1:\"1\";s:8:\"user_new\";s:1:\"0\";s:13:\"user_reminded\";s:1:\"0\";s:18:\"user_reminded_time\";s:1:\"0\";s:12:\"p8pbb_avatar\";s:70:\"./phpBB3/download/file.php?avatar=6961_1359010779.jpg&t=1359010779\";}s:18:\"phpbb_user_updated\";i:1359010771;}s:13:\"session.token\";s:32:\"ba7856d1fd9fb7b83bbecc6d58ffd130\";s:15:\"cbcurrentavatar\";s:21:\"514_50ffa1364a39a.jpg\";}' , `time` = '1359011215'
WHERE `session_id` = '90q7r2tnc72c9511ngjhrqb191'
37 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
1.4 × SELECT id
FROM akdvi_assets
2.3 × SELECT c.*, u.*
FROM akdvi_users AS u
LEFT JOIN akdvi_comprofiler AS c
ON c.id = u.id
3.3 × SELECT a.id
FROM akdvi_user_usergroup_map AS map
LEFT JOIN akdvi_usergroups AS a
ON a.id = map.group_id
4.3 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM akdvi_comprofiler_plugin
5.2 × SELECT *
FROM `akdvi_comprofiler_tabs`
6.2 × SELECT *
FROM akdvi_comprofiler_tabs t
7.2 × SELECT a.*
FROM `akdvi_groupjive_users` AS a
LEFT JOIN `akdvi_groupjive_groups` AS b
ON b.`id` = a.`
group`
LEFT JOIN `akdvi_groupjive_categories` AS c
ON c.`id` = b.`category`
8.2 × SELECT a.*
FROM `akdvi_groupjive_groups` AS a
LEFT JOIN `akdvi_groupjive_categories` AS b
ON b.`id` = a.`category`
9.2 × SELECT a.*
FROM `akdvi_groupjive_categories` AS a
10.2 × SELECT a.*
FROM `akdvi_groupjive_groups` AS a
11.2 × SELECT *
FROM `akdvi_comprofiler_plugin`
12.2 × SELECT b.rules
FROM akdvi_assets AS a
LEFT JOIN akdvi_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
13.2 × SELECT `value`
FROM `akdvi_admintools_storage`
14.1 × SELECT `enabled`
FROM `akdvi_extensions`
15.1 × SELECT `query`
FROM `akdvi_admintools_wafexceptions`
16.1 × SELECT *
FROM `akdvi_admintools_ipautoban`
17.1 × SELECT a.*
FROM `akdvi_groupjive_users` AS a
18.1 × SELECT a.*
FROM `akdvi_groupjive_plugin_photo` AS a
19.1 × SELECT `id`
FROM `akdvi_comprofiler_members`
20.1 × SELECT `userid`
FROM `akdvi_comprofiler_plug_profilegallery`
21.1 × SELECT a.`userid`
FROM `akdvi_comprofiler_plug_profilebook` AS a
22.1 × SELECT a.*
FROM `akdvi_groupjive_plugin_video` AS a
23.1 × SELECT a.*
FROM `akdvi_comprofiler_plugin_activity` AS a
LEFT JOIN `akdvi_comprofiler_members` AS b
ON b.`memberid` = a.`user_id`
24.1 × SELECT `data`
FROM `akdvi_session`
25.1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM akdvi_menu AS m
LEFT JOIN akdvi_extensions AS e
ON m.component_id = e.extension_id
26.1 × SELECT parent.id, parent.lft, parent.rgt
FROM akdvi_usergroups AS parent
27.1 × SELECT *
FROM `akdvi_usergroups`
28.1 × SELECT rules
FROM akdvi_assets
29.1 × SELECT b.id
FROM akdvi_user_usergroup_map AS map
LEFT JOIN akdvi_usergroups AS a
ON a.id = map.group_id
LEFT JOIN akdvi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
30.1 × SELECT id
FROM akdvi_menu
31.1 × SELECT `source`
FROM `akdvi_admintools_redirects`
32.1 × SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
FROM `akdvi_usergroups` AS a
LEFT JOIN `akdvi_usergroups` AS b
ON a.`lft` > b.`lft`
AND a.`rgt` < b.`rgt`
GROUP BY a.`id`
33.1 × SELECT *
FROM `akdvi_groupjive_plugin_auto`
Andere Tabellen:
1.1 × UPDATE `akdvi_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:20;s:19:\"session.timer.start\";i:1359010755;s:18:\"session.timer.last\";i:1359011207;s:17:\"session.timer.now\";i:1359011215;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":2:{s:4:\"data\";a:0:{}s:6:\"return\";s:33:\"http://www.dev.burn-out-forum.de/\";}}}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";s:3:\"514\";s:4:\"name\";s:12:\"Max Mustermann\";s:8:\"username\";s:5:\"Metis\";s:5:\"email\";s:23:\"metis@burn-out-forum.de\";s:8:\"password\";s:65:\"61c7f756fa39cc955541d7d84742bf96:LD4bV7liprvrzFPTQdcwtVeFNsrz5G1R\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2013-01-23 07:15:12\";s:13:\"lastvisitDate\";s:19:\"2013-01-23 22:00:22\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:106:\"{\"language\":\"\",\"editor\":\"\",\"timezone\":\"Europe\\/Berlin\",\"admin_style\":\"\",\"admin_language\":\"\",\"helpsite\":\"\"}\";s:6:\"groups\";a:2:{i:2;s:1:\"2\";i:10;s:2:\"10\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"timezone\";s:13:\"Europe/Berlin\";s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:3:{i:0;i:1;i:1;i:2;i:4;i:10;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:2;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:5:\"phpbb\";a:78:{s:7:\"user_id\";s:4:\"6961\";s:9:\"user_type\";s:1:\"0\";s:8:\"group_id\";s:1:\"2\";s:16:\"user_permissions\";s:64:\"00000000006hjypwg0\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nzik0zi000000\";s:14:\"user_perm_from\";s:1:\"0\";s:7:\"user_ip\";s:13:\"217.246.9.139\";s:12:\"user_regdate\";s:10:\"1358925313\";s:8:\"username\";s:5:\"Metis\";s:14:\"username_clean\";s:5:\"metis\";s:13:\"user_password\";s:34:\"$H$9D11zG9nNzWgD6nTen6UwS.WNaOXwP/\";s:12:\"user_passchg\";s:10:\"1358925313\";s:17:\"user_pass_convert\";s:1:\"0\";s:10:\"user_email\";s:23:\"metis@burn-out-forum.de\";s:15:\"user_email_hash\";s:12:\"-16494690923\";s:13:\"user_birthday\";s:10:\" 0- 0- 0\";s:14:\"user_lastvisit\";s:10:\"1358978413\";s:13:\"user_lastmark\";s:10:\"1358925313\";s:18:\"user_lastpost_time\";s:10:\"1358965594\";s:13:\"user_lastpage\";s:20:\"ucp.php?i=pm&p=84866\";s:21:\"user_last_confirm_key\";s:0:\"\";s:16:\"user_last_search\";s:10:\"1358957500\";s:13:\"user_warnings\";s:1:\"0\";s:17:\"user_last_warning\";s:1:\"0\";s:19:\"user_login_attempts\";s:1:\"0\";s:20:\"user_inactive_reason\";s:1:\"0\";s:18:\"user_inactive_time\";s:1:\"0\";s:10:\"user_posts\";s:1:\"9\";s:9:\"user_lang\";s:2:\"de\";s:13:\"user_timezone\";s:4:\"1.00\";s:8:\"user_dst\";s:1:\"0\";s:15:\"user_dateformat\";s:13:\"D j. M Y, H:i\";s:10:\"user_style\";s:1:\"8\";s:9:\"user_rank\";s:1:\"0\";s:11:\"user_colour\";s:0:\"\";s:16:\"user_new_privmsg\";s:1:\"0\";s:19:\"user_unread_privmsg\";s:1:\"0\";s:17:\"user_last_privmsg\";s:10:\"1358964869\";s:18:\"user_message_rules\";s:1:\"0\";s:16:\"user_full_folder\";s:2:\"-3\";s:14:\"user_emailtime\";s:1:\"0\";s:20:\"user_topic_show_days\";s:1:\"0\";s:22:\"user_topic_sortby_type\";s:1:\"t\";s:21:\"user_topic_sortby_dir\";s:1:\"d\";s:19:\"user_post_show_days\";s:1:\"0\";s:21:\"user_post_sortby_type\";s:1:\"t\";s:20:\"user_post_sortby_dir\";s:1:\"a\";s:11:\"user_notify\";s:1:\"1\";s:14:\"user_notify_pm\";s:1:\"1\";s:16:\"user_notify_type\";s:1:\"0\";s:13:\"user_allow_pm\";s:1:\"1\";s:21:\"user_allow_viewonline\";s:1:\"1\";s:20:\"user_allow_viewemail\";s:1:\"1\";s:20:\"user_allow_massemail\";s:1:\"1\";s:12:\"user_options\";s:5:\"99199\";s:11:\"user_avatar\";s:19:\"6961_1358978290.jpg\";s:16:\"user_avatar_type\";s:1:\"1\";s:17:\"user_avatar_width\";s:3:\"130\";s:18:\"user_avatar_height\";s:2:\"97\";s:8:\"user_sig\";s:30:\"Blum, blum und wiedermal blum\";s:19:\"user_sig_bbcode_uid\";s:8:\"3cm9c7r3\";s:24:\"user_sig_bbcode_bitfield\";s:0:\"\";s:9:\"user_from\";s:14:\"GPS Freie Zone\";s:8:\"user_icq\";s:0:\"\";s:8:\"user_aim\";s:0:\"\";s:8:\"user_yim\";s:0:\"\";s:9:\"user_msnm\";s:0:\"\";s:11:\"user_jabber\";s:0:\"\";s:12:\"user_website\";s:0:\"\";s:8:\"user_occ\";s:0:\"\";s:14:\"user_interests\";s:0:\"\";s:11:\"user_actkey\";s:0:\"\";s:14:\"user_newpasswd\";s:0:\"\";s:14:\"user_form_salt\";s:16:\"501e518d0173ae55\";s:17:\"user_accept_rules\";s:1:\"1\";s:8:\"user_new\";s:1:\"0\";s:13:\"user_reminded\";s:1:\"0\";s:18:\"user_reminded_time\";s:1:\"0\";s:12:\"p8pbb_avatar\";s:70:\"./phpBB3/download/file.php?avatar=6961_1359010779.jpg&t=1359010779\";}s:18:\"phpbb_user_updated\";i:1359010771;}s:13:\"session.token\";s:32:\"ba7856d1fd9fb7b83bbecc6d58ffd130\";s:15:\"cbcurrentavatar\";s:21:\"514_50ffa1364a39a.jpg\";}' , `time` = '1359011215'
2.1 × SHOW FULL COLUMNS
FROM `akdvi_assets
3.1 × SHOW FULL COLUMNS
FROM `akdvi_users
4.1 × DELETE
FROM `akdvi_session`
The user will see the same error, when visiting the recent activity-site. But he can use his profile, see members and groups. For me it looks like a problem with recent activity.
krileon
