New server and 1054 error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Hawkmoth
    Member
    • May 2012
    • 34
    • 4.1.x

    [Forum] New server and 1054 error

    Hello. Sorry to be such a noob.

    We upgraded in May to 4.1.7 and then in June to 4.2. Everything seemed to be working fine but a server move was needed. Because of many problems with our previous server we have moved to a new server this weekend. DB was back up from old server and loaded to new server with ftp. Domain was redirected. I have admin panel operations but no main page.

    The new host tells me there is an error this morning, Japan time
    MySQL Error : Unknown column 'phrasegroup_adv_portal' in 'field list'
    Error Number : 1054
    They suggest as follow:
    So it looks like there is an
    issue with the database itself and not the login credentials....
    If this is a new install, I recommend reinstalling the software and see
    if it resolves the issue for you. If you have any other questions or
    concerns, please do not hesitate to contact us.
    I think they suggest i just reinstall from my software file to the new server. Is this good suggestion? But I am concerned about losing information from the DB.

    I read some other posts about 1054 error. Maybe this error is because of a problem with a plugin? I don't know how to proceed.

    - - - Updated - - -

    At 5.55 am local time maybe my brain is not on yet.

    I received a pm from one of our members on another site:
    I can see the site now but there are no members showing only some new spammers who have joined.
    I don't understand because I cannot see anything, only database error messages.

    I need tea......
    http://www.antifraudintl.org
  • kh99
    Senior Member
    • Aug 2009
    • 533

    #2
    That error has to do with vBAdvanced. Did you by any chance install that recently? It looks like a column expected by vba doesn't exist in your database, for some reason.

    Comment

    • Hawkmoth
      Member
      • May 2012
      • 34
      • 4.1.x

      #3
      Thank you klh. Yes, we do use vBAdvanced to create a portal page for our website and we did reinstall that recently.
      http://www.antifraudintl.org

      Comment

      • Dustin L.
        Senior Member
        • Mar 2011
        • 639
        • 4.2.X

        #4
        You might be able to get support for the issue here: http://www.vbadvanced.com/forum/index.php



        Dustin
        http://quikmsg.net/strtoupper/ - Convert lowercase text and code to all uppercase!
        http://quikmsg.net/strtolower/ - Convert uppercase text and code to all lowercase!

        Comment

        • Hawkmoth
          Member
          • May 2012
          • 34
          • 4.1.x

          #5
          Thank you Dustin. I'm not sure what the problem is. At http://antifraudintl.org/forum.php there is space for content and the spammers have found us since yesterday but I can't find the DB. I am going to try and reimport it.

          Also I have noticed that for some reason the config.php is corrupted or something. We don't use titles like "junior member" and I can't edit profiles of spammers and remove spam links because it says they are protected users. They are not ever protected users.
          http://www.antifraudintl.org

          Comment

          • Dustin L.
            Senior Member
            • Mar 2011
            • 639
            • 4.2.X

            #6
            You can download the vB ZIP package from the Members' Area and use the default config provided. Of course, you'll have to edit it to your appropriate settings.



            Dustin
            http://quikmsg.net/strtoupper/ - Convert lowercase text and code to all uppercase!
            http://quikmsg.net/strtolower/ - Convert uppercase text and code to all lowercase!

            Comment

            • Hawkmoth
              Member
              • May 2012
              • 34
              • 4.1.x

              #7
              Well I don't know how we got to where we are but our site is back on now. So problems resolved, whatever they were.
              http://www.antifraudintl.org

              Comment

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