Problems with upgrade

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zel
    Member
    • Mar 2005
    • 30
    #1

    Problems with upgrade

    Hi, I'm performing an upgrade from 4.2.0 to vb5.

    The steps I followed are:

    Under Settings -> Options -> Site Name / URL / Contact Details I changed the URL to www.mysite.com/vb5/core
    I backed up the DB
    I restored in a new DB
    I launched upgrade.php

    I got the following error:
    Module: 500a23, Step 2 Database Error:1064
    Query:
    UPDATE vb_setting SET
    value = value |
    WHERE varname = 'defaultregoptions'

    I refreshed the page and the installer ended its tasks correctly.

    The problem is I see a page without styles and very difficult to navigate.
    It seems that the login functions correctly (I see my PMs) but if I try to access the admincp I see the same style and no admincp (screenshot attached).
    Attached Files
    Tags: None
    • Hartmut
      Senior Member
      • Nov 2007
      • 2870
      • 4.2.x
      #2
      Originally posted by zel
      The steps I followed are:

      Under Settings -> Options -> Site Name / URL / Contact Details I changed the URL to www.mysite.com/vb5/core
      Not good. Go back again and change the URL to what it was before, dont change the URL before you upgrade to vb5, leave it like it is.
      No private support, only PM me when I ask for it. Support in the forums only.

        Comment

        • zel
          Member
          • Mar 2005
          • 30
          #3
          Originally posted by Hartmut
          Not good. Go back again and change the URL to what it was before, dont change the URL before you upgrade to vb5, leave it like it is.
          Sorry but it does not work.
          This time I left the URL of my test site.
          Then I followed the steps I wrote above.
          The problem remains.

            Comment

            • Merjawy
              Senior Member
              • Sep 2002
              • 2613
              #4
              Originally posted by zel
              ...Module: 500a23, Step 2 Database Error:1064
              Query:
              UPDATE vb_setting SET
              value = value |
              WHERE varname = 'defaultregoptions'

              ...
              That's a known issue, if you refresh the page it will finish the upgrade.
              To be or not to be... Where the hell is the question????
              My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

              Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
              CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
              Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

                Comment

                • zel
                  Member
                  • Mar 2005
                  • 30
                  #5
                  Originally posted by Merjawy
                  That's a known issue, if you refresh the page it will finish the upgrade.
                  I know. The upgrade finished successfully.
                  But the problems with the forums remain (see the attachment in the first post).

                    Comment

                    • Merjawy
                      Senior Member
                      • Sep 2002
                      • 2613
                      #6
                      Try changing the css option
                      AdminCP > Settings >> Options >> Style & Language Options >> Save CSS to files

                      Change that to No
                      To be or not to be... Where the hell is the question????
                      My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

                      Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
                      CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
                      Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

                        Comment

                        • zel
                          Member
                          • Mar 2005
                          • 30
                          #7
                          The problem was the MySQL variable 'max_allowed_packet' bytes'.

                          I increased the size to 16MB and now it works.

                          I continue to have problems of blank page in some cases.

                            Comment

                            • Hartmut
                              Senior Member
                              • Nov 2007
                              • 2870
                              • 4.2.x
                              #8
                              Originally posted by zel
                              I continue to have problems of blank page in some cases.
                              In which cases does this happen?
                              No private support, only PM me when I ask for it. Support in the forums only.

                                Comment

                                • zel
                                  Member
                                  • Mar 2005
                                  • 30
                                  #9
                                  Originally posted by Hartmut
                                  In which cases does this happen?
                                  It happens in the home of the site (www.mysite.com/vb5/)
                                  The other parts seems to work properly (admincp, blogs, profile, social-groups, mp).

                                  If I look the HTML of the blank page:
                                  --
                                  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
                                  <HTML><HEAD>
                                  <META http-equiv="Content-Type"
                                  content="text/html; charset=windows-1252"></HEAD>
                                  <BODY></BODY></HTML>
                                  --
                                  Last edited by zel; Wed 19 Sep '12, 4:46am.

                                    Comment

                                    • Hartmut
                                      Senior Member
                                      • Nov 2007
                                      • 2870
                                      • 4.2.x
                                      #10
                                      Hm, did you check for correct URL in the presentation config.php? Did you upload the mod_rewrite (.htacces and/or web.config) in forum root?
                                      No private support, only PM me when I ask for it. Support in the forums only.

                                        Comment

                                        • zel
                                          Member
                                          • Mar 2005
                                          • 30
                                          #11
                                          Originally posted by Hartmut
                                          Hm, did you check for correct URL in the presentation config.php? Did you upload the mod_rewrite (.htacces and/or web.config) in forum root?
                                          Yes. .htacces is in place and the URL is correct.

                                            Comment

                                            • Wayne Luke
                                              vBulletin Technical Support Lead
                                              • Aug 2000
                                              • 74154
                                              #12
                                              Turn off "Store CSS as Files".
                                              Translations provided by Google.

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

                                                Comment

                                                • zel
                                                  Member
                                                  • Mar 2005
                                                  • 30
                                                  #13
                                                  Originally posted by Wayne Luke
                                                  Turn off "Store CSS as Files".
                                                  It's turned off...

                                                    Comment

                                                    Previous template Next

                                                    Related Topics

                                                    Collapse
                                                    Working...