?
avatar zero-24
zero-24
25 Nov 2014

Steps to reproduce the issue

Download and extract xampp 5.6.3 (they change the versioning to reflect the PHP Version)
Download and extract joomla 2.5.x / 3.x (staging) (github branche or stable)
try to install

Expected result

Installation works

Actual result

Installation hangs by creating the database

System information (as much as possible)

Default xampp Konfiguration with:

Apache 2.4.10, MySQL 5.6.21, PHP 5.6.3, phpMyAdmin 4.2.11, OpenSSL 1.0.1, XAMPP Control Panel 3.2.1, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.56 (with mod_proxy_ajp as connector), Strawberry Perl 7.0.56 Portable

Additional comments

I think the Joomla Core should work with the default xampp config as it is often used for "testing" and planing joomla if can't be done on the production site not only by experts mostly by end users to pre-test Joomla.

avatar zero-24 zero-24 - open - 25 Nov 2014
avatar zero-24
zero-24 - comment - 25 Nov 2014

please note that we need to fix http://issues.joomla.org/tracker/joomla-cms/5192 bevor you can test this for 2.5.x

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/5193.

avatar roland-d
roland-d - comment - 25 Nov 2014

It could also be because of issue http://issues.joomla.org/tracker/joomla-cms/5172 if display errors is on.

avatar zero-24
zero-24 - comment - 25 Nov 2014

It could also be because of issue http://issues.joomla.org/tracker/joomla-cms/5172 if display errors is on.

hmm it works if i add:
@ini_set('display_errors', 'Off');
Into:
\includes\framework.php

and set max_execution_time to 120 (default: 30).

So it sounds for me that we have some issues with the max_execution_time as display erros is disabled on production servers.

avatar sovainfo
sovainfo - comment - 25 Nov 2014

Known issue, even with XAMPP 1.8.3, Depending on infrastructure, so, increasing max_execution_time is not the right solution. Calling set_time_limit() before time consuming activity might be. It would still allow for increasing max_execution_time on infra that is too slow!

avatar zero-24
zero-24 - comment - 25 Nov 2014

Calling set_time_limit() before time consuming activity might be.

@sovainfo can you send a patch?

It hangs if you install the mysql files. So i think this is the time consuming activity :smile:

avatar sovainfo
sovainfo - comment - 25 Nov 2014

Can't reproduce the situation. You could replace line 817 of installation/model/databse.php. It is an empty line, replace it with set_time_limit();

Now each query has 30 seconds to complete, assuming max_execution_time is set to 30.

avatar zero-24
zero-24 - comment - 27 Nov 2014

@sovainfo sorry this:

You could replace line 817 of installation/model/database.php. It is an empty line, replace it with set_time_limit();

don't help me at my end.

avatar sovainfo
sovainfo - comment - 27 Nov 2014

found the usage of set_time_limit() in core joomla, try this:
'// Execute the query.
$db->setQuery($query);
@set_time_limit(ini_get('max_execution_time'));
try
{
$db->execute();'
}

avatar zero-24
zero-24 - comment - 29 Nov 2014

@sovainfo

This still don't work:
database

avatar roland-d
roland-d - comment - 29 Nov 2014

@sovainfo @zero-24 So I downloaded XAMPP 5.6.3 and a copy of Joomla staging. Did a clean installation with installing sample test data and this went without a hitch. No problems at all. So I can't reproduce this issue.

avatar Bakual
Bakual - comment - 29 Nov 2014

It's a known issue with xampp. I had this happen with older versions as well. But only on my laptop, all works fine on my computer.
It depends on the enviroment and how fast the CPU/HD/whatever can apply the SQL queries. Raising the max_execution time in php.ini solves it.
There is probably not much we can do here on ourself.

avatar sovainfo
sovainfo - comment - 29 Nov 2014

The only other thing I can think of is set_time_limit(0);

avatar roland-d
roland-d - comment - 29 Nov 2014

Rather than finding a code solution, we could also try to contact the XAMPP people and request if they can change their default values.

avatar zero-24
zero-24 - comment - 29 Nov 2014

@roland-d

we could also try to contact the XAMPP people and request if they can change their default values.

The current xampp Maintainers are: Beltran Rueda and Daniel Lopez Ridruejo
https://www.apachefriends.org/about.html

avatar sovainfo
sovainfo - comment - 29 Nov 2014

wamp is currently on 120, uniformserver on 30 as well.
No idea what the value should be, probably prefer to set it in installation to (0) cancelling the timeout!

avatar zero-24
zero-24 - comment - 29 Nov 2014

If i set:
@set_time_limit(0);

into this line: https://github.com/joomla/joomla-cms/blob/staging/installation/application/framework.php#L18

All works ok here. But this is maybe more a "hack" than a solution?

avatar sovainfo
sovainfo - comment - 30 Nov 2014

Don't consider this a hack. What it is saying is that no matter how poor your infra is, you want to continue executing this script. Which is exactly what you want. There is nothing wrong with the script. It only takes more time than your configuration allows.

avatar zero-24 zero-24 - close - 30 Nov 2014
avatar zero-24
zero-24 - comment - 30 Nov 2014

thanks @sovainfo see here: #5256

avatar zero-24 zero-24 - change - 30 Nov 2014
Status New Closed
Closed_Date 0000-00-00 00:00:00 2014-11-30 00:36:06
avatar zero-24 zero-24 - close - 30 Nov 2014
avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?

Add a Comment

Login with GitHub to post a comment