Cant edit or change files across the CMS

[howey]

Hi

I keep a domain on my server solution to test and develop sites before moving them to the live domain. I usually install these in sub directories.

I have recently developed a site on this server solution under a sub directory. The site works fine on the testdomain/subdirectory.

On copying the database tables to the live installation, the site works and is viewable but I can't change anything in the CMSMS. I get error messages, the following is when I tried to change the footer template (I have removed a few lines of code with the tel and address on etc).

Code: Select all

UPDATE gf_layout_templates SET name = '00_footer', content = '<div class=\"footer-bg\">\r\n<div class=\"container\">\r\n <div class=\"row\"></div>\r\n <div class=\"col-lg-12\">\r\n <div class=\"col-lg-12\">\r\n <p><strong>Green Frog Power Ltd</strong></p>\r\n Birmingham&nbsp;B46&nbsp;1JA&nbsp;UK</p>\r\n </div>\r\n </div>\r\n </div>\r\n</div>', description = '', type_id = 2, type_dflt = NULL, category_id = NULL, owner_id = 1, listable = 0, modified = 1461141097 WHERE id = '18' -- Unknown column 'listable' in 'field list'

I'll attache the system information for both installations, the main difference is the CMS version, the test installation is 2.0.1.1 the live version is 2.1.1.

Test system info

Code: Select all

----------------------------------------------

Cms Version: 2.0.1.1

Installed Modules:

    AdminSearch: 1.0
    CMSContentManager: 1.0.1
    DesignManager: 1.0.1
    FileManager: 1.5.1
    MicroTiny: 2.0
    ModuleManager: 2.0
    Navigator: 1.0.1
    News: 2.50.1
    Search: 1.50.1


Config Information:

    php_memory_limit:
    max_upload_size: 64000000
    url_rewriting: none
    page_extension:
    query_var: page
    auto_alias_content: true
    locale:
    set_names: true
    timezone: Europe/London
    permissive_smarty: false


Php Information:

    phpversion: 5.5.33
    md5_function: On (True)
    json_function: On (True)
    gd_version: 2
    tempnam_function: On (True)
    magic_quotes_runtime: Off (False)
    E_STRICT: 0
    E_DEPRECATED: 0
    test_file_timedifference:
    test_db_timedifference:
    memory_limit: 128M
    max_execution_time: 30
    output_buffering: 4096
    file_uploads: On (True)
    post_max_size: 64M
    upload_max_filesize: 64M
    session_save_path: /tmp (1777)
    session_use_cookies: On (True)
    xml_function: On (True)
    xmlreader_class: On (True)


Performance Information:

    allow_browser_cache: Off (False)
    browser_cache_expiry: 60
    php_opcache: Off (False)
    smarty_cache: Off (False)
    smarty_compilecheck: Off (False)
    smarty_cache_udt: Off (False)
    auto_clear_cache_age: On (True)

Server Information:

    Server Api: cgi-fcgi
    Server Db Type: MySQL (mysql)
    Server Db Version: 10.0.22
    Server Db Grants: Could not find a suitable "GRANT ALL" permission, this does not necessarily lead to problems... But if you have problems installing/removing modules or adding and deleting items/pages this could be the cause!
    Server Time Diff: No file system time difference found


----------------------------------------------

Live version

Code: Select all

CMS Made Simple
CMS Made Simple™ Admin Console - XXX - System Information
My Account Welcome: Paul Cooper

    Documentation
    My Account
    View Site
    Logout

 
Open/Close
 
You have 1 unhandled notification
 

    CMS
    Open/Close CMS
    Content
    Open/Close Content
    Layout
    Open/Close Layout
    User Management
    Open/Close User Management
    Extensions
    Open/Close Extensions
    Site Admin
    Open/Close Site Admin
        Module Manager
        Settings - Content Manager
        Settings - Design Manager
        Settings - Global Settings
        Settings - News module
        System Maintenance
        System Information
        System Verification
        Admin Log
    My Preferences
    Open/Close My Preferences

System Information
Drop files here to upload
Open/Close
Please copy and paste this selected text into your forum posting

----------------------------------------------

Cms Version: 2.1.1

Installed Modules:

    AdminSearch: 1.0
    CMSContentManager: 1.0.1
    DesignManager: 1.0.1
    FileManager: 1.5.1
    MicroTiny: 2.0
    ModuleManager: 2.0
    Navigator: 1.0.1
    News: 2.50.1
    Search: 1.50.1


Config Information:

    php_memory_limit:
    max_upload_size: 64000000
    url_rewriting: none
    page_extension:
    query_var: page
    auto_alias_content: true
    locale:
    set_names: true
    timezone: Europe/London
    permissive_smarty: false


Php Information:

    phpversion: 5.5.33
    md5_function: On (True)
    json_function: On (True)
    gd_version: 2
    tempnam_function: On (True)
    magic_quotes_runtime: Off (False)
    E_STRICT: 0
    E_DEPRECATED: 0
    test_file_timedifference: No time difference found
    test_db_timedifference: No time difference found
    create_dir_and_file: 1
    memory_limit: 128M
    max_execution_time: 30
    register_globals: Off (False)
    output_buffering: 4096
    disable_functions:
    open_basedir:
    test_remote_url: Success
    file_uploads: On (True)
    post_max_size: 64M
    upload_max_filesize: 64M
    session_save_path: /tmp (1777)
    session_use_cookies: On (True)
    xml_function: On (True)
    xmlreader_class: On (True)
    check_ini_set: On (True)
    curl: On


Performance Information:

    allow_browser_cache: Off (False)
    browser_cache_expiry: 60
    php_opcache: Off (False)
    smarty_cache: Off (False)
    smarty_compilecheck: Off (False)
    smarty_cache_udt: Off (False)
    auto_clear_cache_age: On (True)

Server Information:

    Server Software: Apache/2.4.18 (Unix)
    Server Api: cgi-fcgi
    Server Os: Linux 2.6.32-042stab111.11 On x86_64
    Server Db Type: MySQL (mysql)
    Server Db Version: 10.0.22
    Server Db Grants: Could not find a suitable "GRANT ALL" permission, this does not necessarily lead to problems... But if you have problems installing/removing modules or adding and deleting items/pages this could be the cause!


Permission Information:

    tmp: /home/cluster-sites/910/g/greenfrogpower.co.uk/public_html/tmp (0755)
    tmp_cache: /home/cluster-sites/910/g/greenfrogpower.co.uk/public_html/tmp/cache (0755)
    templates_c: /home/cluster-sites/910/g/greenfrogpower.co.uk/public_html/tmp/templates_c (0755)
    modules: /home/cluster-sites/910/g/greenfrogpower.co.uk/public_html/modules (0755)
    uploads: /home/cluster-sites/910/g/greenfrogpower.co.uk/public_html/uploads (0755)
    File Creation Mask (umask): /home/cluster-sites/910/g/greenfrogpower.co.uk/public_html/tmp/cache (0755)
    config_file: 0444

----------------------------------------------
 
Copyright © CMS Made Simple™ 2.1.1 “Nicholls Town”

    Documentation
    Forums
    About
    Team

The only problem I can see is the

Server Db Grants: Could not find a suitable "GRANT ALL" permission, this does not necessarily lead to problems... But if you have problems installing/removing modules or adding and deleting items/pages this could be the cause!

But this is common to both installations?

My only other thought was that I was introducing an error on copying the tables using MyPHPAdmin.

Any advice/help gratefully received.

[velden]

Not sure if I understand correctly:
You are using a database created on a 2.0.1.1 CMSMS installation (test) in a 2.1.1 CMSMS installation (2.1.1).

If so: unsupported.

[howey]

Hi

Would the best option be to upgrade the test site to 2.1.1 and then copy the DB tables across?

Just so I understand, does the MySQL structure/schema change with the upgrade? With every problem, I try to understand what went wrong so I increase my knowledge. Hopefully, I will make fewer errors in the future.

Much appreciate your help.

[paulbaker]

Just so I understand, does the MySQL structure/schema change with the upgrade?

Yes it may do. Basically you should always keep site files and database upgraded together to the same version.

The upgrade process is described here:
http://docs.cmsmadesimple.org/upgrading ... nformation