Stenis

+Clients
  • Content count

    998
  • Joined

  • Last visited


About Stenis

  • Rank
    Spam Happy

Recent Profile Visitors


11,801 profile views

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 record in IPS Extras   

    Error: Unknown column 'session_has_archive'
    Just uploaded the 1.6 version but that keeps "crashing" when I go to the index.php page,
     
    Error: Unknown column 'session_has_archive' in 'field list' File: /system/Db/Db.php Line: 285
     
    I have used almost all previously relesased versions without errors.
    • 0 replies
    • 0 views
  6. Stenis added a record in IPS Extras   

    Parse error: syntax error, unexpected T_STRING
    When running the web converter I get this error:
     
    [b]Warning[/b]: Unexpected character in input: '\' (ASCII=92) state=1 in [b]/home/X/public_html/forum/utf8convert/index.php[/b] on line [b]22[/b]

    [b]Warning[/b]: Unexpected character in input: '\' (ASCII=92) state=1 in [b]/home/X/public_html/forum/utf8convert/index.php[/b] on line [b]22[/b]

    [b]Parse error[/b]: syntax error, unexpected T_STRING in [b]/home/X/public_html/forum/utf8convert/index.php[/b] on line [b]22[/b]
    • 0 replies
    • 0 views
  7. Stenis added a post in a topic: Related articles   

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

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

    Great, thanks!
  10. 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?
  11. Stenis added a post in a topic: "Best answer" tag displayed in VNC and Recent Topics hook   

    Ok, very nice. Thanks!
  12. 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.
  13. 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/
  14. 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/
  15. 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.