- Development - lists.drupal.org

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

Multiple strings with same translation may break form functionality
by lodewijk evers 02 Feb '06

02 Feb '06

Today I spent a lot of time tracking why a form did not work and found an issue with translations and a commonly used way of validating forms. In a site with german localization and ecommerce modules I translated a lot of the form submit buttons strings in the checkout process into a generic label "Weiter" (Next in German) and I broke the process. *Why?* Because the "$op" operator is frequently used to check if an action should be performed in a similar way to: <?php switch ($op) { case t('Do something'): ... } ?> And if the translation for 'Do something' just happens to be the same like the translation for another form button in the same series of forms you can guess why it's not working... In my case it was validating an address with the formdata for a shopping cart, and barfed. I don't know if this issue is solved in the forms API for 4.7+ but if it isn't we should look into that. For 4.6 it might be wise to use translations with caution. Regards, Lodewijk Evers Ontwerpwerk multdisciplinary design l.evers(a)ontwerpwerk.nl http://www.ontwerpwerk.nl

1 0

Patch for fixing date support in 4.7b4
by Sammy Spets 02 Feb '06

02 Feb '06

Hi ya'll, Here is my first patch submission of this series. Hope you like it. Problems solved: * Date field data is now returned to the integer state before code reaches the submit stage (changed actually by the validation stage). The change is transparent to modules expecting the integer value to be in $edit. * Dates were creeping backwards by a day each time a form was submitted. This is now fixed. Problem was with expand_date() using the timestamps if user timestamps are enabled. Problem was only evident when using positive timezone offsets. See discussion at the end of this mail for more details. * Date field data is now automatically validated for correctness as a date. I.e whether the silly user entered in 31/Feb/2001. An error message is added with form_set_error(). * Select fields didn't flag errors found in their data. I.e the class attribute of select fields was not set by theme_select. * Date fields didn't display errors as the error cases didn't cascade into the child elements in the form array structures. Lemme know if there is something wrong with this stuff. Discussion ---------- IMO date fields can be classified into two different requirements. First is the kind of date which is the same regardless of your timezone. An example of this is a birthday. Second, the kind of date that changes depending on location such as the submission time of a comment. Dates must to be placed into one of these categories before timezone support is feasible. The first category, dates without timezone, can be displayed by the current date implementation. Unfortunately, the second cannot and must be linked with the time part of the timestamp _at_all_times_. For this reason I proposed a time and datetime time to be placed in core. I'm going to implement the two types and submit a patch. The datetime field will support timezones and the time field will not for the reasons above. As for timezone support overall... there are two snags i ran into while doing some testing. 1) format_date() will break on Windows because it uses gmdate/date. 2) format_date() is broken anyway in the way it calculates the new timestamp. I.e the timestamp must be converted to UTC before adding the timezone to it. Here is an example: say system timezone is +1100 (UNIX timestamp) and user timezone is -0300 timestamp = 2006-02-01 00:00:00 timestamp += timezone // == 2006-01-31 21:00 **wrong** timestamp = 2006-02-01 00:00:00 timestamp -= system_timezone // == 2006-01-31 13:00 timestamp += timezone // == 2006-01-31 10:00 **right!** I haven't fixed this yet as I need more information from developers and decision makers involved with drupal. I have the solution to this in my head. The decision to be made is whether the database stores localtime or UTC. localtime is better because it makes it possible to query the database without doing conversions from UTC. UTC is better because it avoids the common time hurdle with drupal - timezone support sucks. Many of the developers on this list have responded to me with workarounds for various things. Thank you for those. Additionally, i've received something like, "we don't have enough time to put this stuff into drupal before releasing 4.7". The efforts you've all put in has been astounding and by far 4.7 is a major leap forward for drupal. Unfortunately, the celebration of 4.7 is marred for me, and no doubt many others, because fundamental things like date support are still broken since the days of 4.4. How can you even suggest releasing a product out to market that fails to meet the minimum standard of operability and call it a release? Would an OS be released if dates were broken? Even MS won't do that anymore! Drupal is like an OS and the applications are the modules. Don't forget that! <take in a deep breath> All better now. I'm off to add these types to the system. Happy patching! -- Sammy Spets Synerger Pty Ltd http://www.synerger.com/

1 0

RE: [development] wall street journal featuring drupal site!
by Steven Peck 02 Feb '06

02 Feb '06

ironically, my sister in laws site is for her store in Fresno, Ca as well. ;) ________________________________ From: development-bounces(a)drupal.org on behalf of Khalid B Sent: Wed 2/1/2006 6:11 PM To: development(a)drupal.org Subject: Re: [development] wall street journal featuring drupal site! Suzi is thinkinkless http://drupal.org/user/30957 She is active in the community, although more so a few months ago. Here is the site launch http://drupal.org/node/42817 On 2/1/06, ae2005 <kae2005(a)comcast.net> wrote: > check this out!!! > today's wall street journal feature very prominently a drupal site > called > fresno famous. > http://drupal.org/node/47487 > > > anyone know her? suzi arnold

1 0

wall street journal featuring drupal site!
by ae2005 02 Feb '06

02 Feb '06

check this out!!! today's wall street journal feature very prominently a drupal site called fresno famous. http://drupal.org/node/47487 anyone know her? suzi arnold The FresnoFamous folks wouldn't discuss the dollars and cents of the bail-bond ad. But Mr. Gillespie paid just $100 for 10,000 views of his church's banner ad, currently the only one on the Greesnboro site. Based on normal traffic patterns, those views should occur in about two weeks, says Roch Smith Jr., Greensboro101's owner. Mr. Smith, of course, projects that business will grow. But to the extent that it does, competition will be ferocious. Local newspapers of all stripes -- dailies, alternative weeklies and weekly shoppers -- aren't likely to cede these community spaces without a fight. And then there are the "aggregators," companies striving to create a common software platform that can be used in many different locales. Backfence.com5 is a venture capital-funded operation starting out in the suburbs of Washington, D.C. YourHub.com6, owned by the Denver Newspaper Agency, is already active in four states. And then there is the question of what, if anything, the Googles and Yahoos of the world might do. Indeed, Jarah Euston, the 26-year-old former Wall Street bond analyst who founded FresnoFamous two years ago, says that one of her biggest fears is MySpace, the youth-oriented "social networking" site. There is a lot of information about events on MySpace. Ms. Euston frets that it will one day become easily searchable by ZIP Code, and thus compete with the calendar listings currently at the heart of her business. One indication that economies of scale will play their expected crucial role in community journalism is that both Ms. Euston and Mr. Smith are thinking of expanding, Ms. Euston to Modesto, another central California town, and Mr. Smith to Syracuse, N.Y., where he found a simpatico blogger. And both say they would welcome some way for small sites to band together to attract national advertisers while still keeping their independence. So what about the advertisers? Mr. Gillespie says he was drawn to Greensboro101 because he himself is an active blogger. Mr. Ramirez says he was simply trying to help his family-owned business keep up with changing times. (By the way, while most people's stereotype of a typical bail-bond client is not someone reading blog posts, Mr. Ramirez says Web surfers tend to skew young, and the young in turn tend to skew toward getting into trouble.) As for whether the ads have paid off, both men say it is too soon to tell. Community Web sites are clearly one of those economic spaces that are "in play." It's hard not to root for the locally owned little guys, in much the same way that most of us would prefer that local film buffs, not Blockbuster, own the nearby video store. You can find a list of many of community sites at cyberjournalist.net7. I'm inclined to urge people, if they like their local site, to support its advertisers. I'm just a little worried about how some Fresno readers might take that advice. Write to Lee Gomes at lee.gomes(a)wsj.com8 URL for this article: http://online.wsj.com/article/SB113875833236061670.html

2 1

freetagging: let's users select a parent category
by Fabio Varesano 01 Feb '06

01 Feb '06

Hi everybody, I'm currently playing with the new free tagging feature of drupal 4.7 . A feature I would like to have is permits users to select a parent category while adding a free tag. What do you guys think about this? Fabio

5 5