Joomla! 3 freezes when creating a database table

Question

I am trying to install Joomla! 3.2.1 on my system, but the installation freezes halfway. I downloaded and installed Wamp Server 2.4 and wanted to install Joomla locally! 3.2.1, but the installation freezes and does not end.

It is not possible to complete the installation while creating the table for creating tables: it simply remains on this bit, it would seem, forever.

Increasing the maximum runtime in php.ini and restarting wamp did not help.

My Wamp 2.4 uses:

• MySQL 5.6.12
• php 5.4.16
• Apache 2.4.4

How can I make the installer go past this point?

Answer 1

This problem is most common with Joomla 3.x. To solve this problem, go to wamp\www\Your joomla folder\installation\sql\mysql and open the Joomla.sql file, find the term

"ENGINE = InnoDB"

and replace ALL with

"ENGINE = MyISAM"

MyIsam is more supported and compatible with Joomla.

Do the same with the (sample_data.sql) file if this is a quick start.

Answer 2

The problem is that PHP timeout. 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 the php.ini file using the wampmanager menu system

 wampmanager -> PHP -> php.ini 

Find parameter

 max_execution_time = 30 

And change it to

 max_execution_time = 200 

Then restart Apache so that it sees these changes.

After the installation is completed, go back and change it to a value of no more than 60 .

Answer 3

Most users encounter this problem when installing Joomla 3.x. I also ran into this problem. Then I found a solution to make some configuration changes in the php.ini file and the mysql joomla file. I made the 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 is working fine

Answer 4

If changing max_execute_time or replacing InnoDB did not work for you, try installing it in another browser, such as Opera. Worked for me.

Answer 5

I implemented the following changes:

 "ENGINE=InnoDB" 

and replace ALL with

 "ENGINE=MyIsam" 

and then I increased the runtime in the php.ini file to 200, as indicated in earlier answers.

 max_execution_time = 30 

And change it to

 max_execution_time = 200 

Also in the php.ini file

 Output_Buffering=Off Display_Errors=Off 

It worked!

Answer 6

I also ran into the same problem with installing joomla 3.4.5 on my windows computer.

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

I tried to do the same 5-6 times. Then, after a multiplayer game, I came to the conclusion that only my modifying 2 parameters can be allowed in the php.ini configuration file, usually inside

 <XAMPP_INSTALL_DIR>/php/php.ini memory_limit = 512M max_execution_time = 200 

It worked. Thus, there is no need to modify the InnoDB engine for MyIsam. The basic setup works well. Just a problem with the default php configuration settings.