Hi everyone,
It seems that i'm having trouble with my website, for some reason the whole resource list disappeared from modx. Ive checked the database and everything is there, though i had to fix the tables first (I thought this was the problem.) My filebrowser is just working, and i didn't do anything weird to my permissions. I checked the permissions and made sure that they were the same as the permissions from another website of me.
I have tried reinstallingen for like 3 times already, and even did an upgrade to the latest 2.2.4 version of modx unfortunately without any succes.
I get this error in error log:
[2012-07-02 09:17:08] (ERROR @ /connectors/resource/event.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.hide_children_in_tree' in 'field list'
)
[2012-07-02 09:17:09] (ERROR @ /connectors/resource/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.show_in_tree' in 'where clause'
)
[2012-07-02 09:17:14] (ERROR @ /connectors/resource/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.show_in_tree' in 'where clause'
)
[2012-07-02 09:18:08] (ERROR @ /connectors/resource/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.show_in_tree' in 'where clause'
)
[2012-07-02 09:26:36] (ERROR @ /connectors/resource/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.show_in_tree' in 'where clause'
)
[2012-07-02 09:27:39] (ERROR @ /connectors/security/user.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.hide_children_in_tree' in 'field list'
)
[2012-07-02 09:27:39] (ERROR @ /connectors/resource/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.show_in_tree' in 'where clause'
)
[2012-07-02 09:33:09] (ERROR @ /connectors/system/activeresource.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.hide_children_in_tree' in 'field list'
)
[2012-07-02 09:33:09] (ERROR @ /connectors/resource/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modResource.show_in_tree' in 'where clause'
)
My server settings:
MySQL - 5.1.63 (UTF8 Set)
PHP - 5.2.17
MODX Revolution 2.2.4-pl (traditional)
Im looking forward to hear from you guys! Thanks in advance.
Greetings,
Nick
The first thing to try is manually deleting all the files in the core/cache directory and clearing your browser cache and cookies.
If that doesn't do it, try turning off the compress_js and compress_css system settings.
------------------------------------------------------------------------------------------
PLEASE, PLEASE specify the version of MODX you are using.
MODX info for everyone:
http://bobsguides.com/modx.html
Hi BobRay,
First off thanks for your quick reply, i appreciate!
Unfortunately we have bin unable to get it working even after doing what you described, we found a snippet which was supposed to work but i'm not taking the risk yet. Do you have any ideas left?
Thanks in advance,
Nick
Is the whole Resource tab missing, or just the resources in it?
Have you messed with the MODX security system at all (e.g., created Resource Groups)?
------------------------------------------------------------------------------------------
PLEASE, PLEASE specify the version of MODX you are using.
MODX info for everyone:
http://bobsguides.com/modx.html
Hi BobRay,
I had this problem after i've saved a document, it kept on loading and ended with an error (Not sure what error it was) Than me resource list was gone and i had several other errors which i fixed already, but the resources (So not the tab it self) are still gone. I also thought it had something to do with the permissions so i cross checked it with another website to make sure everything was set properly and this was the case. All the users are in the administrator group, and not in a resource group. I'm also stunned cause i really thought it had something to do with it, but for as i can see all the settings match with those of an other site.
Thanks,
Nick
Make sure the Administrator group has a Context Access ACL entry with a context of 'web'. Without it, you can log in, but you can't see web resources in the tree.
Also, update your User Profile and make yourself a sudo user to see if that makes a difference.
If none of that works, the next thing to try would be repairing the tables in PhpMyAdmin.
------------------------------------------------------------------------------------------
PLEASE, PLEASE specify the version of MODX you are using.
MODX info for everyone:
http://bobsguides.com/modx.html
