Announcement

Collapse
No announcement yet.

Database error after Upgrade

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

  • Database error after Upgrade

    Seems I am missing something...

    I have disabled ALL plugins etc and tried again. When I do the vbplaza parts of the error message disapper, but the rest remains, so...

    Is there someway to FIX this in the database.

    I only get this error when editing/saving in the Forum area of my AdminCP.


    Code:
    Database error in vBulletin 3.6.0:
    
    Invalid SQL:
    UPDATE forum SET
        title_clean = 'Sports',
        title = 'Sports',
        description_clean = '',
        description = '',
        link = '',
        displayorder = 42,
        parentid = 58,
        daysprune = -1,
        defaultsortfield = 'title',
        defaultsortorder = 'asc',
        showprivate = 0,
        newpostemail = '',
        newthreademail = '',
        ### Bitfield: forum.options ###
            options = IF(options & 8, options - 8, options),
            options = IF(options & 16, options - 16, options),
            options = IF(options & 32, options - 32, options),
            options = IF(options & 32768, options - 32768, options),
            options = IF(options & 8192, options - 8192, options),
            options = IF(options & 4, options, options + 4),
            options = IF(options & 1, options, options + 1),
            options = IF(options & 2, options, options + 2),
            options = IF(options & 16384, options, options + 16384),
            options = IF(options & 256, options - 256, options),
            options = IF(options & 64, options, options + 64),
            options = IF(options & 128, options, options + 128),
            options = IF(options & 512, options, options + 512),
            options = IF(options & 1024, options, options + 1024),
            options = IF(options & 2048, options, options + 2048),
            options = IF(options & 4096, options, options + 4096),
            options = IF(options & 65536, options, options + 65536),
        styleid = 0,
        password = '',
        vbbux_perview = 0.01,
        vbbux_perthread = 1,
        vbbux_perreply = 0.02,
        ### Bitfield: forum.vbpforumoptions ###
            vbpforumoptions = IF(vbpforumoptions & 16, vbpforumoptions - 16, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 32, vbpforumoptions - 32, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 64, vbpforumoptions - 64, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 128, vbpforumoptions - 128, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 256, vbpforumoptions - 256, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 512, vbpforumoptions - 512, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 1024, vbpforumoptions - 1024, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 2048, vbpforumoptions - 2048, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 4096, vbpforumoptions - 4096, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 8192, vbpforumoptions - 8192, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 16384, vbpforumoptions - 16384, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 32768, vbpforumoptions - 32768, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 65536, vbpforumoptions - 65536, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 1, vbpforumoptions - 1, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 2, vbpforumoptions - 2, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 4, vbpforumoptions - 4, vbpforumoptions),
            vbpforumoptions = IF(vbpforumoptions & 8, vbpforumoptions - 8, vbpforumoptions),
        vbp_cangetaccesscost = 0,
        vbp_cangiveaccesscost = 0,
        vbp_candenyaccesscost = 0,
        vbp_cangetpasswordcost = 0
    WHERE forumid = 59;
    
    MySQL Error  : Unknown column 'defaultsortfield' in 'field list'
    Error Number : 1054
    Date         : Thursday, August 17th 2006 @ 09:26:06 AM
    Script       : http://www.afterseppuku.com/theforum/admincp/forum.php?do=update
    Referrer     : http://www.afterseppuku.com/theforum/admincp/forum.php?do=edit&f=59
    IP Address   : 67.185.88.39
    Username     : G_Man
    Classname    : vb_database

    Thanks in advance for you help,

    Wade

  • #2
    Try disabling Plugins globally in the vBulletin Options.

    Part of that query is still from plugins.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      More info . tryed it .

      worked with G on this a little :

      even with the plug ins disabled gives and error message :
      Code:
      Database error in vBulletin 3.6.0:
      
      Invalid SQL:
      UPDATE forum SET
      	title_clean = 'Santai',
      	title = 'Santai',
      	description_clean = 'Messages for Santai',
      	description = 'Messages for Santai',
      	link = '',
      	displayorder = 8,
      	parentid = 23,
      	daysprune = -1,
      	defaultsortfield = 'title',
      	defaultsortorder = 'asc',
      	showprivate = 0,
      	newpostemail = '',
      	newthreademail = '',
      	### Bitfield: forum.options ###
      		options = IF(options & 8, options - 8, options),
      		options = IF(options & 16, options - 16, options),
      		options = IF(options & 32, options - 32, options),
      		options = IF(options & 32768, options - 32768, options),
      		options = IF(options & 8192, options, options + 8192),
      		options = IF(options & 4, options, options + 4),
      		options = IF(options & 1, options, options + 1),
      		options = IF(options & 2, options, options + 2),
      		options = IF(options & 16384, options, options + 16384),
      		options = IF(options & 256, options - 256, options),
      		options = IF(options & 64, options, options + 64),
      		options = IF(options & 128, options, options + 128),
      		options = IF(options & 512, options, options + 512),
      		options = IF(options & 1024, options, options + 1024),
      		options = IF(options & 2048, options, options + 2048),
      		options = IF(options & 4096, options, options + 4096),
      		options = IF(options & 65536, options, options + 65536),
      	styleid = 0,
      	password = ''
      WHERE forumid = 66;
      
      MySQL Error  : Unknown column 'defaultsortfield' in 'field list'
      Error Number : 1054
      Date         : Thursday, August 17th 2006 @ 04:05:08 AM
      Script       : http://www.afterseppuku.com/theforum/admincp/forum.php?do=update
      Referrer     : http://www.afterseppuku.com/theforum/admincp/forum.php?do=edit&f=66&s=
      IP Address   : 
      Username     : Santai
      Classname    : vb_database
      looked at the tables in his data base : dark red are added by the mod - after the upgrade - :
      forumid styleid title title_clean description description_clean options displayorder replycount lastpost lastposter lastthread lastthreadid lasticonid threadcount daysprune newpostemail newthreademail parentid parentlist password link childlist lastpostid vbbux_perview vbbux_perthread vbbux_perreply vbpforumoptions vbp_cangetaccesscost vbp_cangiveaccesscost vbp_candenyaccesscost vbp_cangetpasswordcost
      compared them to what i have :
      forumid styleid title title_clean description description_clean options showprivate displayorder replycount lastpost lastposter lastpostid lastthread lastthreadid lasticonid threadcount daysprune newpostemail newthreademail parentid parentlist password link childlist showdefault defaultsortfield defaultsortorder
      looks to me as if during the upGrade a step was missed? - or didnt' complete itself and went to the next one - (with / with out any help )

      dont know enough about adding and setting up the missing fields and there configuration to "add them" .

      thanks again .
      .. . / GFXstyles certain amount of common sense is necessary to survive in this world !
      insanity leaves you no restrictions

      Comment


      • #4
        Run this query to add that column:

        ALTER TABLE forum ADD defaultsortfield VARCHAR(50) NOT NULL DEFAULT 'lastpost';

        If you also get an error about the defaultsortorder, run this query:

        ALTER TABLE forum defaultsortorder ENUM('asc', 'desc') NOT NULL DEFAULT 'desc';
        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
          Originally posted by Steve Machol View Post
          Run this query to add that column:

          ALTER TABLE forum ADD defaultsortfield VARCHAR(50) NOT NULL DEFAULT 'lastpost';

          If you also get an error about the defaultsortorder, run this query:

          ALTER TABLE forum defaultsortorder ENUM('asc', 'desc') NOT NULL DEFAULT 'desc';

          First Query seemed to run fine... still got error, so ran second Query and got this while running Query:

          An error occurred while attempting to execute your query. The following information was returned.
          error number: 1064
          error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'defaultsortorder ENUM('asc', 'desc') NOT NULL DEFAULT 'desc'' at line 1

          Comment


          • #6
            Oops, it should be:

            ALTER TABLE forum ADD defaultsortorder ENUM('asc', 'desc') NOT NULL DEFAULT 'desc';
            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
              Originally posted by Steve Machol View Post
              Oops, it should be:

              ALTER TABLE forum ADD defaultsortorder ENUM('asc', 'desc') NOT NULL DEFAULT 'desc';
              haha... I saw that, but I thought, "what do I know!!"

              okay, new error, but....

              Code:
              Database error in vBulletin 3.6.0:
              
              Invalid SQL:
              UPDATE forum SET
                  title_clean = 'Sports',
                  title = 'Sports',
                  description_clean = '',
                  description = '',
                  link = '',
                  displayorder = 42,
                  parentid = 58,
                  daysprune = -1,
                  defaultsortfield = 'lastpost',
                  defaultsortorder = 'desc',
                  showprivate = 0,
                  newpostemail = '',
                  newthreademail = '',
                  ### Bitfield: forum.options ###
                      options = IF(options & 8, options - 8, options),
                      options = IF(options & 16, options - 16, options),
                      options = IF(options & 32, options - 32, options),
                      options = IF(options & 32768, options - 32768, options),
                      options = IF(options & 8192, options - 8192, options),
                      options = IF(options & 4, options, options + 4),
                      options = IF(options & 1, options, options + 1),
                      options = IF(options & 2, options, options + 2),
                      options = IF(options & 16384, options, options + 16384),
                      options = IF(options & 256, options - 256, options),
                      options = IF(options & 64, options, options + 64),
                      options = IF(options & 128, options, options + 128),
                      options = IF(options & 512, options, options + 512),
                      options = IF(options & 1024, options, options + 1024),
                      options = IF(options & 2048, options, options + 2048),
                      options = IF(options & 4096, options, options + 4096),
                      options = IF(options & 65536, options, options + 65536),
                  styleid = 0,
                  password = '',
                  vbbux_perview = 0.01,
                  vbbux_perthread = 1,
                  vbbux_perreply = 0.02,
                  ### Bitfield: forum.vbpforumoptions ###
                      vbpforumoptions = IF(vbpforumoptions & 16, vbpforumoptions - 16, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 32, vbpforumoptions - 32, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 64, vbpforumoptions - 64, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 128, vbpforumoptions - 128, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 256, vbpforumoptions - 256, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 512, vbpforumoptions - 512, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 1024, vbpforumoptions - 1024, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 2048, vbpforumoptions - 2048, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 4096, vbpforumoptions - 4096, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 8192, vbpforumoptions - 8192, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 16384, vbpforumoptions - 16384, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 32768, vbpforumoptions - 32768, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 65536, vbpforumoptions - 65536, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 1, vbpforumoptions - 1, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 2, vbpforumoptions - 2, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 4, vbpforumoptions - 4, vbpforumoptions),
                      vbpforumoptions = IF(vbpforumoptions & 8, vbpforumoptions - 8, vbpforumoptions),
                  vbp_cangetaccesscost = 0,
                  vbp_cangiveaccesscost = 0,
                  vbp_candenyaccesscost = 0,
                  vbp_cangetpasswordcost = 0
              WHERE forumid = 59;
              
              MySQL Error  : Unknown column 'showprivate' in 'field list'
              Error Number : 1054
              Date         : Thursday, August 17th 2006 @ 04:27:51 PM
              Script       : http://www.afterseppuku.com/theforum/admincp/forum.php?do=update
              Referrer     : http://www.afterseppuku.com/theforum/admincp/forum.php?do=edit&f=59
              IP Address   : 66.225.4.186
              Username     : G_Man
              Classname    : vb_database

              I see a pattern...


              That looks like the last one I am missing though...
              Last edited by G_Man; Thu 17 Aug '06, 12:38pm.

              Comment


              • #8
                Run this query:

                ALTER TABLE forum ADD showprivate TINYINT UNSIGNED NOT NULL DEFAULT '0';
                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


                • #9
                  Originally posted by Steve Machol View Post
                  Run this query:

                  ALTER TABLE forum ADD showprivate TINYINT UNSIGNED NOT NULL DEFAULT '0';



                  THANK YOU VERY MUCH.

                  Saved the Forum just fine - I'm on lunchbreak so will check it out more thoroughly later. I really appreciate your help and patience.

                  Cheers,
                  Wade

                  Comment


                  • #10
                    Glad to help.
                    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

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