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

    I am halfway through the Revolution setup. When I get to the Connection character set I get this message:

    Checking database: MODX could not create your database. Please manually create your database and then try again.

    I have set to utf8, and utf8_general_ci. I have gone into phpMyAdmin and the server connection collation is set to utf8_geberal_ci so not sure why I am getting this message? Any help appreciated please

    Regards,

    DS

    This question has been answered by multiple community members. See the first response.

      www.PawsForWildlife.co.uk
      www.Borntobrick.co.uk
      • 3749
      • 24,544 Posts
      On many servers, you have to create the MODX database yourself before running Setup. This is because the host doesn't allow databases to be created in code.
        Did I help you? Buy me a beer
        Get my Book: MODX:The Official Guide
        MODX info for everyone: http://bobsguides.com/modx.html
        My MODX Extras
        Bob's Guides is now hosted at A2 MODX Hosting
        • 7527
        • 437 Posts
        I have created a database with 1and1, and set the server connection collation in phpMyAdmin before the setup. Is that what you mean?
          www.PawsForWildlife.co.uk
          www.Borntobrick.co.uk
          • 3749
          • 24,544 Posts
          Yes. The error probably means that you gave the wrong name for the database in Setup. Hosts often add a prefix to the name you entered. You can see the true name of the DB in cPanel. While you're there, double-check the database username as well and make sure you created a database user with full rights to the DB.
            Did I help you? Buy me a beer
            Get my Book: MODX:The Official Guide
            MODX info for everyone: http://bobsguides.com/modx.html
            My MODX Extras
            Bob's Guides is now hosted at A2 MODX Hosting
            • 7527
            • 437 Posts
            I have checked my control panel. The database host is correct, the database login and password is correct. When I hit test I get :

            Connecting to database server: Success!
            
            - Checking MySQL server version: OK! Running: 5.5.46-0+deb7u1-log 
            - Checking MySQL client version: OK! Running: 5.0.11-20120503-$Id:15d5c781cfcad91193dceae1d2cdd127674ddb3e$


            Set Connection char set and collation to utf8, utf8_general_ci and still get the error. phpMyAdmin is set for utf8_general_ci. I really don't understand where the error is as all info is entered correctly?
            Regards

            DS
              www.PawsForWildlife.co.uk
              www.Borntobrick.co.uk
              • 7527
              • 437 Posts
              Ok got past this issue, created an administrator user name and password and then got hit with this message:

              Warning: strftime(): Invalid date.timezone value 'Europe/England', we selected the timezone 'UTC' for now. in /homepages/10/d568633693/htdocs/setup/includes/modinstall.class.php on line 463

              Warning: strftime(): Invalid date.timezone value 'Europe/England', we selected the timezone 'UTC' for now. in /homepages/10/d568633693/htdocs/setup/includes/modinstall.class.php on line 191

              Warning: Cannot modify header information - headers already sent by (output started at /homepages/10/d568633693/htdocs/setup/includes/modinstall.class.php:463) in /homepages/10/d568633693/htdocs/setup/includes/request/modinstallrequest.class.php on line 235

              Any ideas?
              DS
                www.PawsForWildlife.co.uk
                www.Borntobrick.co.uk
              • discuss.answer
                • 28042 ☆ A M B ☆
                • 24,524 Posts
                Somewhere the PHP date.timezone is set to be Europe/England, which is not a valid setting.
                http://php.net/manual/en/timezones.europe.php

                The business about the headers already being sent is from MODX and PHP both trying to send the error message and stepping on each other.
                  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
                  • 7527
                  • 437 Posts
                  Thank you Sottwell. I have returned to the setup this morning and I now cannot get to the setup page because of this message:

                  FATAL ERROR: MODX Setup cannot continue.
                  
                  To use PHP 5.3.0+, you must set the date.timezone setting in your php.ini. Please do set it to a proper timezone before proceeding. A list can be found here.


                  I have a php.ini file in my root, and in my setup file with the following line in:

                  date.timezone = Europe/London


                  So I am not sure why I cannot proceed?
                  Regards,
                  DS [ed. note: distant_smile last edited this post 10 years, 7 months ago.]
                    www.PawsForWildlife.co.uk
                    www.Borntobrick.co.uk
                  • discuss.answer
                    • 7527
                    • 437 Posts
                    I did a fresh install of Revo, re-added the php.ini file and all is well.
                      www.PawsForWildlife.co.uk
                      www.Borntobrick.co.uk