xoops forums

Dave_L

XOOPS is my life!
Posted on: 2006/7/14 12:41
Dave_L
Dave_L (Show more)
XOOPS is my life!
Posts: 2277
Since: 2003/11/7
#1

Recommended versions of PHP and MySQL

I'm setting up a server with a fresh install of Fedora 5. I'll be using XOOPS 2.2.4 for now, and will upgrade it to XOOPS 2.3/2.4 eventually.

I'm trying to decide which versions of PHP and MySQL to install.

-----

The latest versions available at http://php.net/ are PHP 5.1.4 and PHP 4.4.2.

I've been using PHP 5.x for testing/development on localhost for some time, and know that the modules I use are compatible with it, so I'd prefer to stick with PHP 5.x.

1) Do you think PHP 5.1.4 is reasonably stable, and compatible with XOOPS 2.2.4? Or would PHP 4.4.2 be a better choice?

-----

The latest versions available at http://mysql.org/ are MySQL 5.0.22 and MySQL 4.1.20.

I've been using MySQL 4.x, and have no experience with MySQL 5.x.

2) Do you think MySQL 5.0.22 would be compatible with XOOPS 2.2.4? Or would MySQL 4.1.20 be a safer choice?

Chris03

Quite a regular
Posted on: 2006/7/14 14:28
Chris03
Chris03 (Show more)
Quite a regular
Posts: 372
Since: 2004/2/22
#2

Re: Recommended versions of PHP and MySQL

I run around 500+ XOOPS sites, we have had some issues with the 5x series of MySQL, so far PHPv5 has caused no issues.
KickassAMD

kaotik

Just can't stay away
Posted on: 2006/7/14 16:39
kaotik
kaotik (Show more)
Just can't stay away
Posts: 861
Since: 2004/2/19
#3

Re: Recommended versions of PHP and MySQL

Hi David
Personally I prefer to use MySQL 4. version 5 has also given me some issues. I've used both php4 and 5 without any problems with XOOPS 2.2.4

Dave_L

XOOPS is my life!
Posted on: 2006/7/19 20:44
Dave_L
Dave_L (Show more)
XOOPS is my life!
Posts: 2277
Since: 2003/11/7
#4

Re: Recommended versions of PHP and MySQL

Thanks Chris03 and kaotik.

After installing Fedora 5, we found that it included PHP 5.1.4 and MySQL 5.0.22.

Since the server is only being used for testing at this point, I may stick with those versions for now. If I have problems with MySQL 5, I can downgrade it to version 4.

What kind of issues have you had with MySQL 5?

birdseed

Just popping in
Posted on: 2006/7/19 22:00
birdseed
birdseed (Show more)
Just popping in
Posts: 59
Since: 2005/2/26
#5

Re: Recommended versions of PHP and MySQL

Hi DaveL,

I use fedora core 5 for XOOPS development (xoops 2.2.4) @home. Almost everythings works fine, I had some problems in my own modules, but not the core. mysql5 has more sql2003 compliance. Some module queries won't work. One examples is the scope of Variables in SQL statements which is narrower in MySQL 5.

Consider this hack in class/errorhandler.php

function handleError($error)
    {
        
// BIRDSEEDMUSIC HACK: nervige Reference-Meldungen von php 4.4 ignorieren
        
if ($error['errstr'] == "Only variables should be assigned by reference"
        
|| $error['errstr'] == "Only variable references should be returned by reference") {
            return;
        }
        if ((
$error['errno'] & error_reporting()) != $error['errno']) {
            return;
        }
        
$this->_errors[] = $error;
        if (
$error['errno'] == E_USER_ERROR) {
            
$this->_isFatal true;
            exit();
        }
    }


It keeps you from the mass of reference error messages in XOOPS 2.2.4.

Best php Version for XOOPS is 4.3.x.

greetigs
birdseedmusic

Dave_L

XOOPS is my life!
Posted on: 2006/7/20 11:19
Dave_L
Dave_L (Show more)
XOOPS is my life!
Posts: 2277
Since: 2003/11/7
#6

Re: Recommended versions of PHP and MySQL

Thanks, birdseed. That's helpful.