August 2010 - Development - lists.drupal.org

Convert query to COUNT query
by nan wich 17 Aug '10

17 Aug '10

I'm havng trouble getting my head around converting this to a count query for doing a pager_query. SELECT c.name, c.mail, COUNT(*) AS num, pv.value AS usertype, td.name AS role FROM {comments} c INNER JOIN {node} n ON n.nid=c.nid INNER JOIN {term_node} tn ON tn.nid=n.nid AND tn.vid=n.vid INNER JOIN {term_data} td ON td.tid=tn.tid AND td.vid = 2 LEFT JOIN {profile_values} pv ON pv.uid=c.uid AND pv.fid = 13 WHERE c.mail <> '' GROUP BY role, c.mail ORDER BY num DESC I know the pv.value (usertype, LEFT JOIN profile_values) is not needed. But a user (c.mail) will end up in multiple roles (td,name, this is not the same as a Drupal role), so DISTINCT is my real downfall here. Nancy

3 4

Wierd URL in logs.
by nan wich 17 Aug '10

17 Aug '10

This is more of a minor annoyance than a serious issue. I see in dblog that I am getting this a few times a day - unfortunately it seems to be most often with the CEO. I am getting a"Page not found" on URLs like http://www.example.com/valid_category/-//W3C//DTD%20XHTML%201.0%20Strict//EN. Obviously someone is picking up some of the DOCTYPE information. Has anyone else ever seen this? Does anyone have an idea how to get it fixed? Nancy E. Wichmann, PMP Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

5 6

Re: [development] Features/drush issue
by Pierre Rineau 17 Aug '10

17 Aug '10

Le mardi 17 août 2010 à 16:46 +0200, Adrian Rossouw a écrit : > On 17 Aug 2010, at 10:05 AM, Pierre Rineau wrote: > > > > > Me neither, all of my features always goes to overridden as soon as they > > are activated. Drupal configuration such as variables etc might do this. > > I don't think this is really a problem, but more likely a normal side > > effect due to a more global site configuration done outside the feature > > itself, which seems quite unavoidable on most sites. > > use strongarm to get variables into features. Strongarm is quite brutal, I already use it for some variables, but not all of these will be strongarmed. Some variable will still be overriden by other modules installation procedure, or normal site usage. Plus, I made quite "fluid" features, which enable or disable variables, features (not development seed features), does some configuration bits depending of the other installed modules. What I meant is once your feature is enabled, and your site living, this is totally normal that they'd finish overriden sooner or later. Pierre.

1 0

Email content type UTF8 not accepted
by Diego G 17 Aug '10

17 Aug '10

Hello everyone I have a module that sends text/html emails using the function drupal_mail(). Everything was working fine until I needed to send them in German, instead of English. I changed the email's content type header to "text/html; charset=utf-8", but the email is always sent as "text/html; charset=iso-8859-1", and the German characters are not properly shown. I tried to send it to several different mail servers (yahoo, hotmail, and others), and the result was the same. Intriguingly, when I change the content type to "text/plain; charset=utf-8", the charset is kept UTF-8, as I want, and the characters are properly shown. This problem only happens when the content type is "text/html". I also tried to set the content type header within the html code to "text/plain; charset=utf-8" too, but the problem persisted. It seems like Drupal is changing the charset to iso-8859-1. Does anyone have any idea of what is causing this problem? Cheers Diego This is my code: ... $language = user_preferred_language(); $params = array( 'subject' => t('Test'), 'body' => t($message, $variables, $language->language) ); drupal_mail('notification', 'notice', $email, $language, $params); ... function notification_mail($key, &$message, $params) { $message['headers']['Content-Type'] = "text/html; charset=utf-8"; $message['subject'] = $params['subject']; $message['body'][] = $params['body']; }

3 4

Features/drush issue
by Leo Burd 17 Aug '10

17 Aug '10

Hello there, For some reason, I'm unable to get rid of the "overridden" message that is associated with all the different features in my site. That message seems to always be associated with CCK and fieldgroup components. Also, no features get listed whenever I run "drush features". Does anyone have any suggestions on how to solve this problem? Thanks in advance, Leo

3 2

check path access on hook_view
by Lluís Forns 16 Aug '10

16 Aug '10

Is there a way to check if user have access to node/123/my_module/tab so link is shown in hook_view from another node just if user have access to it? thanks -- *Les normes hi són perquè hi pensis abans de saltar-te-les *La vida és com una taronja, què esperes a exprimir-la? *Si creus que l'educació és cara, prova la ignorància. *La vida és com una moneda, la pots gastar en el que vulguis però només una vegada. *Abans d'imprimir aquest missatge, pensa en el medi ambient.

2 2

Redirection issue with drupal_http_request
by nitin gupta 14 Aug '10

14 Aug '10

Hi, I recently came across this issue when drupal_http_request reported error (-1002 - missing schema) for the following URL: http://feedproxy.google.com/~r/variety/news/film/~3/ksODaiUYe-U/VR1118022938 This URL redirects twice. For the first time, it returns the location: http://www.variety.com/article/VR1118022938?categoryid=3762&cs=1&nid=2564&u… with 302 code. This URL when requested returns the Location: /article/VR1118022938.html?categoryid=3762&cs=1&nid=2564&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+variety%2Fnews%2Ffilm+%28Variety+-+Film+News%29 with 302 code. As the drupal_http_request requests the location, a missing schema error is reported. Whereas the browser, and the following test site: http://www.rexswain.com/cgi-bin/httpview.cgi, correctly returns the content of the page. Is drupal_http_request missing some recommended functionality? -- Regards, Nitin Kumar Gupta http://publicmind.in/blog/

3 2

Update on DrupalCon Copenhagen Core developer summit
by Gábor Hojtsy 12 Aug '10

12 Aug '10

Hello World, Earlier this year, for DrupalCon San Francisco, we introduced the new concept of the Core developer summit, which reaches back to the original Drupal developer meetups allowing for planning, problem solving and coding for Drupal core developers. It makes it possible to get together in one space to plan ahead and solve problems at hand. We always keep looking at ways to improve our processes, and for the summit announced for Drupalcon Copenhagen, we’ve seen less interest in presenting improvement suggestions and more on looking at how Drupal 7 can be brought forward. So our plan for the Core developer summit in Copenhagen is twofold: provide a place to plan ahead and hammer some outstanding issues for Drupal 7 at the same time. The upcoming summit on 22nd August 2010 will start with kick-off sessions for these two groups, Dries Buytaert presenting for the Drupal 7 focus group and Sam Boyer and Jen Simmons presenting about core and process improvements. Jen talks about making Drupal a better HTML (5) generating machine, while Sam talks about improving our revision control account application process, which is the gate to Drupal contributions. After the kick-off sessions, we’ll break up into two groups and provide plenty of space to be fruitful and get stuff done. If you are interested in planning improvements for our processes and code and/or getting Drupal 7 released sooner, the core summit is for you! We are still looking for people to sign up at http://cph2010.drupal.org/core-developer-summit/register Gábor Hojtsy (summit coordinator)

1 0

Temporary form data storage ... and avoiding validation
by Jeff Greenberg 12 Aug '10

12 Aug '10

I'm using a module-generated form in a mode like a shopping cart, where the user can add data to it, go to other pages, and come back to it, and the data persists. At first I wasn't submitting the data until it was time to complete the process, and so, to persist the data, I was using variable_get/set because without the form being submitted, nothing was being persisted in form_state. However, I've since switched to each of the buttons (return to other pages, update form, submit) causing a submit, with varying logic based on which button was clicked. I discovered (duh!) that variable_set/get was a poor idea, because two users online at the same time end up would get each other's persisted data on the form. So, two questions. Is form_state going to persist the user data for me between form loads, or is there a better method? And I've run into an interesting problem in that the portion of the form with required fields (name, etc) doesn't need to be filled in until the user wants to submit, but of course, that ends up throwing an error when the form is 'submitted' due to one of the other buttons being clicked. Is there a way to have those buttons cause a submit, but bypass validation?

6 7

Re: [development] D6 Content Migration to another D6 Installation
by As If Productions 12 Aug '10

12 Aug '10

At 02:15 PM 8/11/2010, Phil Glanville wrote: >would it (in theory) be possible to copy just 'node' or content >specific db tables without causing serious problems? Not only in theory, but in practice! I would never depend on a module to do this for me, and I do a lot of migrations. If the two sites are literally identical (content types, fields, taxonomy), you can just directly copy the old tables to the new database. The node and node_revisions tables are particularly safe in this regard. CCK stuff requires more finesse. In complex cases, a few simple PHP scripts can connect to both databases and directly query the specific tables you wish to address. These scripts can also handle any data manipulation that needs to occur in order to make the old schema data fit the new schema (if/when there are any differences between them). Basically you write scripts that SELECT data from the old DB and manipulate them one row at a time into an INSERT query on the other DB. The only prerequisite is that you need to be intimately familiar with the DB schemas, and how various Drupal tables relate to each other. Dump both DBs before starting, so you can roll back if anything goes wacky. LVX TF --- As If Productions http://www.asifproductions.com Interactive Worlds and Immersive Obsessions

2 1