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 Categories Counts at 0, no posts, no replies

Jadzia
Topic Author
Offline
New Member

16 years 7 months ago - 16 years 7 months ago #29777 by Jadzia

Categories Counts at 0, no posts, no replies was created by Jadzia

Hi

I have just done a fresh install of Joomla and Kunena 1.5.5 at www.narromine.nsw.au and imported the database from the old version. Now the posts are showing 0 in the caetgories, when you go into the posts you can see the stats. I added a new post and it shows up fine, however not in the latest posts. I have run a debug and have the following info;

Warning: Spoiler!

Code:

Profile Information
Application afterLoad: 0.001 seconds, 0.24 MB
Application afterInitialise: 0.104 seconds, 3.63 MB
Application afterRoute: 0.125 seconds, 4.21 MB
Application afterDispatch: 0.462 seconds, 13.31 MB
Application afterRender: 0.601 seconds, 14.76 MB
Memory Usage
15521720
Queries logged

   1.
      SELECT *
        FROM jos_session
        WHERE session_id = 'b4f77a13d2ce389cb30ce50da344d78f'
   2.
      DELETE
        FROM jos_session
        WHERE ( time < '1254088396' )
   3.
      SELECT *
        FROM jos_session
        WHERE session_id = 'b4f77a13d2ce389cb30ce50da344d78f'
   4.
      UPDATE `jos_session`
        SET `time`='1254091996',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='0',`data`='L3BfaO8QczfLRPNLb3dWNHQ1yPKyL98kYoudMk4kFaedzFcN5mpCsALT0AbtFPmiRgtNwcHgk1E1dPIACV6etNbEWLdmupqJTXexV4vF3r21Ds2_l50MZz2n1FXmfs6KD-aHdI9pIm026X9FhZDyEb6wqXFvY6aQ9kREP9se5TkkGmJgsbBQvM8QhmElcOf0IQDgIGVUbHXuaRwxlZr5PdE8lQk3OlbGNbFAAG1sw9V-nusOGElegxM0_5Igy7xVZz4hn_doUKGwGaU1qrmdAhqRp7BL8o9ZtyRu7YsJccTf2nEo4aLLbwaHQ1T-fFH9msVU5bPx8DapyGqwVJaU-rttBEptTIXmGNwFQhgrmoEJU2MPDHWTWxDZhILJzCTyjjYTD4tN9gnni_ppZ0K5m3XM42EBWPCi50IMdWuUvyFXJZlppDi5sRkPnSe6LnAUKbHP5IeoWvkdFlOxLY84aBernx3fqIJgkiPn9qvWFutyJLUyVLvVlQXC92KuxIODkaPMkEdgtH1S284H0D1WiAHY7Gk7jdmqQ31vZcCLh2-uUSfAlECCVSGaIGTWL1l-EMKdbdyOBFu3Y_iM2llIaeflVpqoqooZFx5_dGX40fYveriRAYp62o0PRqS2a9MSabwwOmYZSlShs4eVjFyj164FJoir5ldR85kULVqujw7F8RU5dLOSnYh9TDILlFpBOBgQZjHr9QX0lHxgLP_OPARaOTUP4s4WNAEIQ0QG055do1d988D4dvsyVIuv4LceBRN5sr5PvHgHemul_Kst1C77gYyc_TBHl9MCtG7IYAtaqfc9xRjhqcRxPq90ya3-ryNAexj_6SyReqJY_C5SxPmXBR1AfbD3mvMMX_SPnMPBpbhMAO7cqPDKcZAZc_xYSPvosr8TA47zDD2-sMTYJqVVx5UiugOPkhxhZd3jtev_du2B6eO3xbelGhRNisei9WqOB8pROjk1uX9rbYzCG9ZiGFl8g_elYsuWdtw5eRr1sw19LweKaA3sERjtSh9366h9uRoYq5EwLl7GvVGNz7057kFFu5r1qY5swko8g3soBMFMeNua9XvJH_z_ReIjLD_I3l8IBbmQ_Ko6SI2WYFhCzHip9DWBt2GpCVH3fT6xSgWCdg9S6B-oUl7v-DO5ocO08HMpEqMoyvEvUyYuRdOjNQNEzklXlnTXqSw-IlXoPGE0GDN7DXdz-hHGxZGGM_lBdWZumUgZDqrag_sisEfTS51gS2ozuZn8XAI1limFmeaFNibscekv6zKVU83wkw20x257sesAOqasEzKp1qTunQ1c9_KSjf9VeZJC_hTZYZu68TuhINlFguElrSYx-Abb3h3VRXo8TmnFbpaBtA2vktM49aVikZjQF1UHshF8lrqbz_AqFjtqroq-jRVugNKpuASXP7G5mbhDAxQoIdsvGfRq8eUhQbvXYul2BECvZGo3X2WacTHaWyd-ObN46ZS87Nfjo90hEIAzr6BJRFfvlsxeu7dRfsmbQsTY7wGNOs0zgnmXGE3H6qOubTZ6FVExp4khYt-TZCgUVhMIg2qF5VVD26mS_Dl2Co7hH-0ruUPNw0EP242lxIUImllnlrHuFbVFTfxNipioD8B3tLTT4Q_xBc64rUzmaF9gqg7k13wGcnhAvoOYQ3VAVvDFiDiuVq0H-WrWrTuVfB6P6Za11G5adcSxeiUiZI5flKVtQr_YiJXh1YJN0LXAublwIoaZhDzqMIyV1c5xaOuVEwpT9lmc1dFdSgsXY6lZvDU_lb2hE2aUr9ako53JW7m6RfecpGxumOkJPI-lR5BaNGwvgV5G58wumt5mylLBLe75XriWazxyA64CExv_Rh5CBabw8nx-VlzgLrrJ_qiWievtUgKeTA1PXTsKUT_cCP0DUbYUB4iwt__KeT5_I6PhLeCQAdnGnbaqKDjOVbKNBfahkLQtPWDrC6vNxJYgjy1V9Ezt3x35KsZFzEcGg_6k7KN9zy95z4mwYij6d8PkvtIt0GDXS61TinuxFcjB5pytkZuin2MolBngQK89m7Ot2JIxqvrT5QE2UlH-V5l4e0qrlMTKH6bp6YzAzxK9ZLUU6PxLPDrIwaFFZQakt2e7z5KdcbfgMJ20-4aXDBvoFa2KJk3wMqgDqzlVSnOktKYYynp9WQABH6PC-NIVukRn'
        WHERE session_id='b4f77a13d2ce389cb30ce50da344d78f'
   5.
      SELECT folder AS type, element AS name, params
        FROM jos_plugins
        WHERE published >= 1
        AND access <= 2
        ORDER BY ordering
   6.
      SELECT m.*, c.`option` AS component
        FROM jos_menu AS m
        LEFT JOIN jos_components AS c
        ON m.componentid = c.id
        WHERE m.published = 1
        ORDER BY m.sublevel, m.parent, m.ordering
   7.
      SELECT template
        FROM jos_templates_menu
        WHERE client_id = 0
        AND (menuid = 0 OR menuid = 8)
        ORDER BY menuid DESC
        LIMIT 0, 1
   8.
      SELECT *
        FROM jos_components
        WHERE parent = 0
   9.
      SELECT *
        FROM jos_fb_users
        WHERE userid = '62'
  10.
      SHOW TABLES LIKE 'jos_fb_%'
  11.
      SELECT *
        FROM jos_fb_config
  12.
      SELECT g.*
        FROM jos_core_acl_aro_groups AS g
        INNER JOIN jos_core_acl_groups_aro_map AS gm
        ON gm.group_id = g.id
        INNER JOIN jos_core_acl_aro AS ao
        ON ao.id = gm.aro_id
        WHERE ao.value='62'
        ORDER BY g.id
  13.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_kunena'
        AND published='1'
  14.
      SELECT id
        FROM jos_menu
        WHERE link = 'index.php?option=com_comprofiler'
        AND published=1
        AND access <= 2
  15.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_uddeim'
        AND published='1'
  16.
      SELECT template
        FROM jos_templates_menu
        WHERE client_id='0'
  17.
      DELETE
        FROM jos_fb_whoisonline
        WHERE time < '1254090196'
  18.
      SELECT COUNT(*)
        FROM jos_fb_whoisonline
        WHERE userip='121.216.205.17'
        AND userid='62'
  19.
      UPDATE jos_fb_whoisonline
        SET  time='1254091996',  what='Forum Main',  do='',  task='',  link='/members/forums/listcat',  func='listcat'
        WHERE userid='62'
        AND userip='121.216.205.17'
  20.
      SELECT *
        FROM jos_fb_sessions
        WHERE userid = '62'
  21.
      UPDATE `jos_fb_sessions`
        SET `allowed`='5,6,7,8,9,10,11,501,502,503,504,507,512,513,515',`lasttime`='1253836733',`readtopics`='227,226,76',`currvisit`='1254091996'
        WHERE userid='62'
  22.
      SELECT VIEW
        FROM jos_fb_users
        WHERE userid='62'
  23.
      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
  24.
      SELECT MAX(posts)
        FROM jos_fb_users
  25.
      SELECT su.VIEW, u.name, su.moderator, su.avatar
        FROM jos_fb_users AS su
        LEFT JOIN jos_users AS u
        ON u.id=su.userid
        WHERE su.userid=62
        LIMIT 0, 1
  26.
      SELECT *
       
        FROM jos_users AS u
       
        LEFT JOIN jos_comprofiler AS c
        ON c.id = u.id
        WHERE u.id = 62
  27.
      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 = 8 OR mm.menuid = 0 )
        ORDER BY position, ordering
  28.
      SELECT *
        FROM jos_fb_categories
        WHERE parent='0'
        AND published='1'
        ORDER BY ordering
  29.
      SELECT code, `location`
        FROM jos_fb_smileys
  30.
      SELECT id, title, sdescription, description, created, published, showdate
        FROM jos_fb_announcement
        WHERE published='1'
        ORDER BY created DESC
        LIMIT 0, 1
  31.
      SELECT w.userid, u.id, u.username AS username, k.showOnline
        FROM jos_fb_whoisonline AS w
        LEFT JOIN jos_users AS u
        ON u.id=w.userid
        LEFT JOIN jos_fb_users AS k
        ON k.userid=w.userid
        WHERE w.link LIKE '%/members/forums/listcat%'
        GROUP BY w.userid
        ORDER BY u.username ASC
  32.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='501'
  33.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=501
  34.
      SELECT c.*, m.id AS mesid, m.subject, m.catid, m.name AS mname, m.userid, u.id AS uid, u.username, u.name AS uname
                         
        FROM jos_fb_categories AS c
                         
        LEFT JOIN jos_fb_messages AS m
        ON c.id_last_msg = m.id
                         
        LEFT JOIN jos_users AS u
        ON u.id = m.userid
                         
        WHERE c.parent='501'
        AND c.published='1'
                         
        ORDER BY ordering
  35.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='5'
  36.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='5'
        AND published='1'
        ORDER BY ordering
  37.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='5'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
  38.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='5'
  39.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='5'
        AND hold='1'
  40.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
  41.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=5
  42.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=5
  43.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='5'
  44.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='11'
  45.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='11'
        AND published='1'
        ORDER BY ordering
  46.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='11'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
  47.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='11'
  48.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='11'
        AND hold='1'
  49.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
  50.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=11
  51.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=11
  52.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='11'
  53.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='10'
  54.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='10'
        AND published='1'
        ORDER BY ordering
  55.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='10'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
  56.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='10'
  57.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='10'
        AND hold='1'
  58.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
  59.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=10
  60.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=10
  61.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='10'
  62.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='507'
  63.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='507'
        AND published='1'
        ORDER BY ordering
  64.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='507'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
  65.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='507'
  66.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='507'
        AND hold='1'
  67.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
  68.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=507
  69.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=507
  70.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='507'
  71.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='515'
  72.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='515'
        AND published='1'
        ORDER BY ordering
  73.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='515'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
  74.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='515'
  75.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='515'
        AND hold='1'
  76.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
  77.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=515
  78.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=515
  79.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='515'
  80.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='502'
  81.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=502
  82.
      SELECT c.*, m.id AS mesid, m.subject, m.catid, m.name AS mname, m.userid, u.id AS uid, u.username, u.name AS uname
                         
        FROM jos_fb_categories AS c
                         
        LEFT JOIN jos_fb_messages AS m
        ON c.id_last_msg = m.id
                         
        LEFT JOIN jos_users AS u
        ON u.id = m.userid
                         
        WHERE c.parent='502'
        AND c.published='1'
                         
        ORDER BY ordering
  83.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='7'
  84.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='7'
        AND published='1'
        ORDER BY ordering
  85.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='7'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
  86.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='7'
  87.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='7'
        AND hold='1'
  88.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
  89.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=7
  90.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=7
  91.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='7'
  92.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='503'
  93.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=503
  94.
      SELECT c.*, m.id AS mesid, m.subject, m.catid, m.name AS mname, m.userid, u.id AS uid, u.username, u.name AS uname
                         
        FROM jos_fb_categories AS c
                         
        LEFT JOIN jos_fb_messages AS m
        ON c.id_last_msg = m.id
                         
        LEFT JOIN jos_users AS u
        ON u.id = m.userid
                         
        WHERE c.parent='503'
        AND c.published='1'
                         
        ORDER BY ordering
  95.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='8'
  96.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='8'
        AND published='1'
        ORDER BY ordering
  97.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='8'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
  98.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='8'
  99.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='8'
        AND hold='1'
 100.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
 101.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=8
 102.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=8
 103.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='8'
 104.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='504'
 105.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=504
 106.
      SELECT c.*, m.id AS mesid, m.subject, m.catid, m.name AS mname, m.userid, u.id AS uid, u.username, u.name AS uname
                         
        FROM jos_fb_categories AS c
                         
        LEFT JOIN jos_fb_messages AS m
        ON c.id_last_msg = m.id
                         
        LEFT JOIN jos_users AS u
        ON u.id = m.userid
                         
        WHERE c.parent='504'
        AND c.published='1'
                         
        ORDER BY ordering
 107.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='6'
 108.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='6'
        AND published='1'
        ORDER BY ordering
 109.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='6'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
 110.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='6'
 111.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='6'
        AND hold='1'
 112.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
 113.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=6
 114.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=6
 115.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='6'
 116.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='512'
 117.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='512'
        AND published='1'
        ORDER BY ordering
 118.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='512'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
 119.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='512'
 120.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='512'
        AND hold='1'
 121.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
 122.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=512
 123.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=512
 124.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='512'
 125.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='9'
 126.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='9'
        AND published='1'
        ORDER BY ordering
 127.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='9'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
 128.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='9'
 129.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='9'
        AND hold='1'
 130.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
 131.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=9
 132.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=9
 133.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='9'
 134.
      SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
        FROM jos_fb_categories
        WHERE id='513'
 135.
      SELECT id, name, numTopics, numPosts
        FROM jos_fb_categories
        WHERE parent='513'
        AND published='1'
        ORDER BY ordering
 136.
      SELECT DISTINCT thread
        FROM jos_fb_messages
        WHERE catid='513'
        AND hold='0'
        AND time>'1253836733'
        GROUP BY thread
 137.
      SELECT userid
        FROM jos_fb_moderation
        WHERE catid='513'
 138.
      SELECT COUNT(*)
        FROM jos_fb_messages
        WHERE catid='513'
        AND hold='1'
 139.
      SELECT m.thread, COUNT(*) AS totalmessages
                                     
        FROM jos_fb_messages AS m
                                     
        LEFT JOIN jos_fb_messages AS mm
        ON m.thread=mm.thread
                                     
        WHERE m.id='0'
                                     
        GROUP BY m.thread
 140.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=513
 141.
      SELECT name, id
        FROM jos_fb_categories
        WHERE id=513
 142.
      SELECT *
        FROM jos_fb_moderation AS m
        LEFT JOIN jos_users AS u
        ON u.id=m.userid
        WHERE m.catid='513'
 143.
      SELECT u.id, IFNULL(u.username, 'Guest') AS username, IFNULL(u.name,'Guest') AS name, msg.subject, msg.id AS fbid, msg.catid, from_unixtime(msg.time) AS date, thread.hits AS hits, msg.locked, msg.topic_emoticon, msg.parent, cat.id AS catid, cat.name AS catname
        FROM (SELECT msg1.*
        FROM (SELECT msg2.*
        FROM jos_fb_messages msg2
        WHERE msg2.hold='0'
        AND moved='0'
        AND msg2.catid IN (5,6,7,8,9,10,11,501,502,503,504,507,512,513,515) 
        ORDER BY msg2.time DESC) msg1
        GROUP BY msg1.thread) msg
        LEFT JOIN jos_users u
        ON u.id = msg.userid
        LEFT JOIN jos_fb_categories cat
        ON cat.id = msg.catid
        LEFT JOIN jos_fb_messages thread
        ON thread.id = msg.thread
        ORDER BY msg.time DESC
        LIMIT 0, 10
 144.
      SELECT COUNT(*)
        FROM jos_users
 145.
      SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
        FROM jos_fb_categories
        WHERE parent='0'
 146.
      SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
        FROM jos_fb_categories
 147.
      SELECT id, username AS username
        FROM jos_users
        WHERE block='0'
        AND activation=''
        ORDER BY id DESC
        LIMIT 0, 1
 148.
      SELECT SUM(time >= '1254060000'
        AND parent='0') AS todayopen,  SUM(time >= '1253973600'
        AND time < '1254060000'
        AND parent='0') AS yesterdayopen,  SUM(time >= '1254060000'
        AND parent>'0') AS todayanswer,  SUM(time >= '1253973600'
        AND time < '1254060000'
        AND parent>'0') AS yesterdayanswer 
        FROM jos_fb_messages
        WHERE time >= '1253973600'
        AND hold='0'
 149.
      SELECT p.userid, p.posts, u.id, u.username AS username
        FROM jos_fb_users AS p
        INNER JOIN jos_users AS u
        ON u.id = p.userid
        WHERE p.posts > '0'
        ORDER BY p.posts DESC
        LIMIT 0, 5
 150.
      SELECT u.uhits AS hits, u.userid AS user_id, j.id, j.username AS user
        FROM jos_fb_users AS u
        INNER JOIN jos_users AS j
        ON j.id = u.userid
        WHERE u.uhits>'0'
        ORDER BY u.uhits DESC
        LIMIT 0, 5
 151.
      SELECT *
        FROM jos_fb_messages
        WHERE moved='0'
        AND hold='0'
        AND parent='0'
        AND catid IN (5,6,7,8,9,10,11,501,502,503,504,507,512,513,515)
        ORDER BY hits DESC
        LIMIT 0, 5
 152.
      SELECT w.userip, w.time, w.what, u.username AS username, u.id, k.moderator, k.showOnline 
        FROM jos_fb_whoisonline AS w
        LEFT JOIN jos_users AS u
        ON u.id=w.userid 
        LEFT JOIN jos_fb_users AS k
        ON k.userid=w.userid 
        INNER JOIN jos_session AS s 
        ON s.guest='0'
        AND s.userid=w.userid 
        WHERE w.userid!='0' 
        GROUP BY u.id 
        ORDER BY username ASC
 153.
      SELECT COUNT(*)
        FROM jos_fb_whoisonline
        WHERE user='0'
 154.
      SELECT id, title
        FROM jos_fb_groups AS g, jos_fb_users AS u
        WHERE u.group_id=g.id
        AND u.userid='62'
 155.
      SELECT id, title
        FROM jos_fb_groups AS g, jos_fb_users AS u
        WHERE u.group_id=g.id
        AND u.userid='62'
 156.
      SELECT id, title
        FROM jos_fb_groups
 157.
      SELECT *
        FROM jos_fb_categories
        WHERE id IN (5,6,7,8,9,10,11,501,502,503,504,507,512,513,515)
        ORDER BY ordering, name
 158.
      SELECT s.*, sn.name AS socnet, sn.url AS socneturl 
        FROM jos_stalker AS s 
        LEFT JOIN jos_stalker_socnets AS sn
        ON sn.id = s.socnetid 
        ORDER BY ordering
 159.
      SELECT username
        FROM jos_users
        WHERE id = 62
 160.
      SELECT id
        FROM jos_menu
        WHERE link LIKE '%com_uddeim%'
        AND published=1
        AND access<=2
        LIMIT 1
 161.
      SELECT id
        FROM jos_menu
        WHERE link LIKE '%com_uddeim%'
        AND published=0
        AND access<=2
        LIMIT 1
 162.
      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
 163.
      SELECT popup
        FROM jos_uddeim_emn
        WHERE userid=62
 164.
      SELECT gid
        FROM jos_users
        WHERE id=62
 165.
      SELECT id
        FROM jos_menu
        WHERE link LIKE '%com_uddeim%'
        AND published=1
        AND access<=2
        LIMIT 1
 166.
      SELECT id
        FROM jos_menu
        WHERE link LIKE '%com_uddeim%'
        AND published=0
        AND access<=2
        LIMIT 1
 167.
      SELECT count(a.id)
        FROM jos_uddeim AS a
        WHERE a.totrash=0
        AND a.toread=0
        AND a.toid=62
 168.
      SELECT count(a.id)
        FROM jos_uddeim AS a
        WHERE a.totrash=0
        AND archived=0
        AND a.toid=62
 169.
      SELECT count(a.id)
        FROM jos_uddeim AS a
        WHERE a.totrashoutbox=0
        AND ((a.systemmessage IS NULL) OR (a.systemmessage=''))
        AND a.fromid=62
 170.
      SELECT count(id)
        FROM jos_uddeim
        WHERE (totrashdate>=1253955196
        AND toid=62
        AND totrash=1) OR (totrashdateoutbox>=1253955196
        AND fromid=62
        AND totrashoutbox=1
        AND toid<>62
        AND ((systemmessage IS NULL) OR (systemmessage='')))
 171.
      SELECT name,avatar,username,firstname,lastname
        FROM jos_comprofiler,jos_users
        WHERE user_id = 62
 172.
      SELECT id
        FROM jos_menu
        WHERE link LIKE '%com_comprofiler%'
 173.
      SELECT *
        FROM jos_comprofiler
        WHERE user_id = 62
        AND approved =1
 174.
      SELECT exclude_items
        FROM jos_alpha_userpoints_rules
        WHERE `plugin_function`='sysplgaup_excludeusers'
        AND `published`='1'
 175.
      SELECT aup.points, u.username AS usrname, aup.userid AS userID, aup.referreid
        FROM jos_alpha_userpoints AS aup, jos_users AS u
        WHERE aup.userid = u.id
        AND aup.referreid!='62'
        AND aup.referreid!=''
        ORDER BY aup.points DESC, u.username ASC
        LIMIT 0, 5
 176.
      SELECT a.userid, a.referreid, a.upnid, a.points, a.max_points, a.last_update, a.referraluser, a.referrees, a.blocked, a.birthdate, a.avatar, a.levelrank, a.leveldate, a.gender, a.aboutme, a.website, a.phonehome, a.phonemobile, a.address, a.zipcode, a.city, a.country, a.education, a.graduationyear, a.job, a.facebook, a.twitter, a.icq, a.aim, a.yim, a.msn, a.skype, a.gtalk, a.xfire, a.profileviews,a.id AS rid, u.*
        FROM jos_alpha_userpoints AS a, jos_users AS u
        WHERE a.referreid='4A9C8059F021F'
        AND a.userid=u.id
 177.
      SELECT username
        FROM jos_users
        WHERE id = 62
        LIMIT 0, 1
 178.
      SELECT a.userid, a.referreid, a.upnid, a.points, a.max_points, a.last_update, a.referraluser, a.referrees, a.blocked, a.birthdate, a.avatar, a.levelrank, a.leveldate, a.gender, a.aboutme, a.website, a.phonehome, a.phonemobile, a.address, a.zipcode, a.city, a.country, a.education, a.graduationyear, a.job, a.facebook, a.twitter, a.icq, a.aim, a.yim, a.msn, a.skype, a.gtalk, a.xfire, a.profileviews,a.id AS rid, u.*
        FROM jos_alpha_userpoints AS a, jos_users AS u
        WHERE a.referreid='4A9C805D110FD'
        AND a.userid=u.id
 179.
      SELECT username
        FROM jos_users
        WHERE id = 345
        LIMIT 0, 1
 180.
      SELECT a.userid, a.referreid, a.upnid, a.points, a.max_points, a.last_update, a.referraluser, a.referrees, a.blocked, a.birthdate, a.avatar, a.levelrank, a.leveldate, a.gender, a.aboutme, a.website, a.phonehome, a.phonemobile, a.address, a.zipcode, a.city, a.country, a.education, a.graduationyear, a.job, a.facebook, a.twitter, a.icq, a.aim, a.yim, a.msn, a.skype, a.gtalk, a.xfire, a.profileviews,a.id AS rid, u.*
        FROM jos_alpha_userpoints AS a, jos_users AS u
        WHERE a.referreid='4A9C805ABDA6B'
        AND a.userid=u.id
 181.
      SELECT username
        FROM jos_users
        WHERE id = 295
        LIMIT 0, 1
 182.
      SELECT a.userid, a.referreid, a.upnid, a.points, a.max_points, a.last_update, a.referraluser, a.referrees, a.blocked, a.birthdate, a.avatar, a.levelrank, a.leveldate, a.gender, a.aboutme, a.website, a.phonehome, a.phonemobile, a.address, a.zipcode, a.city, a.country, a.education, a.graduationyear, a.job, a.facebook, a.twitter, a.icq, a.aim, a.yim, a.msn, a.skype, a.gtalk, a.xfire, a.profileviews,a.id AS rid, u.*
        FROM jos_alpha_userpoints AS a, jos_users AS u
        WHERE a.referreid='4A9C805ACD226'
        AND a.userid=u.id
 183.
      SELECT username
        FROM jos_users
        WHERE id = 176
        LIMIT 0, 1
 184.
      SELECT a.userid, a.referreid, a.upnid, a.points, a.max_points, a.last_update, a.referraluser, a.referrees, a.blocked, a.birthdate, a.avatar, a.levelrank, a.leveldate, a.gender, a.aboutme, a.website, a.phonehome, a.phonemobile, a.address, a.zipcode, a.city, a.country, a.education, a.graduationyear, a.job, a.facebook, a.twitter, a.icq, a.aim, a.yim, a.msn, a.skype, a.gtalk, a.xfire, a.profileviews,a.id AS rid, u.*
        FROM jos_alpha_userpoints AS a, jos_users AS u
        WHERE a.referreid='4A9C805DF1AC5'
        AND a.userid=u.id
 185.
      SELECT username
        FROM jos_users
        WHERE id = 413
        LIMIT 0, 1
 186.
      SELECT count(u.id)
        FROM jos_uddeim AS u
        WHERE u.totrash=0
        AND u.toread=0
        AND u.toid=62
 187.
      SELECT id
        FROM jos_menu
        WHERE published>=0
        AND link LIKE '%com_uddeim%'
 188.
      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

Legacy Queries logged

Language Files Loaded

    * /home/ziueon/public_html/language/en-GB/en-GB.ini 1
    * /home/ziueon/public_html/language/en-GB/en-GB.tpl_narromine.ini
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_stalker.ini 1
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_uddeim.ini
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_uddeim_mailbox.ini
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_procomplete.ini
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_alphauserpoints_mostactiveusers.ini 1
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_alphauserpoints_couponcode.ini 1
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_superfishmenu.ini 1
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_search.ini 1
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_cblogin.ini
    * /home/ziueon/public_html/language/en-GB/en-GB.mod_login.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

Last edit: 16 years 7 months ago by Matias.

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

Matias
Offline
Administrator

16 years 7 months ago #30173 by Matias

Replied by Matias on topic Re: Categories Counts at 0, no posts, no replies

What happens when you post a message with debug mode enabled?

I suppose that you did this in wrong order: you should first import database and only after that install Kunena. Well, installing it again should work, too, so go and grab K1.5.6.

Did it work?

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

Jadzia
Topic Author
Offline
New Member

16 years 7 months ago - 16 years 7 months ago #30227 by Jadzia

Replied by Jadzia on topic Re: Categories Counts at 0, no posts, no replies

Installing it again didn't work, here is the debug on posting a message, and thanks

)

Warning: Spoiler!

Profile Information
Application afterLoad: 0.001 seconds, 0.24 MB
Application afterInitialise: 0.111 seconds, 3.90 MB
Application afterRoute: 0.132 seconds, 4.51 MB
Application afterDispatch: 0.708 seconds, 13.54 MB
Application afterRender: 0.851 seconds, 14.71 MB
Memory Usage
15463160
Queries logged

1.
SELECT *
FROM jos_session
WHERE session_id = '1ff67df82c918d847844832ebf160d10'
2.
DELETE
FROM jos_session
WHERE ( time < '1254561086' )
3.
SELECT *
FROM jos_session
WHERE session_id = '1ff67df82c918d847844832ebf160d10'
4.
UPDATE `jos_session`
SET `time`='1254564686',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='0',`data`='_JYrKDTsM2xH-_3hvzdm9s4C3oEfkUKU59pt0hp-KbKRTveGodqAt8z9Etunk01v6T3qRQX1xBVJ2eaqmp7DLSjIYQcCE6-QD56-JyD7T3K3vDrlqWrTJSZ4w3hGZAQYIlsaH0Eb50oyBk9EIBRgPR9EdSHadBMDVM2tbXqacTRKuFC5yFCQkxHJtLQxqdOFycTuCWLzynbCNuF2tbQgFAp6bJIadoEmEKhygFaZ3uB7XXSBgvVFie2XwKO5YQgcnw2evthZCiwAY46LMHgoKZbrH284Wz-gC_UmpQGkpc6t_EzVyAXuvzGd4lfE0wxm_2x2E8Nvd6shreavI33m4bYxK1X_u8ib9y491YsWcI87fL4BEnudOLSUvKBYIAeiyg_1dmP9cQJtYNy-ZYgGc5DpBpnTyCENSM-pK7LNdI1KbzELgpTUJh9jt2gbDPXRlPBbDOoI5sSZmXARaL0voZvHKcQPOPZ2pSyd0x3tzWADFUZWF51MCEBYU0T3Befzmybz3IKvKqE9QTRCv7W8HoR7lhqCMzfbeNOd9kTAOSDlGroeFQJIwEUguLRYl8bc2RYtc4JEqkPIppBlj8B70XdcxZKfP1yN76ZkGn5I8hk--c9M0985H1pFJvAWRlnq2Qo599Khr_SC4T3TTwetYb2oE0wv97nNaJFo8HRNfKlz0NZqUWammJnWxtkfimMqdvumZgim9DhRbpfWLxK53EA7YniIrWs-fedmzdhUABIhQhpiDgdcv-JVjxhN76j42Z1G3Q7hN7653wYEeJIPrT7h6Zp2mRWCbPmax9QvabJPWNTuCL4hX8yDKVK6FE-QE1avQ0DRXacowUfFeXSY0XcVYKUYpMSVf-LYbesvQ6syWgPBR5WdprGwi4oNryGCGo3WFvU30yX2BRwxUWkdvrZqAoscYmiL8W3MMZxQp5rhVj3kb99mvaQ4oD_aJ-_F6uVb7gVtjxql7o-7w8RuQR0Kua4wP5WePSwVE61elPqNfnPrfw0xjVxh-SQ-jPbP0O1sv1331WGR2Az3X9sj_0vh5La0Ns5xx34tdEJ3XZmsv7_z73_N-nmRtKqewVsKIqMJ4mVivvDc7L25hnK-tUacjxUe3b70-jyM-F7EKIisSbMLqCT0_g6odpxxx-AU47rf1f29rtuuE963fiiDd6uXUXdcMhnK-7ClATLFPKcUIjixNdmKyOZ0KIRZ9uhg6pg-mWojJPz2bKKUjP93NphsitmKMzfVoPK2wOSxuOYdZUiHRpAFtrmslEq4tq8d4Xe7xTTdVsfWWQBM4lrH-sXh8EelOJvJtjzd8GajbJD-hYOZf5YaLLIqReuVH0UwD0OldDFvvwCtVOCk2wWsc6oEDFVuhq-2NR6f8emw5xT_havCMplZ0IGIFh6XYHW3JgCz95uzv0vjJ5mfpKpu5jLnAMXv1V6QCHqfw_0P7lG1QsyS5oRlXIlIbZ469WOAkEW8EeK9fWXOom168ILJXio_TtI70LniUYnHh7B8SzevbXh-ZNiQsyOaFLWRH9aSwaF_Tgbl8heb01BlMn9K6K4w-GqwhldMgbC2z5K6OozpSs90-f6_o5GM3k3ynZrIr64-yXUbZ_i7Pt4h_6TzhNlgBMXGRrVniuUCGz2An01GZ964fmAZfliFOqoGkuA15PAPjsjFg2f-AMEoNUoTDlgP3slxwUc5rjSThTccQCxF9qDrg7f-CIxO4E3KaOC_z7gKT9Mdt_jK6nHLa-B2lN1_5oD5fbFTfjqIusYDyW_R0-vKhtP_RwHNqjQtakyA-_gMoGx9Ip1SM4U_lQEUmiuyWpRBKG7L1GFPgypeHorFm3iHeYusvyEMbBJamaWQM8Fz2fnR96kSlOvx0BBbJ9oUQURcHAHqkZXlVccRTmhkw155RTqHhMl1oUZi3ph9yxgimMsrn-YCANIjXFqdJP1XxRVZAORNSWFt-AupFX1mYNldy51ivTCN0pLnFv5EQf4wTKm9SjPCB9qxAf5hTNxfog2Wt7uAk1D8LVLLAFPNIOCcbGsaachab3l3wtFHj5O-UlCIH65N4s95P0a3OFd3NmqCCRvJPonrvc36gz93TIKSe7FLMAS4RBX_xTIbuCyZY6bHUW56QejCxsLDX6S8tOWP0BLZNMFEARi6X5nMdXkpWOkHT6sdnilQt_borZa29Bh4o10BQoiNZxRdB8scLRhIrI09ulBrCvHCz_8bGSR5i04V9W_41ddhp4pR5oXkENOdDe5ULL0aMLUs8w..'
WHERE session_id='1ff67df82c918d847844832ebf160d10'
5.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
6.
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'members/forums/513-youth/228-test%' OR sefurl LIKE 'members/forums/513-youth/228-test%'
7.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
8.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 30)
ORDER BY menuid DESC
LIMIT 0, 1
9.
SELECT *
FROM jos_components
WHERE parent = 0
10.
SELECT *
FROM jos_fb_users
WHERE userid = '62'
11.
SHOW TABLES LIKE 'jos_fb_%'
12.
SELECT *
FROM jos_fb_config
13.
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='62'
ORDER BY g.id
14.
SELECT id
FROM jos_menu
WHERE link='index.php?option=com_kunena'
AND published='1'
15.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 2
16.
SELECT id
FROM jos_menu
WHERE link='index.php?option=com_uddeim'
AND published='1'
17.
SELECT template
FROM jos_templates_menu
WHERE client_id='0'
18.
DELETE
FROM jos_fb_whoisonline
WHERE time < '1254562886'
19.
SELECT COUNT(*)
FROM jos_fb_whoisonline
WHERE userip='121.216.205.17'
AND userid='62'
20.
SELECT subject
FROM jos_fb_messages
WHERE id='228'
21.
UPDATE jos_fb_whoisonline
SET time='1254564686', what='test', do='', task='', link='/members/forums/513-youth/228-test', func='view'
WHERE userid='62'
AND userip='121.216.205.17'
22.
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review
FROM jos_fb_categories
WHERE id='513'
23.
SELECT *
FROM jos_fb_sessions
WHERE userid = '62'
24.
UPDATE `jos_fb_sessions`
SET `allowed`='5,6,7,8,9,10,11,501,502,503,504,507,512,513,515',`lasttime`='1254099864',`readtopics`='',`currvisit`='1254564686'
WHERE userid='62'
25.
SELECT VIEW
FROM jos_fb_users
WHERE userid='62'
26.
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
27.
SELECT MAX(posts)
FROM jos_fb_users
28.
SELECT parent
FROM jos_fb_categories
WHERE id='513'
29.
SELECT su.VIEW, u.name, su.moderator, su.avatar
FROM jos_fb_users AS su
LEFT JOIN jos_users AS u
ON u.id=su.userid
WHERE su.userid=62
LIMIT 0, 1
30.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 62
31.
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 = 30 OR mm.menuid = 0 )
ORDER BY position, ordering
32.
SELECT code, `location`
FROM jos_fb_smileys
33.
SELECT *
FROM jos_fb_messages AS a
LEFT JOIN jos_fb_messages_text AS b
ON a.id=b.mesid
WHERE a.id='228'
AND a.hold='0'
34.
SELECT readtopics
FROM jos_fb_sessions
WHERE userid='62'
35.
UPDATE jos_fb_sessions
SET readtopics='228'
WHERE userid=62
36.
SELECT *
FROM jos_fb_messages AS a
LEFT JOIN jos_fb_messages_text AS b
ON a.id=b.mesid
WHERE (a.id='228' OR a.thread='228')
AND a.hold='0'
AND a.catid='513'
37.
SELECT *
FROM jos_fb_categories
WHERE id='513'
38.
SELECT name, id
FROM jos_fb_categories
WHERE id='504'
39.
SELECT thread
FROM jos_fb_subscriptions
WHERE userid='62'
AND thread='228'
40.
SELECT thread
FROM jos_fb_favorites
WHERE userid='62'
AND thread='228'
41.
SELECT *
FROM jos_fb_categories
WHERE id='513'
AND published='1'
42.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
43.
SELECT *
FROM jos_fb_categories
WHERE id='504'
AND published='1'
44.
SELECT name, id
FROM jos_fb_categories
WHERE id=504
45.
SELECT subject, id
FROM jos_fb_messages
WHERE id='228'
46.
SELECT w.userid, u.id, u.username AS username, k.showOnline
FROM jos_fb_whoisonline AS w
LEFT JOIN jos_users AS u
ON u.id=w.userid
LEFT JOIN jos_fb_users AS k
ON k.userid=w.userid
WHERE w.link LIKE '%/members/forums/513-youth/228-test%'
GROUP BY w.userid
ORDER BY u.username ASC
47.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
48.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
49.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
50.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
51.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
52.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
53.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
54.
SELECT COUNT(*)
FROM jos_fb_favorites
WHERE thread='228'
55.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
56.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
57.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
58.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
59.
SELECT a.userid
FROM jos_fb_users AS a
LEFT JOIN jos_fb_moderation AS b
ON b.userid=a.userid
WHERE b.catid='513'
60.
SELECT a.*, b.id, b.name, b.username, b.gid
FROM jos_fb_users AS a
LEFT JOIN jos_users AS b
ON b.id=a.userid
WHERE a.userid='62'
61.
SELECT id, parent_id, value, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=25
62.
SELECT *
FROM jos_fb_ranks
WHERE ((rank_min <= '77')
AND (rank_special = '0'))
ORDER BY rank_min DESC
LIMIT 1
63.
SELECT COUNT(userid)
FROM jos_session
WHERE userid='62'
64.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
65.
SELECT subject, id
FROM jos_fb_messages
WHERE id=229
66.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
67.
SELECT subject, id
FROM jos_fb_messages
WHERE id=229
68.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
69.
SELECT subject, id
FROM jos_fb_messages
WHERE id=229
70.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
71.
SELECT subject, id
FROM jos_fb_messages
WHERE id=229
72.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
73.
SELECT subject, id
FROM jos_fb_messages
WHERE id=229
74.
SELECT email, name
FROM jos_users
WHERE id='62'
75.
SELECT id, title
FROM jos_fb_groups AS g, jos_fb_users AS u
WHERE u.group_id=g.id
AND u.userid='62'
76.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
77.
SELECT subject, id
FROM jos_fb_messages
WHERE id=229
78.
SELECT a.*, b.id, b.name, b.username, b.gid
FROM jos_fb_users AS a
LEFT JOIN jos_users AS b
ON b.id=a.userid
WHERE a.userid='62'
79.
SELECT id, parent_id, value, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=25
80.
SELECT *
FROM jos_fb_ranks
WHERE ((rank_min <= '77')
AND (rank_special = '0'))
ORDER BY rank_min DESC
LIMIT 1
81.
SELECT COUNT(userid)
FROM jos_session
WHERE userid='62'
82.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
83.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
84.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
85.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
86.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
87.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
88.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
89.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
90.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
91.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
92.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
93.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
94.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
95.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
96.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
97.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
98.
SELECT email, name
FROM jos_users
WHERE id='62'
99.
SELECT id, title
FROM jos_fb_groups AS g, jos_fb_users AS u
WHERE u.group_id=g.id
AND u.userid='62'
100.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
101.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
102.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
103.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
104.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
105.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
106.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
107.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
108.
SELECT subject, id
FROM jos_fb_messages
WHERE id=228
109.
SELECT name, id
FROM jos_fb_categories
WHERE id=504
110.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
111.
SELECT *
FROM jos_fb_categories
WHERE id IN (5,6,7,8,9,10,11,501,502,503,504,507,512,513,515)
ORDER BY ordering, name
112.
SELECT name, id
FROM jos_fb_categories
WHERE id=513
113.
SELECT *
FROM jos_frsettings
WHERE id = 1
114.
SELECT s.*, sn.name AS socnet, sn.url AS socneturl
FROM jos_stalker AS s
LEFT JOIN jos_stalker_socnets AS sn
ON sn.id = s.socnetid
ORDER BY ordering
115.
SELECT *
FROM jos_frsettings
WHERE id = 1
116.
SELECT *
FROM jos_frsettings
WHERE id = 1
117.
SELECT *
FROM jos_frsettings
WHERE id = 1
118.
SELECT username
FROM jos_users
WHERE id = 62
119.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
120.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=0
AND access<=2
LIMIT 1
121.
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
122.
SELECT popup
FROM jos_uddeim_emn
WHERE userid=62
123.
SELECT *
FROM jos_frsettings
WHERE id = 1
124.
SELECT gid
FROM jos_users
WHERE id=62
125.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
126.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=0
AND access<=2
LIMIT 1
127.
SELECT count(a.id)
FROM jos_uddeim AS a
WHERE a.totrash=0
AND a.toread=0
AND a.toid=62
128.
SELECT count(a.id)
FROM jos_uddeim AS a
WHERE a.totrash=0
AND archived=0
AND a.toid=62
129.
SELECT count(a.id)
FROM jos_uddeim AS a
WHERE a.totrashoutbox=0
AND ((a.systemmessage IS NULL) OR (a.systemmessage=''))
AND a.fromid=62
130.
SELECT count(id)
FROM jos_uddeim
WHERE (totrashdate>=1254427887
AND toid=62
AND totrash=1) OR (totrashdateoutbox>=1254427887
AND fromid=62
AND totrashoutbox=1
AND toid<>62
AND ((systemmessage IS NULL) OR (systemmessage='')))
131.
SELECT *
FROM jos_frsettings
WHERE id = 1
132.
SELECT *
FROM jos_frsettings
WHERE id = 1
133.
SELECT *
FROM jos_frsettings
WHERE id = 1
134.
SELECT count(u.id)
FROM jos_uddeim AS u
WHERE u.totrash=0
AND u.toread=0
AND u.toid=62
135.
SELECT id
FROM jos_menu
WHERE published>=0
AND link LIKE '%com_uddeim%'
136.
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
137.
SELECT *
FROM jos_frsettings
WHERE id = 1

Legacy Queries logged

Language Files Loaded

* /home/ziueon/public_html/language/en-GB/en-GB.ini 1
* /home/ziueon/public_html/language/en-GB/en-GB.tpl_narromine.ini
* /home/ziueon/public_html/language/en-GB/en-GB.mod_stalker.ini 1
* /home/ziueon/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
* /home/ziueon/public_html/language/en-GB/en-GB.mod_uddeim.ini
* /home/ziueon/public_html/language/en-GB/en-GB.mod_uddeim_mailbox.ini
* /home/ziueon/public_html/language/en-GB/en-GB.mod_superfishmenu.ini 1
* /home/ziueon/public_html/language/en-GB/en-GB.mod_search.ini 1
* /home/ziueon/public_html/language/en-GB/en-GB.mod_cblogin.ini
* /home/ziueon/public_html/language/en-GB/en-GB.mod_login.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

Last edit: 16 years 7 months ago by Matias. Reason: Hide output by default

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

Matias
Offline
Administrator

16 years 7 months ago #30277 by Matias

Replied by Matias on topic Re: Categories Counts at 0, no posts, no replies

BTW: did you upgrade from Joomla 1.0 to Joomla 1.5 at the same time? Which version of FB did you have?

Please try if default_ex template works; other default themes haven't been actively updated for a while -- they are deprecated.

Lets start fixing this one problem at time. Can you go to Kunena administration and hit Recount Category Stats? What happens?

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

Jadzia
Topic Author
Offline
New Member

16 years 7 months ago #30294 by Jadzia

Replied by Jadzia on topic Re: Categories Counts at 0, no posts, no replies

I upgraded from Joomla 1.0 - 1.5 years ago, and have just done a clean install of joomla 1.5 and imported the old database back in. It was working fine before then (clean install due to editing issues)
Recounted the categories and also selected default template and still the same issue.

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

sumopunk
Offline
New Member

16 years 7 months ago #30814 by sumopunk

Replied by sumopunk on topic Re: Categories Counts at 0, no posts, no replies

I had a similar issue. I can give the details if needed, but category counts were not working for me because the value of the 'moved' field for all my migrated categories was NULL. Changing that to '0' where applicable allowed the stats to be counted with the recount category stats tool in the control panel.

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

Time to create page: 0.312 seconds