[2009-09-25 15:16:36] (ERROR @ /index.php) No foreign key definition for parentClass: modResource using relation alias: modResourceGroupResource
[2009-09-25 15:16:36] (ERROR @ /index.php) Error SQLER executing statement:
Array
(
[0] => SQLER
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `modResource`.`hidemenu` = 0 AND `modResource`.`privateweb` = 0 AND modRes' at line 1
)
MODX Staff
$c->leftJoin('modResourceGroupResource','modResourceGroupResource');$c->leftJoin('modResource.groupResource','modResource.groupResource');[2009-09-25 16:14:30] (ERROR @ /index.php) Could not load class: groupResource from modResource.mysql.groupresource.
I changed the line to the following, and the menus started working:
$c->leftJoin('modResource.groupResource','modResource.groupResource');
However, I am still getting an error in the log (a different one):
[2009-09-25 16:14:30] (ERROR @ /index.php) Could not load class: groupResource from modResource.mysql.groupresource.
$c->leftJoin('modResourceGroupResource',"ResourceGroupResources");
MODX Staff
You are missing the required base tag in your template HEAD. i.e.
My other problem now is friendly URLS in the menu don’t work.
All links generated are relative - which is fine if you are at a top level. As soon as you click on [www.site.com/container/] all your links from there break... e.g. what should be [www.site.com/page1.html] becomes [www.site.com/container/page1.html] and so forth.
<base href="[[!++site_url]]"></base>
All text/html Resources that are indicated as containers get the container_suffix setting appended instead of the extension specified in the Resource’s specified Content Type. FURLs in Revolution are a bit different than in Evolution.
Also of note: even if you turn off "Friendly Alias Path", containers are still rendered out as [container/] instead of [container.html] (which means they break immediately).