1
Dave_L
Recommended versions of PHP and MySQL
  • 2006/7/14 12:41

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


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 athttp://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 athttp://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?

2
Chris03
Re: Recommended versions of PHP and MySQL
  • 2006/7/14 14:28

  • Chris03

  • Quite a regular

  • Posts: 372

  • Since: 2004/2/22


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

3
kaotik
Re: Recommended versions of PHP and MySQL
  • 2006/7/14 16:39

  • kaotik

  • Just can't stay away

  • Posts: 861

  • Since: 2004/2/19


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
www.kaotik.biz

4
Dave_L
Re: Recommended versions of PHP and MySQL
  • 2006/7/19 20:44

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


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?

5
birdseed
Re: Recommended versions of PHP and MySQL
  • 2006/7/19 22:00

  • birdseed

  • Just popping in

  • Posts: 59

  • Since: 2005/2/26


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

6
Dave_L
Re: Recommended versions of PHP and MySQL
  • 2006/7/20 11:19

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Thanks, birdseed. That's helpful.

Login

Who's Online

171 user(s) are online (84 user(s) are browsing Support Forums)


Members: 0


Guests: 171


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits