Database error after Upgrade

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • G_Man
    New Member
    • Jan 2006
    • 7
    #1

    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
    Tags: None
    • Colin F
      Senior Member
      • May 2004
      • 17689
      #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

        • kennethj
          Senior Member
          • Apr 2001
          • 116
          • 3.6.x
          #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

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488
              #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

                • G_Man
                  New Member
                  • Jan 2006
                  • 7
                  #5
                  Originally posted by Steve Machol
                  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

                    • Steve Machol
                      Former Customer Support Manager
                      • Jul 2000
                      • 154488
                      #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

                        • G_Man
                          New Member
                          • Jan 2006
                          • 7
                          #7
                          Originally posted by Steve Machol
                          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

                            • Steve Machol
                              Former Customer Support Manager
                              • Jul 2000
                              • 154488
                              #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

                                • G_Man
                                  New Member
                                  • Jan 2006
                                  • 7
                                  #9
                                  Originally posted by Steve Machol
                                  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

                                    • Steve Machol
                                      Former Customer Support Manager
                                      • Jul 2000
                                      • 154488
                                      #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

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