Announcement

Collapse
No announcement yet.

mysql error 1020

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

  • #16
    Reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #17
      I'd like to add a Me Too on this one.

      I've been running the forums for a long time (as you'll notice from the version) with not a single problem. However, this past week I've been getting these MySQL errors, at first just a few times a day, but now I'm getting a few an hour.

      Steve, you said Scott was installing the a newer version of MySQL to test, what became of that?
      Ryan "leadZERO" Sommers
      Gamer's Impact President
      [email protected]
      ICQ: 1019590
      AIM/MSN: leadZERO

      -= http://www.gamersimpact.com =-

      Comment


      • #18
        I've changed the file name, images and ran the script you mentioned. (fixoptions.php)

        I receive the following error when running fixoptions.php.
        Code:
         
        Rebuilding options
        Fatal error: Call to undefined function: build_datastore() in /usr/home/rbf/public_html/eq2/includes/adminfunctions.php on line 1836
        Line 1836
        Code:
        build_datastore('options', serialize($vboptions));
        I am still getting the following error;
        Code:
         Database error in vBulletin 3.0.3: 
         
        Invalid SQL: 
         
        SELECT *
         
        FROM eq2_session
         
        WHERE sessionhash = '5fa1d0a2e3c9854bdaec657ec7759957'
         
        AND lastactivity > 1102203232
         
        AND host = '70.57.51.214'
         
        AND idhash = '020e4c15e4545b9eddd0c9006e2d8300'
         
         
         
        mysql error: Record has changed since last read in table 'eq2_session'
         
        mysql error number: 1020
         
        Date: Saturday 04th of December 2004 04:48:52 PM
         
        Script: http://www.lobo.net/~rbf/eq2/
         
        Referer: IP Address: 70.57.51.214
        Can somone please help, the e-mails and board crashes are really getting old.

        Comment


        • #19
          This error is caused by a bug in MySQL 4.1.7 concerning HEAP tables:

          http://www.vbulletin.com/forum/bugs....iew&bugid=3495
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #20
            4.1.8 still has this problem as well. Doesn't look like it will ever get fixed by anybody.

            Comment

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