Joomla 3.0 installation database creating issue

问题:

I try to install Joomla 3 in my system. After download and extract files I put files in my localhost folder wamp/www/jesite/myfiles. After that I run the jesite folder and it displays index page then I give the corresponding details in configuration, database and overview section.

Then I pressed install button after it shows a window with four section

First it completed Backing up old databases and then it shows progress bar in creating database tables. But after that it shows the progress bar for a long time and when I checked in DB it creates 78 tables. But after it shows only the progress bar.

I dont know what I'm doing wrong. Anyone can help me to solve this problem.

回答1:

I change php.ini

from

max_execution_time = 30 

to

max_execution_time = 3000 

also bumped up

memory_limit = 256M  

回答2:

Replacing "ENGINE=InnoDB" by "ENGINE=MyIsam" in the SQL script /installation/sql/mysql/joomla.sql also worked for me, as Giorgi BaneTishvili suggested in the previous answer.

I was installing Joomla 3.1.5 in a Strato shared hosting by uploading Joomla files, not using their auto-installing apps.

I tried adding a php.ini file with max_execution_time = 3000 and memory_limit = 256M, but it did not worked.

回答3:

Edit the SQL install file (Root/installation/SQL/mysql/joomla.sql). Open with notepad and replace all "ENGINE=InnoDB" with "ENGINE=MyIsam" the DB type then it will work succesfully.

回答4:

I had the same problem. Go to \installation\sql\mysql\joomla.sql and change all ENGINE=InnoDB to ENGINE=MyIsam

回答5:

Edit the SQL install file (Root/installation/SQL/mysql/joomla.sql). Open with notepad and replace all "ENGINE=InnoDB" with "ENGINE=MyIsam" the DB type then it will work successfully.

This answer has helped me a lot, Joomla works no after a long search, although I still don't now why I had to make this change in the script, does the original script work well with other users how implement Joomla?

回答6:

changing max_execution_time = 30 to 3000 worked for me for Wampserver 2.4

回答7:

To solve this issue i changed the data base password and removed the special characters, MySqli is an improved version on MySql driver so it is not recommended to change this value on the configuration, also changing to MyIsam removes the integrity of the relations and transactions, so this is also a point of considering. So if your server supports MySqli you should use this option with the default InnoDB engine.

回答8:

Just set (at php.ini)

max_execution_time = 120

works for me, on Xwampp v3.2.1

回答9:

I get this issue as well, to fix:

1. Open file installation/sql/mysql/joomla.sql
2. Replace ENGINE=InnoDb to ENGINE=MyIsam

And it works successfully.