Database error After moving to windows vps from linux server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • badheeu
    New Member
    • Oct 2007
    • 22
    • 4.2.x

    [Blog] Database error After moving to windows vps from linux server

    Hi, Can someone explain me to solve below Issues, Im getting database error for my cms and blog after I have moved my hosting from linux to windows.
    And also in forum I have few issues, Cant move threads. when i tried to move it ended up with a blank page. when I hit refresh it says invalid request.

  • Paul M
    Former Lead Developer
    vB.Com & vB.Org
    • Sep 2004
    • 9886

    #2
    Why did you move to windows ?
    You need to provide details of what server software you are running.

    Those errors seem to relate to missing contenttypeids, but I dont see how a simple move would cause that.
    Baby, I was born this way

    Comment

    • badheeu
      New Member
      • Oct 2007
      • 22
      • 4.2.x

      #3
      Originally posted by Paul M
      Why did you move to windows ?
      You need to provide details of what server software you are running.

      Those errors seem to relate to missing contenttypeids, but I dont see how a simple move would cause that.
      Thank you very much for the quick reply.

      Due to financial I have to cancel my linux server and I have moved it to my Personal VPS. Cant afford to run both servers. Forum was dead since 2013 and im using not the latest backup.

      I am using Product: Plesk Onyx 17.0.17, PHP Version: 5.6.29, MySQL Version : 5.6.33, Windows Server 2012.



      Comment

      • badheeu
        New Member
        • Oct 2007
        • 22
        • 4.2.x

        #4
        I am waiting for a guidance.

        Comment

        • Lynne
          Former vBulletin Support
          • Oct 2004
          • 26255

          #5
          Have you verified that you moved a complete database backup to the new server? As Paul stated, it sounds like you are missing some contentids which would suggest the tables didn't get moved over correctly/completely.

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

          Comment

          • badheeu
            New Member
            • Oct 2007
            • 22
            • 4.2.x

            #6
            Originally posted by Lynne
            Have you verified that you moved a complete database backup to the new server? As Paul stated, it sounds like you are missing some contentids which would suggest the tables didn't get moved over correctly/completely.
            I have lost file system, only db. forum is running but have few bugs.

            And also now im trying to upgrade and ended with an error.

            Comment

            • badheeu
              New Member
              • Oct 2007
              • 22
              • 4.2.x

              #7

              Comment

              • Wayne Luke
                vBulletin Technical Support Lead
                • Aug 2000
                • 73981

                #8
                Seems a step was skipped somewhere and the version in the database wasn't updated properly. You should rerun the 4.2.3 upgrade script.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API

                Comment

                • badheeu
                  New Member
                  • Oct 2007
                  • 22
                  • 4.2.x

                  #9
                  I have updated to the 4.2.4, but still i have db errors in cms and blog, also thread moving and editing issue couldn't fix. what should i have to do.

                  Comment

                  • Paul M
                    Former Lead Developer
                    vB.Com & vB.Org
                    • Sep 2004
                    • 9886

                    #10
                    The issue is exactly the same as before, you are missing the content type ids, which suggests your database is wrong, or broken.
                    Baby, I was born this way

                    Comment

                    • badheeu
                      New Member
                      • Oct 2007
                      • 22
                      • 4.2.x

                      #11
                      how can i fix it

                      Comment

                      • Paul M
                        Former Lead Developer
                        vB.Com & vB.Org
                        • Sep 2004
                        • 9886

                        #12
                        I have no idea.

                        Thats like taking your car to a garage and saying "it doesnt work, how do I fix it".

                        Without investigation of your database itself, no one is ever going to be able to answer that.
                        Baby, I was born this way

                        Comment

                        • badheeu
                          New Member
                          • Oct 2007
                          • 22
                          • 4.2.x

                          #13
                          No Problem, thanks for your support. it works fine now.

                          Comment

                          • Wayne Luke
                            vBulletin Technical Support Lead
                            • Aug 2000
                            • 73981

                            #14
                            Sounds like a caching issue somewhere then.
                            Translations provided by Google.

                            Wayne Luke
                            The Rabid Badger - a vBulletin Cloud demonstration site.
                            vBulletin 5 API

                            Comment

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