hi guys, I’m also having this error after hitting the quick save button when I publish an item:
MySQL ERROR:
Error Number: 1064
Description: 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 ‘LIMIT 1’ at line 1
Query: SELECT * FROM exp_weblog_titles
WHERE entry_id = LIMIT 1
Strang thing is that the item is published when I go to the edit tab. Running php version 5.2.3 and EE version 1.6.6
I’m running the latest version 1.0.3 It only happens when I hit quick save. The normal save button works fine.
I was thinking, isn’t it smart when you’re typing the title in the publish tab to copy the url field in the structure url field? By default, so you can modify this by hand if you want.
P.S. Really like your extension, great piece of work!
I just downloaded this last night and gave it a whirl. In principle it looks like a really handy module. Installation went well, and I followed all the instructions on your http://www.ngenworks.com/software/ee/structure/ site.
I am running into some rather major issues that are suggesting I uninstall and revert to db backup i made before.
Before doing this, I thought I’d post here with hopes of getting some guidance in getting this to work!
Issue 1 When I edit/publish a new entry, I put in the uri on the Structure tab. When I save/update it and then go back to look at the structures tab, the form is blank/reset- none of my settings seem to be sticking! Also- these entries do not show up in the Modules/Structure page either.
It worked for 3 of my entries, but no others…
Issue 2 In the settings tab, when I click on Listing, and then go to select a channel, only 6 channels appear. Is this a limitation of the module? I cannot select any other channels (which happen to be the ones I wanted to work with). Is there some setting in the channel prefs that would cause them to NOT show up in this drop down menu?
Hopefully you can help me out with this- as I’d like to get it working.
thanks,
Rowan
I’m getting the following error. I have php 5, have installed the latest version of Structure, and never installed the pages module:
MySQL ERROR:
Error Number: 1146
Description: Table 'myDB.exp_pages_configuration' doesn't exist
Query: SELECT configuration_value FROM exp_pages_configuration WHERE configuration_name = 'template_weblog_3' AND site_id = '1'
Any ideas? Thanks for all the work on this by the way….
Edit: It’s only happening on one weblog, strangely…
Thanks for fixing that Travis!
Is there some way to output the whole site structure as nested ULs and LIs? The {exp:structure:nav_sub} tag just outputs information depending on the page you’re currently looking at. I want to build the entire menu structure– all the pages and subpages, with proper nesting.
How are people doing this? Is there a plan for a tag for this (or one I’m missing)?
Thanks, Matt
After some strugling the last time I reinstalled the site on a subdomain and now the Structure Module works much better!
But I have one little thing…
To use the listings option you have to publish a page using that weblog and than select the webog you want to list.
That’s what I did but now when I go to this page I don’t see any post: http://jhs.ischagast.nl/nieuws/
I used this code:
{exp:weblog:entries weblog="{template_group}" limit="1" disable="categories|member_data|pagination|trackbacks"}
<div class="article_header">
<h1>{title} <span>{entry_date format="%d %F %Y"}</span></h1>
</div><!-- /article_header -->
{body_nieuws}
{/exp:weblog:entries}
When I go to this page I see the post I want: http://jhs.ischagast.nl/nieuws/index/
And when remove that template that’s used for the listning everything works just fine, but that not what you want because every new post will be shown in the structure tab.
I hope someone knows what I am doing wrong.
Maybe a new feature: Some other thing that would be really great is that it would be possible to generate a sitemap from the pages you see in your structure tab. That would be really awsome 😉
@IschaGast anything that is multi-entry, like a news section or a blog needs to be added as a “listing” so that it doesn’t show up in the sitemap view. When selecting the weblog for a structural page, you would select something other than this “listing” weblog. Hope that makes sense. I think you need to read these instructions: http://www.ngenworks.com/software/ee/structure/#add-listing it will help get your head around the difference between regular and “listing” pages.
argh, I just kind of assumed that my host (the otherwise wonderful enginehosting) would be on the latest version of php, but I’m stuck with php 5.1.6 (in fairness they do however give very good reasons for not upgrading yet). I’m wondering if there are any modifications I can make to get Structure working on php 5.1.6?
James
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.