The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by webignition, May 29, 2007.

  1. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    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.
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    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.
     
Loading...

Share This Page