Announcement

Collapse
No announcement yet.

PHP and MySQL

Collapse
This topic has been answered.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • PHP and MySQL

    Curious...
    Must you have a PHP version in place before creating a MySQL database?
    In other words, will changing PHP versions after your database is created, break anything?
    Thanks.
  • Answer selected by Type636 at Wed 8 Dec '21, 7:19am.

    When you install PHP 7.1, you must make sure that the mysqlnd and mysqli libraries are installed and configured in the php.ini. These are not made available on every installation of PHP, particularly on Windows machines. If you are using a Windows machine, then I suggest making sure you download the x64 non-threadsafe ZIP of PHP and not an installer. The ZIP includes many of the necessary DLLs and ultimately makes installation easier if a little more manual.

    If you are using an Apache/MySQL/Perl/PHP package like XAMPP, then you will need to consult its documentation on how to make sure these libraries are installed if they are not available in your version of PHP.

    Comment


    • #2
      You can change PHP versions without affecting MySQL.
      Vote for:

      - *Admin Settable Paid Subscription Reminder Timeframe*
      -
      *PM - Add ability to reply to originator only*
      - Add Admin ability to auto-subscribe users to specific channel(s)
      - "Quick Route" Interface...

      Comment


      • #3
        Originally posted by Trevor Hannant View Post
        You can change PHP versions without affecting MySQL.
        I was experimenting with vB 4.2.5 with PHP 5.6 worked fine, changed PHP to 7.1, lost forum, back to PHP 5.6, good again.

        Any ideas Trevor?
        I had settled in running vB 4.2.5 with PHP 7.1, now have this issue.

        Comment


        • #4
          When you install PHP 7.1, you must make sure that the mysqlnd and mysqli libraries are installed and configured in the php.ini. These are not made available on every installation of PHP, particularly on Windows machines. If you are using a Windows machine, then I suggest making sure you download the x64 non-threadsafe ZIP of PHP and not an installer. The ZIP includes many of the necessary DLLs and ultimately makes installation easier if a little more manual.

          If you are using an Apache/MySQL/Perl/PHP package like XAMPP, then you will need to consult its documentation on how to make sure these libraries are installed if they are not available in your version of PHP.
          Translations provided by Google.

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

          Comment


          • #5
            Originally posted by Wayne Luke View Post
            When you install PHP 7.1, you must make sure that the mysqlnd and mysqli libraries are installed and configured in the php.ini. These are not made available on every installation of PHP, particularly on Windows machines. If you are using a Windows machine, then I suggest making sure you download the x64 non-threadsafe ZIP of PHP and not an installer. The ZIP includes many of the necessary DLLs and ultimately makes installation easier if a little more manual.

            If you are using an Apache/MySQL/Perl/PHP package like XAMPP, then you will need to consult its documentation on how to make sure these libraries are installed if they are not available in your version of PHP.
            Above fixed it, Wayne...now running vBulletin 4.2.5 with PHP 7.1.33, mysqli was the problem!!

            Doing the bug fixes listed here:
            https://forum.vbulletin.com/forum/vb...fixes-combined

            I realize the above version is no longer officially supported, but I'm now able to fulfill my dream forum with this version!!

            Very sad that developers reverted to a single table layout for the forum, maybe they'll come back to their senses in vB6.x!

            Thank you Wayne, for helping me out with this major issue!!

            Comment

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