We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 28120
    • 380 Posts
    I've just moved a development site from nightly modx-2.2.0-dev-120711 to nightly modx-2.2.0-dev-122111 and got the warnings below. Are any of these going to cause me a problem because I'm hoping to take this site forward to full release and use in production.

    Error updating table for class modResource
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'hide_children_in_tree'
    )
    
    Error updating table for class modResource
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'hide_children_in_tree'
    )
    
    Error updating table for class modResource
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'show_in_tree'
    )
    
    Error updating table for class modResource
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'show_in_tree'
    )
    
    Error updating table for class modUser
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'primary_group'
    )
    
    Error updating table for class modUser
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'primary_group'
    )
    
    Error updating table for class modUserGroup
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'dashboard'
    )
    
    Error updating table for class modUserGroup
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'dashboard'
    )
    
    Error updating table for class modContext
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'rank'
    )
    
    Error updating table for class modContext
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'rank'
    )
    
    Error updating table for class modChunk
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static'
    )
    
    Error updating table for class modChunk
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'static'
    )
    
    Error updating table for class modChunk
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static_file'
    )
    
    Error updating table for class modChunk
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'source'
    )
    
    Error updating table for class modChunk
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'property_preprocess'
    )
    
    Error updating table for class modPlugin
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static'
    )
    
    Error updating table for class modPlugin
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'static'
    )
    
    Error updating table for class modPlugin
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static_file'
    )
    
    Error updating table for class modPlugin
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'source'
    )
    
    Error updating table for class modPlugin
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'property_preprocess'
    )
    
    Error updating table for class modSnippet
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static'
    )
    
    Error updating table for class modSnippet
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'static'
    )
    
    Error updating table for class modSnippet
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static_file'
    )
    
    Error updating table for class modSnippet
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'source'
    )
    
    Error updating table for class modSnippet
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'property_preprocess'
    )
    
    Error updating table for class modTemplate
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static'
    )
    
    Error updating table for class modTemplate
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'static'
    )
    
    Error updating table for class modTemplate
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static_file'
    )
    
    Error updating table for class modTemplate
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'source'
    )
    
    Error updating table for class modTemplate
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'property_preprocess'
    )
    
    Error updating table for class modTemplateVar
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static'
    )
    
    Error updating table for class modTemplateVar
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'static'
    )
    
    Error updating table for class modTemplateVar
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'static_file'
    )
    
    Error updating table for class modTemplateVar
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'source'
    )
    
    Error updating table for class modTemplateVar
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'property_preprocess'
    )
    
    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'
    )
    
    • Mark,

      Don't worry, those are just telling you your db already got the latest changes in tables/fields. I'd say you can safely ignore those.
        • 28120
        • 380 Posts
        Hi Romain - thanks for such a quick response!