- Posts: 694
- Thank you received: 22
Kunena 7.0.4 Released
The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0
Question Bug/Issues with my database (not kunena i think)
- woonydanny
-
Topic Author
- Offline
- Elite Member
-
Less
More
17 years 2 months ago #4261
by woonydanny
still wish that i can write my forum signature through a jomsocial plugin and do it from my jomsocial profile
Replied by woonydanny on topic Re:Bug/Issues with my database (not kunena i think)
any ideas matias?
still wish that i can write my forum signature through a jomsocial plugin and do it from my jomsocial profile
Please Log in or Create an account to join the conversation.
- grumblemarc
-
- Offline
- Elite Member
-
- Still making trouble
Less
More
- Posts: 1107
- Thank you received: 3
17 years 2 months ago #4265
by grumblemarc
We love stars on the Joomla Extension Directory .
Replied by grumblemarc on topic Re:Bug/Issues with my database (not kunena i think)
It's only been an hour. Please be patient.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
17 years 2 months ago #4281
by Matias
Replied by Matias on topic Re:Bug/Issues with my database (not kunena i think)
Hmm.. CB must use another query to count users and to get the last user. I have to check and fix this one..
Board Categories have a known bug that they won't show private categories. Are your categories visible for every user or hidden from visitor?
Delete has empty category list, Move should have something in there.. Try to change action to Move. I think this is the same bug.
Board Categories have a known bug that they won't show private categories. Are your categories visible for every user or hidden from visitor?
Delete has empty category list, Move should have something in there.. Try to change action to Move. I think this is the same bug.
Please Log in or Create an account to join the conversation.
- woonydanny
-
Topic Author
- Offline
- Elite Member
-
Less
More
- Posts: 694
- Thank you received: 22
17 years 2 months ago #4578
by woonydanny
still wish that i can write my forum signature through a jomsocial plugin and do it from my jomsocial profile
Replied by woonydanny on topic Re:Bug/Issues with my database (not kunena i think)
Issue #1:
?
Issue #2:
Move has an empty category list as well.
My forum categories are set to:
Public Access: All Registered
Admin Access: some are set to nothing some set to Public Backend, one to Administrator (to be honest i have never really set these up. What does this actually do?)
Issue #3:
Ok hope you can find the CB query and so we can match these total member figures up.
thankyou again for your help
?
Issue #2:
Move has an empty category list as well.
My forum categories are set to:
Public Access: All Registered
Admin Access: some are set to nothing some set to Public Backend, one to Administrator (to be honest i have never really set these up. What does this actually do?)
Issue #3:
Ok hope you can find the CB query and so we can match these total member figures up.
thankyou again for your help
still wish that i can write my forum signature through a jomsocial plugin and do it from my jomsocial profile
Please Log in or Create an account to join the conversation.
17 years 2 months ago #4583
by Matias
Replied by Matias on topic Re:Bug/Issues with my database (not kunena i think)
Yes, I might know what is happening in here.
PS. If you find the CB query, please post it here so that I can get it fixed.
PS. If you find the CB query, please post it here so that I can get it fixed.
Please Log in or Create an account to join the conversation.
- woonydanny
-
Topic Author
- Offline
- Elite Member
-
Less
More
- Posts: 694
- Thank you received: 22
17 years 2 months ago - 17 years 2 months ago #5816
by woonydanny
still wish that i can write my forum signature through a jomsocial plugin and do it from my jomsocial profile
Replied by woonydanny on topic Re:Bug/Issues with my database (not kunena i think)
Issue #1
Any news?
Issue #2
Any news?
Issue #3
Ok Nant over at joomlapolis told me the User Count done in my User List depends on what options i have set for the CB List.
I have it set to show all users (registered - Super Admin) and have no filters on it.
I have put on debug and have copied the bits i think are to do with the User List. Is it possible to work out from this which query you need kunena to do to match up user Count?
Any news?
Issue #2
Any news?
Issue #3
Ok Nant over at joomlapolis told me the User Count done in my User List depends on what options i have set for the CB List.
I have it set to show all users (registered - Super Admin) and have no filters on it.
I have put on debug and have copied the bits i think are to do with the User List. Is it possible to work out from this which query you need kunena to do to match up user Count?
Code:
#
SELECT *
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 62
#
SELECT gid
FROM jos_users
WHERE id = 62
#
SELECT g1.id AS group_id, g1.name
FROM jos_core_acl_aro_groups g1
LEFT JOIN jos_core_acl_aro_groups g2
ON g2.lft >= g1.lft
WHERE g2.id =25
ORDER BY g1.name
#
SELECT listid, title
FROM jos_comprofiler_lists
WHERE published=1
AND useraccessgroupid IN (24,31,19,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY ordering
#
SELECT listid
FROM jos_comprofiler_lists
WHERE `default`=1
AND published=1
AND useraccessgroupid IN (24,31,19,20,23,30,29,21,18,17,25,28,-2,-1)
#
SELECT *
FROM `jos_comprofiler_lists`
WHERE `listid` = '4'
#
SELECT g1.id AS group_id, g1.name
FROM jos_core_acl_aro_groups g1
LEFT JOIN jos_core_acl_aro_groups g2
ON g2.lft <= g1.lft
WHERE g2.id =20
ORDER BY g1.name
#
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 2
AND type = 'user'
ORDER BY ordering
#
SELECT f.*
FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
AND ( f.profile != 0 OR f.name = 'username')
AND t.enabled = 1
AND t.useraccessgroupid IN (24,31,19,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY t.position, t.ordering, f.ordering
#
SELECT COUNT(*)
FROM jos_comprofiler ue, jos_users u
WHERE u.block = 0
AND ue.approved = 1
AND ue.confirmed = 1
AND u.gid IN ( 18, 19, 20, 21, 30, 23, 24, 25)
AND u.`id` = ue.`id`
#
SELECT ue.*, u.*, '' AS 'NA'
FROM jos_comprofiler ue, jos_users u
WHERE u.block = 0
AND ue.approved = 1
AND ue.confirmed = 1
AND u.gid IN ( 18, 19, 20, 21, 30, 23, 24, 25)
AND u.`id` = ue.`id`
ORDER BY `username` ASC, `registerDate` ASC
LIMIT 0, 150
still wish that i can write my forum signature through a jomsocial plugin and do it from my jomsocial profile
Last edit: 17 years 2 months ago by woonydanny.
Please Log in or Create an account to join the conversation.
Time to create page: 0.223 seconds