MySQL 乔姆拉！3 安装在创建数据库表时冻结
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21510660/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Joomla! 3 installation freezes at creating database table
提问by Universe
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.
我正在尝试安装 Joomla！3.2.1 在我的系统上，但安装中途冻结。我已经下载并安装了 Wamp Server 2.4 并想在本地安装 Joomla！3.2.1，但安装冻结并没有完成。
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.iniand restarting the wamp didn't help.
增加最大执行时间php.ini并重新启动 wamp 没有帮助。
My Wamp 2.4 uses:
我的 Wamp 2.4 使用：
- MySQL 5.6.12
- php 5.4.16
- Apache 2.4.4
- MySQL 5.6.12
- php 5.4.16
- 阿帕奇 2.4.4
How can I get the installer to go past this point?
我怎样才能让安装程序通过这一点？
回答by Universe
This problem occurring most usually at Joomla 3.x.
To solve this go to wamp\www\Your joomla folder\installation\sql\mysqland open Joomla.sql file find the term
这个问题最常发生在 Joomla 3.x。要解决这个问题，请wamp\www\Your joomla folder\installation\sql\mysql打开 Joomla.sql 文件找到术语
"ENGINE=InnoDB"
“引擎= InnoDB”
and replace ALL with
并将 ALL 替换为
"ENGINE=MyIsam"
“引擎=MyIsam”
MyIsam is more supported and compatible with Joomla.
MyIsam 得到更多支持并与 Joomla 兼容。
Do also the same with (sample_data.sql) file, if it's quickstart setup.
如果是快速入门设置，也对 (sample_data.sql) 文件执行相同操作。
回答by RiggsFolly
The problem is that PHP has timed out. By default WAMP comes with the php variable max_execution_time = 30
问题是 PHP 超时了。默认情况下，WAMP 带有 php 变量max_execution_time = 30
Look at your php error logand it should make this error fairly obvious.
看看你的php error log，它应该使这个错误相当明显。
So edit your php.inifile, using the wampmanager menu system
因此php.ini，使用 wampmanager 菜单系统编辑您的文件
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.
然后重新启动 Apache，它会看到这些更改。
Once the install has completed go back and change it back to a value no more than 60.
安装完成后，返回并将其更改回不超过60.
回答by sachin
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 :
大多数用户在安装 Joomla 3.x 时都面临这个问题。我也遇到过这个问题。然后我找到了在我的 php.ini 文件和 joomla 的 mysql 文件中进行一些配置更改的解决方案。我做了以下更改：
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
现在我的 joomla 演示站点运行良好
回答by Shan
I implemented the following changes:
我实施了以下更改：
"ENGINE=InnoDB"
and replace ALL with
并将 ALL 替换为
"ENGINE=MyIsam"
and then I increased the execution time in php.ini file to 200, as pointed in earlier answers.
然后我将 php.ini 文件中的执行时间增加到 200，正如前面的答案所指出的。
max_execution_time = 30
And change it to
并将其更改为
max_execution_time = 200
Further, in php.ini file
此外，在 php.ini 文件中
Output_Buffering=Off
Display_Errors=Off
This did the job!
这做到了！
回答by Dyuuha
In case changing max_execute_timeor replacing InnoDBdidn't work for you, try to install it in different browser like Opera. Worked for me!!
如果更改max_execute_time或替换InnoDB对您不起作用，请尝试将其安装在 Opera 等其他浏览器中。为我工作！！
回答by Pankaj
I too faced the same issue of hanging of the installation of joomla 3.4.5 on my windows machine.
我也面临同样的问题，在我的 Windows 机器上安装 joomla 3.4.5。
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
我尝试执行相同的 5-6 次。然后，在谷歌搜索了很多之后得出的结论是，它可以通过我修改 php.ini 配置文件中的 2 个参数来解决，通常位于
<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.
有效。因此，无需将 InnoDB 引擎修改为 MyIsam。底座安装效果很好。只是我们的 php 配置默认设置的问题。
