"check For New Modules" Causes Internal Server Error

[Fokke]

Hi!

Ok, this is weird one.

My site is running the dev version 2.4.8 on MAMP environment with PHP version 5.5.10 and MySQL version 5.5.34. Everything is running fine.

However, when running the same site on my remote host, clicking "Check for new modules" button in Modules page causes Internal server error, which never goes away, until I delete rows "Modules.site/modules/" and "Modules.wire/modules/" from "caches" table and manually copy them back from the local database.

The rows with the names Modules.info and ModulesVerbose.info are exactly the same between the local and remote databases.

The rows with the names Modules.site/modules/ and Modules.wire/modules/ have the same data, but on local database they are sorted alphabetically, on the remote database they are not. 

The remote server is running PHP 5.3.27-1~dotdeb.0, MySQL 5.0.8-dev.

Unfortunately I have no access to the server logs. I have asked for the logs, but sounds like they are not willing to give me them. Got to put some more pressure on them

Any thoughts?

[arjen]

What about the logs in /site/assets/logs/errors.txt?

[Fokke]

Hi arjen!

The errors.txt file is empty.

When the error occurs, I tried to remove all rows from caches table, and then reload the page. Only Modules.wire/modules/ row will be added, with correct data though. Is there something broken with reading these caches?

[ryan]

I'm not aware of anything broken with the caches in 2.4.8, though there was an issue in 2.4.6 that has been fixed. However, it looks like your MySQL version does not meet the minimum requirements. You mentioned you are using 5.0.8-dev, but the minimum required MySQL version is 5.0.15. If I recall, 5.0.8 is the version of MySQL that had some major issues with sorting. I'm not positive on that, or even sure if that MySQL version is the reason why you got an error, but it seems like the most likely possibility so far. If you are able to reproduce the error again, you might try enabling debug mode so that you could see if any other error messages get output. But chances are that there will be incompatibilities between PW and versions of MySQL prior to 5.0.15.

[Fokke]

Hi Ryan!

After a long waiting, here's the error log:

[Fri Aug 01 11:34:10 2014] [warn] [client 109.204.148.78] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server, referer: http://www.nokikana.fi/test/processwire/module/
[Fri Aug 01 11:34:10 2014] [error] [client 109.204.148.78] Premature end of script headers: index.php, referer: http://www.nokikana.fi/test/processwire/module/

Does this help with recognizing the problem?  I have no clue what these errors mean : )

[arjen]

Fokke, have you tried upgrading the MySQL version to at least 5.0.15? Also you could try to Google your error. Some more info you can find here.

[Fokke]

Unfortunately I'm on shared hosting, and I have been asking and waiting for PHP and MySQL upgrade for too long... If it's not coming soon, I think it's time to switch to another hosting company.