Announcement

Collapse
No announcement yet.

backup fails through vb CP and errors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • backup fails through vb CP and errors

    Hello,

    I have been having a very strange problem and my host has tried to do all the fixes I

    asked of him but no use.

    I can't seem to do a backup through Vb's CP.

    At first the backup would stop at "postedithistory" and give me this message:

    Database error in vBulletin 3.8.6:

    Invalid SQL:
    SHOW CREATE TABLE postedithistory;

    MySQL Error : MySQL server has gone away
    Error Number : 2006

    ======================
    Then, I started getting :

    Invalid SQL:

    SELECT *
    FROM session
    WHERE sessionhash = 'e8368a466232e845e950a1286752e20d'
    AND lastactivity > 1304368904
    AND idhash = '70c127987820e64679bdb9e41252ecda';

    MySQL Error : MySQL server has gone away
    Error Number : 2006

    =======================

    and then this strange one of an email which I don't have:

    Invalid SQL:

    SELECT userid, username, email
    FROM user
    WHERE email = '[email protected]';

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    ========================

    another one:

    Invalid SQL:

    UPDATE session
    SET lastactivity = 1304583431, inforum = 0, inthread = 0, incalendar = 0, badlocation =

    0, useragent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/4.0;

    GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729;

    Media Center PC 6.0; Tablet PC 2.0; .NET4.0C; .NET4.0E; AskTbMYC-

    ST/5.11.1.15497)'
    WHERE sessionhash = 'dc2f783a88a052d3db1f18afb681f606';

    ========================
    Invalid SQL:

    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity, session.badlocation,
    IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid,

    infractiongroupid

    FROM session AS session
    LEFT JOIN user AS user ON(user.userid = session.userid)

    WHERE session.lastactivity > 1304623649;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    =========================
    Invalid SQL:

    SELECT *
    FROM bbcode;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    =========================

    I have disabled all plugins but still can't backup. I have asked my host to increase the

    mySQL wait time from 30 to 60 but still nothing changes.

    Last I tried it now stops at " templatehistory " and stops loading the page.
    I need some help please. I feel I have over worked my host for nothing and probably

    the problem lies in my forum not at their end.


    I am running 3.6.8

    Config:


    Server Type Linux
    Web Server Apache (cgi)
    PHP 5.2.14
    PHP Memory Limit 64.00 MB
    MySQL Version 5.0.92-community
    MySQL Packet Size 32.00


  • #2
    server has gone away -- says it all.. move host

    Comment


    • #3
      Gotta be another solution. Just renewed my account with them for another year and there is no refund plus they have been very helpful from the beginning. Thanks for trying to help.


      Support just said it's a server issue so please close the thread if you like. Thank.
      Last edited by haythamghareeb; Fri 6 May '11, 12:47am.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X