We launched new forums in March 2019β€”join us there. In a hurry for help with your website? Get Help Now!
    • 43921
    • 5 Posts
    Morning chaps,

    Seeing as my provider has hit a wall and I've been unable to locate anything similar here thought I would open it up and ask if anyone has come across this little nugget? Any assistance I can pass on to them would be appreciated.

    Description of Problem:
    Building an intranet site and upon installation all appears well bar the table 'modx.site.content' isn't created therefore I am unable to add content to the site. I can create templates etc, just not documents.

    Steps to Reproduce:
    My provider has replicated the error externally and we think it is down to the charset element of the install being blank


    • MODX Version: MODX Revolution 2.2.7-pl (traditional)
    • PHP Version: 5.3.25
    • Database (MySQL, SQL Server, etc) Version: MySQL 5.6.11
    • Additional Server Info: Windows 2008 R2 Standard Addition Service Pack 1
    • Installed MODX Add-ons: None, yet, not got that far
    • Error Log Contents: (attach as file if it’s too large)

    • Whole error log reports therefore trimmed to show the last section

      [2013-05-28 17:09:07] (ERROR @ /manager/index.php) Error 42S02 executing statement:
      Array
      (
      [0] => 42S02
      [1] => 1146
      [2] => Table 'modx.modx_site_content' doesn't exist
      )

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

      • 28042 β˜† A M B β˜†
      • 24,524 Posts
      Did you create the database before installing?
        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
        • 43921
        • 5 Posts
        Morning,

        Thank you for the response, checked with the provider whom has responded with,

        "MODX install would not create Db so
        created manually using MySql and then MODX
        installed OK"

        Therein lies the issue?
          • 42602
          • 81 Posts
          For MODx to create database for tables, the mysql connection user needs to have db creation privileges. This is rarely seen with shared hosting plans (if I presume right) and the DB needs to be created manually before install of any php app really.
            • 43921
            • 5 Posts
            It's on a dedicated in-house server so there are should be no issues with it being shared hosting. I have purchased a server and configuration as per the specs through my providers whom have also installed the relevant MySQL; PHP and then loaded ModX. Evidently they came upon an issue with the database, created it and then progressed and whereas it does say completed successfully it appears not to have.

            I'm pretty sure it's a case of not being able to see the wood for the trees (as the saying goes) and will revert your comment about db creation privileges although all other tables appear to have been created which would suggest that isn't the issue?
            • discuss.answer
              • 42602
              • 81 Posts
              Oh yeah, forgot that all of the other tables were created.

              I would suggest filing a bug to bug reports. Could be something to do with the server in general, meaning support of MODx on windows host platforms.
                • 43921
                • 5 Posts
                Thanks both, appreciated.

                Will look to bug the item and also see if 2.2.6 installs with better luck.
                • discuss.answer
                  • 22303 MODX Staff
                  • 10,725 Posts
                  FYI - http://tracker.modx.com/issues/9912

                  This bug bit me on installing new on MySQL 5.6.11. Apparently there are some BC breaks in that release regarding the behavior of sql_mode=STRICT_TRANS_TABLES and/or truncating max key length. You can disable the STRICT sql_mode or correct the key length of the uri column (set to 1000 but gets auto-truncated to 333 when using utf8 collations) to install successfully.

                  I'll get a fix in for a 2.2.8 patch release shortly.
                    • 43921
                    • 5 Posts
                    Many thanks, passed to provider to resolve.
                    Much appreciated.