We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 1441
    • 61 Posts
    Hello there.

    After a search, I seem to be unable to rectify a problem with the upgrade. Each time a page is loaded (with limited success - i.e. wayfinder and other snippets don't work) I get a whole error log full of the following:

    [2012-01-06 16:53:59] (ERROR @ /index.php) Error 42S02 executing query: SELECT `modChunk`.`id` AS `modChunk_id`, `modChunk`.`source` AS `modChunk_source`, `modChunk`.`property_preprocess` AS `modChunk_property_preprocess`, `modChunk`.`name` AS `modChunk_name`, `modChunk`.`description` AS `modChunk_description`, `modChunk`.`editor_type` AS `modChunk_editor_type`, `modChunk`.`category` AS `modChunk_category`, `modChunk`.`cache_type` AS `modChunk_cache_type`, `modChunk`.`snippet` AS `modChunk_snippet`, `modChunk`.`locked` AS `modChunk_locked`, `modChunk`.`properties` AS `modChunk_properties`, `modChunk`.`static` AS `modChunk_static`, `modChunk`.`static_file` AS `modChunk_static_file`, `Source`.`id` AS `Source_id`, `Source`.`name` AS `Source_name`, `Source`.`description` AS `Source_description`, `Source`.`class_key` AS `Source_class_key`, `Source`.`properties` AS `Source_properties`, `Source`.`is_stream` AS `Source_is_stream` FROM `modx_site_htmlsnippets` AS `modChunk` LEFT JOIN `modx_media_sources` `Source` ON `modChunk`.`source` = `Source`.`id` WHERE `modChunk`.`name` = ? ORDER BY `modChunk`.`id` ASC  - Array
    (
        [0] => 42S02
        [1] => 1146
        [2] => Table 'xxxxx_master.modx_media_sources' doesn't exist
    )
    
    [2012-01-06 16:53:59] (ERROR @ /index.php) Error 42S02 executing query: SELECT `modChunk`.`id` AS `modChunk_id`, `modChunk`.`source` AS `modChunk_source`, `modChunk`.`property_preprocess` AS `modChunk_property_preprocess`, `modChunk`.`name` AS `modChunk_name`, `modChunk`.`description` AS `modChunk_description`, `modChunk`.`editor_type` AS `modChunk_editor_type`, `modChunk`.`category` AS `modChunk_category`, `modChunk`.`cache_type` AS `modChunk_cache_type`, `modChunk`.`snippet` AS `modChunk_snippet`, `modChunk`.`locked` AS `modChunk_locked`, `modChunk`.`properties` AS `modChunk_properties`, `modChunk`.`static` AS `modChunk_static`, `modChunk`.`static_file` AS `modChunk_static_file`, `Source`.`id` AS `Source_id`, `Source`.`name` AS `Source_name`, `Source`.`description` AS `Source_description`, `Source`.`class_key` AS `Source_class_key`, `Source`.`properties` AS `Source_properties`, `Source`.`is_stream` AS `Source_is_stream` FROM `modx_site_htmlsnippets` AS `modChunk` LEFT JOIN `modx_media_sources` `Source` ON `modChunk`.`source` = `Source`.`id` WHERE `modChunk`.`name` = ? ORDER BY `modChunk`.`id` ASC  - Array
    (
        [0] => 42S02
        [1] => 1146
        [2] => Table 'xxxxx_master.modx_media_sources' doesn't exist
    )
    


    It seems database related... is there any way I can try to re-upgrade or check the database integrity?

    (Thank you!) [ed. note: anablepo last edited this post 12 years, 4 months ago.]
      • 28215
      • 4,149 Posts
      Definitely try to re-upgrade. That table should exist.
        shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
        • 1441
        • 61 Posts
        Ok. (Thanks for the reply)

        I dumped the "Upgraded" database tables and and restored the pre-upgrade tables and re-ran the setup. It generated the following errors:

        Error updating table for class sources.modMediaSource
        Array
        (
        [0] => 42S21
        [1] => 1060
        [2] => Duplicate column name 'is_stream'
        )
        
        Error updating table for class sources.modMediaSource
        Array
        (
        [0] => 42000
        [1] => 1061
        [2] => Duplicate key name 'is_stream'
        )
        
        Error updating table for class modDashboard
        Array
        (
        [0] => 42S21
        [1] => 1060
        [2] => Duplicate column name 'hide_trees'
        )
        
        Error updating table for class modDashboard
        Array
        (
        [0] => 42000
        [1] => 1061
        [2] => Duplicate key name 'hide_trees'
        )
        


        ...but the site seems to be working fine. Is this something to be concerned about?

        (thank you SO much.)
          • 28215
          • 4,149 Posts
          Nope.
            shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
            • 1441
            • 61 Posts
            Neat. Thank you very much!