Error: Main databases NOT set up successfully

Error: Main databases NOT set up successfully

de către Harald H-
Număr de răspunsuri: 4

Hi everyone,

in the first step of the moodle setup i everything is fine, in the next step i got a messege...."Error: Main databases NOT set up successfully" that is because moodlöe reports that there are several tables already existing like:

"1050: Table 'mdl_config' already exists" and so on,

if i click on continue, there is always the same screen,

instalation is not finishing,

any idea?

TIA

Harald

Media notelor: -
Ca răspuns la Harald H

Re: Error: Main databases NOT set up successfully

de către Howard Miller-
Imaginea Core developers Imaginea Documentation writers Imaginea Particularly helpful Moodlers Imaginea Peer reviewers Imaginea Plugin developers
well does it already exist?

It sounds as though your installation is clashing with another moodle install on the same mysql server. Is this possible? You can have multiple installations, but you either have to use a completely different database (and database user to be on the safe side), or change the prefix from mdl_ to something else (done in config.php).
Ca răspuns la Howard Miller

Re: Error: Main databases NOT set up successfully

de către Harald H-

thanks for the answer, but it is the only moodle installation on the server, and there the db is only for the moodle installation.

i think the problem is maybe a missconfiguration of php. i can start the installation, it setup the first set of tabelles, when i click on continue it just call the same index.php side again (not the next step), of course i get a message tables existing already.

so i guess moodle is not able to send variables to the next installation page.

actually i dont know what is the problem. there are running several complex php scripts on this server (like typo3 or phprojekt).

any idea?

thanks

Ca răspuns la Harald H

Re: Error: Main databases NOT set up successfully

de către Todd Benson-
I figured out your problem.  I had the same problem.  It is an error in the mysql.sql file.  For the table 'prefix_user_teachers', it tries to create a index by using the following syntax 'KEY UNIQUE `courseuserid` (course,userid)'.  This is incorrect and causes MySQL to error out.  Just change the line to say 'UNIQUE KEY `courseuserid` (course,userid)'.  And then it works.