April 2008 - support - lists.drupal.org

form displaying results & tablesort (5.X)
by Ivan Sergio Borgonovo 17 Apr '08

17 Apr '08

Having FAPI I'd like to avoid to use $_GET directly. I've a form that display the result of a search. The technique is similar to: http://jeff.viapositiva.net/drupal/dynamic-forms or http://www.lullabot.com/articles/drupal_5_making_forms_that_display_their_o… the trick is that $form_values are still available... but 1) it seems I can't use get method 2) not being able to use get method, if the result of the form contains a tablesorted table, once you sort the table clicking on a column despite the fact the values are all in the url... $form_values is empty. Of course I could use $_GET array in place of the $form_values array... but this miss the use of FAPI (validation, token...). Is there a neater approach? Did some of these use case get better in D6? -- Ivan Sergio Borgonovo http://www.webthatworks.it

1 0

[Fwd: "Illegal Choice" Error When Changing Select List to Text Field]
by Steve Edwards 16 Apr '08

16 Apr '08

Well, I figured out the answer to my question by looking in the code for the _form_validate() function in form.inc. For those interested in the resolution, I hadn't unset the $form['nice_menus_number']['#options'] setting in the form, so it was still using the items in the select list as validation parameters. Once I added this line unset($form[$form['nice_menus_number']['#options']) to my form alter function, it worked just as I wanted. Steve -------- Original Message -------- Subject: "Illegal Choice" Error When Changing Select List to Text Field Date: Wed, 16 Apr 2008 13:42:37 -0700 From: Steve Edwards <killshot91(a)comcast.net> To: support(a)drupal.org I'm using the Nice Menus module, and I would like to be able to have more than the 10 menus allowed by the module. This limit is set by a hardcoded select list on the admin settings page for the module. I want to modify the form by changing the select list to a text field so that an arbitrary number of menus can be selected. To do this, I'm using hook_form_alter() to modify the nice_menus_number field in the nice_menus_admin_settings form. First here is the form code in the module /** * Settings form as implemented by hook_menu */ function nice_menus_admin_settings() { $form['nice_menus_number'] = array( '#type' => 'select', '#title' => t('Number of Nice Menus'), '#description' => t('The total number of independent nice menus (blocks) you want.'), '#default_value' => variable_get('nice_menus_number', '2'), '#options' => drupal_map_assoc(array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)), ); return system_settings_form($form); } and here is my form alter function: function cwl_form_alter($form_id, &$form) { switch ($form_id) { case 'nice_menus_admin_settings': $form['nice_menus_number']['#type'] = 'textfield'; $form['nice_menus_number']['#size'] = 2; break; } } This works in that it changes the field type to a text field, and the value attribute is the value in the nice_menus_number variable. This works fine as long as I select a value of 10 or less. However, if I select a value higher than 10, I get an error that says " An illegal choice has been detected. Please contact the site administrator." But, if I change my function to also use a select list, like this: function cwl_form_alter($form_id, &$form) { switch ($form_id) { case 'nice_menus_admin_settings': $form['nice_menus_number']['#options'] = drupal_map_assoc(array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)); break; } } it works fine, and I can select a value higher than 10. Since it's using the default system_settings_form() function, there isn't a maximum value set somewhere. Plus, the default value is being set correctly when the form is initially displayed. Can anybody explain why a select list works, but a text field doesn't? Thanks. Steve

1 0

"Illegal Choice" Error When Changing Select List to Text Field
by Steve Edwards 16 Apr '08

16 Apr '08

I'm using the Nice Menus module, and I would like to be able to have more than the 10 menus allowed by the module. This limit is set by a hardcoded select list on the admin settings page for the module. I want to modify the form by changing the select list to a text field so that an arbitrary number of menus can be selected. To do this, I'm using hook_form_alter() to modify the nice_menus_number field in the nice_menus_admin_settings form. First here is the form code in the module /** * Settings form as implemented by hook_menu */ function nice_menus_admin_settings() { $form['nice_menus_number'] = array( '#type' => 'select', '#title' => t('Number of Nice Menus'), '#description' => t('The total number of independent nice menus (blocks) you want.'), '#default_value' => variable_get('nice_menus_number', '2'), '#options' => drupal_map_assoc(array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)), ); return system_settings_form($form); } and here is my form alter function: function cwl_form_alter($form_id, &$form) { switch ($form_id) { case 'nice_menus_admin_settings': $form['nice_menus_number']['#type'] = 'textfield'; $form['nice_menus_number']['#size'] = 2; break; } } This works in that it changes the field type to a text field, and the value attribute is the value in the nice_menus_number variable. This works fine as long as I select a value of 10 or less. However, if I select a value higher than 10, I get an error that says " An illegal choice has been detected. Please contact the site administrator." But, if I change my function to also use a select list, like this: function cwl_form_alter($form_id, &$form) { switch ($form_id) { case 'nice_menus_admin_settings': $form['nice_menus_number']['#options'] = drupal_map_assoc(array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)); break; } } it works fine, and I can select a value higher than 10. Since it's using the default system_settings_form() function, there isn't a maximum value set somewhere. Plus, the default value is being set correctly when the form is initially displayed. Can anybody explain why a select list works, but a text field doesn't? Thanks. Steve

1 0

Forum topics not posting
by Tony Yarusso 15 Apr '08

15 Apr '08

I recently enabled the core Forums module, and somethings not working quite right. Users are able to click the "Post new forum topic" link, successfully fill out the form, and submit, and the results DO show up in the "Administer > Content" area, but do not display in the forum itself. It still claims there are 0 topics and 0 posts. It appears that the posts are not being assigned any category, although I would have thought that would have been taken care of by the node/add/forum/38 link used to post them. What are we doing wrong? -- Tony Yarusso http://tonyyarusso.com/

3 7

Drupal 6.2 / PostgreSQL 8.2 installation failure
by Jesper K. Pedersen 15 Apr '08

15 Apr '08

Trying to install a fresh clean Drupal version 6.2 on my webserver ended up with these error messages : Drupal installation complete ------------------------------ warning: pg_query() [function.pg-query]: Query failed: ERROR: column "uid" does not exist LINE 1: SELECT * FROM users u WHERE uid = 1 ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: SELECT * FROM users u WHERE uid = 1 in /www_root/drupal.famped.dk/modules/user/user.module on line 167. warning: pg_query() [function.pg-query]: Query failed: ERROR: column "uid" does not exist LINE 1: SELECT * FROM users WHERE uid = 1 ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: SELECT * FROM users WHERE uid = 1 in /www_root/drupal.famped.dk/modules/user/user.module on line 527. warning: pg_query() [function.pg-query]: Query failed: ERROR: column "name" of relation "users" does not exist LINE 1: INSERT INTO users (name, mail, pass, init, status, created) ... ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: INSERT INTO users (name, mail, pass, init, status, created) VALUES ('jkp', 'jesper(a)famped.dk', 'cb32154ec178b88cb055c4b8f50aeaae', 'jesper(a)famped.dk', 1, 1207916857) in /www_root/drupal.famped.dk/modules/user/user.module on line 325. warning: pg_query() [function.pg-query]: Query failed: ERROR: column "name" does not exist LINE 1: SELECT * FROM users u WHERE LOWER(name) = LOWER('jkp') AND p... ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: SELECT * FROM users u WHERE LOWER(name) = LOWER('jkp') AND pass = 'cb32154ec178b88cb055c4b8f50aeaae' AND status = 1 in /www_root/drupal.famped.dk/modules/user/user.module on line 167. --------- When checking my PostgreSQL backend I can see the problem. The "users" table do not contain the columns "uid", "name" and "pass" but have the following definition : Table "public.users" Column | Type | Modifiers -------------+-----------------------+---------------------------------------------------- id | integer | not null default nextval('users_id_seq'::regclass) user_name | character varying(25) | not null user_passwd | character varying(25) | not null Indexes: "users_pkey" PRIMARY KEY, btree (id) Any ideas of what the problem is? Thanks Jesper K. Pedersen

2 2

multisite
by Jacob Roufa 15 Apr '08

15 Apr '08

Hi all, I have a multisite setup that works great. It allows me two different sites using one Drupal core codebase just as promised. It works better and easier than redirecting to different domain names using Apache Virtual Hosts. However, I have one issue with it. When I create a symbolic link, in the sites folder, for each site (i.e. sitename linked to sitename.domain.tld) so that I can visit it not only by sitename, I am directed to a different site in my browser. In my browser, when I go to http://sitename and log in, then visit http://sitename.domain.tld I'm not logged in! But they're the same thing, one's just a symbolic link to the other! I really am confused and wondering if this is proper behavior because it doesn't seem like it. Thanks! -- Jake Roufa Web Consultant http://jacobroufa.com

4 5

Create filter's view usefull only for exposed filter
by Davide Michel 'ZioBudda' Morelli 15 Apr '08

15 Apr '08

Hi all, I have a content type with a select's CCK field type and this "select list" is created via PHP Code (runtime)) . Now I want to create a view and use this "select list" for one of my filter. My need is that when I call the view for the first tyme, this view must return me all node, like if I have selected all fields/values of this select . My problem is that Drupal expect that I select one of the item of "select when I save the new view, so it does not permit me to save the view because I have not select any filed of this select. How can I do it ? Tnx. - Michel 'ZioBudda' Morelli michel(a)ziobudda.net Consulenza sistemistica in ambito OpenSource. Sviluppo applicazioni web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ajaxblog.it MSN: michel(a)ziobuddalabs.it JABBER: michel(a)gmail.com

1 0

Broken CCK Module
by Fred Jones 14 Apr '08

14 Apr '08

On a normal site when I go to http://xxx.org/admin/content/types/audio I see the links: # Edit # Manage fields # Display fields # Add field # Add group Or something like that, depending on which CCK modules I have. However, I have a 'broken' site that shows: * List * Add content type * Fields * Export * Import which is more like what I would expect to see at the URL http://xxx.org/admin/content/types On the 'broken' site I indeed see those same links on /admin/content/types CCK (5.x-1.6-1) is of course enabled, but this site has a LOT of modules, including one custom one. This is what CCK says: Required by: Asset Manager (disabled), Content Copy (enabled), Content Taxonomy (enabled), Content Taxonomy ActiveSelect (enabled), Content Taxonomy Autocomplete (enabled), Content Taxonomy Options (enabled), Date (enabled), Date Copy (enabled), EMail (enabled), Fieldgroup (enabled), Image (enabled), Node Reference (enabled), Number (enabled), Option Widgets (enabled), Text (enabled), User Reference (enabled) I would think that next debugging step would be to disable CCK, but that requires disabling all those required mods. I am a bit concerned, however, that if I disable them, something may happen to our data. Any advice as to how to proceed? This is not my site--I just inherited it and need to work on it. I suppose I will make a backup and do my debugging idea, but if anyone has another idea, let me know. :) Thanks!

3 8

[OT??] Jquery 1.1.2 or 1.2.3
by Davide Michel 'ZioBudda' Morelli 14 Apr '08

14 Apr '08

Hi all. I'm creating a new portal site for one of my client, and I need to use some jquery functions. But which version of query ? 1.1.2 or 1.2.3 ? With drupal_update module I can upgrade from 1.0.5 (drupal's jquery default) to 1.1.2, but it is avaible the new 1.2.3 version. I have see that some drupal's module requires 1.2.3 version, but does Drupal 5.7 support this version ? Tnx. -- Michel 'ZioBudda' Morelli michel(a)ziobudda.net Consulenza sistemistica in ambito OpenSource. Sviluppo applicazioni web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ajaxblog.it MSN: michel(a)ziobuddalabs.it JABBER: michel(a)gmail.com

2 1

Passing a whole PathAuto category path into a View URL
by Neil: esl-lounge.com 12 Apr '08

12 Apr '08

This is quite a complicated one. I have a Vocabulary, "Location". It is 4 levels deep. (country > state > county > town). I have attached it to three content types: page, story, blog. I have used PathAuto on the category paths to dynamically alter the URLs to this pattern: article/[catpath-raw], which gives me URLs such as: article/united-states/texas/kent-county/jayton I attached one each of the Page, Story and Blog content types to this town and I go there and get a listing of 3 nodes. Perfect. Now, what I want to do is to create a View to be able to go to: article/united-states/texas/kent-county/jayton/blog to see ONLY the blog entries article/united-states/texas/kent-county/jayton/page to see ONLY the page entries, and so on ultimately, I would like to go to article/united-states/texas/kent-county/jayton/page/1 to see on UID 1's page entries for that city. But one step at a time... :-) The problem: how do I pass all of that cat path to the Views URL? I set up a View with first argument as "term name" and second argument as "node:type" and I set up the page URL as "article" so if I then go to article/jayton/blog, it works perfectly...However, if I go to article/united-states/texas/kent-county/jayton/blog, I get a Page Not Found as the "term name" is only passing the last part of the overall catpath (i.e. jayton) to Views, not all of it. How can I pass all the catpath into the page URL? Is it even possible to do that? Thanks in advance. Neil

2 1