September 2010 - Development - lists.drupal.org

Re: [development] Drupal.org on HipHop
by Степан Кузьмин 22 Sep '10

22 Sep '10

Wow! I have been waiting it since HipHop was released. Great job! Thanks. 2010/9/22 <development-request(a)drupal.org>: > Send development mailing list submissions to > development(a)drupal.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.drupal.org/mailman/listinfo/development > or, via email, send a message with subject or body 'help' to > development-request(a)drupal.org > > You can reach the person managing the list at > development-owner(a)drupal.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of development digest..." > > > Today's Topics: > > 1. Drupal.org on HipHop (Gerhard Killesreiter) > 2. Re: Problem with db_affected_rows() in MySQL (Nikola Kotur) > 3. Re: Problem with db_affected_rows() in MySQL (Bob Hutchinson) > 4. Re: Drupal.org on HipHop (Gerhard Killesreiter) > 5. Re: Drupal.org on HipHop (Dipen) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 22 Sep 2010 12:49:53 +0200 > From: Gerhard Killesreiter <gerhard(a)killesreiter.de> > Subject: [development] Drupal.org on HipHop > To: "Drupal.org Infrastructure Maintainers" > <infrastructure(a)drupal.org>, development(a)drupal.org > Message-ID: <4C99DF51.1070009(a)killesreiter.de> > Content-Type: text/plain; charset=UTF-8 > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi there, > > I've been following the development of Facebook's HipHop PHP compiler > since February with the intention of setting up a copy of drupal.org on > it. This has now been achieved, see http://driphop.drupal.org/ > > This runs on a copy of the database, so feel free to make any changes. > It uses bakery for authentication, so you should be able to log-in. > > Please report any errors you notice in the infrastructure issue queue, > I've added a driphop.drupal.org component. > > The website might be unavailable from time to time. > > I have not yet done any proper benchmarks for this setup. The aim here > is to find bugs (the fastest php page is the one with a parse error > after all...). > > > Known bugs: > > 1) Due do some issue with the way URL rewriting works in Hiphop vs how t > works in apache, the homepage gives you a 404 but does actually show the > orange d.o box. /node does work, but does not show you the orange box... > > 2) The local task tabs lack some HTML that the CSS needs to render them > properly. Somehow the relevant theme function doesn't appear to get called. > > 3) I've had to remove three blocks that use PHP in the "pages" column. > > 4) Uploaded files are not available and none can be uploaded. > > Thanks to Narayan for getting me a database and to the OSL for loaning > us another VM. > > Cheers, > Gerhard > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (GNU/Linux) > > iEYEARECAAYFAkyZ31EACgkQfg6TFvELooTKLACfUZn2xwluH1u7DChZEtyvo6DG > HYoAoLuCR8PD/5ypWbeUkrs4Yeb6NXhO > =DetO > -----END PGP SIGNATURE----- > > > ------------------------------ > > Message: 2 > Date: Wed, 22 Sep 2010 12:51:17 +0200 > From: Nikola Kotur <kotnick(a)gmail.com> > Subject: Re: [development] Problem with db_affected_rows() in MySQL > To: development(a)drupal.org > Message-ID: <1285152677.3556.15.camel@eton> > Content-Type: text/plain; charset="utf-8" > > On Wed, 2010-09-22 at 15:05 +0530, sivaji j.g wrote: > >> I assume this is with an intention of avoiding duplicate records >> inserts. However in my case db_affected_rows() mostly returns 0 though >> a matching row is found in the table. >> >> I guess it is because the values being updated is same as values >> already available in the row. > > > Yes, as MySQL documentation clearly states: > > For UPDATE statements, the affected-rows value by default is the number > of rows actually changed. If you specify the CLIENT_FOUND_ROWS flag to > mysql_real_connect() when connecting to mysqld, the affected-rows value > is the number of rows ?found?; that is, matched by the WHERE clause. > > http://dev.mysql.com/doc/refman/5.1/en/mysql-affected-rows.html > >

1 0

Problem with db_affected_rows() in MySQL
by sivaji j.g 22 Sep '10

22 Sep '10

Hi, I am using support module for my current projects. This module often runs UPDATE SQL statement and checks db_affected_rows() before issuing INSERT statements like db_query("UPDATE {support_ticket} SET message_id = '%s', state = %d, priority = %d, client = %d, assigned = %d WHERE nid = %d", isset($node->message_id) ? $node->message_id : '', $node->state, $node->priority, $node->client, $node->assigned, $node->nid); if (!db_affected_rows()) { db_query("INSERT INTO {support_ticket} (nid, message_id, state, priority, client, assigned) VALUES(%d, '%s', %d, %d, %d, %d)", $node->nid, isset($node->message_id) ? $node->message_id : '', $node->state, $node->priority, $node->client, $node->assigned); } I assume this is with an intention of avoiding duplicate records inserts. However in my case db_affected_rows() mostly returns 0 though a matching row is found in the table. I guess it is because the values being updated is same as values already available in the row. As a result drupal throws user warning like. user warning: Duplicate entry '292' for key 'PRIMARY' query: INSERT INTO support_ticket (nid, message_id, state, priority, client, assigned) VALUES(292, '', 1, 2, 7, 11) in /sites/all/modules/support/support.module on line 650. I am planning to rewrite all the UPDATE query with SELECT COUNT(*) to fix this. Is there any other workaround available for this ? I am using Drupal 6.19, PHP 5.3 and MySQL Server version: 5.1.41-3ubuntu12.6 (Ubuntu). Thanks in advance. -- Sivaji +91 9941 571 690

3 2

HI is there is any module for this?
by Ramya Rayen 22 Sep '10

22 Sep '10

HI i want to create a website that basically is for (biding's),only for that. i need the following stuffs: 1]user have to buy a bid first(which will be in some particular range) 2]next he can bid on items (note that there might be many users biding on the same item) 3]the person who "BIDS" more(in sense,he bids the "highest") have to be displayed(only his name) for all users those have there bids on that particular item Is there any module for this kind of stuffs?? please help me? Regards, Anto.

2 4

Development platform?
by Jeff Greenberg 22 Sep '10

22 Sep '10

I'm curious to hear what others are using as a development platform. I'm dying a slooooooow motion death on mine. I have a 2GHz dual-core laptop with 3Gb of memory running Vista. I decided I wanted to develop on Linux, so I'm running Vbox with Ubuntu 10.4 as the guest, with 1.5Gb of memory and 50Gb of disk (only using about 8) alloted to it. As I type this message, the letters appear a second or two after I've typed them (thankfully I'm a touch typer and it buffers). Don't even ask about running update.php or bringing up the modules page...several minutes each. In looking at the resource monitor, it's not memory (no paging is going on) but the CPU is pegged. All I have running is firefox, chrome and thunderbird at the moment. Jedit, which is much lighter than JavaBeans, etc., runs painfully slow too. So...ANY ideas (short of tossing the laptop and buying a real workstation) would be greatly appreciated! Jeff

14 16

Importing D7 alpha5 data into D7 alpha7
by Jeff Greenberg 21 Sep '10

21 Sep '10

I applied the D7 alpha 7 release which didn't go too well, so I decided to create a new alpha 7 instance and import the data into it. I moved over all the content tables... blocks, views, field data, node types, node tables, field config tables. Everything is 99% ok, the site looks like it did, I can access everything, my nodes are there, as are the blocks and views. The one odd thing that happened was that in the field_config_entity_type table, the new one had 1 as node and 2 as comment, whereas the older version was the reverse, and all the entity-id's for the fields was 2 (which they should be, having been created for nodes), so I changed node to 2 and comment to 1. The only issue I'm having, which is probably something small with a big result, is that even though all the field data is there, and the field data maps to the node entity type and the correct nodes, when I edit the node the field data is missing, and when I preview a view using those fields the field data is missing, but when I look at the field data in the db it's fine. One hint, though I haven't figured out the cause or correction, is that when I look at the sql generated by the view, it shows field_data_field_myfield.etid = 1 When I put that query in phpmyadmin, and change the value etid to 2, it comes back with data. I can't find where it's getting the value of 1 from. I did clear cache, and all the etid values for in the field config table are 2. Jeff

2 3

Drupal 7 schema changes
by E.J. Zufelt 21 Sep '10

21 Sep '10

Good evening, I'm curious where the best place to subscribe would be to receive notifications of schema or API changes in head (basically anything that may brake a site using d7)? I don't mind having to use the head to head module or some more labour intensive means of correcting problems, but I do need to be notified about the problems I need to fix. Thanks, Everett Zufelt http://zufelt.ca Follow me on Twitter http://twitter.com/ezufelt View my LinkedIn Profile http://www.linkedin.com/in/ezufelt

3 2

PDO question
by Bob Hutchinson 20 Sep '10

20 Sep '10

I'm having problems with a database field which is type 'datetime' in a Drupal 7 install, using alpha7. It installed OK a few months ago but now causes the module install to crash, it would appear that the datetime type is no longer supported or this is a bug in the PDO Database Abstraction Layer. I notice that core modules using timestamp fields are using type 'int', should I do the same? I am reluctant to do this as it will make upgrades from D6 just that much more difficult, I am testing this on Ubuntu 10.04, fully up to date. -- ----------------- Bob Hutchinson Midwales dot com -----------------

5 5

Checking Menu Access for Anonymous User
by Adam B. Ross 20 Sep '10

20 Sep '10

Hello all, I am trying to determine a good approach to identifying whether a specified menu path could be accessed by anonymous users, in an effort to implement some kind of baseline cacheable security for an Input Filter. However, I cannot specify a user with such functions as menu_get_item() to ask for the access right of an anonymous user. Is there a good approach to this? - abr/Grayside

2 2

RSS Feeds
by nan wich 20 Sep '10

20 Sep '10

Does anyone know why the "read more" link on an outgoing RSS feed is a relative link rather than absolute? And then, how to fix it? Nancy

3 4

Book tokens for pathauto
by E.J. Zufelt 20 Sep '10

20 Sep '10

Good morning, I have pathauto setup for book as: book/[node:book] Ideally I'd like to be able to set : books/[book:title]/[node:book] Where book:title is the title of the book's root node, and node:book is the title of the current book page (node). I checked and there don't appear to be modules to provide me with additional tokens for the book module, and I didn't find what I was looking for on the pathauto configuration page. If this is a case where I am missing a simple feature or module I'd love to know. I'd also be willing to write a book token module with more tokens if someone would point me to some type of resource to get started. Thanks, Everett Zufelt http://zufelt.ca Follow me on Twitter http://twitter.com/ezufelt View my LinkedIn Profile http://www.linkedin.com/in/ezufelt

3 5