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

    after haven`t working on my page for some days, I logged in again and as a surprise - all ressources under the "web"-tree were gone! You can see this with the attached image.
    I could browse the page, so they should not be deleted at all.

    Also i can see all my snippets, chunks etc. No problem.
    Havent changed anything i can remember.

    When browsing the error-log some weired errors are show up:

    ERROR @ /modx/connectors/resource/index.php) Error 42S22 executing statement:
    error: 42S22 1054
    "Unknown column 'modResource.hide_children_in_tree' in 'field list'"

    and: "Unknown column 'modResource.show_in_tree' in 'where clause"

    I also havent check all of the permissions for the admin, the namespace, disabled packaged like Tinymce and flushed all cached i could found. Even i deleted the cache-folder on my harddisc and of course the browser cache.

    After read some hints here in the forum i found several tables in my db which need to be repaired. After successfully done that, the error was not resolved.

    Any suggestions?
    Thanks!

    -----------------------------
    Web Server:
    * PHP xampp latest stable 1.7.4
    * Apache 2.0
    * Win7 64bit

    Database:
    * MySQL version: 5.0.7-dev - 091210

    MODx:
    * Version: MODX Revolution 2.2.0-rc1 (traditional)
    * Any plugins you're running:

    Browser/Client:
    * Firefox 8, Opera, IE9 [ed. note: peterlicht last edited this post 14 years, 11 months ago.]