Joomla! 3 installation freezes at creating database table
Solution 1
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.
Solution 2
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
.
Solution 3
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
Solution 4
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!!
Solution 5
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!
Related videos on Youtube
![Universe](https://i.stack.imgur.com/Dk3eR.jpg?s=256&g=1)
Universe
Hello friend! I like programming and I don't like to talk a lot about me (especially if there is not a face to face conversation). SOreadytohelp #SOreadytohelp
Updated on July 09, 2022Comments
-
Universe almost 2 years
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?
-
Universe about 10 yearsmaybe the changes of
Output_Buffering=Off and Display_Errors=Off
are not necessary.. -
BRap almost 10 yearstnx that worked for me ;) (you must restart the Apache after every change...)
-
Universe over 9 yearsmaybe the changes of
Output_Buffering=Off
,Display_Errors=Off
andmax_execution_time
are not necessary.. -
miksiii over 9 yearsIs it possible that Joomla is that dumb?
-
R T about 9 yearsyep this one is better. on xampp chaing max_execution_time to 200 solved the issue.
-
Mohd Abdul Mujib about 9 yearsWorked for me too. Guyz, this seems a better option, 'cause you don't have to change anything from the default Joomla! Installation.
-
Bharanikumar about 9 yearsThanks, i face exact prob, now got solution. i would like to what is actual root for this problem, in the sense, if we remove innodb, then we could not able tow create any relationship for the mention table.
-
Andrii Muzychuk about 9 yearsChanging timeout is a better solution
-
Andrii Muzychuk about 9 years@Universe, the same with this approach ;-)
-
Universe about 9 years@Chiz as you think but your comment doesn't add any help. Post a answer if you think different than me, and leave the people choose what fit on their problem
-
Andrii Muzychuk about 9 years@Universe, I tried this approach - doesn't work. I tried approach below - it works. This is my help.
-
Universe about 9 years@Chiz that you say doesn't make "Changing timeout" a better solution... (as you comment in the beginning). But is an alternative, If my approach doesn't work with you. But are you sure that you apply the second approach having reset first the changes from my approach?
-
arniotaki almost 9 yearsThe crucial part of that answer is to stop and restart your Apache! Otherwise it wont work! At least that is what happened to me
-
Muhammad almost 9 yearsit is really a better solution because it is not forcing to use MyIsam, Thanks :)
-
Malaiselvan almost 9 years@Universe Is there a way without changing the ENGINE. Because we use relationships in our database model and we want to use INNODB engine in our custom component...
-
Universe almost 9 years@Malaiselvan as far as I know, not. You should consider change your model, if you can
-
Malaiselvan almost 9 years@Universe Thanks... I used your solution and after installing I changed back all joomla tables back to INNODB.... It works great so far...
-
Universe almost 9 years@Malaiselvan nice to hear that!
-
silvachathura over 7 yearsany idea if i try to do the changes in a hosted server, where to change the php.ini file ?
-
RiggsFolly about 7 years@Malaiselvan Would have been a lot simpler to just increase the timeout in PHP than all that engine changing