glz_custom_fields

andocobo · 2011-05-05 00:18:05

Hi Gerhard,
This plugin is exactly what i’m after for the project i’m currently working on, however i’m having some problems installing it. When i run the install script textpattern throws out the following error.

“Warning: 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 ‘TYPE=MyISAM’ at line 7 CREATE TABLE `custom_fields` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL default ‘’, `value` varchar(255) NOT NULL default ‘’, PRIMARY KEY (id), INDEX (`name`) ) TYPE=MyISAM”

If you have any ideas about how to resolve this problem i’d love to hear them! :)
Thanks!

cuda · 2011-06-01 18:37:01

Installed 1.2.4 on TXP 4.4.0 and now when I switch a custom field to textarea it disappears from the write tab….any ideas?

alanfluff · 2011-06-01 18:45:24

Hi Dayne,

I have 1.2.4 on 4.4 and although I’ve not tried switching a filed from one type to textarea, I’ve had no other issues, so all I can suggest is the usual, agressive clearing of cache and then the obvious that I missed once, I once added a field as a textarea and wondered where it was, only to have a “LIKE DUH!” moment when I realized it was in the middle of the Write page, under Excerpt (or above it, etc).

Good luck. Cheers, -Alan

GugUser · 2011-06-01 18:57:32

cuda schrieb:

Installed 1.2.4 on TXP 4.4.0 and now when I switch a custom field to textarea it disappears from the write tab….any ideas?

You have to enable excerpts in the preferences.

aswihart · 2011-06-06 17:03:04

I’m using the latest build of 1.2.4, for some reason I don’t see the ‘custom_x_set’ displayed in the custom field table on the glz_custom_fields Extensions editing screen. I can still tell which custom field is which if I click “Edit”, then it displays in the Edit area: screenshot

GugUser · 2011-06-06 21:27:22

Don’t use white space in the name. And I think, the name should not begin with a number. More about the allowed characters in the documentation of the custom_field and the preferences.

cuda · 2011-06-07 17:22:00

@alanfluff

DUhhhhhhhhhhhh there it is in in the middle under the write tab….I really only want to use it so I can insert text longer then 255 characters…

@gerhard
would it be possible to make that display under the custom menu? it would be a toggle switch in the plugin that would let you choose write column or advanced menu for text area’s

johnstephens · 2011-06-07 17:29:16

@cuda, you can move fields around using bot_wtc. It may require some custom CSS to set an appropriate width for textarea if you want it in the sidebar, though.

I prefer to keep textareas in the main content area, along with the Body & Excerpt textareas.

frickinmuck · 2011-06-14 21:47:27

I recently saw a post or an article on a plugin that enabled one to output the values of a glz “select” custom field as a menu on the front end of a site, so that that visitors can use it to sort articles based on their association with that item in the custom field. I can’t seem to find it now – am I imagining things?

So, for example, the custom field choices might be

Cats
Dogs
Horses

And the select menu on the front end would show the users those choices and they would get a list of articles that had “Cats” or “Dogs” or “Horses” selected in that custom field. Make sense?

uli · 2011-06-14 21:56:31

This one?

frickinmuck · 2011-06-15 01:17:28

Thanks, uli! My hero! :^)

frickinmuck · 2011-06-16 23:09:12

Ok, I’m realizing that what I want to do is a bit more complex than what’s being done here, or else I don’t have the sophistication to take this where I need to, or maybe that tutorial is a bit too incomplete for someone who needs a bit more hand-holding like me.

I like the way this essentially enables one to display articles according to a custom field, and I need that functionality, but I need to take it farther. Here’s what I’m hoping to be able to do with this:

1] Output the custom field values (otherwise known as the custom field options, otherwise known as the categories I’ve added in the category tab) as a menu (either as an “option/select” menu or just as a ul) in the sidebar that the visitor can use to sort articles, and have that list of available options appear based on what is essentially the parent category (which is also the custom field name). For example, if the parent/custom field was “Animals” the menu would have:

Cats
Dogs
Horses
Pigs
Cheetahs
Porcupines

2] A list of all articles that are using the selected custom field option will then display in the main area of the page when the visitor selects that option from the menu on the sidebar of the site. For example, if they clicked on “Dogs”

How to train a dog to “sit” November 12, 2011
Why I’ve never liked Rottweilers Dec 23, 2011
Canine psychology tricks Jan 4, 2012
The 5 Best Hounds for Life on a Farm Jan 23, 2011

Could anyone point me in the right direction? Since these aren’t assigned as category1/category2, they don’t work as a category list (or is it not working for some other reason?). Maybe I’m beginning to confuse myself, but I’m having a hard time getting started in the right direction.

EDIT: Perhaps a simpler way of explaining my purpose is to say, I’m hoping to use this a sort of a tagging system, and would have several such “menus” based on different parameters I want the articles to have. For example, one menu might be “Animals”, as discussed earlier, and another menu might be “Article Type” and have the following options:

Opinion
Instructional
Lists

In other words, any one article could appear in the resulting article list depending on the menu and item selected. The first article listed above,

How to train a dog to “sit” November 12, 2011

Would appear if you selected “Dog” from the “Animals” menu, and it would also appear if you selected “Instructional” from the “Article Type” list.

I moved this to its own How Do I post and added more detail on what I need.

Last edited by frickinmuck (2011-06-17 15:14:39)

Textpattern CMS

Textpattern CMS support forum

#841 2011-05-05 00:18:05

Re: glz_custom_fields

#842 2011-06-01 18:37:01

Re: glz_custom_fields

#843 2011-06-01 18:45:24

Re: glz_custom_fields

#844 2011-06-01 18:57:32

Re: glz_custom_fields

#845 2011-06-06 17:03:04

Re: glz_custom_fields

#846 2011-06-06 21:27:22

Re: glz_custom_fields

#847 2011-06-07 17:22:00

Re: glz_custom_fields

#848 2011-06-07 17:29:16

Re: glz_custom_fields

#849 2011-06-14 21:47:27

Re: glz_custom_fields

#850 2011-06-14 21:56:31

Re: glz_custom_fields

#851 2011-06-15 01:17:28

Re: glz_custom_fields

#852 2011-06-16 23:09:12

Re: glz_custom_fields

Board footer