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?

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

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

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?

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



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

Thanks, birdseed. That's helpful.