Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-04-06 17:22:31
- NotMuch
- New Member
- Registered: 2007-04-06
- Posts: 7
Custom Fields
Does anyone know where custom_field tags for each article are stored in the database. Textpattern was installed as the CMS for our office and displays our website, but the company contracted to do the work did not set up a way to actually set custom fields when posting articles. We have an article that needs a custom field set (because of the way this contractor designed the site) and I cannot for the life of me find how to do so.
I was able to find the preferences in the database, but could not find what I needed.
Offline
#2 2007-04-06 17:30:37
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Custom Fields
You set values for them from the Write tab, where you enter your article. Look under “Advanced Options”.
Offline
#3 2007-04-06 20:08:40
- NotMuch
- New Member
- Registered: 2007-04-06
- Posts: 7
Re: Custom Fields
Thanks, but that tab doesn’t exist in our implementation. The contractors who created our site did so using Textpattern but did not use a standard install. All pages are managed through a tab called Extensions, then a sub-tab called Business Pages. However a lot of standard Textpattern functionality is still there, as the template for our non-home, non-news pages has this line in it:
<div id="content" class="<txp:custom_field name="layout-type" />">However, I and several other people have found no way of setting this for a particular page on the site. I have some of knowledge of SQL, so I thought I might try and manually edit the database to set this field for that page. I was not able to find it in the database however, so I was hoping for a little more direction.
Offline
Re: Custom Fields
It’s one of the custom_1 … custom_10 fields in the textpattern table (it’s not set per page, but per article). You can either go the trial and error route to find which of those 10 custom fields is linked to the name ‘layout-type’ or you can look that up in the txp_prefs table.
Last edited by ruud (2007-04-06 20:15:30)
Offline
#5 2007-04-06 20:23:55
- NotMuch
- New Member
- Registered: 2007-04-06
- Posts: 7
Re: Custom Fields
I was able to find that no problem. The prefs are still accessible, and I was able to find them in the txp_prefs table as well. However, what I’m asking for is a way to set “layout-type=something” for an article.
Offline
#6 2007-04-06 21:19:32
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Custom Fields
Are you absolutely sure there is no Advanced options link in the ‘Write’ screen (where you write/edit your articles)? It should show the custom fields, and judging from the tags used there should be one named ‘layout-type’.
Offline
#7 2007-04-06 21:25:44
- NotMuch
- New Member
- Registered: 2007-04-06
- Posts: 7
Re: Custom Fields
This is what I see when I click the Advanced Options Link:
Edit: Link pulled as the identity of the design firm in question could be gleaned by crafty individuals.
Last edited by NotMuch (2007-04-06 23:23:26)
Offline
#8 2007-04-06 21:36:22
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Custom Fields
Geez, I hate it when people modify stuff then don’t document it so we get confused users.
Would you please post your “High” diagnostics results (Admin > Diagnostics… God I hope that is still there…)?
If worse comes to worse you can enter this data in the textpattern table (custom_1 – custom_10), but we should try and fix this. It’s ridiculous to have to do that by hand.
Offline
#9 2007-04-06 22:23:27
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Custom Fields
If that is what I think it is, your copy of Textpattern has been extensively modified. You’ll need to contact the design firm that built it for you.
Alex
Offline
#10 2007-04-06 23:05:05
- NotMuch
- New Member
- Registered: 2007-04-06
- Posts: 7
Re: Custom Fields
Nope, Diagnostics have been stripped out as well.
We had some major problems with the design firm, so contacting them is basically out of the question. It sounds like we’re pretty much out of options, so I’ll have to talk to my boss and see what can be done.
Last edited by NotMuch (2007-04-06 23:15:45)
Offline
#11 2007-04-06 23:25:34
- NotMuch
- New Member
- Registered: 2007-04-06
- Posts: 7
Re: Custom Fields
Rereading Mary’s comment, is it true that I could insert the URL of the page and the value into custom_9 (where layout-type is stored on our setup) and it’d work?
Last edited by NotMuch (2007-04-06 23:26:25)
Offline
Re: Custom Fields
Is it possible to see how much was customized? How old is the TXP install? If it’s pre-4.0.4, then you could probably get the same functionality out of a stock 4.0.4 install…whatever extra functionality was added (aside from screwing up the database and core files).
Offline