Php upgrade causes 500 error in VB 5.2.2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • frank47
    Member
    • Jun 2003
    • 88

    Php upgrade causes 500 error in VB 5.2.2

    Updated to php 5.6 and now entire forum (vb 5.2.2) is completely down...HTTP 500 Internal Sever Error

    Do I needc to upgrade to solve this or is there another way?

  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    Please upgrade to 5.2.5 in the first instance.
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • frank47
      Member
      • Jun 2003
      • 88

      #3
      Gee that worked well...
      Uploaded 5.2.5 and now get:

      2: mysqli_real_connect() expects parameter 6 to be long, string given

      from ../core/install/upgrade.php

      Comment

      • BirdOPrey5
        Senior Member
        • Jul 2008
        • 9613
        • 5.6.3

        #4
        Verify you are using mysqli (i at the end) in the database type -

        Code:
         $config['Database']['dbtype'] = 'mysqli';
        Then verify your database name, username, password are all properly formatted. Did you create a new config.php file or use the same one from 5.2.2?

        Comment

        • frank47
          Member
          • Jun 2003
          • 88

          #5
          Neither can be the problem because the forum is actually working with the new uploaded files but does not upgrade as per above..

          Trying to log ointo the admincp, says vBulletin 5.1.7 Admin Control Panel

          Comment

          • BirdOPrey5
            Senior Member
            • Jul 2008
            • 9613
            • 5.6.3

            #6
            The max PHP version for VB 5.1.7 is below the minimum PHP version of VB 5,2,5. Make sure you have upgraded to at least PHP 5.6.x before upgrading. PHP 5.6.x will no longer work with the mysql version in the config.php gile. It must be changed to mysqli and you must ensure php is compiled with mysqli support.

            Of course make a database backup before running the upgrade.php file.

            Comment

            • glennrocksvb
              Former vBulletin Developer
              • Mar 2011
              • 4011
              • 5.7.X

              #7
              Check the core config.php and make sure the database server port is set to a number (3306 is the default) and not a string.

              PHP Code:
              $config['MasterServer']['port'] = 3306

              Flag Icon Postbit Insert GIPHY Impersonate User BETTER INITIALS AVATAR Better Name Card Quote Selected Text Bookmark Posts Post Footer Translate Stop Links in Posts +MORE!

              Comment

              • frank47
                Member
                • Jun 2003
                • 88

                #8
                None of this makes sense ...

                Running php 5.6.x
                Uploaded all files for 4.2.5

                The forum is working but...

                1. upgrade.php just gives the error:
                "2: mysqli_real_connect() expects parameter 6 to be long, string given"

                2. Delete the install directory and try to access Admincp and

                Says "vBulletin 5.1.7 Admin Control Panel"
                Does not accept my login either

                So, if db is working, I must have mysqli enabled - that is not the issue
                I do not see amy config.php file within core

                Comment

                • Necrophyte
                  Member
                  • Oct 2014
                  • 58
                  • 5.2.x

                  #9
                  Not true. Mysqli and mysql are not the same, which is why it won't move further.
                  Config.php is in core/includes
                  You may need to add the php library for mysqli as well.
                  If you run a PHP script with just phpinfo();
                  Then do a search for mysqli on the page with CTRL+F. You should see something like below:

                  mysqli
                  Client API library version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
                  Active Persistent Links 0
                  Inactive Persistent Links 0
                  Active Links 0
                  mysqli.allow_local_infile On On
                  mysqli.allow_persistent On On
                  mysqli.default_host no value no value
                  mysqli.default_port 3306 3306
                  mysqli.default_pw no value no value
                  mysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
                  mysqli.default_user no value no value
                  mysqli.max_links Unlimited Unlimited
                  mysqli.max_persistent Unlimited Unlimited
                  mysqli.reconnect Off Off
                  mysqli.rollback_on_cached_plink Off Off
                  Last edited by Necrophyte; Sat 10 Dec '16, 10:19am.

                  Comment

                  • BirdOPrey5
                    Senior Member
                    • Jul 2008
                    • 9613
                    • 5.6.3

                    #10
                    config.php is in /core/includes/ directory.

                    Comment

                    • frank47
                      Member
                      • Jun 2003
                      • 88

                      #11
                      Ok, we are not connecting here.
                      mysqli is configured in php. I knwo tyhgis because I recompiled and ALSO I have vb 5.2.5 running on another site on the same server.

                      The config.php does not have
                      Code:
                       $config['Database']['dbtype'] = 'mysqli';
                      OR
                      [FONT=Courier New][COLOR=#0000BB]$config[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'MasterServer'[/COLOR][COLOR=#007700]][[/COLOR][COLOR=#DD0000]'port'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]3306[/COLOR][COLOR=#007700]; [/COLOR][/FONT]
                      If I can get to admicp on another site, it is not a mysqli issue

                      Also it does not let me log into admincp. Doesn't say anything just reloads page
                      URL is .../loginerror=badlogin_strikes_logintypeemail&strikes=2&vb_login_username=Admin


                      PHP Version 5.6.28

                      fyi:
                      Client API library version 5.5.52
                      Active Persistent Links
                      Inactive Persistent Links
                      Active Links
                      Client API header version 5.5.52
                      MYSQLI_SOCKET /var/lib/mysql/mysql.sock
                      mysqli.allow_local_infile On On
                      mysqli.allow_persistent On On
                      mysqli.default_host no value no value
                      mysqli.default_port 3306 3306
                      mysqli.default_pw no value no value
                      mysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
                      mysqli.default_user no value no value
                      mysqli.max_links Unlimited Unlimited
                      mysqli.max_persistent Unlimited Unlimited
                      mysqli.reconnect Off Off
                      mysqli.rollback_on_cached_plink Off Off
                      Last edited by frank47; Sat 10 Dec '16, 4:22pm.

                      Comment

                      • frank47
                        Member
                        • Jun 2003
                        • 88

                        #12
                        Figured it out .... thanx

                        Comment

                        Related Topics

                        Collapse

                        Working...