No announcement yet.

The Whole Story and Porblem

  • Filter
  • Time
  • Show
Clear All
new posts

  • The Whole Story and Porblem

    I have started forum last 8 months a go.I remember how difficult it was for me.i hve started this forum wiht the hosting of but after soemtimes when mysql data base reaches his limite of 100mb then i my forum was closed and i was shocked to know that there is limite for mysql database space.

    Then i changed the host today.So i have to do aeverything from beginigng.anyway i was able to up my forum again.After that i have given the backup file(4mb) to my host and said them to resotore but after they restore the .sql file my forum again started to give mysql data base problem.The error is as follow

    Database error in vBulletin 3.6.0:

    Invalid SQL:

    SELECT text, languageid, special
    FROM phrase AS phrase
    LEFT JOIN phrasetype USING (fieldname)
    WHERE phrase.fieldname = 'frontredirect'
    AND varname = 'login' AND languageid IN (-1, 0, 1);

    MySQL Error : Unknown column 'phrase.fieldname' in 'where clause'
    Error Number : 1054
    Date : Monday, August 7th 2006 @ 12:01:18 AM
    Script :
    Referrer :
    IP Address :
    Username : Admin
    Classname : vb_database


    After that i thought that my sql data base is 140mb so how come the back up file is only of 4 mb...but now since they have restored the database i don';t know what to do? Also i have transfered the domain so i m not able to backup again from SSH...........
    But i again made the backup from phpmyadmin this time it is 24mb.still my database is there in the phpmyadmin o fmy first host.Will this backup will me?

    My question are :- How can again get my forum back.?

    The backup file i got from phpmyadmin will help me to get my forum back?

    Guys if i missed then please ask me and give me the possible way to over come this problem.
    My Site Address :-

    Only Serious Members Are Needed

  • #2
    Did you do the backup before you upgraded to vb 3.6 - 'fieldname' was added to the phrase table as part of the 3.5 to 3.6 upgrade process, but your table seems to be missing it.
    Baby, I was born this way


    • #3
      Then what shd i do now?
      My Site Address :-

      Only Serious Members Are Needed


      • #4
        Theres not much I can tell you - the phrase table changes were part of the Beta 1 upgrade script so you may need to run through the whole 3.5 to 3.6 upgrade procedure as there is no way of telling what else may be wrong/missing/broken. I'm not sure what the officially recommend way of doing that is, or if it's even possible. The staff will know better than I do.
        Baby, I was born this way


        • #5
          I'm not sure if this will fix everything by try running this query to add that field:

          ALTER TABLE phrase ADD fieldname varchar(20) NOT NULL DEFAULT '';
          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.


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