We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 13137
    • 204 Posts
    Upon installing a clean Evo 1.1, if I check to install "Sample Web Site", I am presented with the following "Database Alerts!",
    and am unable to login. If I install without sample data, everything installs as expected.

    Anyone else experiencing this or have any ideas?


    Installing demo site: Database Alerts!

    MODX setup couldn't install/alter some tables inside the selected database.

    The following errors had occurred during installation

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO
    `modx_site_htmlsnippets` VALUES (4, 'FormSignup', 'For the weblogin signup', 0, 2, 0, ' \r\n\r\n\r\n \r\n User Details\r\n Items marked by * are required\r\n User name:* \r\n Full name: \r\n Email address:* \r\n \r\n \r\n \r\n Password\r\n Password:* \r\n Confirm password:* \r\n \r\n \r\n \r\n Optional Account Profile Info\r\n Country:\r\n \r\n \r\n Afghanistan\r\n Albania\r\n Algeria\r\n American Samoa\r\n Andorra\r\n Angola\r\n Anguilla\r\n Antarctica\r\n Antigua and Barbuda\r\n Argentina\r\n Armenia\r\n Aruba\r\n Australia\r\n Austria\r\n Azerbaijan\r\n Bahamas\r\n Bahrain\r\n Bangladesh\r\n Barbados\r\n Belarus\r\n Belgium\r\n Belize\r\n Benin\r\n Bermuda\r\n Bhutan\r\n Bolivia\r\n Bosnia and Herzegowina\r\n Botswana\r\n Bouvet Island\r\n Brazil\r\n British Indian Ocean Territory\r\n Brunei Darussalam\r\n Bulgaria\r\n Burkina Faso\r\n Burundi\r\n Cambodia\r\n Cameroon\r\n Canada\r\n Cape Verde\r\n Cayman Islands\r\n Central African Republic\r\n Chad\r\n Chile\r\n China\r\n Christmas Island\r\n Cocos (Keeling) Islands\r\n Colombia\r\n Comoros\r\n Congo\r\n Cook Islands\r\n Costa Rica\r\n Cote D'Ivoire\r\n Croatia\r\n Cuba\r\n Cyprus\r\n Czech Republic\r\n Denmark\r\n Djibouti\r\n Dominica\r\n Dominican Republic\r\n East Timor\r\n Ecuador\r\n Egypt\r\n El Salvador\r\n Equatorial Guinea\r\n Eritrea\r\n Estonia\r\n Ethiopia\r\n Falkland Islands (Malvinas)\r\n Faroe Islands\r\n Fiji\r\n Finland\r\n France\r\n France, Metropolitan\r\n French Guiana\r\n French Polynesia\r\n French Southern Territories\r\n Gabon\r\n Gambia\r\n Georgia\r\n Germany\r\n Ghana\r\n Gibraltar\r\n Greece\r\n Greenland\r\n Grenada\r\n Guadeloupe\r\n Guam\r\n Guatemala\r\n Guinea\r\n Guinea-bissau\r\n Guyana\r\n Haiti\r\n Heard and Mc Donald Islands\r\n Honduras\r\n Hong Kong\r\n Hungary\r\n Iceland\r\n India\r\n Indonesia\r\n Iran (Islamic Republic of)\r\n Iraq\r\n Ireland\r\n Israel\r\n Italy\r\n Jamaica\r\n Japan\r\n Jordan\r\n Kazakhstan\r\n Kenya\r\n Kiribati\r\n Korea, Democratic People's Republic of\r\n Korea, Republic of\r\n Kuwait\r\n Kyrgyzstan\r\n Lao People's Democratic Republic\r\n Latvia\r\n Lebanon\r\n Lesotho\r\n Liberia\r\n Libyan Arab Jamahiriya\r\n Liechtenstein\r\n Lithuania\r\n Luxembourg\r\n Macau\r\n Macedonia, The Former Yugoslav Republic of\r\n Madagascar\r\n Malawi\r\n Malaysia\r\n Maldives\r\n Mali\r\n Malta\r\n Marshall Islands\r\n Martinique\r\n Mauritania\r\n Mauritius\r\n Mayotte\r\n Mexico\r\n Micronesia, Federated States of\r\n Moldova, Republic of\r\n Monaco\r\n Mongolia\r\n Montserrat\r\n Morocco\r\n Mozambique\r\n Myanmar\r\n Namibia\r\n Nauru\r\n Nepal\r\n Netherlands\r\n Netherlands Antilles\r\n New Caledonia\r\n New Zealand\r\n Nicaragua\r\n Niger\r\n Nigeria\r\n Niue\r\n Norfolk Island\r\n Northern Mariana Islands\r\n Norway\r\n Oman\r\n Pakistan\r\n Palau\r\n Panama\r\n Papua New Guinea\r\n Paraguay\r\n Peru\r\n Philippines\r\n Pitcairn\r\n Poland\r\n Portugal\r\n Puerto Rico\r\n Qatar\r\n Reunion\r\n Romania\r\n Russian Federation\r\n Rwanda\r\n Saint Kitts and Nevis\r\n Saint Lucia\r\n Saint Vincent and the Grenadines\r\n Samoa\r\n San Marino\r\n Sao Tome and Principe\r\n Saudi Arabia\r\n Senegal\r\n Seychelles\r\n Sierra Leone\r\n Singapore\r\n Slovakia (Slovak Republic)\r\n Slovenia\r\n Solomon Islands\r\n Somalia\r\n South Africa\r\n South Georgia and the South Sandwich Islands\r\n Spain\r\n Sri Lanka\r\n St. Helena\r\n St. Pierre and Miquelon\r\n Sudan\r\n Suriname\r\n Svalbard and Jan Mayen Islands\r\n Swaziland\r\n Sweden\r\n Switzerland\r\n Syrian Arab Republic\r\n Taiwan\r\n Tajikistan\r\n Tanzania, United Republic of\r\n Thailand\r\n Togo\r\n Tokelau\r\n Tonga\r\n Trinidad and Tobago\r\n Tunisia\r\n Turkey\r\n Turkmenistan\r\n Turks and Caicos Islands\r\n Tuvalu\r\n Uganda\r\n Ukraine\r\n United Arab Emirates\r\n United Kingdom\r\n United States\r\n United States Minor Outlying Islands\r\n Uruguay\r\n Uzbekistan\r\n Vanuatu\r\n Vatican City State (Holy See)\r\n Venezuela\r\n Viet Nam\r\n Virgin Islands (British)\r\n Virgin Islands (U.S.)\r\n Wallis and Futuna Islands\r\n Western Sahara\r\n Yemen\r\n Yugoslavia\r\n Zaire\r\n Zambia\r\n Zimbabwe\r\n \r\n \r\n \r\n \r\n Bot-Patrol\r\n Enter the word/number combination shown in the image below.\r\n \r\n Form code:* \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n \r\n var id = \"[+country+]\";\r\n var f = document.websignupfrm;\r\n var i = parseInt(id); \r\n if (!isNaN(i)) f.country.options[i].selected = true;\r\n\r\n\r\n\r\nSignup completed successfully!\r\nYour account was created. A copy of your signup information was sent to your email address.\r\n', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (6, 'nl_sidebar', 'Default Template TPL for Ditto', 0, 1, 0, '[+title+]\r\n[+longtitle+]', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (8, 'ditto_blog', 'Blog Template', 0, 1, 0, '\r\n\ [+title+]\r\n By [+author+] on [+date+]. Comments\r\n ([!Jot?&docid=`[+id+]`&action=`count-comments`!])Tags: [+tagLinks+]\r\n [+summary+]\r\n [+link+]\r\n', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (9, 'footer', 'Site Template Footer', 0, 1, 0, '[(site_name)] is powered by MODX CMS |\r\n Design by Andreas Viklund\r\nDesigned by ziworks\r\n\r\n\r\n\r\nMODX - The XHTML, CSS and Ajax CMS and PHP Application Framework', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (10, 'meta', 'Site Template Meta', 0, 1, 0, 'Valid XHTML Valid css MODx', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (11, 'mh.InnerRowTpl', 'Inner row template for MODXHost top menu', 0, 1, 0, '[+wf.linktext+][+wf.wrapper+]', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (12, 'mh.InnerTpl', 'Inner nesting template for MODXHost top menu', 0, 1, 0, '\r\n [+wf.wrapper+]\r\n', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (13, 'mh.OuterTpl', 'Outer nesting template for MODXHost top menu', 0, 1, 0, ' \r\n [+wf.wrapper+]\r\n ', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (14, 'mh.RowTpl', 'Row template for MODXHost top menu', 0, 1, 0, '[+wf.linktext+][+wf.wrapper+]', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (15, 'Comments', 'Comments (Jot) showing beneath a blog entry.', 0, 1, 0, '\r\n[!Jot? &customfields=`name,email` &subscribe=`1` &pagination=`4` &badwords=`dotNet` &canmoderate=`Site Admins` !]\r\n', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (16, 'ContactForm', '', 0, 1, 0, '[+validationmessage+]\r\n\r\n\r\n\r\n \r\n Contact Form\r\n\r\n \r\n\r\n Your name:\r\n \r\n\r\n Your Email Address:\r\n \r\n\r\n Regarding:\r\n \r\n General Inquiries\r\n Press or Interview Request\r\n Partnering Opportunities\r\n \r\n\r\n Message: \r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n\r\n', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (17, 'ContactFormReport', '', 0, 1, 0, 'This is a response sent by [+name+] using the feedback form on the website. The details of the message follow below:\r\n\r\n\r\nName: [+name+]\r\nEmail: [+email+]\r\nRegarding: [+subject+]\r\ncomments:[+message+]\r\n\r\nYou can use this link to reply: [+email+]\r\n', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (18, 'reflect_month_tpl', 'For the yearly archive. Use with Ditto.', 0, 1, 0, '[+month+] [+year+]', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement REPLACE INTO `modx_site_htmlsnippets` VALUES (19, 'ContactStyles', 'Styles for form validation', 0, 1, 0, '\r\ndiv.errors{ color:#F00; }\r\n#EmailForm .invalidValue{ background: #FFDFDF; border:1px solid #F00; }\r\n#EmailForm .requiredValue{ background: #FFFFDF; border:1px solid #F00; }\r\n', 0).

    Column count doesn't match value count at row 1 during the execution of SQL statement .

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

    This question has been answered by iusemodx. See the first response.

      • 13226
      • 953 Posts
      Your problem could have to do with this report
        • 13137
        • 204 Posts
        I did a file compare of "install\setup.data.sql" between v1.0.15 and v1.1 and they are the same. :/
        • discuss.answer
          • 13226
          • 953 Posts
          You need to do the file compare with the one found in the develop branch on github - the modification was made after the 1.1 release

          You can find it here
            • 13137
            • 204 Posts
            That solved it!

            Everything installs and functions correctly now, thank you very much for the speedy reply. smiley
              • 13226
              • 953 Posts
              No problem, glad I could help.