October 2011 - support - lists.drupal.org

Passing value from webform to read-only field on redirected page.
by Jessica Hannan - Halo Digital Design 28 Oct '11

28 Oct '11

I'm a somewhat green developer (I have RPG programming experience) and I'm working on a website for a baseball association. I am developing it from the ground up, including registration which is where I'm having my issues. Parents need to register their children for the upcoming season. I need to create views from those registrations to set up the rest of the content on the website (rosters, etc) I have set up the parents as content profiles and children as nodes, referencing their parents. Easy enough (now that it's done!) I created the baseball registration pages using uc_event_registration with the content type of paid event. I added a webform to the product page for the parent to select their own child and complete checkout, and I thought I had really accomplished something until I realized that I was not able to access that data with Views. Monday, upon realizing this wonderful gem of information while I was trying to set up a view of all of the children who were registered (all test data), I worked on a solution for 20 hours straight and made no forward progress besides loading dozens of additional modules which were useless to me. I have a solution worked out in my head that I know will work because of an accidental experiment on Monday, On the content type for the event registration page I placed a node reference field with a view to select children of the logged in user, not realizing that wasn't going to show up on the product page itself (I was tired, what can I say?), but instead, took the first value from the list and added it to the product page an a read only field. Lo and behold, I was able to access that field with Views! Today I created a webform which will allow a parent to choose one of their children and upon submit, will redirect to the registration page. My issue is I don't know how to pass that value (the child's name) to a read only field on the product page. Another option would be to add CCK fields to an Ubercart product page, but I can't seem to figure that one out, either. If you at all understand what I'm trying to do and feel like taking pity on me before I give myself a concussion from beating my head on my screen, I would VERY much appreciate it. I don't often wave a white flag, but I'm days away from the deadline and I can't create any of the other Views as they depend on the child's registration info. Thanks! Jessica Hannan 815-545-5541 http://www.HaloDigitalDesign.com Join us on Facebook!! http://www.facebook.com/halodigitaldesign

1 0

Re: [support] help with: bypassing Views Taxonomy filter limitation
by sebastian 28 Oct '11

28 Oct '11

Hello folks, Just wanted to add that a nested SELECT is not performance optimized. The "better" SQL query is actually: SELECT DISTINCT node.nid AS nid, node.title AS node_title, node.vid AS node_vid FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT OUTER JOIN term_node term_node2 ON node.vid = term_node2.vid AND term_node2.tid = 3 WHERE term_node2.tid IS NULL AND term_data.vid = 2 GROUP BY node.nid By using an LEFT OUTER JOIN instead of a WHERE NOT EXISTS (SELECT... The rule of thumb is: Use JOIN with IS NULL [=inverted selection] instead of a derived table. I didn't come up with this, but someone else schooled me. :-) Sincerely, Sebastian. On 2011-10-26 11:05 PM, Joel Willers wrote: > Thanks for posting the solution to this. I'll add it to my collection of solutions to problems I might have in the future. > > Joel > > > -----Original Message----- > From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of sebastian > Sent: Wednesday, October 26, 2011 5:13 AM > To: support(a)drupal.org > Subject: Re: [support] help with: bypassing Views Taxonomy filter limitation > > OK! > > Finally found an answer, here is the correct mysql query to exclude a > specific TID from the results of your nodes: > > SELECT DISTINCT(node.nid) AS nid, > node.title AS node_title, > node.vid AS node_vid > FROM node node > LEFT JOIN term_node term_node ON node.vid = term_node.vid > LEFT JOIN term_data term_data ON term_node.tid = term_data.tid > WHERE NOT EXISTS > (SELECT * > FROM term_node > WHERE term_node.tid = 3 > AND term_node.nid = node.nid) > GROUP BY nid > > Obviously this can be modified now to take an argument and the View will > now deliver correct results. > > Phew! > > S. > > On 2011-10-26 7:05 AM, sebastian wrote: >> Hi there, not sure why the $query I am seeing has so many wild cards, >> but here is a far simpler version of the mysql query it makes [reduced >> to bare essentials]: >> >> SELECT DISTINCT(node.nid) AS nid, >> node.title AS node_title >> FROM node node >> LEFT JOIN term_node term_node ON node.vid = term_node.vid >> LEFT JOIN term_data term_data ON term_node.tid = term_data.tid >> WHERE UPPER(term_data.name) NOT LIKE UPPER('%personal%') >> GROUP BY nid >> >> Again, the problem is that it will still accept [not filter out] a node >> if it has more than one Taxonomy term and at least one of those terms >> are not the match [in this case the term "personal"]. >> >> Is anyone good with sql queries and knows how I would have to change >> this to eliminate a node if ANY of it's terms are matched instead of ALL? >> >> Thank you kindly, >> >> Sebastian. >> >> >> On 2011-10-25 6:12 PM, sebastian wrote: >>> Hello, >>> >>> Have a noodle here. >>> >>> D6, V2. If I make a View and set the filter to: >>> >>> Does NOT contain TERM "personal" >>> >>> And then I run the display, it will NOT show a Node that has ONLY one >>> tag that says "Personal". But if I have more tan one Tag on that node, >>> then it WILL show the Node, making my filter useless... >>> >>> So I wrote a HOOK to pre-process the query: >>> >>> function joinTaxonomy_views_query_alter(&$view,&$query) { >>> if($view->name == 'blog_feed'){ >>> dpm($view); >>> } >>> } >>> >>> Now I can see that there are values I can change, but I am unfortunetly >>> not a mySQL query-master. >>> >>> The $query that it generates*, which needs adjusting, is: >>> >>> SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, >>> node.title AS node_title, >>> node.created AS node_created, >>> node.type AS node_type, >>> node.vid AS node_vid, >>> node_revisions.teaser AS node_revisions_teaser, >>> node_revisions.format AS node_revisions_format, >>> node.uid AS node_uid >>> FROM {node} node >>> LEFT JOIN {term_node} term_node ON node.vid = term_node.vid >>> LEFT JOIN {term_data} term_data ON term_node.tid = term_data.tid >>> LEFT JOIN {node_revisions} node_revisions ON node.vid = >>> node_revisions.vid >>> WHERE (node.status<> 0) AND (node.type in ('%s')) AND >>> (UPPER(term_data.name) NOT LIKE UPPER('%%%s%%')) >>> GROUP BY nid >>> ORDER BY node_created DESC >>> ) count_alias >>> >>> Can anyone tell me what the query SHOULD be so that it excludes any node >>> which has my defined Term-name and not just nodes that ONLY have my >>> designated rejected-term filter? >>> >>> If it is helpful I can give a full-dump of the $views variable here, but >>> trying not to kill you with detail. >>> >>> If a TID is easier, I know the TID and it won't change very often, if >>> ever, so I could hard code it to a number, if that's helpful... >>> >>> Thank you so much for your help! >>> >>> Sincerely, >>> >>> S. >>> >>> * $query taken from: >>> views.inc >>> /** >>> * Execute the view's query. >>> */ >>> function execute($display_id = NULL) { >>> // ... >>> $query >>> // ... >>> }

1 0

Using Git for Site Building
by DTH 28 Oct '11

28 Oct '11

So I want to create a new D7 site and I've read http://drupal.org/node/803746 I think I get it. So basically I'm creating a branch for pure Drupal core which I can pull to whenever I want to update Drupal. Say I only want to work from official releases (current 7.8). I checkout the 7.8 tag. Branch that to "mysite" etc. Then I add all my contrib modules and custom modules to the "mysite" branch. Then when 7.9 is released, I pull again from Drupal.org, checkout the 7.9 tag(?) and then merge that with "mysite"? However, (in part, as 7.8 is a way behind head), isn't my Git timeline cluttered with things that are fairly irrelevant to me? I can see that using Git makes it much easier to get the latest version (rather than download zip, unzip, delete, copy etc), but it makes it harder for me to see my (irregular) changes to my custom modules and htaccess etc when they're mixed in with dozens of changes to core? Especially as lots of those changes are already ahead of where I start building my site? Also, if I'm going this route: should I have contrib be handled by Git as well? So I can pull the latest version of Views or Domain Access? If I do that, does the whole thing end up a mess with 40 remote repositories etc? Are there any other suggestions/alternatives/tips for someone who wants to build a site and use Git mainly to keep track of their own changes? Can I make Drupal a submodule? (I'm still not super sure how there work mind)

4 7

views feeds again not working yet
by Jim Ruby 27 Oct '11

27 Oct '11

Ok, did some checking on validation services with this link: http://tools.forret.com/podcast/validator.php tried my feed: http://accessibleworld.org/taxonomy/term/16/all/feed saw no enclosures like you do with the following link: http://www.acbradio.org/news/xml/podcast.php?pgm=replay How can I fix this as all my podcast feeds are not delivering the file enclosure. Follow me on: Twitter: http://twitter.com/1rubytweets Facebook: http://www.facebook.com/profile.php?id=1058306793 Join me on: Yahoo: jruby6767 Msn: jruby(a)charter.net

2 4

Another DBTNG question
by Ms. Nancy Wichmann 27 Oct '11

27 Oct '11

Boombatower's conversion doesn't seem to handle HAVING: SELECT uid FROM {userpoints} WHERE uid > 0 GROUP BY uid HAVING SUM(points) > %d I wonder if this even works on a Postgres system, but that's not my issue. How would this convert to DBTNG? Yes, I know I can still do a db_query (as I am currently doing), but I'd like to convert everything. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

3 3

rss.xml empty
by magnus＠ditch.org.uk 26 Oct '11

26 Oct '11

Hi, I am working on an existing site (D6 recently upgraded to D7) where I have found that rss.xml displays only a title but no feed items in a web browser. I am aiming to present feed items in a view. I have been able to create this behaviour using a feed from another website. I am wondering, then, why the rss feed for my own site is not working. I have no documentation about the site, but have observed that the Feeds Aggregator module is installed. Some feeds importers have been created. Deselecting these has produced an extended title for rss.xml and after reselecting the feed importers, that extended title remains, but no feed items are present (recent or old) There are several different custom content types - some are promoted to front page, some not. Can anyone tell me how to recover Drupal's out-of-the-box RSS feed on my site? Thanks & best wishes, Magnus

1 1

File downloads
by Daniel Germer 26 Oct '11

26 Oct '11

Hey, I am looking into a file download tool, I would love it to have the ability to read a complete directory tree and be able to restrict download access to members or a specific Role. An upload facility in the front-end would also be wonderful. As would be the possibility to add rating to files (these are going to be mostly .pdf files but might also be .ppt etc in a university setting. What is a good module to use for that purpose with drupal 7 any suggestions?

2 1

help with: Putting BBOX bounds coordinates defined on openlayers map into the fields in the form
by Tomas KLIMENT 26 Oct '11

26 Oct '11

Dear list, I've just subscribed to this mailing list with need to ask somebody for an advice. I've been working with Drupal since 1 month in order to create sort of metadata (MD) editor for my stakeholders and have encountered one problem, which I could not solve so far using web resources searching. One part of the MD editor - Drupal form has to provide to the metadata producer a field to define Geographic Bounding Box definition by drawing such a box on the map and fill 4 bounds fields (North, East, South and West). An example of such a functionality is shown in attached figure * Figure1_BoundsDefinition_INSPIREGeoportal.png* I am using Drupal version 6, and found similar functionality in the taxonomy terms definition, where within the particular term definition one might define also its geographical bounds as is shown in attached figure *Figure2_Bounds_GeoTaxonomy.png* My question is whether I can implement such a function inside the form, to get bounds to similar fields as depicted on the images? I found also module, which might solve this problem for me most probably (GeoField - http://drupal.org/project/geofield) however it's implementation only for Drupal 7. And actually I'm not sure whether even this module might fulfil my requirements. Many thanks in advance to anybody who might give my any feedbacks, recommendations, hints ... Tomas -- ------------------------------------------------------------------ Ing. Tomas Kliment Contact information: Private: Juzna 4, 04801 Roznava, Slovakia Tel: +421 907 232019 e-mail: tomas.kliment(a)gmail.com www: http://about.me/klimeto Work: Slovak University of Technology Faculty of Civil Engineering Department of Theoretical Geodesy Radlinskeho 11, block A, 5th floor 813 68 Bratislava 15, Slovakia Tel: +421 259274 297 e-mail: tomas.kliment(a)stuba.sk Position: Doctoral student Intership: The National Research Council Institute of ecosystem study Largo Vittorio Tonolli, 50-52 28922 Pallanza Verbania, Piemonte, Italy Position: Junior Researcher - held under the Institute of Marine Science based in Venice Tel: +39 389 4955 954

1 0

help with: bypassing Views Taxonomy filter limitation
by sebastian 26 Oct '11

26 Oct '11

Hello, Have a noodle here. D6, V2. If I make a View and set the filter to: Does NOT contain TERM "personal" And then I run the display, it will NOT show a Node that has ONLY one tag that says "Personal". But if I have more tan one Tag on that node, then it WILL show the Node, making my filter useless... So I wrote a HOOK to pre-process the query: function joinTaxonomy_views_query_alter(&$view, &$query) { if($view->name == 'blog_feed'){ dpm($view); } } Now I can see that there are values I can change, but I am unfortunetly not a mySQL query-master. The $query that it generates*, which needs adjusting, is: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created, node.type AS node_type, node.vid AS node_vid, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.uid AS node_uid FROM {node} node LEFT JOIN {term_node} term_node ON node.vid = term_node.vid LEFT JOIN {term_data} term_data ON term_node.tid = term_data.tid LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (UPPER(term_data.name) NOT LIKE UPPER('%%%s%%')) GROUP BY nid ORDER BY node_created DESC ) count_alias Can anyone tell me what the query SHOULD be so that it excludes any node which has my defined Term-name and not just nodes that ONLY have my designated rejected-term filter? If it is helpful I can give a full-dump of the $views variable here, but trying not to kill you with detail. If a TID is easier, I know the TID and it won't change very often, if ever, so I could hard code it to a number, if that's helpful... Thank you so much for your help! Sincerely, S. * $query taken from: views.inc /** * Execute the view's query. */ function execute($display_id = NULL) { // ... $query // ... }

1 2

Re: [support] Structuring a menu where there's no parent
by DTH 26 Oct '11

26 Oct '11

I (just) have, but unless I'm being dumb (possible), that just seems to allow for easy creation of dropdowns, rather than allowing me to alter the menu structure. > From: Steve Karsch <steve(a)stevekarsch.com> > Have you had a look at Nice Menus? http://drupal.org/project/nice_menus > > On Tue, Oct 25, 2011 at 7:05 AM, DTH <david(a)hartster.org> wrote: >> Am assuming I'm being a bit obtuse, but effectively I want my menu to look like: >> >> ---Home >> ---Events >> -------Event 1 >> -------Event 2 >> -------Event 3 >> ---Contact etc >> >> This will be a dropdown menu, so when people mouseover Events, they >> see the dropdown of Event 1/Event 2/Event 3. This is all fine. >> However, there is no content for an Events page itself, and if someone >> clicks on Events, they should be taken by to the Event 1 page. >> >> What's the neatest way of doing this? I could create a "blank" Events >> page and then redirect somehow (custom module/global redirect?) to >> Event1, but this seems slightly hacky. Is there an alternative. >> >> I'm using D7.

2 2