My host can do a PHP4/MySQL4 to PHP5/MySQL5 upgrade of my site. Will my Drupal 5.1 site run as-is after that or are there adjustments that will be needed to any of the configuration? Seems like a good move with the recent announcements about the future of Drupal.

gil

Comments

vm’s picture

if using PHP5 insure you are usig mysqli in your DB string in settings.php

Capnj’s picture

www.lunarpages.com did NOT require the "i" for MySQL in the db string. Just an FYI. Apparently that need varies, but thanks.

- gil -

cog.rusty’s picture

The PHP upgrade won't be a problem, except perhaps for some rare contributed module.
The MySQL upgrade *might* be a problem, depending on
- Your exact MySQL version, 4.0 or 4.1
- Any non-english content that you may have
- Whether your host is going to run some database conversion script and what exactly.

I would test the database on another MySQL5 test installation and I would still keep the initial backup until everything is over.

But this is something that you will have to go through sooner or later.

Capnj’s picture

Thanks to all for the feedback to date. I would think this sort of discussion is going to become quite necessary for a lot of us who know just enough to be dangerous.

Current MySQL is 4.1.21 and the encoding is already utf8_unicode_ci. I'm inquiring about any conversion scripts they might run. Any other issues with MySQL to look for with 4.1?

- gil -

inforeto’s picture

If moving from 4.0. and you get collation errors, then search the site for ways to convert your database to a collation like "utf8_general_ci".
This link showed up in the results: http://www.mostrey.be/drupal_character_encoding_mysql

vlooivlerke’s picture

MySQL database 4.1.22
PHP 5.2.6
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Web server Apache/1.3.41 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_jk/1.2.25 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
jQuery Update Installed correctly

Hi

When I upgraded my php4 to php5 (no mysql update) my file permissions stopped working. It states that the folder are not writable but the permissions is 775 (like it always was)

If I try to change the permissions to 777 in cpanel it states that i dont have the permission to do that.

Must I ask my host to restart my Apache server? or what is causing this.
Thanks

............edit

must i change my mysql to => mysqli ?

i did not upgrade the mysql db

cog.rusty’s picture

There is no reason that PHP5 would change that behavior. The behavior you describe is strange, because if the owner is apache's user account then Drupal shouldn't have a problen writing to them, and if the owner is your own user account then you shouldn't have a problem to chmod them to 777 using FTP.

Can you give us the exact error message and where that happens?
Also, can you look up who the owner of those directories or files is?

inforeto’s picture

Perhaps apache was recompiled with other options beside the php upgrade.
Changing suexec to phpexec or back can change the way php is given permissions.

cog.rusty’s picture

With suexec, all files, either uploaded or created by php, would be owned by the user account, and also there wouldn't be any problem at all with writing or chmod. So, probably this is not the case.

I don't know what phpexec is.