Announcement

Collapse
No announcement yet.

A database problem 3.7.xxx upgrade...

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

  • A database problem 3.7.xxx upgrade...

    Just applied the upgrade yesterday, but it might have been after the time stamp on the below emails. 14+ database error emails this morning, all time stamped as sent at 1:31 AM.

    Any ideas on what I missed, whether I need to do something or even whether they'll continue?

    Doug



    Database error in vBulletin 3.6.8:

    Invalid SQL:

    SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid

    FROM forum AS forum;

    MySQL Error : Unknown column 'lastprefixid' in 'field list'
    Error Number : 1054
    Request Date : Friday, October 3rd 2008 @ 12:17:35 PM
    Error Date : Friday, October 3rd 2008 @ 12:17:35 PM
    Script : http://www.madisonrcboats.org/forum/index.php
    Referrer :
    IP Address : 85.12.24.171
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

  • #2
    Did you run the install/upgrade.php script successfully with no errors?

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      Yes. I ran the update script.

      Comment


      • #4
        No you didn't, or at least you didn't upload all the 3.7.3 files and run the upgrade process to the end.

        You need to upload all the 3.7.3 files and run 'install/upgrade.php'. You need to make sure that version 3.7.3 is showing in the upper right hand corner of the page. If it's not, then you have not uploaded all the vB 3.7.3 files.
        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


        • #5
          OK, I have gotten this error:
          =========================
          Database error in vBulletin 3.7.3:

          Invalid SQL:

          SELECT COUNT(*) AS count
          FROM vb_moderation AS moderation
          INNER JOIN vb_post AS post ON (post.postid = moderation.primaryid)
          WHERE moderation.type = 'reply';

          MySQL Error : Unknown column 'moderation.primaryid' in 'on clause'
          Error Number : 1054
          Request Date : Tuesday, October 21st 2008 @ 09:54:17 PM
          Error Date : Tuesday, October 21st 2008 @ 09:54:17 PM
          Script : http://www.meadwench.com/forum/cpown...ex.php?do=home
          Referrer : http://www.meadwench.com/forum/cpowner/index.php
          IP Address : 71.0.16.144
          Username : webmaster
          Classname : vB_Database
          MySQL Version : 5.0.51a-community
          ============================================

          Here is what I have done:
          1. Verified and re-verified that I have uploaded all VB files from the 'upload' directory of a fresh download of 3.7.3 Patch Level 1 from vbulletin.com. Despite this, both my main directory and my cpadds (modcp) directory show outdated files, the main directory showing 3.7.1 and modcp showing 3.6.8. I've re-uploaded these files from the unzipped production package several times, and no change.

          2. Run upgrade.php, verifying that it shows 3.7.3 in the upper right hand corner. All steps ran fine, no errors.

          3. Disabled all add-ons.

          4. Double-checked my config.php to ensure that the admincp and modcp names were correct (they are).

          5. Cleared cookies & closed browser.

          I reopened the browser, and still showing the error.

          Thanks for any insights,

          Vicky Rowe
          Gotmead.com

          Comment


          • #6
            That error means you missed one or more upgrade steps. Please look at the moderation table in the database and tell me what fields it has.
            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


            • #7
              It has threadid, postid, type and dateline. There are no records in the table.

              I followed the upgrade steps:

              1. shut down my forum
              2. Uploaded the files except for install.php
              3. ran upgrade.php and made sure all the steps showed 'ok' before going to the next one.


              Vicky Rowe
              Gotmead.com

              Comment


              • #8
                Fill out a support ticket at:

                http://members.vbulletin.com/members...ontactform.php

                Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.
                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

                Related Topics

                Collapse

                Working...
                X