We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 23917
    • 2 Posts
    Hi,

    When i,m trying to install modx on my local server then following error showing in database connection test. Can anyone solve this matter.......


    Connection to host: passed... Checking database: failed - modx does not exist!

    Thanks,

    Programmer_Kohli
    • Did you already create the database named ’modx’? If you did not, the install program will try to create it for you. If the database user you specified does not have "create database" permissions, you will have to manually create the database before you can proceed with the installation.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 23917
        • 2 Posts
        Quote from: sottwell at Apr 06, 2006, 06:48 AM

        Did you already create the database named ’modx’? If you did not, the install program will try to create it for you. If the database user you specified does not have "create database" permissions, you will have to manually create the database before you can proceed with the installation.

        Well Thanks for that & i appreciate for that but still it’s showing error. After creating a manual database & defining that, connection is successfuly tested but when at last click for installation then it show some errors, Can u solve that again :

        Creating database tables: Database Alerts!

        MODx setup couldn’t install/alter some tables inside the selected database.

        The following errors had occurred during installation


        These are upper & below head error statements, inside these statements a lot of sql errors statements.

        MySQL server has gone away during the execution of SQL statement .

        Some tables were not updated. This might be due to previous modifications.


        Thanks,

        Programmer Kohli
        • Is the database you are installing to a non-English MySQL installation? If this is true, open the sqlParser.class.php file in the Install folder and replace these lines, near the bottom of the file:
          				// Ignore duplicate and drop errors - Raymond 
          				if ($this->ignoreDuplicateErrors){
          					if (eregi('^duplicate key', mysql_error()) || (eregi('^alter', $sql_do) && eregi('^duplicate', mysql_error()))) continue;
          					if (eregi('^can\'t drop', mysql_error()) || (eregi('^alter', $sql_do) && eregi('^can\'t drop', mysql_error()))) continue;
          				}
          				// End Ignore duplicate

          with these:
          				// Ignore duplicate and drop errors - Raymond 
          				if ($this->ignoreDuplicateErrors){
          					if (mysql_errno() == 1060 || mysql_errno() == 1061 || mysql_errno() == 1091) continue;
          				}
          				// End Ignore duplicate


          You will need to empty the database and start over. This "fix" has been included in the next (0.9.1) release.
            Studying MODX in the desert - http://sottwell.com
            Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
            Join the Slack Community - http://modx.org