Jump to content

  •  

  • Makaaveli's Photo

    Makaaveli

    Member Since 10 Nov 2006
    Offline Last Active May 13 2012 09:55 PM
    -----

    Topics I've Started

    changing URL in all posts

    07 April 2012 - 02:46 PM

    This is a bit annoying, because I made this topic in the past, got my answer and now when I search it, it won't list it because it can only go as far back as "April 11"...

    Anyways, I think this is the query (note: I got this from a 2.3.x tutorial...) -

    UPDATE ibf_posts SET post=REPLACE(post, 'old url', 'new url')
    

    Would this be right? (Changing clanblasphemy.com with clanblasphemy.tk).

    UPDATE ibf_posts SET post=REPLACE(post, 'clanblasphemy.com', 'clanblasphemy.tk')
    

    Major problem connecting to SQL..

    22 February 2012 - 06:03 PM

    I'm having issues with connecting to my forums, I think it has something to do with SQL. .

    This is the error I get -

    Warning: mysqli_query() [function.mysqli-query]: (HY000/2013): Lost connection to MySQL server during query in /var/www/vhosts/**/board/ips_kernel/classDbMysqliClient.php on line 256


    I asked my host and they replied..

    Quote

    Hi, no problem, the DB server looks perfect, cache / querys all check out.

    Is this a specific query which is trying to run? Are others ok?

    And this is the sql error logs showing -

    Quote

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Wed, 22 Feb 2012 10:52:57 +0000
    Error: 2013 - Lost connection to MySQL server during query
    IP Address: 220.181.125.70 - /board/
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT f.*,p.* FROM ibf_forums f  LEFT JOIN ibf_permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )  
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File    | Function   | Line No.   |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin/applications/forums/sources/classes/forums/class_forums.php   | [class_forums].getForumList    | 144    |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin/applications/forums/app_class_forums.php | [class_forums].forumsInit | 124    |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin/sources/base/ipsRegistry.php | [app_class_forums].__construct     | 1311   |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

    Does anyone know what the problems can be?

    Weirdist thing...

    16 October 2011 - 12:06 AM

    2 topics pinned by the same author.

    I can only edit 1 of them, the other I get this error page -

    Quote

    Forbidden
    You do not have permission to access this document.

    Any wild guesses?