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.
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:
- MySQL 5.6.12
- php 5.4.16
- Apache 2.4.4
How can I get the installer to go past this point?
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.
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
.
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
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!!