Correct me if I am wrong, but I believe that error appears when you have no pages setup with the EpxressionEngine pages module. So this error is appearing because it is trying to do something with things that do not exist.
I do, actually, have pages set up with the Pages module. The error only appears in this particular situation:
I’m hoping that Leevi’s recommendation for a SQL change might help, but I’m still too new to EE to know where it should go …
Got a chance to give it a test driver. Great add-on to maximize Pages module. Here are my early feedbacks/questions.
My normal Static Page URL for my home page is:
http://localhost/ee/index.php/home
If I leave the field blank, it creates a page URL as:
http://localhost/home
If I create a different value “home_page”, it creates a page URL as:
http://localhost/ee/index.php/home_page
but it links to no page.
If I create same value as “home”, then the proper URL is created.
Back to the SQL error.
I made the changes you recommended to lib.lg_navigation.php (and cleared the caches) and the errors remained the same.
I’m going to try to see if the problem might be related to my earlier removal of the pages module and use of the tomes module.
If anyone else has any suggestions, I’d be oh, so grateful. This module is, potentially, the answer to my hierarchical navigation prayers …
John, you wrote:
Correct me if I am wrong, but I believe that error appears when you have no pages setup with the EpxressionEngine pages module. So this error is appearing because it is trying to do something with things that do not exist.
Now, there’s an interesting point. When I navigate to Modules > Pages, I see two pages I’ve created.
However, when I go to Edit Entry > LG Navigation, the Page Parent drop-down says “No pages have been created.”
What might be causing LG Navigation to not know I’ve created pages?
(Again, at one point, I disabled Pages and enabled Tome.)
ADDITION: When I disable LG Navigation, the errors go away and the Pages work fine. Also, I’m running 1.6.2.
John, you wrote: Now, there’s an interesting point. When I navigate to Modules > Pages, I see two pages I’ve created. However, when I go to Edit Entry > LG Navigation, the Page Parent drop-down says “No pages have been created.” What might be causing LG Navigation to not know I’ve created pages? (Again, at one point, I disabled Pages and enabled Tome.) ADDITION: When I disable LG Navigation, the errors go away and the Pages work fine. Also, I’m running 1.6.2.
Make sure you’ve chosen what weblogs you want to include the navigation in. This can be set in the Naviagtion extension setting. Then check that the pages you’ve created are in those weblogs.
Tim
Make sure you’ve chosen what weblogs you want to include the navigation in. This can be set in the Naviagtion extension setting. Then check that the pages you’ve created are in those weblogs.
Thanks. I did both of those things.
Incidentally, the edit-entry errors appear only in that weblog when its seleced in LG Navigation.
The errors don’t appear in that one when its unchecked, and they don’t appear in the other unchecked weblogs.
UPDATE: Upgraded from 1.6.2 to 1.6.3 and reinstalled module. Same error, except for one difference in the WHERE statement.
WHERE entry_id IN (465,466,464)
UPDATE: In lib.lg_navigation.php, I changed this …
WHERE entry_id IN
.. to this …
WHERE t.entry_id IN
… as you recommended. It’s now working. Don’t know if it’s related to the 1.6.3 upgrade or what but …
Working!
Hi Leevi,
First of all, thank you for starting this. It’s a huge step forward in terms of handling Navigation with the built in Pages module. A few comments if I may…
I think that as an extension, the navigation properties should be editable from with the native Pages module tab. That way there is only one step to enable or disable a page in the Navigation output.
Having a visual sorting method for the pages is paramount. Most cms’s represent the site structure in this way as it is easier for inexperienced users to understand. The benefit to developers is also significant.
To make the navigation system flawless, I believe there needs to be an option for creating items that are identified as dynamic sections (as in Mark Huots Tome module) for news or other dynamic blog sections.
Thoughts?
Thanks, Tim
Hi Leevi, First of all, thank you for starting this. It’s a huge step forward in terms of handling Navigation with the built in Pages module. A few comments if I may… 1. I think that as an extension, the navigation properties should be editable from with the native Pages module tab. That way there is only one step to enable or disable a page in the Navigation output. 2. Having a visual sorting method for the pages is paramount. Most cms’s represent the site structure in this way as it is easier for inexperienced users to understand. The benefit to developers is also significant. 3. To make the navigation system flawless, I believe there needs to be an option for creating items that are identified as dynamic sections (as in Mark Huots Tome module) for news or other dynamic blog sections. Thoughts? Thanks, Tim
I agree with #1 and #2 would be very nice.
Until this module is done or the Pages module has better functionality, I have a hack to show the pages in proper hierarchy order, combined with Mark’s Pages-Nested Menu plugin, it should do the trick for those who want to drive the site with Pages module only. See my wiki post here.
Hi Leevi, First of all, thank you for starting this. It’s a huge step forward in terms of handling Navigation with the built in Pages module. A few comments if I may… 1. I think that as an extension, the navigation properties should be editable from with the native Pages module tab. That way there is only one step to enable or disable a page in the Navigation output. 2. Having a visual sorting method for the pages is paramount. Most cms’s represent the site structure in this way as it is easier for inexperienced users to understand. The benefit to developers is also significant. 3. To make the navigation system flawless, I believe there needs to be an option for creating items that are identified as dynamic sections (as in Mark Huots Tome module) for news or other dynamic blog sections. Thoughts? Thanks, TimI agree with #1 and #2 would be very nice.
Hey guys,
I have been flat out with client work so this one has taken a bit of a back seat which is a huge shame.
1. I think that as an extension, the navigation properties should be editable from with the native Pages module tab. That way there is only one step to enable or disable a page in the Navigation output.
Maybe for version 1.1 😊
Having a visual sorting method for the pages is paramount. Most cms’s represent the site structure in this way as it is easier for inexperienced users to understand. The benefit to developers is also significant.
For sure… I think this is a given currently you can sort the pages and the code for the nested loops is complete. The front end needs to be implemented.
. To make the navigation system flawless, I believe there needs to be an option for creating items that are identified as dynamic sections (as in Mark Huots Tome module) for news or other dynamic blog sections.
To be honest this comment really took the wind out of my sails. :( You are absolutely correct but to implement this would be alot of work. While doing some research I found: http://wordpress.org/extend/plugins/wordpress-navigation-list-plugin-navt/screenshots/ which looks like the perfect functionality. I’ll try and incorporate something like this for a future version.
Cheers Leevi
Any updates for us Levi? 😊
Not really… I got sidetracked with LG Quarantine and LG File Manager… and a million other client projects.
Honestly although I have the basics of this module down, its such a big project I’m not sure it can be completed on time before EE 2.0. I’ll try but there are no promises.
As it stands the module can nest pages quite effectivley, ordering is a little trickey but if your setting up the nav as a once off it shoudl be ok.
Wish me luck
Is this module stripping out the index.php in the URL for the auto generated menus for anyone else? I would love to remove it but as luck goes the server that it is doing on is not working properly with htaccess to remove the index.php. In this situation I cannot change hosts. Not sure which will take longer, figuring out why htaccess is not working or why the index.php is being stripped out by the module when building the menus.
All the other paths on the site output the index.php but not the auto generated nav menu.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.