- Development - lists.drupal.org

Allowing users to create easy pre-fab sites?
by Bob Fishel 28 Jul '10

28 Jul '10

Is anyone aware of anyone using Drupal as a hosting system. My goal is to allow users (probably through OG + Domain Access + Domain Access Advanced + ubercart) to purchase a hosting plan and automatically have a domain set up for them. My users are all in the same industry so the type of nodes they will need to create can be boiled down to a simple 3-4 types. Basically I want them to be able to: 1. Be assigned a template domain/site with some default pages with some lorem ipsum text (should be easy to accomplish using rules) 2. Be able to switch themes on their domain only (I'm not sure how to do this) 3. It'd be totally awesome if they could modify there themes by dragging and dropping blocks to change the layout of their particular site (again no idea how to do this) 4. Grant other users the ability to edit their site (I'm not sure how to do this without exposing my entire user list to them....) Thanks -Bob

6 6

Drupal 7 API Change notification: Schema date/time types removed
by Randy Fay 28 Jul '10

28 Jul '10

*We try to notify this list when API changes are made in Drupal 7, so contrib and custom developers have a chance to fix their code before they have the pain of figuring out why it's broken. *In (issue <http://drupal.org/node/866340>) the date:normal, datetime:normal, and time:normal types were removed from the Schema API. If you used these in your code, you have changes to make. -Randy -- Randy Fay Drupal Module and Site Development randy(a)randyfay.com +1 970.462.7450

1 0

High volume site, benchmarking
by Dayton Perkins 28 Jul '10

28 Jul '10

I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- /Kindest regards,/ *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 http://goodnewsdesign.com Signature <http://goodnewsdesign.com>

6 7

Fancy Node Access with OG
by Adam B. Ross 28 Jul '10

28 Jul '10

I'm working on a node access module to stomp all over OG's og_public grant realm. As part of this process, I am conditionally creating a grant that specifically grants no access. It appears this grant does not even get written to the node_access table. This would not be a problem, except (or so I surmise) without a "0" in the update column of that table, users that are not members of a given group can go directly to node/#/edit and make changes. (On account of the <em>edit any **** content type</em> permission. Is there some way I can simply revoke access to nodes? Why am I attempting this madness? I am attempt to skate along the top of the Spaces module.

3 3

Madhusudhan Srinivasa has invited you to Dropbox
by Dropbox 27 Jul '10

27 Jul '10

We're excited to let you know that Madhusudhan Srinivasa has invited you to Dropbox! Madhusudhan Srinivasa has been using Dropbox to sync and share files online and across computers, and thought you might want it too. Visit http://www.dropbox.com/link/20.hVL39qgILC/NjI2OTAwNTQ5Nw to get started. - The Dropbox Team ____________________________________________________ To stop receiving invites from Dropbox, please go to http://www.dropbox.com/bl/7e5ec61eecd4/development%40drupal.org

5 5

node_load() oddness
by Brian Vuyk 23 Jul '10

23 Jul '10

Can anyone think of a situation where a node_load() contained in a function returns partial results when the function is called from a batch script? I have a simple function that I am calling the from a batch API script that processes through a bunch of nodes to fix filepaths in certain migrated content. I've begun experiencing a strange issue while testing it; I've boiled it down to the following test case: <?php function migration_fix_photos($nid) { $node = node_load($nid); dpm($node); drupal_set_message('NID is ' . $nid); } ?> When I call this function with a given NID from a batch script, on some runs, the $node object returned by $node_load is only partially loaded - it has 3 of the 10-12 CCK fields the node should contain, also, $node->title, $node->nid, $node->uid and $node->type are missing from the object, among other portions. The behavior changes between runs of the batch script. I can run a testing run, and only get partially loaded nodes. I can re-run the batch script, and they are fully loaded. Note that this changes per-run of the batch script, not per-call of the function. That is, when the batch script operates on 2000 nodes, the partial node_load() will or will not happen for all 2000 times the above function is run. I could run the batch script again, and get perfectly normal results for all 2000 nodes next time. If I call the above function directly, it shows correct results every time. This only happens when called from a batch script. Note that the $nid argument is always shown as correct (tested with the drupal_set_message() call). Does anyone have any ideas why this is happening? I have tried using Xdebug, but I can't determine how to attach onto the background AJAX requests the browser is making.

6 12

Recommendations for audio playlists player?
by Domenic Santangelo 22 Jul '10

22 Jul '10

I'm trying to make the following possible: -Add audio files with titles and possibly descriptions to Drupal. Either 1 audio file per node, or many per node, whatever. -Display them in an embedded audio player that does a playlist. Additionally, the files in the playlist should be customizable -- switched out, reordered, etc. I've done single-file node/players a ton of times but never tried the jukebox thing. Any pointers? Thx, -D

2 1

Views Exposed filter hiding field values
by Idan Arbel 22 Jul '10

22 Jul '10

Hello, I have a very strange issue with views exposed filter - I have a node with a cck select fields with to values "give" and "take" These fields are used as an exposed filter so that users can filter the list according to either give or take, I'm using the "is none of" operator because I want a user to see the opposite of what he's selected - filter by give you see all the takes, filter by take you see all the gives. So far so good. The weird issue is that I'm displaying the field value (under fields). And when I filter according to the field, the value is missing. So I filter according to "give" I see all the take nodes, but the field that displayes the "take" is missing. When I don't use the exposed filter (set to any) I see the fields. Now when I change the exposed filter operator to "is one of" I see the field when filtering. Any idea why this is happening - the exposed filter shouldn't really affect individual fields correct? Idan

1 0

with anonymous user able to edit nodes
by Idan Arbel 22 Jul '10

22 Jul '10

Hello, I have strange critical issue with anonymous user being able to edit nodes. I have nodes created by anonymouse users (created using node import) and any anonymous user can edit them. in the permissions anonymous user don't have permissions to edit anything. Idan

8 12

MySql Performance Problem
by nan wich 20 Jul '10

20 Jul '10

I suppose this is my fault for packing so much into a single query, but I really do want to use tablesort on it. Here's the query (pager_query with a limit of 20) SELECT n.nid, n.title, n.status, n.created, n.uid, ra.energy, nc.totalcount, nc.daycount, ppc.totalcount AS printcount, pmc.sentcount, r.realname, cs.comment_count, v.value AS votes FROM node n INNER JOIN realname r ON r.uid=n.uid INNER JOIN radioactivity ra ON ra.id=n.nid LEFT JOIN node_counter nc ON nc.nid=n.nid LEFT JOIN node_comment_statistics cs ON cs.nid=n.nid LEFT JOIN votingapi_cache v ON v.content_id=n.nid AND v.function='sum' LEFT JOIN print_page_counter ppc ON ppc.path=CONCAT('node/', n.nid) LEFT JOIN print_mail_page_counter pmc ON pmc.path=CONCAT('node/', n.nid) WHERE n.type = 'blog' AND n.status = 1 ORDER BY ra.energy DESC On my test site, this runs really fast - but there are only 6 rows. On the production site, there are 8,000 nodes and this query takes 35 seconds to run. EXPLAIN tells me: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ra ALL PRIMARY NULL NULL NULL 6 Using temporary; Using filesort 1 SIMPLE n eq_ref PRIMARY,node_status_type,node_type,uid PRIMARY 4 drupal6b.ra.id 1 Using where 1 SIMPLE nc eq_ref PRIMARY PRIMARY 4 drupal6b.n.nid 1 1 SIMPLE cs eq_ref PRIMARY PRIMARY 4 drupal6b.ra.id 1 1 SIMPLE v ALL NULL NULL NULL NULL 3729 1 SIMPLE ppc ALL PRIMARY NULL NULL NULL 2738 1 SIMPLE pmc ALL PRIMARY NULL NULL NULL 2745 1 SIMPLE r eq_ref PRIMARY PRIMARY 4 drupal6b.n.uid 1 Using where With the performance I see, I am not suprised to see "filesort" in there. Can someone suggest ways to improve the performance? Nancy

6 9