Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Jan 2005
    Posts
    1,880

    Default Upgrading to PHP 5.2.x - mysql/mysqli problems to look out for?

    I'll soon be upgrading from PHP 4.4.x/CGI to 5.2.x CGI and would like to check if I should still expect problems with mysql/mysqli conflicts as previously detailed in another thread.

    In short, it seems in the past that there have been problems whereby PHP is configured to use both mysql and mysqli and cannot install as only one of these, not both, can be selected, or at least that's as far as I understand it.

    Other threads, which I can't seem to find now, refer to similar issues and also mention a bugzilla entry which details similar problems and for which patches were provided, ending with comments in a thread that such issues have now been resolved. All such threads I could find were perhaps one or two years old and so I can't be sure they're still relevant.

    I'd like to use the standard mysql module and not the mysqli module for PHP 5.2.x.

    In the 'Apache Update' section of WHM I see checkboxes for 'Mysql Module' and 'Use System Mysql', but I see no checkbox for selecting/unselecting the mysqli module.

    If I were to check 'Mysql Module' and uncheck 'Use System Mysql', would anyone like to hazard a guess as to what mysql module I'd end up with? Mysql or mysqli?

    Since PHP5 seems to default towards using mysqli and as there seems to be no option for unselecting mysqli, I'm somewhat uncertain of what mysql module I'd end up with and so would appreciate hearing from anyone who has done this recently.
    Jon Cram <jon@webignition.net>
    Web and interface design http://webignition.net/
    Hosting Reborn (free cpanel accounts) http://hostingreborn.com/

  2. #2
    Member
    Join Date
    Jan 2005
    Posts
    1,880

    Default

    Update:

    I recently upgraded from PHP 4.4.2 to 4.4.7 (will go to 5.2.2 some time soon) and the configure line included '--with-mysqli' '--with-mysql=/usr' and this doesn't seem to have caused any problems, so I'm expecting it won't when I upgrade to PHP5.
    Jon Cram <jon@webignition.net>
    Web and interface design http://webignition.net/
    Hosting Reborn (free cpanel accounts) http://hostingreborn.com/

Similar Threads & Tags
Similar threads

  1. Problems upgrading from mysql 4.1.22 to 5.0.45
    By SNN in forum Database Discussions
    Replies: 21
    Last Post: 07-25-2010, 01:12 PM
  2. Problems upgrading from mysql 4.1.22 to 5.0.45
    By SNN in forum cPanel and WHM Discussions
    Replies: 21
    Last Post: 07-25-2010, 01:12 PM
  3. PHP 5.x.x: Can WHM Compile with mysql and mysqli APIs Automatically?
    By jfxberns in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 12-26-2006, 02:05 PM
  4. Some problems after upgrading MySQL
    By Nightweaver in forum cPanel and WHM Discussions
    Replies: 6
    Last Post: 12-22-2005, 08:08 PM
  5. PHP 5.04 without mysql/mysqli conflict?
    By Pirotess in forum cPanel and WHM Discussions
    Replies: 12
    Last Post: 09-26-2005, 12:36 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube