CODEWITHSUNDEEP
mysqlinstallationwampserverfreezejoomla3.0
Universe
Universe

Reputation: 1610

Joomla! 3 installation freezes at creating database table

I am trying to install Joomla! 3.2.1 on my system but the installation freezes half way through. I've downloaded and installed the Wamp Server 2.4 and wanted to locally install Joomla! 3.2.1, but the installation freezes and doesn't finish.

browser screenshot of hanging install

It stops short of finishing the installation during the "creating database tables" task: it just stays on this bit seemingly forever.

Increasing the max execution time in php.ini and restarting the wamp didn't help.

My Wamp 2.4 uses:

How can I get the installer to go past this point?

Upvotes: 45

Views: 94618

Answers (6)

Pankaj
Pankaj

Reputation: 645

I too faced the same issue of hanging of the installation of joomla 3.4.5 on my windows machine.

OS: Win 8.1 x64
XAMPP v3.2.1
Joomla: 3.4.5

I tried to perform the same 5-6 times. Then, after googling a lot came to conclusion that it can be resolved just my modifying 2 parameters in the php.ini config file usually located inside the 

<XAMPP_INSTALL_DIR>/php/php.ini

memory_limit = 512M
max_execution_time = 200

It worked. So, there is no need to modify the InnoDB engine to MyIsam. Base installation works well. Just the issue with our default settings of the php configuration.

Upvotes: 1

RiggsFolly
RiggsFolly

Reputation: 94662

The problem is that PHP has timed out. By default WAMP comes with the php variable max_execution_time = 30

Look at your php error log and it should make this error fairly obvious.

So edit your php.ini file, using the wampmanager menu system

wampmanager -> PHP -> php.ini

Find the parameter

max_execution_time = 30

And change it to 

max_execution_time = 200

Then restart Apache, so it see's these changes.

Once the install has completed go back and change it back to a value no more than 60.

Upvotes: 24

Shan
Shan

Reputation: 47

I implemented the following changes:

"ENGINE=InnoDB"

and replace ALL with

"ENGINE=MyIsam"

and then I increased the execution time in php.ini file to 200, as pointed in earlier answers.

max_execution_time = 30

And change it to

max_execution_time = 200

Further, in php.ini file

Output_Buffering=Off 
Display_Errors=Off

This did the job!

Upvotes: 2

Universe
Universe

Reputation: 1610

This problem occurring most usually at Joomla 3.x. To solve this go to wamp\www\Your joomla folder\installation\sql\mysql and open Joomla.sql file find the term

"ENGINE=InnoDB"

and replace ALL with

"ENGINE=MyIsam"

MyIsam is more supported and compatible with Joomla.

Do also the same with (sample_data.sql) file, if it's quickstart setup.

Upvotes: 82

sachin
sachin

Reputation: 93

Most of user's are facing This problem when installing Joomla 3.x. I have also faced this problem. Then i found the solution to do some configuration changes in my php.ini file and joomla's mysql file. i did following changes :

in php.ini file

Output_Buffering=Off 
Display_Errors=Off 
and in wamp\www\Your joomla folder\installation\sql\mysql\Joomla.sql
replaced all the occurence of "ENGINE=InnoDB" with "ENGINE=MyIsam"

Now my joomla demo site has been working fine

Upvotes: 3

Dyuuha
Dyuuha

Reputation: 21

In case changing max_execute_time or replacing InnoDB didn't work for you, try to install it in different browser like Opera. Worked for me!!

Upvotes: 2

Related Questions