Kunena 6.3.0 released
The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3
Solved Internal server error attempting to upgrade from K 2.0.3 -> K 3.0.5 on J! 2.5.9
The configuration report indicates that you have the required versions of PHP and MySQL and that you should have sufficient server resources (e.g. memory and execution times) to handle most tasks that you need to do.
As I am sure you have read in the article I referred you to read in msg #4 of this topic ( HTTP 500 Internal Server Error ), the "internal server error" is one of those catch-all conditions when something goes wrong. There can be thousands of possible reasons for getting an error like this but, depending on one's experience, they can take minutes, hours, days or weeks before you eventually determine the cause. Most of the time (and when I say most of the time I mean perhaps one time in 10,000 times) these problems are not caused by Kunena but they are result of something completely external to Kunena. For example, if you do not have sufficient memory you will get an "internal server error".
I could make dozens of educated guesses about what could be the cause of your internal server error when you attempt to upgrade from K 2.0.3 to K 3.0.5, starting with
- the outdated version J! 2.5.9 (that was made obsolete over a year ago) that you are using;
- the fact that we have had numerous reports from members of this community about their problems with Shape5.com templates;
- your "release candidate" Kunena template (that was made obsolete over 2 years ago)
- the outdated verion K 2.0.3 that was superseded by K 2.0.4 in January 2013)
but, rather than try to guess what is the cause of the problem it would make far better sense if you enabled Joomla debug mode, attempt the upgrade again, and see if there is any additional information that appears on the screen at the time that you get "internal server error".
For a person like me to tell you what is wrong when someone reports "I get an 'internal server error' when I try to upgrade" is a bit like someone on the other end of the telephone hearing "I cannot start my car" and that's all the information you're given. :laugh:
So, unless there is some additional information you can give us about why you get the HTTP 500 Internal Server Error , there is not a lot that we can do to assist you without spending time working alongside you while you're doing the work. Have you any ideas, yourself, how you would like us to help you better than we already have tried?
In conclusion, I cannot tell you exactly why you are getting the internal server error when you try to upgrade from K 2.0.3 to K 3.0.5; I have changed the subject of this topic so that people will better understand what is happening.
If you have some ideas how we can assist you further, I am sure that we would welcome those suggestions.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
Thank you very much for the detailed reply.
You must have looked the last paragraph I added below the configuration report. (marked P.S,)
I will further investigate the issue while giving special attention to the points you pointed out in your posts.
I will keep you updated.
Many thanks,
Tamir
Please Log in or Create an account to join the conversation.
I looked at what you wrote about the 404 Error but this is irrelevant. If you get an HTTP 500 Internal Server Error during the upgrade then it does not really matter if you get an "HTTP 404 Not Found" error after the upgrade, does it? If the upgrade does not work then it does not work.tamirzzz wrote: You must have looked the last paragraph I added below the configuration report. (marked P.S,)
What you have to do is to tell us why it does not work.
If you enable Joomla debug mode you may be able to tell us why the upgrade does not work.
Have you enabled Joomla debug mode? (Do you know how to enable Joomla debug mode?) Have you attempted to upgrade to K 3.0.5 after enabling Joomla debug mode? What does this tell you and what can you tell us?
That's what you have to do. Please read HTTP 500 Internal Server Error which will help you.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
Yes, I have.
keep getting the same screen:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
However, I post the last queries:
**14 Queries Logged**
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'a0cbba379d5c8e76060900119f333b6b'
DELETE
FROM `jos_session`
WHERE `time` < '1398840885'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_kunena'
SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_installer'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-04-30 07:24:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-04-30 07:24:45')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 1
SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN jos_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1398841875;s:18:\"session.timer.last\";i:1398841948;s:17:\"session.timer.now\";i:1398842685;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";N;}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:14:\"[email protected]\";s:8:\"password\";s:34:\"$P$DWgFL85uqbG0YBtMtm4IVJ6fohHot1/\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2006-02-13 21:13:55\";s:13:\"lastvisitDate\";s:19:\"2014-04-29 14:02:35\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:147:\"{\"editor\":\"\",\"expired\":\"\",\"expired_time\":\"\",\"admin_language\":\"\",\"language\":\"\",\"helpsite\":\"\",\"timezone\":\"\",\"update_cache_list\":\"1\",\"admin_style\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}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_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":9:{s:6:\"editor\";s:0:\"\";s:7:\"expired\";s:0:\"\";s:12:\"expired_time\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:17:\"update_cache_list\";s:1:\"1\";s:11:\"admin_style\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"55732a55c3cd2f89c12807ccb2a894af\";}__wf|a:1:{s:13:\"session.token\";s:32:\"6b84c962169af1438def03ab9424b175\";}' , `time` = '1398842686'
WHERE `session_id` = 'a0cbba379d5c8e76060900119f333b6b'
**11 Query Types Logged, Sorted by Occurrences.**
**SELECT Tables:**
**3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions**
**2 × SELECT COUNT(session_id)
FROM jos_session**
**1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN jos_languages AS l
ON l.lang_code = language**
**1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id**
**1 × SELECT COUNT(*)
FROM jos_messages**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT folder AS type, element AS name, params
FROM jos_extensions**
**1 × SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id**
**1 × SELECT `data`
FROM `jos_session`**
**OTHER Tables:**
**1 × UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1398841875;s:18:\"session.timer.last\";i:1398841948;s:17:\"session.timer.now\";i:1398842685;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";N;}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:14:\"[email protected]\";s:8:\"password\";s:34:\"$P$DWgFL85uqbG0YBtMtm4IVJ6fohHot1/\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2006-02-13 21:13:55\";s:13:\"lastvisitDate\";s:19:\"2014-04-29 14:02:35\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:147:\"{\"editor\":\"\",\"expired\":\"\",\"expired_time\":\"\",\"admin_language\":\"\",\"language\":\"\",\"helpsite\":\"\",\"timezone\":\"\",\"update_cache_list\":\"1\",\"admin_style\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}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_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":9:{s:6:\"editor\";s:0:\"\";s:7:\"expired\";s:0:\"\";s:12:\"expired_time\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:17:\"update_cache_list\";s:1:\"1\";s:11:\"admin_style\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"55732a55c3cd2f89c12807ccb2a894af\";}__wf|a:1:{s:13:\"session.token\";s:32:\"6b84c962169af1438def03ab9424b175\";}' , `time` = '1398842686'**
**1 × DELETE
FROM `jos_session`**
perhaps, this will give you some indication.
Tnx
Please Log in or Create an account to join the conversation.
I enter the site and clicked the forum menu item. for unknown reasons the site is still up and running (although installation fails).
I have recorded the DB queries. Tnx
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'c8e299bcfdf76569f12cfd9b2113ad54'
DELETE
FROM `jos_session`
WHERE `time` < '1398841261'
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_kunena'
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 jos_menu AS m
LEFT JOIN jos_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
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
SELECT *
FROM jos_kunena_configuration
WHERE id=1
SHOW FULL COLUMNS
FROM `jos_kunena_users`
SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role
FROM jos_kunena_categories AS c
INNER JOIN jos_community_groups_members AS g
ON c.accesstype='jomsocial'
AND c.access=g.groupid
WHERE c.published=1
AND g.approved=1
AND g.permissions='1'
SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_kunena')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT DISTINCT(user_id)
FROM jos_usergroups as ug1
INNER JOIN jos_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN jos_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (
SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_kunena')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT DISTINCT(user_id)
FROM jos_usergroups as ug1
INNER JOIN jos_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN jos_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (7)
SELECT user_id, category_id, role
FROM jos_kunena_user_categories
WHERE role IN (1,2)
SHOW FULL COLUMNS
FROM `jos_kunena_sessions`
SHOW FULL COLUMNS
FROM `jos_community_config`
SELECT *
FROM jos_community_config
WHERE `name` = 'config'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=inbox%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-04-30 07:31:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-04-30 07:31:01')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 166 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT *
FROM jos_kunena_categories
ORDER BY ordering, name
SHOW FULL COLUMNS
FROM `jos_kunena_categories`
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT *
FROM jos_kunena_topics
WHERE id IN (7991,7994,7996,7992,7240,7983,7775,7997,7615)
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (122,2180,2202,2209,2356,1533,411,1430,6140,150,1171,445)
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.*
FROM `jos_community_users` as a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session`s
ON s.`userid`=a.`userid`
WHERE a.`userid` IN (122,2180,2202,2209,2356,1533,411,1430,6140,150,1171,445)
SHOW FULL COLUMNS
FROM `jos_community_profiles`
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '122'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '150'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '411'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '445'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '1171'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '1430'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '1533'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '2180'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '2202'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '2209'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '2356'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '6140'
SHOW FULL COLUMNS
FROM `jos_kunena_announcement`
SELECT *
FROM jos_kunena_announcement
WHERE published=1
ORDER BY created DESC
LIMIT 0, 1
SELECT code, location
FROM jos_kunena_smileys
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT s.userid, s.time
FROM jos_session AS s
WHERE s.client_id=0
AND s.userid>0
GROUP BY s.userid
ORDER BY s.time DESC
SELECT guest, time, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT COUNT(*), MAX(id)
FROM jos_users
WHERE (block=0 OR activation="")
SELECT SUM(time>=1398805200
AND parent=0) AS todayTopicCount, SUM(time>=1398805200
AND parent>0) AS todayReplyCount, SUM(time>=1398718800
AND time<1398805200
AND parent=0) AS yesterdayTopicCount, SUM(time>=1398718800
AND time<1398805200
AND parent>0) AS yesterdayReplyCount
FROM jos_kunena_messages
WHERE time>=1398718800
AND hold=0
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 9448
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `jos_community_users` as a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='9448'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '9448'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT *
FROM jos_template_styles
WHERE template = 'traction';
SELECT *
FROM jos_menu
WHERE template_style_id IN (9)
AND alias = 'forums'
SELECT menutype
FROM jos_menu
WHERE language = 'he-IL'
AND home = 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SHOW FULL COLUMNS
FROM `jos_easyblog_configs`
SELECT *
FROM jos_easyblog_configs
WHERE `name` = 'config'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
SELECT menutype
FROM jos_menu
WHERE language = 'he-IL'
AND home = 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 jos_menu AS m
LEFT JOIN jos_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
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `jos_community_users` as a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '0'
select `id`
FROM `jos_easyblog_team`
where `access` = '3'
and `published` = '1'
select distinct a.`id`, a.`private`
from `jos_easyblog_category` as a
left join `jos_easyblog_category_acl` as b
on a.`id` = b.`category_id`
and b.`acl_id` = '1'
where a.`private` != '0'
and b.`category_id` NOT IN ( SELECT c.category_id
FROM `jos_easyblog_category_acl` as c
WHERE c.acl_id = '1'
AND c.content_id IN ('1') )
SELECT a.`id` AS key1, a.*, b.`id` as key2, b.`title` as `category`
FROM `jos_easyblog_post` AS a
LEFT JOIN `jos_easyblog_category` AS b
ON a.category_id = b.id
WHERE a.`published` = 1
AND a.`ispending` = '0'
AND a.`private` = '0'
AND a.`issitewide` = '1'
ORDER BY a.`created` desc
LIMIT 5
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_easyblog'
SHOW FULL COLUMNS
FROM `jos_easyblog_post`
SELECT *
FROM jos_easyblog_post
WHERE `id` = '17'
SELECT COUNT(1)
FROM `jos_easyblog_comment`
WHERE `post_id`='17'
AND `published` = '1'
SHOW FULL COLUMNS
FROM `jos_easyblog_users`
SELECT *
FROM jos_easyblog_users
WHERE `id` = '1533'
SHOW FULL COLUMNS
FROM `jos_users`
SELECT *
FROM `jos_users`
WHERE `id` = 1533
SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS g
INNER JOIN `jos_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 1533
SELECT *
FROM jos_easyblog_post
WHERE `id` = '13'
SELECT COUNT(1)
FROM `jos_easyblog_comment`
WHERE `post_id`='13'
AND `published` = '1'
SELECT *
FROM jos_easyblog_post
WHERE `id` = '12'
SELECT COUNT(1)
FROM `jos_easyblog_comment`
WHERE `post_id`='12'
AND `published` = '1'
SELECT *
FROM jos_easyblog_users
WHERE `id` = '6140'
SELECT *
FROM `jos_users`
WHERE `id` = 6140
SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS g
INNER JOIN `jos_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 6140
SELECT *
FROM jos_easyblog_post
WHERE `id` = '11'
SELECT COUNT(1)
FROM `jos_easyblog_comment`
WHERE `post_id`='11'
AND `published` = '1'
SELECT *
FROM jos_easyblog_users
WHERE `id` = '445'
SELECT *
FROM `jos_users`
WHERE `id` = 445
SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS g
INNER JOIN `jos_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 445
SELECT *
FROM jos_easyblog_post
WHERE `id` = '10'
SELECT COUNT(1)
FROM `jos_easyblog_comment`
WHERE `post_id`='10'
AND `published` = '1'
SELECT *
FROM jos_easyblog_post
WHERE `id` = '17'
SELECT `id`
FROM `jos_menu`
WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=1533'
AND `published`='1'
AND (`language`='he-IL' OR `language` = '*' )
LIMIT 1
SELECT a.*
FROM `jos_easyblog_post` as a
WHERE a.`id` ='17'
SHOW FULL COLUMNS
FROM `jos_easyblog_category`
SELECT *
FROM jos_easyblog_category
WHERE `id` = '1'
SELECT COUNT(1)
FROM `jos_easyblog_category`
WHERE `alias`='קטגוריה-ראשית'
AND `id`!='1'
SELECT `title`
FROM `jos_easyblog_category`
WHERE `id` = '1'
SHOW FULL COLUMNS
FROM `jos_easyblog_ratings`
SELECT *
FROM `jos_easyblog_ratings`
WHERE `created_by`='0'
AND `uid`='17'
AND `type`='entry'
AND `sessionid`='c8e299bcfdf76569f12cfd9b2113ad54'
SELECT AVG(value) AS ratings, COUNT(1) AS total
FROM `jos_easyblog_ratings`
WHERE `uid`='17'
AND `type`='entry'
SHOW FULL COLUMNS
FROM `jos_assets`
SELECT id
FROM jos_assets
WHERE parent_id = 0
SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_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
SELECT COUNT(*)
FROM `jos_easyblog_configs`
WHERE `name` = 'default'
SELECT *
FROM `jos_easyblog_acl`
WHERE `published`=1
ORDER BY `id` ASC
SELECT *
FROM `jos_easyblog_acl_group`
WHERE `content_id`='1'
AND `type`='
group'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '1533'
SELECT *
FROM jos_easyblog_post
WHERE `id` = '13'
SELECT `id`
FROM `jos_menu`
WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=1533'
AND `published`='1'
AND (`language`='he-IL' OR `language` = '*' )
LIMIT 1
SELECT a.*
FROM `jos_easyblog_post` as a
WHERE a.`id` ='13'
SELECT *
FROM `jos_easyblog_ratings`
WHERE `created_by`='0'
AND `uid`='13'
AND `type`='entry'
AND `sessionid`='c8e299bcfdf76569f12cfd9b2113ad54'
SELECT AVG(value) AS ratings, COUNT(1) AS total
FROM `jos_easyblog_ratings`
WHERE `uid`='13'
AND `type`='entry'
SELECT id
FROM jos_assets
WHERE parent_id = 0
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '1533'
SELECT *
FROM jos_easyblog_post
WHERE `id` = '12'
SELECT `id`
FROM `jos_menu`
WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=6140'
AND `published`='1'
AND (`language`='he-IL' OR `language` = '*' )
LIMIT 1
SELECT a.*
FROM `jos_easyblog_post` as a
WHERE a.`id` ='12'
SELECT *
FROM `jos_easyblog_ratings`
WHERE `created_by`='0'
AND `uid`='12'
AND `type`='entry'
AND `sessionid`='c8e299bcfdf76569f12cfd9b2113ad54'
SELECT AVG(value) AS ratings, COUNT(1) AS total
FROM `jos_easyblog_ratings`
WHERE `uid`='12'
AND `type`='entry'
SELECT id
FROM jos_assets
WHERE parent_id = 0
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '6140'
SELECT *
FROM jos_easyblog_post
WHERE `id` = '11'
SELECT `id`
FROM `jos_menu`
WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=445'
AND `published`='1'
AND (`language`='he-IL' OR `language` = '*' )
LIMIT 1
SELECT a.*
FROM `jos_easyblog_post` as a
WHERE a.`id` ='11'
SELECT *
FROM `jos_easyblog_ratings`
WHERE `created_by`='0'
AND `uid`='11'
AND `type`='entry'
AND `sessionid`='c8e299bcfdf76569f12cfd9b2113ad54'
SELECT AVG(value) AS ratings, COUNT(1) AS total
FROM `jos_easyblog_ratings`
WHERE `uid`='11'
AND `type`='entry'
SELECT id
FROM jos_assets
WHERE parent_id = 0
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community%'
AND `published`='1'
AND `type`='component'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '445'
SELECT *
FROM jos_easyblog_post
WHERE `id` = '10'
SELECT `id`
FROM `jos_menu`
WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=445'
AND `published`='1'
AND (`language`='he-IL' OR `language` = '*' )
LIMIT 1
SELECT a.*
FROM `jos_easyblog_post` as a
WHERE a.`id` ='10'
SELECT *
FROM `jos_easyblog_ratings`
WHERE `created_by`='0'
AND `uid`='10'
AND `type`='entry'
AND `sessionid`='c8e299bcfdf76569f12cfd9b2113ad54'
SELECT AVG(value) AS ratings, COUNT(1) AS total
FROM `jos_easyblog_ratings`
WHERE `uid`='10'
AND `type`='entry'
SELECT id
FROM jos_assets
WHERE parent_id = 0
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '445'
SELECT COUNT(*)
FROM jos_kunena_topics AS tt
WHERE tt.hold IN (0)
AND tt.category_id IN (6,15,10,7,13,14,3,4,11)
AND tt.last_post_time>'1367307061'
AND tt.moved_id='0'
SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
FROM jos_kunena_topics AS tt
LEFT JOIN jos_kunena_user_topics AS ut
ON tt.id=ut.topic_id
AND ut.user_id='0'
WHERE tt.hold IN (0)
AND tt.category_id IN (6,15,10,7,13,14,3,4,11)
AND tt.last_post_time>'1367307061'
AND tt.moved_id='0'
ORDER BY tt.last_post_time DESC
LIMIT 0, 10
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (9445,4609,775,2244)
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.*
FROM `jos_community_users` as a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session`s
ON s.`userid`=a.`userid`
WHERE a.`userid` IN (9445,4609,775,2244)
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '775'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '2244'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '4609'
SELECT `id`
FROM `jos_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `jos_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '9445'
SELECT *
FROM jos_kunena_user_topics
WHERE user_id='0'
AND topic_id IN (7996,7997,7995,7978,7994,7992,7991,7990,7989,7988)
SHOW FULL COLUMNS
FROM `jos_kunena_user_topics`
SELECT *
FROM jos_kunena_keywords_map AS m
INNER JOIN jos_kunena_keywords AS k
ON m.keyword_id=k.id
WHERE m.topic_id IN (7996,7997,7995,7978,7994,7992,7991,7990,7989,7988)
AND m.user_id IN (0,0)
SELECT a. * , count( b.id ) AS counter, c.name AS username
FROM `jos_community_groups_discuss` AS a
INNER JOIN `jos_users` AS c
ON a.creator = c.id
LEFT JOIN `jos_community_wall` AS b
ON b.contentid = a.id
AND b.type = 'discussions'
AND a.parentid = '0'
INNER JOIN `jos_community_groups`AS g
ON g.id = a.groupid
WHERE g.published = '1'
GROUP BY a.id
ORDER BY a.created DESC
LIMIT 5
UPDATE `jos_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1398843045;s:18:\"session.timer.last\";i:1398843045;s:17:\"session.timer.now\";i:1398843061;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":1:{s:10:\"user0_read\";a:10:{i:603;s:3:\"603\";i:6;s:1:\"6\";i:15;s:2:\"15\";i:10;s:2:\"10\";i:7;s:1:\"7\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:3;s:1:\"3\";i:4;s:1:\"4\";i:11;s:2:\"11\";}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"700d9da3d12d694b49f6fd49df8adb8c\";s:16:\"com_mailto.links\";a:10:{s:40:\"58464d2607aa6b7ca4731b9c29380eacdbcdffd6\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\" tamirdwh.funet.co.il/subdomains/dwh/main...n-israel/166-People-
and-computers-אנשים-ומחשבים/2812-מפגש-ibi-מאי-2014\";s:6:\"expiry\";i:1398843047;}}}' , `time` = '1398843063'
WHERE `session_id` = 'c8e299bcfdf76569f12cfd9b2113ad54'
**72 QUERY TYPES LOGGED, SORTED BY OCCURRENCES.**
**טבלאות SELECT:**
**65 × SELECT `id`
FROM `jos_menu`**
**23 × SELECT `value`
FROM `jos_community_fields_values`**
**23 × SELECT `id`
FROM `jos_community_fields`**
**10 × SELECT *
FROM jos_easyblog_post**
**6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions**
**5 × SELECT id
FROM jos_assets**
**5 × SELECT AVG(value) AS ratings, COUNT(1) AS total
FROM `jos_easyblog_ratings`**
**5 × SELECT a.*
FROM `jos_easyblog_post` as a**
**5 × SELECT COUNT(1)
FROM `jos_easyblog_comment`**
**5 × SELECT *
FROM `jos_easyblog_ratings`**
**3 × SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt**
**3 × SELECT *
FROM `jos_users`**
**3 × SELECT *
FROM jos_easyblog_users**
**3 × SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS g
INNER JOIN `jos_user_usergroup_map` AS m
ON m.group_id = g.id**
**2 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.*
FROM `jos_community_users` as a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session`s
ON s.`userid`=a.`userid`**
**2 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `jos_community_users` as a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'**
**2 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid**
**2 × 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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id**
**2 × SELECT DISTINCT(user_id)
FROM jos_usergroups as ug1
INNER JOIN jos_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN jos_user_usergroup_map AS m
ON ug2.id=m.group_id**
**2 × SELECT menutype
FROM jos_menu**
**1 × SELECT a.`id` AS key1, a.*, b.`id` as key2, b.`title` as `category`
FROM `jos_easyblog_post` AS a
LEFT JOIN `jos_easyblog_category` AS b
ON a.category_id = b.id**
**1 × SELECT a. * , count( b.id ) AS counter, c.name AS username
FROM `jos_community_groups_discuss` AS a
INNER JOIN `jos_users` AS c
ON a.creator = c.id
LEFT JOIN `jos_community_wall` AS b
ON b.contentid = a.id
AND b.type = 'discussions'
AND a.parentid = '0'
INNER JOIN `jos_community_groups`AS g
ON g.id = a.groupid**
**1 × SELECT *
FROM jos_kunena_keywords_map AS m
INNER JOIN jos_kunena_keywords AS k
ON m.keyword_id=k.id**
**1 × SELECT `title`
FROM `jos_easyblog_category`**
**1 × SELECT COUNT(*)
FROM jos_kunena_topics AS tt**
**1 × SELECT COUNT(*)
FROM `jos_easyblog_configs`**
**1 × SELECT *
FROM `jos_easyblog_acl`**
**1 × select distinct a.`id`, a.`private`
from `jos_easyblog_category` as a
left join `jos_easyblog_category_acl` as b
on a.`id` = b.`category_id`
and b.`acl_id` = '1'**
**1 × SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
FROM jos_kunena_topics AS tt
LEFT JOIN jos_kunena_user_topics AS ut
ON tt.id=ut.topic_id
AND ut.user_id='0'**
**1 × SELECT COUNT(1)
FROM `jos_easyblog_category`**
**1 × SELECT *
FROM `jos_easyblog_acl_group`**
**1 × SELECT *
FROM jos_kunena_user_topics**
**1 × SELECT *
FROM jos_easyblog_category**
**1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid**
**1 × SELECT *
FROM jos_community_config**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT *
FROM jos_kunena_categories**
**1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt**
**1 × SELECT user_id, category_id, role
FROM jos_kunena_user_categories**
**1 × SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role
FROM jos_kunena_categories AS c
INNER JOIN jos_community_groups_members AS g
ON c.accesstype='jomsocial'
AND c.access=g.groupid**
**1 × SELECT folder AS type, element AS name, params
FROM jos_extensions**
**1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id**
**1 × SELECT *
FROM jos_languages**
**1 × SELECT *
FROM jos_kunena_configuration**
**1 × SELECT *
FROM jos_kunena_topics**
**1 × SELECT *
FROM jos_kunena_announcement**
**1 × SELECT `data`
FROM `jos_session`**
**1 × SELECT *
FROM jos_template_styles**
**1 × SELECT *
FROM jos_menu**
**1 × SELECT *
FROM jos_easyblog_configs**
**1 × SELECT SUM(time>=1398805200
AND parent=0) AS todayTopicCount, SUM(time>=1398805200
AND parent>0) AS todayReplyCount, SUM(time>=1398718800
AND time<1398805200
AND parent=0) AS yesterdayTopicCount, SUM(time>=1398718800
AND time<1398805200
AND parent>0) AS yesterdayReplyCount
FROM jos_kunena_messages**
**1 × SELECT COUNT(*), MAX(id)
FROM jos_users**
**1 × SELECT code, location
FROM jos_kunena_smiley**
**1 × SELECT s.userid, s.time
FROM jos_session AS s**
**1 × SELECT guest, time, usertype, client_id
FROM jos_session**
**1 × select `id`
FROM `jos_easyblog_team`**
**טבלאות אחרות:**
**1 × SHOW FULL COLUMNS
FROM `jos_easyblog_category**
**1 × SHOW FULL COLUMNS
FROM `jos_users**
**1 × SHOW FULL COLUMNS
FROM `jos_easyblog_users**
**1 × SHOW FULL COLUMNS
FROM `jos_easyblog_ratings**
**1 × SHOW FULL COLUMNS
FROM `jos_assets**
**1 × UPDATE `jos_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1398843045;s:18:\"session.timer.last\";i:1398843045;s:17:\"session.timer.now\";i:1398843061;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":1:{s:10:\"user0_read\";a:10:{i:603;s:3:\"603\";i:6;s:1:\"6\";i:15;s:2:\"15\";i:10;s:2:\"10\";i:7;s:1:\"7\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:3;s:1:\"3\";i:4;s:1:\"4\";i:11;s:2:\"11\";}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"700d9da3d12d694b49f6fd49df8adb8c\";s:16:\"com_mailto.links\";a:10:{s:40:\"58464d2607aa6b7ca4731b9c29380eacdbcdffd6\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\" tamirdwh.funet.co.il/subdomains/dwh/main...n-israel/166-People-
and-computers-אנשים-ומחשבים/2812-מפגש-ibi-מאי-2014\";s:6:\"expiry\";i:1398843047;}}}' , `time` = '1398843063'**
**1 × SHOW FULL COLUMNS
FROM `jos_kunena_user_topics**
**1 × SHOW FULL COLUMNS
FROM `jos_easyblog_post**
**1 × SHOW FULL COLUMNS
FROM `jos_easyblog_configs**
**1 × SHOW FULL COLUMNS
FROM `jos_kunena_sessions**
**1 × SHOW FULL COLUMNS
FROM `jos_kunena_users**
**1 × SHOW FULL COLUMNS
FROM `jos_community_config**
**1 × SHOW FULL COLUMNS
FROM `jos_kunena_categories**
**1 × SHOW FULL COLUMNS
FROM `jos_kunena_announcement**
**1 × SHOW FULL COLUMNS
FROM `jos_community_profiles**
**1 × DELETE
FROM `jos_session`**
Please Log in or Create an account to join the conversation.
Hi,
I tried installing through the upgrade manager in Kunena (as opposed to the extension manager). Now, I have more clues, it failed with the following message:
500 - **An error has occurred.**
**Installation unexpectedly terminated:****Package Install: Custom install routine failure**
**Return to Control Panel**
Call stack
# Function Location
1 JAdministrator->dispatch() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/libraries/joomla/application/component/helper.php:348
4 require_once() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/libraries/joomla/application/component/helper.php:380
5 LiveUpdate::handleRequest() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/administrator/components/com_kunena/admin.kunena.php:26
6 JController->execute() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/administrator/components/com_kunena/liveupdate/liveupdate.php:63
7 LiveUpdateController->install() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/libraries/joomla/application/component/controller.php:761
8 LiveUpdateModel->install() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/administrator/components/com_kunena/liveupdate/classes/controller.php:150
9 JInstaller->install() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/administrator/components/com_kunena/liveupdate/classes/model.php:99
10 JInstallerPackage->install() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/libraries/joomla/installer/installer.php:472
11 JInstaller->abort() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/libraries/joomla/installer/adapters/package.php:140
12 JError::raiseError() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/libraries/joomla/installer/installer.php:417
13 JError::raise() /home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/libraries/joomla/error/error.php:251
and the DB queries were:
**7 Queries Logged**
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'a0cbba379d5c8e76060900119f333b6b'
DELETE
FROM `jos_session`
WHERE `time` < '1398843515'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_kunena'
SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:50;s:19:\"session.timer.start\";i:1398841875;s:18:\"session.timer.last\";i:1398845310;s:17:\"session.timer.now\";i:1398845315;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";N;}}}s:10:\"com_kunena\";O:8:\"stdClass\":1:{s:11:\"user62_read\";N;}s:13:\"com_templates\";O:8:\"stdClass\":1:{s:6:\"styles\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}s:11:\"com_plugins\";O:8:\"stdClass\":1:{s:7:\"plugins\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:6:\"folder\";s:6:\"kunena\";}s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:14:\"[email protected]\";s:8:\"password\";s:34:\"$P$DWgFL85uqbG0YBtMtm4IVJ6fohHot1/\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2006-02-13 21:13:55\";s:13:\"lastvisitDate\";s:19:\"2014-04-29 14:02:35\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:147:\"{\"editor\":\"\",\"expired\":\"\",\"expired_time\":\"\",\"admin_language\":\"\",\"language\":\"\",\"helpsite\":\"\",\"timezone\":\"\",\"update_cache_list\":\"1\",\"admin_style\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}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_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":9:{s:6:\"editor\";s:0:\"\";s:7:\"expired\";s:0:\"\";s:12:\"expired_time\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:17:\"update_cache_list\";s:1:\"1\";s:11:\"admin_style\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"55732a55c3cd2f89c12807ccb2a894af\";}__wf|a:1:{s:13:\"session.token\";s:32:\"6b84c962169af1438def03ab9424b175\";}__liveupdate|a:2:{s:6:\"target\";s:83:\"/home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/tmp/com_kunena.update.zip\";s:7:\"tempdir\";s:79:\"/home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/tmp/com_kunena_update\";}' , `time` = '1398845315'
WHERE `session_id` = 'a0cbba379d5c8e76060900119f333b6b'
**6 Query Types Logged, Sorted by Occurrences.**
**SELECT Tables:**
**2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions**
**1 × SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id**
**1 × SELECT folder AS type, element AS name, params
FROM jos_extensions**
**1 × SELECT `data`
FROM `jos_session`**
**OTHER Tables:**
**1 × UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:50;s:19:\"session.timer.start\";i:1398841875;s:18:\"session.timer.last\";i:1398845310;s:17:\"session.timer.now\";i:1398845315;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";N;}}}s:10:\"com_kunena\";O:8:\"stdClass\":1:{s:11:\"user62_read\";N;}s:13:\"com_templates\";O:8:\"stdClass\":1:{s:6:\"styles\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}s:11:\"com_plugins\";O:8:\"stdClass\":1:{s:7:\"plugins\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:6:\"folder\";s:6:\"kunena\";}s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:14:\"[email protected]\";s:8:\"password\";s:34:\"$P$DWgFL85uqbG0YBtMtm4IVJ6fohHot1/\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2006-02-13 21:13:55\";s:13:\"lastvisitDate\";s:19:\"2014-04-29 14:02:35\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:147:\"{\"editor\":\"\",\"expired\":\"\",\"expired_time\":\"\",\"admin_language\":\"\",\"language\":\"\",\"helpsite\":\"\",\"timezone\":\"\",\"update_cache_list\":\"1\",\"admin_style\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}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_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":9:{s:6:\"editor\";s:0:\"\";s:7:\"expired\";s:0:\"\";s:12:\"expired_time\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:17:\"update_cache_list\";s:1:\"1\";s:11:\"admin_style\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"55732a55c3cd2f89c12807ccb2a894af\";}__wf|a:1:{s:13:\"session.token\";s:32:\"6b84c962169af1438def03ab9424b175\";}__liveupdate|a:2:{s:6:\"target\";s:83:\"/home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/tmp/com_kunena.update.zip\";s:7:\"tempdir\";s:79:\"/home/virtual/tamirdwh/public_html/subdomains/dwh/mainj25/tmp/com_kunena_update\";}' , `time` = '1398845315'**
**1 × DELETE
FROM `jos_session`**
Please Log in or Create an account to join the conversation.
After the installation failed. I looked in the extension manager while searching to the Kunena keyword, and found that some of the version 3 elements were successfully installed. I am attaching a screenshot. please have alook at the version column.
Tnx
Please Log in or Create an account to join the conversation.
I do not know what the "upgrade manager in Kunena" is.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.