Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

[SOLVED] : Error 500 when connection to Admin

  • BO-Samson
  • BO-Samson
  • OFFLINE
  • Posts: 28
  • Thanks: 5
  • Karma: 0
11 years 9 months ago - 11 years 9 months ago #219155 by BO-Samson
Hello,

I mentioned a "funny" error. Everybody can offer connections to other users. All ist working finde. But if somebody offers a connection to me, he will see error 500

SQL=SELECT `id` FROM `akdvi_comprofiler_members` WHERE `memberid` = 473 AND `referenceid` = 506 AND `accepted` = 1 AND `pending` = 0


When I refuse connection, the error desappears. I found no solution for this.

Regards
Samson
Last edit: 11 years 9 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #219167 by krileon
Replied by krileon on topic Re: Error 500 when connection to Admin
Joomla version? CB version? Please enable debug mode and maximum error reporting in Joomla global configuration. Once done re-test and see if it displays any further information regarding the error (should hopefully show where it's coming from).


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • BO-Samson
  • BO-Samson
  • OFFLINE
  • Posts: 28
  • Thanks: 5
  • Karma: 0
11 years 9 months ago #219179 by BO-Samson
Replied by BO-Samson on topic Re: Error 500 when connection to Admin
Hello,

Joomla 3.02, CB 1.9. In between I deleted all entries in Groups, activities ... the admin-profile is empty now and everything ist working again.

I tried with another admin-account. No Problem. But this was never a problem. Only this special Super-User-account had problems. I think it was a problem with one of the groups. When the problem should come up again, I will ask again. And I will give debug-information.

Sorry for disturbing.

Regards
Samson
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

  • BO-Samson
  • BO-Samson
  • OFFLINE
  • Posts: 28
  • Thanks: 5
  • Karma: 0
11 years 9 months ago - 11 years 5 months ago #219534 by BO-Samson
Replied by BO-Samson on topic Re: Error 500 when connection to Admin
Hello,

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&amp;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&amp;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`

I hope this will help you to find the issue.

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.

Regards
Samson
Last edit: 11 years 5 months ago by BO-Samson. Reason: member-name changed

Please Log in or Create an account to join the conversation.

  • BO-Samson
  • BO-Samson
  • OFFLINE
  • Posts: 28
  • Thanks: 5
  • Karma: 0
11 years 9 months ago #219535 by BO-Samson
Replied by BO-Samson on topic Re: Error 500 when connection to Admin
I deactivated recent-activity-tab and the error is gone on own community-site. Recent-activity-site does still not work.

Please Log in or Create an account to join the conversation.

  • BO-Samson
  • BO-Samson
  • OFFLINE
  • Posts: 28
  • Thanks: 5
  • Karma: 0
11 years 9 months ago #219538 by BO-Samson
Replied by BO-Samson on topic Re: Error 500 when connection to Admin
Okay, I went on testing ...

I played with cb.activity-seetings. If I set "Anzeigen" ("show to" or anything similar in english version) to "Self only" everything will work fine. Any other setting will cause the error.
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum