Removing "Title" field results in error
3 posts by 2 authors in: Forums > CMS Builder
Last Post: June 21, 2008 (RSS)
Hello. This is probably something really simple. But as I'm completely out of ideas now, I thought I'd seek some advice. :-)
I am trying to remove the "title" field from an "About Us" page. I am only allowing the client to change the content from a plain text box and want to keep it as straight forward as possible for them. So, I only want the "content" text box visible in their CMS Editor Window. I deleted the "uploads" item and it disappeared from the CMS Editor window nicely. But, for some reason, when I try to remove the "title" item, I get the following error:
getRecords(about_us) MySQL Error: Unknown column 'title' in 'order clause'
I also tried changing the field type to "none" so that the field would still exist, but then it would not be visible in the client's CMS Editor window. But, I get the same error.
Unfortunately, it appears that the item not only has to exist, but the field also has to appear on the Editor page to keep from getting the error. I also tried starting from scratch, building a "single" menu type so as to only include a "content" field, thinking that would keep the code from looking for it. But, it looks like you get a "title" field by default, even when building from the ground up.
Finally, since I'm sure the error is being caused by the "Sort Order" looking for the "title" field, I tried to change the sort type (or delete it completely). However, since I'm using a "single" menu type, and not a "multi", it appears that I do not have access to the "sorting" tab in order to make that change.
Any ideas? Thanks so much, in advance, for the help.
Jeremy
I am trying to remove the "title" field from an "About Us" page. I am only allowing the client to change the content from a plain text box and want to keep it as straight forward as possible for them. So, I only want the "content" text box visible in their CMS Editor Window. I deleted the "uploads" item and it disappeared from the CMS Editor window nicely. But, for some reason, when I try to remove the "title" item, I get the following error:
getRecords(about_us) MySQL Error: Unknown column 'title' in 'order clause'
I also tried changing the field type to "none" so that the field would still exist, but then it would not be visible in the client's CMS Editor window. But, I get the same error.
Unfortunately, it appears that the item not only has to exist, but the field also has to appear on the Editor page to keep from getting the error. I also tried starting from scratch, building a "single" menu type so as to only include a "content" field, thinking that would keep the code from looking for it. But, it looks like you get a "title" field by default, even when building from the ground up.
Finally, since I'm sure the error is being caused by the "Sort Order" looking for the "title" field, I tried to change the sort type (or delete it completely). However, since I'm using a "single" menu type, and not a "multi", it appears that I do not have access to the "sorting" tab in order to make that change.
Any ideas? Thanks so much, in advance, for the help.
Jeremy
---------------------------
Dwelling Productions
www.dwellingproductions.com
Dwelling Productions
www.dwellingproductions.com
Re: [dwelling] Removing "Title" field results in error
By Dave - June 21, 2008
Hi Jeremy,
Thanks for reporting this. Here's how to fix it.
- Open up /data/schema/about_us.ini.php
- Search for this line: listPageOrder = "title"
- And replace it with this (remove title): listPageOrder = ""
I'll fix that for the next release as well. It shouldn't happen when you create a custom "single" menu, but if you need to change the presets you can find them in /data/schemaPresets/ and they're in the same format.
Hope that helps, let me know if you need anything else or if you run into any other problems!
Thanks for reporting this. Here's how to fix it.
- Open up /data/schema/about_us.ini.php
- Search for this line: listPageOrder = "title"
- And replace it with this (remove title): listPageOrder = ""
I'll fix that for the next release as well. It shouldn't happen when you create a custom "single" menu, but if you need to change the presets you can find them in /data/schemaPresets/ and they're in the same format.
Hope that helps, let me know if you need anything else or if you run into any other problems!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com
Re: [Dave] Removing "Title" field results in error
By dwellingproductions - June 21, 2008 - edited: June 21, 2008
Ah, that's it! Thank you so much.
Yes, for now, I'll just delete from the schemaPresets folder as well and that should keep all future sections from having that issue.
Much appreciated!
Jeremy
Yes, for now, I'll just delete from the schemaPresets folder as well and that should keep all future sections from having that issue.
Much appreciated!
Jeremy
---------------------------
Dwelling Productions
www.dwellingproductions.com
Dwelling Productions
www.dwellingproductions.com