Announcement

Collapse
No announcement yet.

Errors On New Install and Update

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

  • Errors On New Install and Update

    Hello,

    I moved servers so I had to install the new version of VB on godaddy.com. After that I was able to upload a backup of my old forum onto godaddy and updated my forums from that backup.

    All of my users, threads and posts made it thru. Thing is I have 5 problems with the site now.

    1. New post button doesn't work. This is the error code we get:

    Database error in vBulletin 3.6.2:

    Invalid SQL:
    SELECT searchid FROM search AS search WHERE userid = 2 AND searchhash = 'fddbf430200660d73ef276a9ccab741a' AND orderedids = '4654,4617,4566,4674,4039,4288,4673,4666,4677,4011' AND announceids = '' AND completed = 1;

    MySQL Error : Unknown column 'completed' in 'where clause'
    Error Number : 1054
    Date : Saturday, February 2nd 2008 @ 01:01:53 PM
    Script : http://www.importfanatix.com/Forums/....php?do=getnew
    Referrer : http://www.importfanatix.com/Forums/...ed=1#post47909
    IP Address : 68.39.44.22
    Username : StanBo
    Classname : vB_Database
    2. Edit button doesn't work. There is no error code with this but this is the event step by step:

    Edit screen pops up.

    Allows you to make the edit.

    After saving the screen collapses and you can’t see the new information.

    After a refresh the thread is back to normal as if unedited.
    3. Find all posts by user doesn't work.

    Database error in vBulletin 3.6.2:

    Invalid SQL:

    REPLACE INTO search
    (userid, ipaddress, personal,
    searchuser, forumchoice,
    sortby, sortorder, searchtime,
    showposts, orderedids, dateline,
    displayterms, searchhash, completed)
    VALUES
    (2, '68.39.44.22', 1,
    'StanBo', '',
    'post.dateline', 'DESC', 0.23674,
    1, '47912,47910,47909,47907,47888,47887,47886,47877,47876,47874,47873,47872,47871,47778,47752 ,47750,47748,47745,47735,47734,47733,47732,47731,47730,47714,47712,47711,47710,47709,47708 ,47554,47553,47552,47355,47340,47336,47334,47333,47329,47228,47226,47225,47223,47222,47221 ,47220,47219,47125,46983,46982,46814,46751,46750,46745,46744,46743,46716,46715,46713,46712 ,46711,46516,46476,46475,46474,46461,46460,46459,46451,46450,46449,46447,46446,46445,46440 ,46438,46437,46436,46416,46414,46312,46206,46205,46204,46138,46137,46135,46134,46133,46009 ,45968,45955,45954,45953,45930,45928,45851,45839,45838,45836,45834,45832,45831,45676,45672 ,45671,45669,45668,45667,45666,45665,45664,45663,45568,45562,45561,45547,45546,45544,45540 ,45538,45537,45536,45532,45531,45529,45527,45440,45438,45436,45434,45386,45385,45384,45383 ,45382,45381,45380,45360,45358,45336,45332,45328,45327,45324,45323,45283,45264,45263,45237 ,45236,45235,45234,45233,45232,45231,45206,45205,45201,45200,45197,45195,45152,45151,45150 ,45149,45148,45147,45146,45145,45144,45143,45040,45039,45037,45036,45022,45019,45013,45012 ,45010,45009,45008,44905,44904,44899,44895,44894,44893,44808,44807,44803,44799,44798,44795 ,44794,44784,44783,44782,44778,44777,44775,44773,44770,44769,44768,44767,44764,44747,44743 ,44742,44735,44734,44729,44728,44727,44726,44725,44724,44717,44716,44592,44589,44587,44586 ,44580,44579,44577,44465,44199,44194,44192,44191,44190,44189,44186,44184,44074,44072,44070 ,44069,44068,44067,44066,44065,44063,43949,43947,43886,43883,43881,43880,43878,43877,43876 ,43875,43775,43773,43772,43769,43766,43765,43763,43756,43608,43607,43606,43601,43600,43598 ,43596,43593,43591,43590,43581,43580,43579,43575,43573,43570,43569,43289,43288,43285,43283 ,43189,43188,43185,43183,43182,43177,43176,43175,43174,43173,43172,43171,43169,43168,43167 ,43056,43053,43050,43048,43047,43046,43043,42973,42972,42971,42969,42968,42966,42963,42962 ,42961,42960,42959,42958,42919,42918,42916,42915,42913,42912,42911,42902,42901,42900,42899 ,42898,42793,42792,42791,42790,42789,42787,42758,42747,42732,42731,42718,42712,42711,42710 ,42708,42704,42703,42612,42606,42603,42602,42599,42597,42596,42534,42533,42532,42527,42519 ,42501,42499,42492,42491,42490,42489,42488,42442,42441,42440,42439,42438,42379,42378,42377 ,42304,42303,42289,42277,42276,42275,42274,42273,42206,42205,42204,42153,42128,42126,42105 ,42102,42101,42100,42099,42098,42072,42070,42069,42068,42003,42001,41950,41933,41925,41924 ,41922,41921,41917,41730,41729,41728,41657,41656,41652,41640,41639,41624,41623,41622,41620 ,41618,41562,41561,41560,41558,41557,41518,41510,41500,41499,41495,41494,41493,41490,41476 ,41473,41472,41471,41470,41469,41467,41437,41435,41430,41429,41161,41100,41099,41057,41056 ,41055,41041,40999,40986,40965,40964,40959,40954,40953,40952,40951,40950,40910,40909,40908 ,40907,40850,40845,40844,40843,40842,40841,40840,40839,40838,40836,40835,40834,40592,40587 ,40586,40585,40584,40568,40566,40565,40555,40554,40553,40552,40550,40549,40548,40547,40546 ,40545,40544,40286,40285,40284,40283,40282,40281,40280,40279,40103,40098,40079,40077,40076 ,39942,39912,39902,39901,39900,39899,39898,39897,39896,39895,39744,39741,39740,39739,39738 ,39737,39736,39735,39734,39733,39732,39731,39729,39728,39726,39580,39579,39578,39577,39576 ,39575,39481,39413,39412,39411,39410,39348,39331,39330,39328,39246,39245,39050,38928,38898 ,38894,38857,38855,38705,38703,38664,38466,38465,38464,38436,38433,38431,38423,38422,38420 ,38418,38416,38414,38413,38410,38194,38193,38192,38182,38181,38180,38177,38176,38175,38174 ,38172,37721,37718,37717,37716,37715,37503,37502,37501,37414,37411,37409,37407,37405,37403 ,37402,37401,37400,37397,37394,37393,37391,37285,37284,37283,37281,37280,37195,37178,37175 ,37174,37173,37172,37066,37064,37063,37062,36974,36709,36708,36707,36706,36705,36548,36545 ,36544,36543,36542,36538,36535,36534,36533,36531,36357,36351,36350,36349,36285,36284,36283 ,36282,36281,36280,36279,36276,36275,36140,36137,36134,36122,36121,36109,36107,36106,36105 ,36104,36103,36101,35931,35930,35929,35928,35927,35926,35924,35923,35775,35730,35728,35727 ,35726,35725,35724,35415,35159,35158,35156,35155,35154,35153,34855,34854,34713,34551,34550 ,34507,34506,34505,34504,34429,34424,34300,34299,34298,34278,34227,34226,34225,34224,34197 ,33858,33857,33856,33631,33615,33614,33613,33559,33557,33554,33553,33552,33483,33482,33464 ,33463,33457,33454,33452,33450,33449,33448,33447,33446,33209,33204,32962,32961,32935,32934 ,32933,32932,32931,32930,32889,32887,32886,32885,32869,32868,32867,32866,32840,32838,32837 ,32836,32835,32834,32833,32832,32357,32356,32355,32256,32255,32238,32237,32236,32235,32234 ,32210,32201,32199,32198,32196,32180,32179,32178,32120,32005,32000,31998,31989,31964,31963 ,31928,31901,31900,31899,31898,31897,31875,31874,31870,31865,31864,31863,31861,31860,31781 ,31759,31758,31757,31755,31467,31466,31465,31454,31453,31452,31434,31433,31432,31428,31427 ,31425,31303,31151,31147,31144,31143,31142,31141,31140,30914,30913,30912,30911,30775,30774 ,30773,30772,30771,30770,30769,30768,30767,30766,30459,30458,30457,30455,30449,30447,30446 ,30249,30111,30109,29893,29892,29891,29890,29844,29724,29715,29714,29558,29557,29556,29555 ,29554,29414,29411,29409,29408,29376,29374,29373,29284,29282,29281,29278,29199,29051,28991 ,28990,28989,28988,28934,28933,28932,28931,28930,28247,28246,28237,28236,28235,28234,28155 ,28154,28151,28149,28007,28006,28005,28004,27934,27932,27931,27929,27689,27603,27602,27577 ,27576,27574,27573,26929,26928,26926,26769,26522,26394,26389,26382,26378,26375,26372,26371 ,26370,26369,26368,26367,26191,26190,26189,26188,26187,26186,26185,25910,25907,25771,25770 ,25767,25605,25459,25440,25438,25437,25436,25435,25007,25006,24952,24951,24950,24949,24931 ,24930,24925,24915,24914,24912,24911,24909,24906,24905,24904,24903,24497,24495,24494,24492 ,24491,24465,24464,24462,24459,24457,24456,24454,24453,24409,24406,24403,24402,24401,24400 ,24399,24398,24397,24172,24171,24170,24169,24168,24139,24124,24108,24105,24104,24087,24085 ,23967,23859,23858,23857,23856,23855,23854,23853,23504,23434', 1201982671,
    'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{ i:2;s:6:\"StanBo\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11: \"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', '732d9b5a390b299ba5e37b835318e20a', 1);

    MySQL Error : Unknown column 'completed' in 'field list'
    Error Number : 1054
    Date : Saturday, February 2nd 2008 @ 01:04:32 PM
    Script : http://www.importfanatix.com/Forums/...o=finduser&u=2
    Referrer :
    IP Address : 68.39.44.22
    Username : StanBo
    Classname : vB_Database


    4. View public Profile doesn't work.

    Database error in vBulletin 3.6.2:

    Invalid SQL:

    SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
    FROM profilefield AS pf
    LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
    WHERE pf.form = 0
    ORDER BY pfc.displayorder, pf.displayorder;

    MySQL Error : Unknown column 'pf.profilefieldcategoryid' in 'field list'
    Error Number : 1054
    Date : Saturday, February 2nd 2008 @ 01:05:15 PM
    Script : http://www.importfanatix.com/Forums/member.php?u=6
    Referrer :
    IP Address : 68.39.44.22
    Username : StanBo
    Classname : vB_Database
    5. Trying to run a search doesn't work.

    Database error in vBulletin 3.6.2:

    Invalid SQL:

    SELECT * FROM search AS search
    WHERE searchhash = 'f455df7c7bbb0138b9a056a740e77da9'
    AND userid = 2
    AND completed = 1;

    MySQL Error : Unknown column 'completed' in 'where clause'
    Error Number : 1054
    Date : Saturday, February 2nd 2008 @ 01:09:02 PM
    Script : http://www.importfanatix.com/Forums/...php?do=process
    Referrer : http://www.importfanatix.com/Forums/...7620#post47620
    IP Address : 68.39.44.22
    Username : StanBo
    Classname : vB_Database

    Sorry for the laundry list of errors. I have to say I am happy to have a site with errors then to loose all of our information like we did years ago when our server failed.

    Any help would be appreciated. I was almost burned at the stake last night at our bi-weekly meet.

    Thanks,

    Stanley


  • #2
    Why aren't you installing 3.6.8? 3.6.2 is not secure.

    First, run this query to add the completed field:

    ALTER TABLE search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1';

    Then To troubleshoot this, first 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. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all plugins.

    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);

    Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    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


    • #3
      Thanks I will reupdate everything and run the diagnostics.

      The site has zero mods as of now. We even have the vb logo in the upper left hand corner lol.

      We just wanted to save our content before I started working on anything.

      Comment


      • #4
        Originally posted by Steve Machol View Post
        First, run this query to add the completed field:

        ALTER TABLE search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1';
        I am lost with this piece of advice. Where am I supposed to add this line?


        Originally posted by Steve Machol View Post
        Then To troubleshoot this, first 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. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

        Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

        [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

        Next, disable all plugins.

        Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

        define('DISABLE_HOOKS', true);

        Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
        I have this down pat.

        Comment


        • #5
          You can run queries in the SQL tab in phpMyAdmin, or to run queries from the Admin CP:

          Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

          Then enter your query in the Manual Query box and click on 'Continue'.
          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


          • #6
            Thank you. I had an idea it might be a MYSQL command but I am very green with this side of the site. Juggle juggle juggle:

            Comment


            • #7
              Originally posted by Steve Machol View Post
              Why aren't you installing 3.6.8? 3.6.2 is not secure.
              Here is another problem. I am running 3.6.8 Patch Level 2. I am not running 3.6.2. I know my error messages show so but that is the version we were running on the old site.

              Could this be another problem?

              Comment


              • #8
                Did you run the upgrade.php script after you put the new php files up on the site?

                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 &lt;- awesome site for html/css help

                Comment


                • #9
                  Originally posted by U2Lynne View Post
                  Did you run the upgrade.php script after you put the new php files up on the site?
                  If I remember correctly yes. I remember the site going thru all of the items and checking them.

                  As of now I have ran that msql command and the search is working.

                  Viewing my public profiles is still messed up. It is all moving along.

                  Comment


                  • #10
                    Ran the command.
                    Rewrote the files.
                    Ran the upgrade.

                    Looks like all of the bugs are gone.



                    Thanks for all of the advice fellas. It is well appreciated. Now I can go back to keeping the natives happy.

                    Comment

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