Site upgrade begs the question on PHP and MySQL versions

[jagalbraith]

The site I administer is a tad old and based on php4 and mySQL4.

I'm in the process of doing an upgrade and am trying to figure out whether its worth running in PHP5 and MySQL5.

I tried doing a search and after trying a half dozen variations on search variables only to be told that the basic terms were too common every time, I'm left with having to ask...

So, the question:

(1) Is Integramod stable in MySQL5 and PHP5?
(2) Is there a version of MySQL5 and PHP5 that should be avoided over others?

[jagalbraith]

I should add that the phpbb website is currently down, so I couldn't search there first either....

[Helter]

IntegraMOD141 is php5 compatible. There have been issues reported while updating from php4 to php5, but they are solvable. If your having search issues, try adding a wildcard to your search query. For example search for "upgrade to php5*"

[Neva]

The only problem I seem to have after doing an upgrade from PHP4 to PHP5 is that my Public Profile Base Info page will not display any info.
See related post: http://www.integramod.com/forum/viewtop ... =18&t=5192

I'm still using an old version of MySQL so I can't comment on it's use.

[Neva]

Just found another thing not working after my PHP update, the spell checker no longer works, it just tells me all the words are ok even if they are not.

[Helter]

I asked Mike to take a look at those files if he has time and see if some incompatible code was left behind. Both of those things seem to work fine on a fresh install, but have issues when php is updated from 4 to 5

[Helter]

this may have to do with the default php5 installation. It is inherently more secure than php4 so several functions are disabled by default. What version are you running? I am running 5.2.6

System Linux integramod.com 2.6.18-1.2257.xxx #1 Fri Dec 15 16:06:24 EST 2006 i686
Build Date Nov 16 2008 08:30:34
Configure Command './configure' '--disable-pdo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-fastcgi' '--enable-ftp' '--enable-libxml' '--enable-magic-quotes' '--enable-sockets' '--enable-zip' '--prefix=/usr' '--with-bz2' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libxml-dir=/opt/xml2/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib' '--with-zlib-dir=/usr'
Server API CGI/FastCGI
Virtual Directory Support disabled
PHP API xx
PHP Extension xx
Zend Extension xx
suhosin xx
Debug Build no
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams zip, php, file, data, http, ftp, compress.bzip2, compress.zlib
Registered Stream Socket Transports tcp, udp, unix, udg
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*

[Neva]

I'm running PHP 5.2.8

System Windows NT NEVA 5.2 build 3790
Build Date Dec 8 2008 19:30:48
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:php-sdksnap_5_2vc6x86template" "--with-php-build=d:php-sdksnap_5_2vc6x86php_build" "--with-pdo-oci=D:php-sdkoracleinstantclient10sdk, shared" "--with-oci8=D:php-sdkoracleinstantclient10sdk, shared"
Server API ISAPI
Virtual Directory Support enabled
Configuration File (php.ini) Path C:WINDOWS
Loaded Configuration File C:PHP5php.ini
Scan this dir for additional .ini files (none)
additional .ini files parsed (none)
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp, compress.zlib, zip
Registered Stream Socket Transports tcp, udp
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*

[Michaelo]

Helter can yo get me a copy of an old database and a new one... No need for the data just the tables... it has to be fairly simple...

And a quick joke... 42 cows in a field... after a while, one cow goes Moo.... and another one says... crap! I was just about to say that... <img>

What can I say... I have a weird imagination....
Mike

[Helter]

there are no db changes since 141. I can give you the 141version of the forumimages db, or the 141 theme demo db. Both have no problems on this server and both have survived the php4 to php5 update with no problems, however my php.ini is customized so I dont know how they would react to a default php5 installation

[Neva]

I was playing around with a few settings in my php.ini and I think I fixed the problem. I changed register_long_arrays = On, by default it was set to Off.

I don't know if you want to make code changes to make this more compatible or just tell everyone to make the change in their php.ini, all I know is it's working now so I'm happy. <img>