February 2006 - Development - lists.drupal.org

120 Projects pages awaiting moderation
by Kieran Lal 03 Feb '06

03 Feb '06

Hi, as part of the effort to categorize projects I have reviewed the list of projects awaiting moderation. I am not sure where to discuss this. By my count it is almost 120 projects. Some of the project pages go back to 2004. There are around 60 site maintainers for Drupal.org. Are there guidelines for approving Project pages, is there a certain quality that we are looking for? I assume most of the 60 site moderators are on this list so administer >> content Filter status on content type is project and status is unmoderated. Let me know what criteria we want for approving projects and I'll work to get this list of 120 projects approved or deleted so that we can categorize them. If you have some time we are still looking for people to help with coming up with categories for modules here: http://dev.bryght.com/t/wiki/DrupalProjectCategories Cheers, Kieran

6 13

When should a module be tagged DRUPAL-4-7?
by Syscrusher 03 Feb '06

03 Feb '06

Good morning! I think it's safe to say that most of us tag modules for DRUPAL-4-6 and earlier versions only when they are ready for release, rather than being under early development (though there's probably some fuzziness to that line). My question is, should that policy also hold for DRUPAL-4-7 tagging, given that Drupal itself is still in beta, or are we encouraged to tag modules that are in late beta for 4.7 now to encourage more testing? Thanks for any comments. Scott -- ------------------------------------------------------------------------------- Syscrusher (Scott Courtney) Drupal page: http://drupal.org/user/9184 syscrusher at 4th dot com Home page: http://4th.com/

4 4

SQL question.
by Gordon Heydon 03 Feb '06

03 Feb '06

Hi, I have been trying to work out a small sql issue, and I was wondering if someone might be able to help me. Basically I have 2 tables and I was to do a left join and pull out all rows which has a value in the right hand table or doesn't exist. eg. SELECT a.a, a.b, b.a, b.c FROM a LEFT JOIN b ON a.a = b.a WHERE b.c = 'A'; So basically I want it to return. a b a c 1 1 null null 2 2 2 A etc. Or do I need to 2 selects and merge them. When I do this now I get more of an inner join instead of a left join. I am not sure how I say "or doesn't exist". Thanks in advance. Gordon.

4 5

Drupal.org slow query log
by Dries Buytaert 03 Feb '06

03 Feb '06

Drupal.org slowest queries: http://drupal.org/node/47702 I'm cross-posting it here because I posted the issue in the "Drupal.org maintenance" project. Please discuss this in the issue rather than on the mailing list. Thanks. -- Dries Buytaert :: http://www.buytaert.net/

1 0

Re: [development] SQL question.
by Pat Collins 03 Feb '06

03 Feb '06

On Fri, 03 Feb 2006 15:17:39 +1100, Gordon Heydon <gordon(a)heydon.com.au> wrote : > Hi, > > I have been trying to work out a small sql issue, and I was wondering if > someone might be able to help me. > > Basically I have 2 tables and I was to do a left join and pull out all > rows which has a value in the right hand table or doesn't exist. > > eg. > > SELECT a.a, a.b, b.a, b.c FROM a LEFT JOIN b ON a.a = b.a WHERE b.c = > 'A'; > Your where clause is going to limit you to only rows where b.c = 'A'. > So basically I want it to return. > > a b a c > 1 1 null null > 2 2 2 A > So you will probably want to add 'OR b.a is null' (or however you have the lack of value defined) to your WHERE above. Pat

2 1

Why does the 'name' key in {sequences} have the table prefix prepended?
by Rob Thorne 02 Feb '06

02 Feb '06

The CivicSpace folks are fixing a minor issue with their installer. Part of the problem is a quirk in the way that Drupal's database-neutral code handles sequence numbers. For the node table, for example, node_save calls the following code: $node->nid = db_next_id <http://drupaldocs.org/api/4.6/function/db_next_id>('{node}_nid'); So if you have a table prefix of "myprefix_", the actual key in the {sequence} table (where db_next_id() is saving away the last value of the sequence number is going to "myprefix_node_nid", rather than "node_nid". Why is this? This is one of the few places I know of that the table prefix gets pushed into the database. Having had to change the table prefix for a client before, I've been bitten by this a couple of times myself. Is there any reason why we could *not* do this? Rob Thorne Torenware Networks

2 2

Categories for organizing Drupal modules-please categorize your modules
by Kieran Lal 02 Feb '06

02 Feb '06

Hi, we have set up a wiki page to help organize Drupal modules to take advantage of the new categorization in the project module on Drupal.org. If have get a chance to make sure that your modules are categorized on the wiki page that would be appreciated. http://dev.bryght.com/t/ wiki/DrupalProjectCategories Content Types Content extension Editors APIs Filters Media User Mail Presentation Events Community Blogging RSS and XML Utility Developer Tools Search Categories -Managing Categories -Organizing content by Categories -Navigation by Categories Commerce Third party Administration Cheers, Kieran

1 0

why locale import is slow and a memory eater?
by Gabor Hojtsy 02 Feb '06

02 Feb '06

Hi, Dries asked me to look into this for 4.7.0, since those with low memory settings or slow servers experience problems importing PO files. The issue is quite simple: - the import script loads in the complete file into a string (in an uberly complicated way :) - then it splits the string into $lines (into another variable) on which it does the processing - while processing the file, it builds up a $strings array which contains all the parsed information from the $lines array @ at this point, there are three copies of the po file in memory, taking up increasly more space: single string < line-by-line array < parsed array - all the above is done in a function, so when the function returns, the three copies of the file reduces to one (the returned $strings array), which is then processed element by element, and the database is modified accordingly It would be really straightforward to read the file line by line, which should get off a lot of burden from PHP (at least a megabyte of text, plus the overhead of the $lines array structure). That eliminates the first two steps. But then the best would be to directly process the PO tokens as parsed (ie. hand over information to the database as soon as possible, and do not keep a big array of this data in memory). And here comes the question. Now, if a PO file is broken for any reason, the real SQL import process is skipped. But whether the file is broken at some point is only possible to tell, if we parse the file up to that point. If the SQL changes are made incrementally, then the PO file would end up half-imported. Question is if it is a problem or not. I think this is a minor problem, since you are supposed to upload a translation which you are about to use, so if your po file is broken it is not a problem that it is half imported, you should fix and try again. I cannot provide an estimate on when will I have the time to work on this, but the file reading methods seem to be perfect low hanging fruit, even if the more direct SQL import is a bit more time to do. Let us clear up first that the incremental SQL import is sufficient. BTW first to upload files on a hosted environment, this open_basedir compatibility patch needs to get it: http://drupal.org/node/5961 Happy New Year everybody, Gabor

3 4

Drupal Fund raising concert @DrupalCon?
by Trae McCombs 02 Feb '06

02 Feb '06

Hi gang, hunmonk, walkah, myself, chrisxj and a few others wanted to try and put together a mini-rock and roll show for people the Thursday (9th) of DrupalCon. It would be a free event, but we'd ask that people drop say 2 or 3 bucks in a hat. Sure, we probably won't get a lot of money but people will have fun in the name of Drupal Development. The Good news: We've got the musicians willing to perform. We can get equipment. The Bad news: We don't have a place to play. Does anyone know of any venue that will let us jam out? We were hoping we could do it where the conference is held, but from what I understand that isn't exactly an option. We would need a place to practice that Tuesday night, and then we'd perform on the Thursday evening. Ideas? Trae -- Trae McCombs || http://occy.net/ Founder - Themes.org // Linux.com CivicSpaceLabs - http://civicspacelabs.org/

1 0

Uploading static HTML files to Drupal
by Natarajan K 02 Feb '06

02 Feb '06

Hi All, There was this thread about importing static HTML into Drupal at http://lists.drupal.org/archives/development/2006-01/msg00591.html. I spent a few days writing an elementary Drupal class in Python (yeah! Python for a PHP webapp. I wanted to learn Python :)) which lets you add/edit Drupal (version 4.7) nodes programatically. I wrote a small upload app using this class which uploads a directory tree containing static HTML pages to Drupal and rewrites all relative URLs to point to approriate drupal nodes. The files are available at http://puggy.symonds.net/~natarajan/code/drupal/uploader.tar.gz Comments, brickbats, suggestions welcome. Natarajan -- http://puggy.symonds.net/~natarajan

3 2