Manager Resource not found, need help !

7 Posts

sutrah Reply #1, 14 years, 8 months ago

Hi all,

I had a problem with the site of a friend that I had installed on modx 2.0.7, the menu tree in the manager was no longer, it would not unfold. So I decided to upgrade to 2.1.5 Modx. Now my menu tree structure appears, but when I want to edit any of my pages I get the message: " Resource not found with ID :"....

I really need help, the "class key" of my pages are right in the database, I do not know how to fix this. Thank you in advance for your help.

202 Posts

Peter Bockenthien Reply #2, 14 years, 8 months ago

Dot these steps and see if it clears up the problem:

In Manager: Clear Cache, Flush Sessions, Flush All Permissions
Clear ALL files/directories in your MODX root/core/cache directory
Empty your browser's cache.

Try the site. Login to the Manager. Read the Error Report under Reports menu.

Hope that helps clear it up.

7 Posts

sutrah Reply #3, 14 years, 8 months ago

Hi, thankyou for yourhelp UltraSEF but the problem persists !

Here is the Error Report :

[2012-01-01 16:57:23] (ERROR @ /connectors/security/user.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modResource.uri' in 'field list'
)

[2012-01-01 16:57:24] (ERROR @ /connectors/security/user.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modResource.uri' in 'field list'
)

[2012-01-01 16:57:27] (ERROR @ /manager/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modResource.uri' in 'field list'
)

24,544 Posts

BobRay Reply #4, 14 years, 8 months ago

Did you run setup after copying the new files?

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting

7 Posts

sutrah Reply #5, 14 years, 8 months ago

Yes i did, the message said that the upgrade was succesfull...

No error during the upgrade process, the setup folder has been deleted....

I also stated that I can create a new document, but I can not save it, there is an error.

7 Posts

sutrah Reply #6, 14 years, 8 months ago

I found this, a problem that seems to be quite similar to mine ...

http://www.modxcms.de/forum/comments.php?DiscussionID=5253

Unfortunately, data from my sql file are not the same, I do not speak German and I do not have the sufficient level to find the correspondence.

an extract of my database:

9649, 0, 0, 0, 1308693300, 1, 'You and Allures', 0, 0, 0, 0, 0, 0, 0, 'modDocument', 'web', 1)

24,544 Posts

BobRay Reply #7, 14 years, 8 months ago

The upgrade should have created two new fields in the modx_site_content table: uri, and uri_override. Could you check in PhpMyAdmin to see if they are there (they'll be the last two fields)?

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting

7 Posts

sutrah Reply #8, 14 years, 8 months ago

Thank you Bobray
I've checked there is no uri or uri override field in the modx_site content table, it must be the problem.

I ve tried it install revo 2.1.5 again but it is still the same.

Is there a way to fix this ??

24,544 Posts

BobRay Reply #9, 14 years, 8 months ago

It kind of sounds like a bug in the upgrade code, but I haven't seen any other reports of this problem.

The fact that they are not there makes me wonder what else you might be missing.

Check to see if you have the file:

setup/includes/upgrades/mysql/2.1.0-rc-1.php

If not, see if you can find a copy of it (it should be in the 2.1.0 package) and put it there. Then run setup again and see if that fixes things. My guess is that it didn't execute during the install. If you look in the file, you'll see that it does a bunch of other necessary stuff including changes to the user table.

If that doesn't work, as a last resort you might try putting the file in place and creating a snippet with this code:

<?php
return require 'full/path/to/2.1.0-rc-1.php';

Then put a tag for that snippet on a page and preview it. I'm not guaranteeing the results though. wink

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting