Stenis

+Clients
  • Content count

    284
  • Joined

  • Last visited


Stenis's Activity

  1. Stenis added a post in a topic: Slow SQL query   

    I opened a support ticket and yes, this SQL Query should be gone. Could it be that I have these Three tags extensions installed?
     
    "Also Tagged With" by Marcher Technologies
    http://community.invisionpower.com/files/file/5775-also-tagged-with-extension/
     
    ANSWERED Tag on Search Results by Adriano Faria
    http://community.invisionpower.com/files/file/6007-answered-tag-on-search-results/
     
    ANSWERED Tag on Board Index Recent Topics by Adriano Faria
    http://community.invisionpower.com/files/file/6008-answered-tag-on-board-index-recent-topics/
  2. Stenis added a post in a topic: Slow SQL query   

    I have no idea if it is DB server cache optimized unfortunately, is there an easy way to check it?
  3. Stenis added a post in a topic: Slow SQL query   

    I experience that my IPS driven site is very slow and each page takes seconds to load. I have a managed server and contacted the support and they say no load on the server but they did see one SQL query that took ~10 seconds. This is one of them, any idea on how to improve performance? Is it a bug?
     
     
    | 541038 | db_ipb | localhost | db_ipbutf8 | Query | 5 | Copying to tmp table | SELECT t.*,xxx.* FROM ibf_topics t LEFT JOIN ibf_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.forum_id=72 AND t.pinned IN (0,1) AND ( t.approved=1 ) ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,30  
     
  4. Stenis added a comment on a blog entry: Get Ready For IPS 4.0!   

    So all my tables are utf8_general_ci and need to be modified using the UTF8 converter script to utf8_unicode_ci. Two questions:
     
    1. How lonq will i typically take to change collation on all tables?
    2. Will it create new tables or will it just modify the existing tables?
  5. Stenis added a post in a topic: Related articles   

    Great, thanks. Got it implemented right now and it does the job :)
  6. Stenis added a post in a topic: Related articles   

     
    Aha, where can I find it?
  7. Stenis added a post in a topic: Reduce space in Category menu?   

    Great, thanks!
  8. Stenis added a post in a topic: Reduce space in Category menu?   

    How can I reduce the space between each line in the default Category menu shown to the right in a default IP.Content 2.3.x installation?
  9. Stenis added a post in a topic: "Best answer" tag displayed in VNC and Recent Topics hook   

    Ok, very nice. Thanks!
  10. Stenis added a post in a topic: "Best answer" tag displayed in VNC and Recent Topics hook   

    To make it clear for users there should be a "Solved" tag/indication in the View New Content for the topics that have a "best answer" as well as in the Recent Topics hook in the sidebar, or preferably ACP options for activating this.
  11. Stenis added a post in a topic: Enter not working in IE 10   

    You can fix it for 3.x as well until 3.4.0 is out, http://community.invisionpower.com/topic/367648-fix-for-ie10-compatibility-issues/
  12. Stenis added a post in a topic: Some IE Errors here at IPB   

    Here is the solution to IE10 problems: http://community.invisionpower.com/topic/367648-fix-for-ie10-compatibility-issues/
  13. Stenis added a post in a topic: Possibilty to move, delete, merge sections that Contains Archived Topics   

    Cannot agree more. I hit this issue today. Un-archiving hundreds of topics manually is not an option, as is un-archiving all topics then move the topics only to enable archiving once again when the move is done. I cannot delete a forum section either without un-archiving all. 3.4.0 must contain a remedy for this.
  14. Stenis added a post in a topic: Fix for IE10 compatibility issues   

    Sort of, it is finished (RTM) and has been released through some channels such as MSDN, TechNet and for businesses with license agreements with Microsoft. So it is out there now, but the official launch when you can purchase Windows 8 and hardware with Windows 8 is set for October 26th.
  15. Stenis added a post in a topic: Fix for IE10 compatibility issues   

    So now that Windows 8 has been released with IE10 there is one major bug in the editor of IP.Board which basically makes the [Enter] key not working meaning you cannot get any line breaks in posts, PMs etc.

    You can make it work in IE10 by pressing F12 and setting the Browser mode to IE9 and Documents Moder to IE9 Standards. For a more permanent and general solution you must edit the templates, go to globalTemplate and look for the row:



    ...and you have a fix until IPS fixes this problem in their code.
    <meta http-equiv="X-UA-Compatible" content="IE=Edge" />[/CODE] change this to... [CODE]<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE9" />