Error: Main databases NOT set up successfully

Error: Main databases NOT set up successfully

von Harald H -
Anzahl Antworten: 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

Mittelwert: -
Als Antwort auf Harald H

Re: Error: Main databases NOT set up successfully

von Howard Miller -
Nutzerbild von Core developers Nutzerbild von Documentation writers Nutzerbild von Particularly helpful Moodlers Nutzerbild von Peer reviewers Nutzerbild von 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).
Mittelwert: -
Als Antwort auf Howard Miller

Re: Error: Main databases NOT set up successfully

von 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

Mittelwert: -
Als Antwort auf Harald H

Re: Error: Main databases NOT set up successfully

von 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.
Mittelwert: -