Announcement

Collapse
No announcement yet.

The Whole Story and Porblem

Collapse
X
 
  • 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 1and1.com 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 : http://www.nutraforum.com/login.php?do=login
    Referrer : http://www.nutraforum.com
    IP Address : 59.92.205.198
    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 :- http://www.NutraForum.com

    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

    Comment


    • #3
      Then what shd i do now?
      My Site Address :- http://www.NutraForum.com

      Only Serious Members Are Needed

      Comment


      • #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 vb.com staff will know better than I do.
        Baby, I was born this way

        Comment


        • #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.


          Comment

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