No announcement yet.

30 instances of a query

  • Filter
  • Time
  • Show
Clear All
new posts

  • 30 instances of a query

    My site has been going down periodically. i enabled the debug mug to see how many queries were being ran. with ALL my mods off but my query number is 48 on the forum home and around the same number when i login to my admincp.

    the following query showed up 30 times on the explain page:

    SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
    customavatar.width, customavatar.height
    FROM tluser AS user
    LEFT JOIN tlavatar AS avatar ON avatar.avatarid = user.avatarid
    LEFT JOIN tlcustomavatar AS customavatar ON customavatar.userid = user.userid
    WHERE user.userid = 1
    any idea what this is?

  • #2

    Thank you for contacting vBulletin Support.

    On a default vBulletin installation the forumhome (index.php) runs between 7 and 13 queries, not 48. Despite the hook system being turned off, something is still adding queries. To my knowledge, the avatar isn't being called on the forumhome. But I could be mistaken. Go to the Admin Control Panel > vBulletin Options > vBulletin Options > Hook System > And turn it off, instead of disabling the plugins. Perhaps this helps.

    I suspect this is caused by a plugin, and not vBulletin. Good luck resolving the issue. I hope your forum soon runs smooth again.

    If you require any further assistance please don't hesitate to ask.

    All the best,