- Posts: 337
- Thank you received: 6
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
Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.
Question More than 250 Queries by Recent Topic
14 years 7 months ago - 14 years 7 months ago #106946
by baboon
Replied by baboon on topic Re: More than 250 Queries by Recent Topic
Hello,
sorry i haven't see the Matias answer before.
so :
1 - I am using Kunena 1.7.0, CB 1.7.0, J1.5.23
2 - I have set the admin as global moderator
and i have still a lof of query with Recent Topics view :
an here the configuration
sorry i haven't see the Matias answer before.
so :
1 - I am using Kunena 1.7.0, CB 1.7.0, J1.5.23
2 - I have set the admin as global moderator
and i have still a lof of query with Recent Topics view :
Profile Information
Application afterLoad: 0.001 seconds, 0.27 MB
Application afterInitialise: 0.070 seconds, 2.82 MB
Application afterRoute: 0.078 seconds, 3.32 MB
Application afterDispatch: 0.830 seconds, 17.76 MB
Application afterRender: 1.029 seconds, 23.36 MB
Memory Usage
24533148
147 queries logged
SELECT *
FROM jos_session
WHERE session_id = '4f19418162a7443962ffa2c4f8f65a87'
SELECT *
FROM jos_session
WHERE session_id = '4f19418162a7443962ffa2c4f8f65a87'
DELETE
FROM jos_session
WHERE ( TIME < '1315907152' )
SELECT *
FROM jos_session
WHERE session_id = '4f19418162a7443962ffa2c4f8f65a87'
UPDATE `jos_session`
SET `time`='1315908052',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:1844;s:19:\"session.timer.start\";i:1315898817;s:18:\"session.timer.last\";i:1315908047;s:17:\"session.timer.now\";i:1315908048;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.2) Gecko/20100101 Firefox/6.0.2\";s:8:\"registry\";O:9:\"JRegistry\":{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:10:\"com_kunena\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:8:\"redirect\";N;s:10:\"ActionBulk\";s:18:\"/forum/recent.html\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:25:\"[email protected]\";s:8:\"password\";s:65:\"fsfsffsffsfsfsf:m9zLI9tsffsffssssssssssssBg2\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2009-02-19 21:53:19\";s:13:\"lastvisitDate\";s:19:\"2011-09-12 20:16:17\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:60:\"admin_language=\nlanguage=\neditor=none\nhelpsite=\ntimezone=0\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:86:\"/home/www/web/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":5:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:4:\"none\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:1:\"0\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"bxbxcbcxbcxbxcb\";s:16:\"com_mailto.links\";a:5:{s:40:\"cbcxbxcbcxbcxbxcbxcb\";O:8:\"stdClass\":2:{s:4:\"link\";s:104:\" www.mywebsite.com/component/content/arti...isplayIdRSM|s:1:\"4\ ";'
WHERE session_id='4f19418162a7443962ffa2c4f8f65a87'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT *
FROM jos_kunena_config
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 62
SELECT u.id AS userid, 0 AS catid
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 92)
ORDER BY menuid DESC
LIMIT 0, 1
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 COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='82.121.141.218'
AND userid='62'
UPDATE jos_kunena_whoisonline
SET TIME='1315900853', what='User is viewing recent discussions', do='', task='', link=' www.mywebsite.com/forum/recent.html ', func='latest'
WHERE userid='62'
AND userip='82.121.141.218'
SELECT *
FROM jos_kunena_sessions
WHERE userid = '62'
UPDATE `jos_kunena_sessions`
SET `allowed`='13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34',`lasttime`='1315898864',`readtopics`='0',`currvisit`='1315900853'
WHERE userid='62'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 0
AND ( mm.menuid = 92 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT *
FROM jos_users
WHERE id = '62'
SELECT c.*, u.*
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` AS g1
LEFT JOIN `jos_core_acl_aro_groups` AS g2
ON g2.`lft` >= g1.`lft`
WHERE g2.`id` = 25
ORDER BY g1.`name`
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
AND t.enabled = 1
AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY t.POSITION, t.ordering, f.ordering
SELECT COUNT(a.id)
FROM jos_uddeim AS a
WHERE a.toid=62
AND a.totrash=0
AND archived=0
AND a.toread=0
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 2
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT COUNT(DISTINCT t.thread)
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.hold IN (0,1,2,3)
AND t.moved=0
AND t.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.time>'1313316053'
SELECT m.id, MAX(t.id) AS lastid
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.hold IN (0,1,2,3)
AND t.moved='0'
AND t.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.time>'1313316053'
GROUP BY t.thread
ORDER BY lastid DESC
LIMIT 0, 20
SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments,
l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx
FROM (
SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL
AND f.userid='62') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount,
COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='62', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='62', m.id, 0)) AS mylastid, MAX(m.TIME) AS lasttime
FROM jos_kunena_messages AS m
LEFT JOIN jos_kunena_favorites AS f
ON f.thread = m.thread
LEFT JOIN jos_kunena_attachments AS a
ON a.mesid = m.id
WHERE m.hold IN (0,1,2,3)
AND m.moved='0'
AND m.thread IN (2928,2960,2955,2950,2947,2942,2940,2938,2929,2925,2923,2920,2918,2916,2912,2904,2898,2896,2892,2866)
GROUP BY thread
) AS l
INNER JOIN jos_kunena_messages AS a
ON a.thread = l.thread
INNER JOIN jos_kunena_messages_text AS t
ON a.id = t.mesid
LEFT JOIN jos_users AS j
ON j.id = a.userid
LEFT JOIN jos_kunena_users AS u
ON u.userid = j.id
LEFT JOIN jos_kunena_categories AS c
ON c.id = a.catid
LEFT JOIN jos_kunena_attachments AS aa
ON aa.mesid = a.id
WHERE (a.parent='0' OR a.id=l.lastid )
GROUP BY a.id
ORDER BY lastid DESC
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id
INNER JOIN jos_session AS s
ON s.client_id=0
AND s.userid=u.id
AND s.userid>0
GROUP BY s.userid
ORDER BY username ASC
SELECT id, username AS username
FROM jos_users
WHERE block=0 OR activation=""
ORDER BY id DESC
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (21815,62,19250,22150,21876,15414,15392,21952,19980,21918,21842,21401,20930,11382,19076,22273,22276,21886)
SELECT thread, MIN(id) AS lastread, SUM(1) AS unread
FROM jos_kunena_messages
WHERE hold IN (0,1,2,3)
AND moved='0'
AND thread NOT IN (0)
AND thread IN (2928,2960,2955,2950,2947,2942,2940,2938,2929,2925,2923,2920,2918,2916,2912,2904,2898,2896,2892,2866)
AND time>'1315898864'
GROUP BY thread
SELECT *
FROM jos_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
SELECT *
FROM jos_kunena_categories
WHERE id IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND published='1'
ORDER BY ordering, name
SELECT id, name, parent
FROM jos_kunena_categories
WHERE published=1
SELECT code, `location`
FROM jos_kunena_smileys
SELECT u.id AS userid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS ku
ON u.id=ku.userid
LEFT JOIN jos_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jos_kunena_categories AS c
ON m.catid=c.id
WHERE u.block='0'
AND ku.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
SELECT *, u.id
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id IN (21815,19250,22150,21876,15414,15392,21952,19980,21918,21842,21401,20930,11382,19076,22273,22276,21886)
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19250
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19250
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19250
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 22150
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 22150
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21876
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21876
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21876
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15392
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21952
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19980
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19980
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19980
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21918
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21918
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21918
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21842
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21401
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21401
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21401
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 20930
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT *
FROM jos_kunena_categories
WHERE id IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND published='1'
ORDER BY ordering, name
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 11382
SELECT username
FROM jos_users
WHERE id = 11382
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 19076
SELECT username
FROM jos_users
WHERE id = 19076
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 22273
SELECT username
FROM jos_users
WHERE id = 22273
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 22276
SELECT username
FROM jos_users
WHERE id = 22276
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21886
LIMIT 0, 1
SELECT COUNT(*)
FROM jos_users
WHERE block=0 OR activation=""
SELECT SUM(TIME >= '1315864800'
AND parent='0') AS todayopen,
SUM(TIME >= '1315778400'
AND TIME < '1315864800'
AND parent='0') AS yesterdayopen,
SUM(TIME >= '1315864800'
AND parent>'0') AS todayanswer,
SUM(TIME >= '1315778400'
AND TIME < '1315864800'
AND parent>'0') AS yesterdayanswer
FROM jos_kunena_messages
WHERE TIME >= '1315778400'
AND hold='0'
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
SELECT username
FROM jos_users
WHERE id = 22276
LIMIT 0, 1
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 92
LIMIT 1
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 90
LIMIT 1
SELECT COUNT(*)
FROM jos_menu AS m
WHERE menutype='kunenamenu'
AND published=1
AND parent=0
AND ordering < 1
AND access <= '2'
SELECT `id`
FROM `jos_components`
WHERE `name`='RSMonials'
AND `enabled`='1'
SELECT *
FROM `jos_rsmonials`
WHERE `status`='1'
ORDER BY `id`
SELECT name
FROM jos_users
WHERE id = 62
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
SELECT a.*, b.username AS displayname
FROM jos_uddeim AS a
LEFT JOIN jos_users AS b
ON a.fromid=b.id
WHERE a.toread=0
AND a.totrash=0
AND a.toid=62
ORDER BY a.datum
SELECT popup
FROM jos_uddeim_emn
WHERE userid=62
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 2
SELECT COUNT(*)
FROM jos_comprofiler_members AS m
LEFT JOIN jos_comprofiler AS c
ON m.referenceid=c.id
LEFT JOIN jos_users AS u
ON m.referenceid=u.id
WHERE m.memberid=62
AND m.pending=1
AND c.approved=1
AND c.confirmed=1
AND c.banned=0
AND u.block=0
SELECT *
FROM jos_acctexp_config
WHERE id = '1'
SELECT `id`
FROM jos_acctexp_metauser
WHERE `userid` = '62'
SELECT *
FROM jos_acctexp_metauser
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '62'
SELECT `id`
FROM jos_acctexp_subscr
WHERE `userid` = '62'
ORDER BY `primary` DESC
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
SELECT `a`.`id`, `a`.`plan`, `a`.`expiration`, `a`.`recurring`, `a`.`lifetime`, `b`.`name`
FROM jos_acctexp_subscr AS a
INNER JOIN jos_acctexp_plans AS b
ON a.plan = b.id
WHERE `userid` = '62'
AND `status` != 'Expired'
AND `status` != 'Closed'
AND `status` != 'Hold'
ORDER BY `lastpay_date` DESC
SELECT `id`
FROM jos_acctexp_displaypipeline
WHERE `userid` = '62'
AND `only_user` = '1'
SELECT `id`
FROM jos_acctexp_displaypipeline
WHERE `only_user` = '0'
SELECT `id`
FROM jos_acctexp_cart
WHERE userid = '62'
SELECT *
FROM jos_acctexp_cart
WHERE id = '895'
SELECT `id`
FROM jos_acctexp_metauser
WHERE `userid` = '62'
SELECT *
FROM jos_acctexp_metauser
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '62'
SELECT `id`
FROM jos_acctexp_subscr
WHERE `userid` = '62'
ORDER BY `primary` DESC
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
an here the configuration
This message contains confidential information
Database collation check: The collation of your table fields are correct
Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Enabled |
This message contains confidential informationhtaccess: Exists | PHP environment: Max execution time: 10 seconds | Max execution memory: 96M | Max file upload: 300M
This message contains confidential information
Joomla default template details : mywebsite | author: JoomlArt.com | version: 1.2.0 | creationdate: 12/26/07
Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.7.0 | creationdate: 2011-08-29
Kunena version detailled: Installed version: 1.7.0 | Build: 5135 | Version name: Tale | Kunena detailled configuration:
Warning: Spoiler!
Third-party components: CommunityBuilder 1.7 | UddeIm
Third-party SEF components: None
Plugins: System - Mootools Upgrade: Enabled | System - Mootools12: Disabled | Kunena Search 1.7.0
Modules: Kunena Latest 1.6.4
Last edit: 14 years 7 months ago by Matias.
Please Log in or Create an account to join the conversation.
Time to create page: 0.337 seconds