June 2008 - support - lists.drupal.org

automated response
by Andrew Cohill 08 Jun '08

08 Jun '08

I'll be on vacation through June 13th. Call Design Nine (540-951-4400) if you need immediate help. I'll be checking phone messages daily. Thanks, Andrew

1 0

My site is haunted! SQL code gets changed by the Phantom of SQL Errors!
by Neil: esl-lounge.com 06 Jun '08

06 Jun '08

This is a real head scratcher. I have two sites: mysite.com and it.mysite.com, the Italian version. I noticed this morning a ton of mysql errors on pages where I have a block called "Related Pages". The sql query for this block is: SELECT n.title, n.nid FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid = $term->tid AND n.nid != $nid LIMIT 3 it gets me a list of 3 related pages that share the same taxonomy terms and was working perfectly about 4 days ago the last time I checked. Now it gives me the error: user 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 'DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.t' at line 1 query: SELECT n.title, DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid = 59 AND n.nid != 200 LIMIT 3 in /home/mysite/public_html/includes/database.mysql.inc on line 172. I pasted the code into phpmyadmin and then noticed the difference between this and what I was getting on the Italian site which has identical code. For some reason, the DISTINCT was getting put into the code. So in block config, the code has been pasted as: SELECT n.title, n.nid FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid = $term->tid AND n.nid != $nid LIMIT 3 and yet the query is being sent as: SELECT n.title, DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid = 59 AND n.nid != 200 LIMIT 3 and it is this which is causing an error. In phpmyadmin, when I take away the DISTINCT(), it works like a dream. this is not happening on the Italian site despite identical block code. Now, I have been doing quite a bit of work with phpmyadmin in last few days although I can't think of anything I've changed on the english DB that may have created this result. Do I have to start calling the mediums and reaching for the garlic and crucifix? Neil

3 4

i18n views
by Ámon Tamás 05 Jun '08

05 Jun '08

Hello, I have a multilingual site where I use some table views. How can I translate the fields labels? Ámon Tamás Sitefejlesztő és programozó -- 5NET Informatikai Kft. 1062 Budapest, Aradi utca 38. A 3/11 telefon: (1) 461-0205 | fax: (1) 461-0206 e-mail: amont(a)5net.hu | web: http://www.5net.hu

2 4

control content type on views theme function
by marolijo - Pol Maresma 04 Jun '08

04 Jun '08

Hello, how can I control the content type of a node on a view? I need to personalize the theme output on views_slideshow module depending on the content type, or altenatively on the views name. function theme_views_slideshow_view_list($view, $nodes, $type) $fields = _views_get_fields(); $items = array(); foreach ($nodes as $node) { $item = ''; if ($node->type == 'producte_estrella') { ... thank's Pol Maresma msn: marolijo

1 0

Email members
by The Janitor 04 Jun '08

04 Jun '08

30 May 2008 - 20:49 (where I live) support(a)drupal.org Greetings from a very damp Cambridgeshire I would like to send a one-off message to all (about 90) authenticated members in the simplest possible way. It will be a simple text message just drawing their attention to a new poll. I've looked at a couple of email modules but they seem either overkill or buggy. Alternatively is there a way to harvest members' email addresses so that I can send an group email from my MUA. TIA. -- Best regards, The Janitor mailto:thejanitor@fastmail.fm Flying with The Bat! Professional version 4.0.7 Privileged and/or confidential information and/or copyright material may be contained in this e-mail.If you are not the intended recipient or the person responsible for delivering it to the intended recipient you must not copy it,deliver it to anyone else or use it in anyway whatsoever.To do so is prohibited and may be unlawful. Instead, kindly destroy this message and notify the sender by reply e-mail. Fe all fod gwybodaeth freiniol a/neu gyfrinachol a/neu ddeunydd dan amodau hawlfraint y neges e-bost yma. Os nad y chi sydd i fod gael y neges, neu'r un sy'n gyfrifol am ei throsglwyddo, rhaid i chi beidio a'i chopio na'i throsglwyddo i neb un arall na'i defnyddio mewn unrhyw fodd o gwbl. Mae gwaharddiad ar i chi wneud hynny ac efallai y byddech chi'n torri'r gyfraith trwy wneud hynny. Dinistriwch y neges yma ac anfonwch neges e-bost at y sawl a'i hanfonodd i roi gwybod iddo fe. The author recommends NOD32 (www.eset.com) as the most effective and efficient anti-virus software.

3 4

CCK type of 'person'
by John Furfey 03 Jun '08

03 Jun '08

New to Drupal and trying something which should be easy. Using CCK to create a person type. Fields are to be lastname, firstname, DOB... CCK is forcing me to give each entry a title which doesn't see to make sense, unless I use the persons full name. But I'd rather have this in lastname, firstname fields. Is there a way to add a unique id in the title field and hide it from the public? ------------------------------------------------------------ John Furfey Digital Systems and Services Coordinator MBLWHOI Library Woods Hole MA 02543 USA PHONE: 508-289-7435 EMAIL: jfurfey(a)mbl.edu http://www.mblwhoilibrary.org

3 2

newbie node id
by Brian Wolf 03 Jun '08

03 Jun '08

Hi, I have a "view" that returns node id's . I would like to use these as "links" in the list built by the view. Thanks, Brian _________________________________________________________________ Change the world with e-mail. Join the i’m Initiative from Microsoft. http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld

2 1

Problem with update my Feed
by angappa moorthy 03 Jun '08

03 Jun '08

Hi, I'm using Drupal 5.7, in my site i have created one feed using 'Administer » Content management >> Add Feed'. It's not getting update after i submit my feed and also it's not happing when i update it manually. It is showing the following error, *"The feed from Business seems to be broken, because of error "-10060 10060 A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond."."* (here 'Business' is my feed title). Anybody please help me to solve this problem.. i have proper internet connection and all and when i use this Rss url in my browser it is showing proper response. The url is http://online.wsj.com/xml/rss/0,,3_7077,00.xml. This is exist when i use any RSS url. Thanks & Regards Angappa Moorthy A -- Does everything with sincere and full of enjoyment. Nothing is serious.

2 1

CCK Field Search
by Fred Jones 03 Jun '08

03 Jun '08

I believe this question has been asked before, but I see no clear answer. I have a site with a simple CCK nodetype with a few text fields. We need to implement a 'scholarly' search whereby one can limit one's search by year, Volume, author, or limit his search to the Title field. We want something akin to the author, subject, date feature here: http://scholar.google.co.il/advanced_scholar_search?hl=en&lr= The Faceted Search module I believe may have this functionality, but neither the stable nor beta version will run correctly on the PHP 4 live server and even the stable one doesn't run on my local PHP 5 dev. server. :( Faceted Search is quite a complicated module. My simple approach would be to just run a regular old text search based on the fields submitted. I would have to add an index or two, but aside from that, I think it would work. Are there any better suggestions? Thanks!

3 6

Theme views_slideshow ?
by marolijo - Pol Maresma 02 Jun '08

02 Jun '08

I usually use a phptemplate_views_view_list_contenttype function to theme the output of my views but can't get this to work with this great module http://drupal.org/project/views_slideshow I tryed to use a Slideshow teaser list without results. Any idea how can I do that? Thank's! Pol Maresma PolNetwork.com / pol (a) polnetwork.com msn: marolijo

1 0