June 2006 - support - lists.drupal.org

Custom Report . . .
by Jason Flatt 22 Jun '06

22 Jun '06

I need to create a custom report that is based on several profile fields. It will need to group on one profile field, sort by another two, and then show four more -- for all active users. Should I be looking to do this as a page node or a module? I've been trying to do it as a page node, but have been mostly unsuccessful thus far. -- Jason Flatt http://www.oadae.net/ Father of Six: http://www.flattfamily.com/ (Joseph, 13; Cramer, 11; Travis, 9; Angela; Harry, 5; and William, 12:04 am, 12-29-2005) Linux User: http://www.sourcemage.org/ Drupal Fanatic: http://drupal.org/

2 1

customizing the taxonomy page
by Sten 22 Jun '06

22 Jun '06

The page contains a list of teasers for the nodes that belongs to that term. My problem is that I would like to customize this page in to respects. 1) I would like to affect the way each node is presented. I don’t want the heading to be h2 and I don’t want a “read more” link as it is already possible to click the heading. 2) My biggest concern though, is that all nodes in that term are listed. I would only like those that are sorted directly under that term in the menu tree to be listed. Is there a way of deciding which nodes will be shown? 3) I would like to have an introductory description of the term. Unfortunately there is no room for a text meant for publishing in the term page, only a description. Can this be made to show up on the term page? Grateful for any advice! Sten

2 2

Re: [support] Dynamic Menus That Work OK Without Javascript
by Greg Knaddison - GVS 18 Jun '06

18 Jun '06

I turned off javascript in my browser and the menus no longer work. In fact, the whole page loses a lot of theming when javascript is turned off. I believe those menus are completely dependent on javascript. Am I missing something? I don't know how you could achieve this without at least some javascript or flash. Regards, Greg On 6/15/06, Randal <digitas(a)panix.com> wrote: > Has anyone set up dynamic menus in Drupal like this: > > http://steuben.com > > ???? > > The critical element here is that since the sub-elements expand in the left navigation when you go to a section or subsection, it is possible to use the entire navigation without javascript (though with javascript you are able to jump directly to any subsubitem). > > Assuming that no one has done this yet, any suggestions on the best modules to use a basis for code hacking to achieve this? > > -- Randal > -- > [ Drupal support list | http://lists.drupal.org/ ] > -- Greg Knaddison | Growing Venture Solutions Denver, CO | http://growingventuresolutions.com Technology Solutions for Communities, Individuals, and Small Businesses

4 3

Re: [support] Dynamic Menus That Work OK Without Javascript
by Greg Knaddison - GVS 17 Jun '06

17 Jun '06

On 6/15/06, Randal <digitas(a)panix.com> wrote: > > It does look like they have broken styling on this site without javascript, but the menus do still work. Maybe it's the definition of "work". They don't expand out anymore, but if you click on animals you get to the other links on a resulting page. If that's your goal then whether or not that "works" using the Nice Menus module is dependent on your configuration of your site. It's still possible using nice menus. Regards, Greg -- Greg Knaddison | Growing Venture Solutions Denver, CO | http://growingventuresolutions.com Technology Solutions for Communities, Individuals, and Small Businesses

4 4

Re: [support] adding content from mysql command line?
by dondi_2006 17 Jun '06

17 Jun '06

> I haven't used it, but you may want to check out http://drupal.org/ > node/46008 > > Ray > Thanks for signalling the import_HTML module. I will study its documentation. However, I would still prefer a command-lin, mysql client based solution, if possible, because it would: not require changing the php config, something I'd rather avoid be more compatible, I believe, with completely automatic, periodical bulk additions of content, rather than one-time imports more integrated with my own situation, meaning that I have to fetch meta-tags and other info from existing databases, rather than having them already available in the HTML pages Thanks, O. , my > On Jun 16, 2006, at 11:27 AM, dondi_2006 wrote: > > > Hello, > > > > what if one has a **lot** of html files (*), each of which should > > become a drupal node in an already built and categorized drupal site? > > > > Is there any way to load them in the website automatically, > > with some shell script which prepares the mysql query and then > > feeds it to the mysql client from the command line? > > > > This would be soo much faster than creating content from the > > browser, one > > node at a time :-( > > > > TIA, > > O. > > > > (*) assuming that the html has been previously cleaned up of bogus > > codes and > > tags > > by another script, of course > > > > > > > > -- > > [ Drupal support list | http://lists.drupal.org/ ] > > -- > [ Drupal support list | http://lists.drupal.org/ ] >

1 0

showing last 4 news
by bunset＠dconsultia.es 17 Jun '06

17 Jun '06

Hi! I have created a new content type with CCK called "news", I am trying show in home page last 4 news but I don't get the correct snippet for it. Anybody can guided me please? Regards, David from dconsultia.es (Spain) -----Mensaje original----- De: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] En nombre de support-request(a)drupal.org Enviado el: viernes, 16 de junio de 2006 14:00 Para: support(a)drupal.org Asunto: support Digest, Vol 42, Issue 21 Send support mailing list submissions to support(a)drupal.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.drupal.org/listinfo/support or, via email, send a message with subject or body 'help' to support-request(a)drupal.org You can reach the person managing the list at support-owner(a)drupal.org When replying, please edit your Subject line so it is more specific than "Re: Contents of support digest..." Today's Topics: 1. Drupal-Postgres-LDAP-FreeBSD (David King) 2. Re: theme search box button next to field (Franz Iberl) 3. Re: Menus (Pherowze) ---------------------------------------------------------------------- Message: 1 Date: Thu, 15 Jun 2006 19:27:59 -0700 From: David King <dking(a)ketralnis.com> Subject: [support] Drupal-Postgres-LDAP-FreeBSD To: support(a)drupal.org Message-ID: <D1FCD04C-F3B3-43FB-88E8-E120F65147CF(a)ketralnis.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed My name is David King, I am having trouble with LDAP users logging on I have a very vanilla Drupal (v4.6.6) install, except that it is installed on Postgres, I have the LDAP authentication module installed, and it is installed on FreeBSD (all three are installed via the FreeBSD Ports system). When I try to have an LDAP user log in, the user is created in the database, and looks like this: $ psql drupal drupal=# select uid,name,data from users; uid | name | data -----+------- +----------------------------------------------------------------------- -------------------------------------------------------- 0 | | 1 | admin | a:1:{s:5:"roles";a:1:{i:0;s:1:"2";}} 2 | dking | a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=DN>";} (3 rows) But the user is presented with a blank page after several seconds. In the log are dumped many (a hundred or so) Postgres errors of the following forms: pg_query(): Query failed: ERROR: multiple assignments to same column "changed" in /usr/local/www/drupal/includes/database.pgsql.inc on line 45. query: UPDATE users SET uid = '2', name = 'dking', pass = '47c6b15aca93873f58522f26300d181d', mail = 'dking@<censored=domain>', mode = '0', sort = '0', threshold = '0', theme = '', signature = '', created = '1150424378', changed = '1150424378', status = '1', timezone = '', language = '', picture = '', init = '', data = 'a:3:{s: 5:"roles";a:1:{i:0;s:1:"2";}s:17:"ldap_authentified";b:1;s: 7:"ldap_dn";s:38:"<censored=dn>";}', data = 'a:3:{s:5:"roles";a:1:{i: 0;s:1:"2";}s:17:"ldap_authentified";b:1;s:7:"ldap_dn";s: 38:"<censored=dn>";}', changed = 1150424379 WHERE uid = 2 in /usr/ local/www/drupal/includes/database.pgsql.inc on line 62. The errors seem to alternate between those two. I can't delete the user in the database, because if I go to Administer > Users > dking (the username) > Edit, I get the browser error that the server has closed the connection. How can I go about troubleshooting/debugging this? Does anyone have any ideas? Some more potentially useful information: ~% uname -a FreeBSD <> 5.3-RELEASE-p20 FreeBSD 5.3-RELEASE-p20 #2: Fri Sep 9 14:11:12 PDT 2005 root@<>:/usr/obj/usr/src/sys/ROUTERKERNEL i386 ~% pkg_info | grep drupal drupal-4.6.6_2006031700 CMS that supports pgsql and mysql drupal-ldap_integration-4.6.0_20060117 LDAP user authentication for the Drupal CMS ~% psql --version psql (PostgreSQL) 8.0.8 ------------------------------ Message: 2 Date: Fri, 16 Jun 2006 08:37:13 +0200 From: Franz Iberl <f.iberl(a)amazonas-box.de> Subject: Re: [support] theme search box button next to field To: support(a)drupal.org Message-ID: <d56558947547037902b3c5585a99fb38(a)amazonas-box.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hello again, > I know the code is correct. It displays correctly in this node: > http://www.animecards.org/node/74 ok, the button 'submit' which fits in the node obiously does not fit in the orange box at the left side. > #search .form-text { > width: 8em; > float: left > } try e.g. 5em ? in a hurry Franz -- http://amazonas.the-dot.de ------------------------------ Message: 3 Date: Fri, 16 Jun 2006 10:44:33 +0300 From: Pherowze <pherowze(a)gmail.com> Subject: Re: [support] Menus To: support(a)drupal.org Message-ID: <b7436d290606160044s4337e83bw5c6f796a5544e174(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Thank you, It works like a charm... On 6/15/06, Metzler, David <metzlerd(a)evergreen.edu> wrote: > > Yep this works. I've done similar things to make blocks appear on > specific pages. You don't technically need path_auto to accomplish this. > If you use the path module, you can manually set up each page with a path ( > e.g. news/todaysnews). What pathauto does for you is to automatically set > the "path" alias names based on content type and/or taxonomy term plus the > page title. You can always override a particular page by specifically > setting its path, provided you have the path module enabled. > > Menu sections can easily be reorganized into different blocks by following > the basic steps. > > 1. Make sure menu module is enabled and add a menu item. > 2. Make sure you have administer menu priviledges. > 3. Make a new menu block using "Add a Menu" under Administer->Menus > 4. Move or add a menu item to your new menu by changing its "Parent > Item" to the newly created menu. > 5. Now go to Administer->Blocks to control the placement of your > newly created menu block in the normal way, as well as which paths it might > appear on. > > Dave > > ------------------------------ > *From:* support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] *On > Behalf Of *Pherowze > *Sent:* Thursday, June 15, 2006 6:43 AM > *To:* support(a)drupal.org > *Subject:* Re: [support] Menus > > Path auto?....Let me find out what it is and how to use it... Kobus, I was > unable to separate the menus using block admin pages... > > Thanks. > > On 6/15/06, Greg Knaddison - GVS <Greg(a)growingventuresolutions.com> wrote: > > > On 6/15/06, Kobus Myburgh <ITBJDM(a)puknet.puk.ac.za> wrote: > > > ...I have the main header with the primary links > > > > which never changes regardless of the section... on the menubar on > > the left > > > or right of the page I will have a submenu which will change whenever > > I go > > > to a different section...... > > > > > > Can this be achieved using drupal...? If so how....? > > > > You can use a custom block with php if-then conditions or switches. Not > > sure if there is an easier way. > > > > If you don't know how to code, it is perhaps better to make separate > > blocks with the menu links in them and only set their visibility in > > block admin pages, otherwise you can make one block with different PHP > > conditions to display the links as they should be per page. > > > > If you use pathauto to create your paths for you then you could set up > a system that splits your "different sections" into different URLs on > the site such as: > > forum/ > blog/ > news/ > > And then create blocks appropriate for those sections and in the block > visibility settings set the blocks to only show on forum/* pages or > blog/* pages as appropriate. > > With pathauto it's possible to separate by either node type (as shown > above) or by the lowest weighted taxonomy term in the lowest weighted > taxonomy. > > Regards, > Greg > > > -- > Greg Knaddison | Growing Venture Solutions > Denver, CO | http://growingventuresolutions.com > Technology Solutions for Communities, Individuals, and Small Businesses > -- > [ Drupal support list | http://lists.drupal.org/ ] > > > > -- > Warmest Regards, > > Pherowze > > -- > [ Drupal support list | http://lists.drupal.org/ ] > > -- Warmest Regards, Pherowze

2 1

Customizing Organic Group Pages
by Mike Hartman 17 Jun '06

17 Jun '06

I'm using organic groups and it's working very well. However, I'd like to change some of the wording on a group's main page for the different sections, ie the "book page", "forum topic" section headings. and also in the OG block where the user has the option to "create book page" or "create forum topic". These do not seem to be in the language strings under Administrator/Localization, and I can't find them in the ca.po file in the OG module. Does anyone know where these settings are and how to change them? Thanks Mike

2 1

adding content from mysql command line?
by dondi_2006 16 Jun '06

16 Jun '06

Hello, what if one has a **lot** of html files (*), each of which should become a drupal node in an already built and categorized drupal site? Is there any way to load them in the website automatically, with some shell script which prepares the mysql query and then feeds it to the mysql client from the command line? This would be soo much faster than creating content from the browser, one node at a time :-( TIA, O. (*) assuming that the html has been previously cleaned up of bogus codes and tags by another script, of course

3 2

RE: [support] Menus
by Metzler, David 16 Jun '06

16 Jun '06

Yep this works. I've done similar things to make blocks appear on specific pages. You don't technically need path_auto to accomplish this. If you use the path module, you can manually set up each page with a path (e.g. news/todaysnews). What pathauto does for you is to automatically set the "path" alias names based on content type and/or taxonomy term plus the page title. You can always override a particular page by specifically setting its path, provided you have the path module enabled. Menu sections can easily be reorganized into different blocks by following the basic steps. 1. Make sure menu module is enabled and add a menu item. 2. Make sure you have administer menu priviledges. 3. Make a new menu block using "Add a Menu" under Administer->Menus 4. Move or add a menu item to your new menu by changing its "Parent Item" to the newly created menu. 5. Now go to Administer->Blocks to control the placement of your newly created menu block in the normal way, as well as which paths it might appear on. Dave ________________________________ From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Pherowze Sent: Thursday, June 15, 2006 6:43 AM To: support(a)drupal.org Subject: Re: [support] Menus Path auto?....Let me find out what it is and how to use it... Kobus, I was unable to separate the menus using block admin pages... Thanks. On 6/15/06, Greg Knaddison - GVS <Greg(a)growingventuresolutions.com> wrote: On 6/15/06, Kobus Myburgh <ITBJDM(a)puknet.puk.ac.za> wrote: > > ...I have the main header with the primary links > > which never changes regardless of the section... on the menubar on > the left > > or right of the page I will have a submenu which will change whenever > I go > > to a different section...... > > > > Can this be achieved using drupal...? If so how....? > > You can use a custom block with php if-then conditions or switches. Not > sure if there is an easier way. > > If you don't know how to code, it is perhaps better to make separate > blocks with the menu links in them and only set their visibility in > block admin pages, otherwise you can make one block with different PHP > conditions to display the links as they should be per page. > If you use pathauto to create your paths for you then you could set up a system that splits your "different sections" into different URLs on the site such as: forum/ blog/ news/ And then create blocks appropriate for those sections and in the block visibility settings set the blocks to only show on forum/* pages or blog/* pages as appropriate. With pathauto it's possible to separate by either node type (as shown above) or by the lowest weighted taxonomy term in the lowest weighted taxonomy. Regards, Greg -- Greg Knaddison | Growing Venture Solutions Denver, CO | http://growingventuresolutions.com Technology Solutions for Communities, Individuals, and Small Businesses -- [ Drupal support list | http://lists.drupal.org/ ] -- Warmest Regards, Pherowze

2 1

theme search box button next to field
by Anisa 16 Jun '06

16 Jun '06

I am trying to document adding more features to the interlaced theme here: http://drupal.org/node/68507 By features, I mean like the search box, avatars, etc. My idea was a lot of times you fiddle and fiddle, but how do you know what to fiddle with? Anyway, even if it doesn't help anyone else, it helped me think things through. It was relatively easy to get a working search box in the header, but theming it has been a *lot* of trial and error. I have gotten it positioned correctly, but I can't understand why the search box button is underneath the field, instead of next to it as it is in the search box, as it is in other themes. Any suggestions? Anisa. -- ********************************* www.AnimeCards.Org 16,000 scans and counting! *********************************

2 3