December 2005 - Development - lists.drupal.org

Fwd: [General inquiry (other)] Amazing ...
by Dries Buytaert 18 Dec '05

18 Dec '05

Begin forwarded message: > From: josef.vesely(a)acn.pc.cz > Date: Sun 18 Dec 2005 03:15:22 GMT+01:00 > To: info(a)drupal.org > Subject: [General inquiry (other)] Amazing ... > > > Josef Vesely sent a message using the contact form at > http://drupal.org/contact: > > I just want say thank you for your perfect job. For now .... > I tried geeglog, php nuke, phpwebsite ... but DRUPAL is faraway > ahead. I > did not learn nothing and just by intuition i set everything up in 5 > minutes. > > JOSEF VESELY -- Dries Buytaert :: http://www.buytaert.net/

3 2

Taking over the revieew module
by andrew morton 18 Dec '05

18 Dec '05

I just wanted to let everyone know that I'm taking over the review module from Ber. I've just about gotten the module rewritten for 4.7. In addition to a basic review node, new version uses hook_nodeapi so that any node can be decorated with a rating. Your feedback and criticism are welcome, andrew

1 0

RE: [development] Re: [infrastructure] CVS repositories on the move
by Steven Peck 18 Dec '05

18 Dec '05

You're kidding right? Please click this link http://themes.drupal.org/ :) ________________________________ From: development-bounces(a)drupal.org on behalf of Larry Garfield Sent: Sat 12/17/2005 7:38 AM To: development(a)drupal.org Subject: Re: [development] Re: [infrastructure] CVS repositories on the move On Saturday 17 December 2005 03:38 am, Dries Buytaert wrote: > The move has been successful. People have been happily committing > patches to the new server and the drupal-cvs mailing list works > again. Special thanks to Michael Marineau (marineam) from the OSL > for doing all the hard work and preparation. > > Except for http://drupaldocs.org/ everything is now running on the > OSL infrastructure. Hooray! Congrats to everyone involved. Any chance of getting themes.drupal.org back, now that Drupal has its own server farm? :-) -- Larry Garfield AIM: LOLG42

3 2

CVS repositories on the move
by Dries Buytaert 18 Dec '05

18 Dec '05

Hello world, we're going to move the CVS repositories from the old server to our server at the OSL. The OSL prepared the move, and we're ready to switch in 20 minutes. The repositories might be unavailable for 20 minutes as we copy the latest snapshot to the new server and as the DNS records propagate. Except for the downtime, the changes should be transparant. -- Dries Buytaert :: http://www.buytaert.net/

3 3

SQL snippets
by puregin 18 Dec '05

18 Dec '05

Hi all, I've just added a handbook page for SQL snippets, paralleling the PHP page and PHP block snippets that we already have. http://drupal.org/node/41586 The idea is to have a place to share SQL scripts as shortcuts for achieving certain configurations, for moving databases from one site to another, or other maintenance, configuration or development tasks. Cheers, Djun

1 0

You guys like knowing this sort of thing
by Earl Dunovant 18 Dec '05

18 Dec '05

Tim Berners-Lee, inventer of the web, blogs on a Drupal-based site. It's not a design wonder, but I can't help but see it as a technological affirmation. http://dig.csail.mit.edu/breadcrumbs/blog/4

2 1

More profiling code -- Database queries
by Mike Gifford 17 Dec '05

17 Dec '05

Hi folks, I've done another set of database patches and have them in the CVS here: sandbox/mgifford/patches/memory_profiling Hopefully they are clear enough to apply to the 4.6 code base. I've got it up and running here now (scroll way down to the bottom -- hmm.. actually you have to be logged in... Not sure why that is the case... Feedback on that would be cool..): http://civicspace2.openconcept.ca/ With 53 modules enabled there were 99 sql queries taking 2.136 seconds. That just seems a bit silly when you're just trying to load the main page of a site.. Yikes, if it were busy there could be thousands of queries an hour.. Anyways, I've done some work on sorting by the query, by the time it takes to execute the query, by the time between queries and finally the number of queries coming from each function. This still needs some work, but it's a reasonable start. I'm in a bit of a rush for some other projects so my reply might be a bit delayed, but I am interested in getting feedback on this (especially as it may affect the effectiveness of the launch). Suggestions formatting this array so that it is more readable would be useful. Also, would really like to group the queries so I know which module is responsible for which queries. I'd like to know which are the expensive ones and which are ones that are more affordable (such as I did in the memory profiling which comes above it). Final memory usage for page 21,451 Kb. Number of modules 53 * civicrm 7044 Kb * event 1231 Kb * flexinode 793 Kb * location 760 Kb * user 610 Kb * mailhandler 509 Kb * node 503 Kb * massmailer 436 Kb * volunteer 356 Kb * pathauto 342 Kb * webform 337 Kb * rsvp 333 Kb * filter 324 Kb * aggregator 317 Kb * taxonomy 308 Kb * forum 270 Kb * system 243 Kb * tinymce 229 Kb * image 224 Kb * profile 194 Kb * privatemsg 191 Kb * lobby 181 Kb * theme_editor 177 Kb * search 176 Kb * feedback 174 Kb * foaf 173 Kb * phplist 172 Kb * block 150 Kb * echopetition 146 Kb * menu 143 Kb * statistics 138 Kb * node_import 135 Kb * upload 132 Kb * poll 116 Kb * locale 107 Kb * target 89 Kb * forms 86 Kb * blog 76 Kb * path 71 Kb * massmailertemplate 70 Kb * massmailer_rolelists 58 Kb * i18n 58 Kb * optin 51 Kb * watchdog 48 Kb * contact 44 Kb * taxonomy_menu 42 Kb * throttle 31 Kb * notify 21 Kb * help 20 Kb * page 15 Kb * mailalias 12 Kb * urlfilter 11 Kb * fontsize 9 Kb Queries for page 102. Time for page 2.934 Sort by Query warning: array_multisort() [function.array-multisort]: Array sizes are inconsistent in /home/civicspace82/public_html/index.php on line 62. * q) SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1 time between queries 7.4E-05 time for query 0.002412 /home/civicspace82/public_html/includes/ session.inc session_start * q) SELECT data, created, headers FROM cache WHERE cid = 'variables' time between queries 0.003297 time for query 0.001858 / home/civicspace82/public_html/includes/bootstrap.inc variable_init * q) SELECT * FROM url_alias time between queries 0.047179 time for query 0.001757 /home/civicspace82/public_html/includes/common.inc drupal_get_normal_path * q) SELECT name, filename, throttle, bootstrap FROM system WHERE type = 'module' AND status = 1 time between queries 0.000472 time for query 0.002581 /home/civicspace82/public_html/includes/ module.inc module_load_all * q) SELECT locale, name FROM locales_meta WHERE enabled = 1 ORDER BY isdefault DESC, name ASC time between queries 1.459143 time for query 0.001796 /home/civicspace82/public_html/modules/i18n/ i18n.module i18n_supported_languages * q) SELECT data, created, headers FROM cache WHERE cid = 'menu: 1:en' time between queries 0.008991 time for query 0.003842 /home/ civicspace82/public_html/includes/menu.inc menu_get_menu * q) SELECT * FROM system WHERE type = 'theme' ORDER BY name time between queries 0.006924 time for query 0.001991 /home/ civicspace82/public_html/includes/theme.inc init_theme * q) SELECT COUNT(*) FROM privatemsg WHERE recipient = '1' AND newmsg = 1 AND recipient_del = 0 time between queries 0.018845 time for query 0.001601 /home/civicspace82/public_html/modules/privatemsg/ privatemsg.module privatemsg_menu * q) SELECT COUNT(*) FROM node_access WHERE nid = 0 AND CONCAT (realm, gid) IN ('all0') AND grant_view = 1 time between queries 0.011821 time for query 0.002054 /home/civicspace82/public_html/ modules/node.module node_db_rewrite_sql * q) SELECT COUNT(*) FROM node n WHERE (n.language ='en' or n.language = '') AND n.promote = 1 AND n.status = 1 time between queries 0.000749 time for query 0.002306 /home/civicspace82/ public_html/modules/node.module node_page_default * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '47' time between queries 0.004199 time for query 0.001674 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM files WHERE nid = 47 time between queries 0.001402 time for query 0.001467 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT * FROM variable WHERE name like 'event_nodeapi_%' time between queries 0.00036 time for query 0.001915 /home/ civicspace82/public_html/modules/event/event.module event_is_enabled * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:1:b32d6b0c4516f99e96b9e5dd821b83ba' time between queries 0.000804 time for query 0.001206 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 47 ORDER BY weight, name time between queries 0.002972 time for query 0.002078 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT * FROM flexinode_type time between queries 0.002094 time for query 0.0015 /home/civicspace82/public_html/modules/ flexinode/flexinode.module flexinode_node_types * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '59' time between queries 0.005586 time for query 0.001582 /home/civicspace82/public_html/modules/node.module node_page_default * q) SHOW FIELDS FROM webform time between queries 0.000563 time for query 0.001484 /home/civicspace82/public_html/modules/webform/ webform.module webform_load * q) SELECT confirmation, email, email_from, email_subject FROM webform WHERE nid = 59 time between queries 0.00047 time for query 0.001075 /home/civicspace82/public_html/modules/node.module node_invoke * q) SELECT cid, name, type, value, extra, mandatory, weight FROM webform_component WHERE nid = 59 ORDER BY weight, name time between queries 0.000326 time for query 0.001678 /home/civicspace82/ public_html/modules/node.module node_invoke * q) SELECT rid FROM webform_role_node WHERE nid = 59 time between queries 0.000298 time for query 0.001695 /home/civicspace82/ public_html/modules/node.module node_invoke * q) SELECT * FROM files WHERE nid = 59 time between queries 0.001235 time for query 0.001011 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 1 time between queries 0.000847 time for query 0.002063 /home/civicspace82/ public_html/modules/webform/webform.module webform_view * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:3:50a42961df5a36d07d849c4c715425ae' time between queries 0.00043 time for query 0.001159 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 59 ORDER BY weight, name time between queries 0.002882 time for query 0.000998 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '58' time between queries 0.005514 time for query 0.001494 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM flexinode_type WHERE ctype_id = 1 time between queries 0.000663 time for query 0.001038 /home/civicspace82/ public_html/modules/flexinode/flexinode.module flexinode_load * q) SELECT * FROM flexinode_field WHERE ctype_id = 1 ORDER BY weight ASC, label ASC time between queries 0.000328 time for query 0.001718 /home/civicspace82/public_html/modules/flexinode/ flexinode.module flexinode_load * q) SELECT flexinode_1.textual_data AS flexinode_1, flexinode_1.numeric_data AS flexinode_1_format FROM node n LEFT JOIN flexinode_data flexinode_1 ON n.nid = flexinode_1.nid AND flexinode_1.field_id = 1 WHERE n.nid = 58 time between queries 0.000598 time for query 0.001576 /home/civicspace82/public_html/ modules/node.module node_invoke * q) SELECT event_start, event_end, timezone FROM event WHERE nid = 58 time between queries 0.000718 time for query 0.001748 /home/ civicspace82/public_html/modules/node.module node_invoke_nodeapi * q) SELECT * FROM location WHERE type = 'node' AND oid = 58 time between queries 0.007896 time for query 0.007418 /home/ civicspace82/public_html/modules/node.module node_invoke_nodeapi * q) SELECT * FROM files WHERE nid = 58 time between queries 0.001099 time for query 0.000908 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT wanted, uid, message_approve, message_deny, message_wait, message_reminder, message_follow_up FROM volunteer WHERE nid = 58 time between queries 0.000515 time for query 0.001776 / home/civicspace82/public_html/modules/node.module node_invoke_nodeapi * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:3:ae2b1fca515949e5d54fb22b8ed95575' time between queries 0.001043 time for query 0.001375 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT u.uid FROM rsvp r LEFT JOIN rsvp_invite u ON r.rid = u.rid WHERE r.nid = 58 AND u.uid = 1 time between queries 0.010988 time for query 0.002764 /home/civicspace82/public_html/modules/rsvp/ rsvp.module rsvp_link * q) SELECT uid FROM rsvp WHERE nid = 58 AND uid = 1 time between queries 0.000351 time for query 0.000931 /home/civicspace82/ public_html/modules/rsvp/rsvp.module rsvp_link * q) SELECT count(cid) AS approved FROM volunteer_contact_event WHERE nid = 58 AND stage > 2 time between queries 0.001141 time for query 0.001805 /home/civicspace82/public_html/modules/volunteer/ volunteer.module volunteer_link * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 58 ORDER BY weight, name time between queries 0.001317 time for query 0.003931 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '57' time between queries 0.186883 time for query 0.001615 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT flexinode_1.textual_data AS flexinode_1, flexinode_1.numeric_data AS flexinode_1_format FROM node n LEFT JOIN flexinode_data flexinode_1 ON n.nid = flexinode_1.nid AND flexinode_1.field_id = 1 WHERE n.nid = 57 time between queries 0.000768 time for query 0.001124 /home/civicspace82/public_html/ modules/node.module node_invoke * q) SELECT event_start, event_end, timezone FROM event WHERE nid = 57 time between queries 0.000676 time for query 0.001062 /home/ civicspace82/public_html/modules/node.module node_invoke_nodeapi * q) SELECT * FROM location WHERE type = 'node' AND oid = 57 time between queries 0.002493 time for query 0.001333 /home/ civicspace82/public_html/modules/node.module node_invoke_nodeapi * q) SELECT * FROM files WHERE nid = 57 time between queries 0.001122 time for query 0.000969 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT wanted, uid, message_approve, message_deny, message_wait, message_reminder, message_follow_up FROM volunteer WHERE nid = 57 time between queries 0.000541 time for query 0.001128 / home/civicspace82/public_html/modules/node.module node_invoke_nodeapi * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:3:df702b7c03b5fbe12a5dc187de5a8210' time between queries 0.001037 time for query 0.001197 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT u.uid FROM rsvp r LEFT JOIN rsvp_invite u ON r.rid = u.rid WHERE r.nid = 57 AND u.uid = 1 time between queries 0.006801 time for query 0.001135 /home/civicspace82/public_html/modules/rsvp/ rsvp.module rsvp_link * q) SELECT uid FROM rsvp WHERE nid = 57 AND uid = 1 time between queries 0.000352 time for query 0.000994 /home/civicspace82/ public_html/modules/rsvp/rsvp.module rsvp_link * q) SELECT count(cid) AS approved FROM volunteer_contact_event WHERE nid = 57 AND stage > 2 time between queries 0.001545 time for query 0.000957 /home/civicspace82/public_html/modules/volunteer/ volunteer.module volunteer_link * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 57 ORDER BY weight, name time between queries 0.001262 time for query 0.001047 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '56' time between queries 0.203868 time for query 0.001698 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM echopetition WHERE nid='56' time between queries 0.000521 time for query 0.003024 /home/civicspace82/ public_html/modules/node.module node_invoke * q) SELECT * FROM files WHERE nid = 56 time between queries 0.003423 time for query 0.001026 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT * FROM echopetition_signup p WHERE petition=56 ORDER BY timestamp DESC time between queries 0.000689 time for query 0.001904 /home/civicspace82/public_html/modules/node.module node_invoke * q) SELECT s.name FROM tinymce_settings s INNER JOIN tinymce_role r ON r.name = s.name WHERE r.rid IN (2,3) time between queries 0.001741 time for query 0.043682 /home/civicspace82/ public_html/includes/module.inc call_user_func_array * q) SELECT * FROM role ORDER BY name time between queries 0.00027 time for query 0.011205 /home/civicspace82/public_html/ modules/tinymce/tinymce.module tinymce_profile_load * q) SELECT * FROM tinymce_settings time between queries 0.000322 time for query 0.00091 /home/civicspace82/public_html/ modules/tinymce/tinymce.module tinymce_textarea * q) SELECT rid FROM tinymce_role WHERE name = 'new' time between queries 0.000374 time for query 0.000968 /home/civicspace82/ public_html/modules/tinymce/tinymce.module tinymce_textarea * q) SELECT filename FROM system WHERE name = 'cathrine' AND type = 'theme' time between queries 0.001798 time for query 0.001534 / home/civicspace82/public_html/includes/common.inc drupal_get_path * q) select count(petitionSignupID) from echopetition_signup where petition=56 time between queries 0.001577 time for query 0.007906 /home/civicspace82/public_html/modules/node.module node_invoke * q) SELECT COUNT(*) FROM echopetition_signup p WHERE petition=56 time between queries 0.000505 time for query 0.001103 / home/civicspace82/public_html/modules/echopetition/ echopetition.module echopetition_signees * q) SELECT echopetition_fields.*, zipcodes.city as city, zipcodes.state as state FROM echopetition_fields LEFT JOIN zipcodes ON (echopetition_fields.fieldValue = zipcodes.zip AND echopetition_fields.fieldName='zipcode') WHERE petitionSignupID=1 time between queries 0.001562 time for query 0.002601 /home/ civicspace82/public_html/modules/echopetition/echopetition.module echopetition_view * q) INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', 'gethostbyaddr() [function.gethostbyaddr]: Address is not a valid IPv4 or IPv6 address in /home/civicspace82/public_html/modules/echopetition/ echopetition.module on line 235.', 2, '', '/', '209.217.66.8', 1134766823) time between queries 0.001224 time for query 0.00835 / home/civicspace82/public_html/includes/common.inc error_handler * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 56 ORDER BY weight, name time between queries 0.003675 time for query 0.001152 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '54' time between queries 0.010415 time for query 0.001653 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM files WHERE nid = 54 time between queries 0.001478 time for query 0.000958 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:3:8fa836ee6744d0706c2e8a4138fd5b21' time between queries 0.000786 time for query 0.001184 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 54 ORDER BY weight, name time between queries 0.00871 time for query 0.001133 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '53' time between queries 0.026748 time for query 0.0016 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM files WHERE nid = 53 time between queries 0.001442 time for query 0.00082 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:1:930f6b97f0c6c47dcdf8c058df3cc6f8' time between queries 0.003021 time for query 0.001139 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 53 ORDER BY weight, name time between queries 0.002521 time for query 0.001089 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '52' time between queries 0.005496 time for query 0.001404 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM eaction_lobby WHERE nid = 52 time between queries 0.014626 time for query 0.001715 /home/civicspace82/ public_html/modules/lobby/lobby.module lobby_load * q) SELECT ttid FROM eaction_lobby2targettype WHERE nid=52 time between queries 0.000346 time for query 0.004285 /home/civicspace82/ public_html/modules/lobby/Data/Lobby.php Data_Lobby load * q) SELECT t.* FROM eaction_lobby2target lt INNER JOIN be_contact t ON t.contactID = lt.tid WHERE lt.nid=52 AND lt.ttid=0 ORDER BY t.lastName, t.firstName time between queries 0.000447 time for query 0.002498 /home/civicspace82/public_html/modules/lobby/Data/ Lobby.php Data_Lobby load * q) SELECT * FROM files WHERE nid = 52 time between queries 0.001468 time for query 0.000823 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:3:8d161b64cd8a3a4dfe1ccd08db272650' time between queries 0.000864 time for query 0.001284 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 52 ORDER BY weight, name time between queries 0.003149 time for query 0.001153 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '51' time between queries 0.018827 time for query 0.001569 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM eaction_lobby WHERE nid = 51 time between queries 0.001722 time for query 0.00105 /home/civicspace82/ public_html/modules/lobby/lobby.module lobby_load * q) SELECT ttid FROM eaction_lobby2targettype WHERE nid=51 time between queries 0.000341 time for query 0.000834 /home/civicspace82/ public_html/modules/lobby/Data/Lobby.php Data_Lobby load * q) SELECT t.* FROM eaction_lobby2target lt INNER JOIN be_contact t ON t.contactID = lt.tid WHERE lt.nid=51 AND lt.ttid=0 ORDER BY t.lastName, t.firstName time between queries 0.00043 time for query 0.003905 /home/civicspace82/public_html/modules/lobby/Data/ Lobby.php Data_Lobby load * q) SELECT * FROM files WHERE nid = 51 time between queries 0.001363 time for query 0.000974 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:1:c6e15f12e193fcbbabf4bf1c8c2bdb56' time between queries 0.000922 time for query 0.001165 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 51 ORDER BY weight, name time between queries 0.003183 time for query 0.001125 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE (n.language ='en' or n.language = '') AND n.nid = '50' time between queries 0.016451 time for query 0.001523 /home/civicspace82/public_html/modules/node.module node_page_default * q) SELECT * FROM eaction_lobby WHERE nid = 50 time between queries 0.003707 time for query 0.001011 /home/civicspace82/ public_html/modules/lobby/lobby.module lobby_load * q) SELECT ttid FROM eaction_lobby2targettype WHERE nid=50 time between queries 0.000415 time for query 0.000722 /home/civicspace82/ public_html/modules/lobby/Data/Lobby.php Data_Lobby load * q) SELECT t.* FROM eaction_lobby2target lt INNER JOIN be_contact t ON t.contactID = lt.tid WHERE lt.nid=50 AND lt.ttid=0 ORDER BY t.lastName, t.firstName time between queries 0.000399 time for query 0.001271 /home/civicspace82/public_html/modules/lobby/Data/ Lobby.php Data_Lobby load * q) SELECT * FROM files WHERE nid = 50 time between queries 0.00151 time for query 0.000946 /home/civicspace82/public_html/ modules/upload.module upload_nodeapi * q) SELECT data, created, headers FROM cache WHERE cid = 'filter:1:6d59713e68d5817a37f0ec437fb2beed' time between queries 0.000903 time for query 0.001139 /home/civicspace82/public_html/ modules/filter.module check_output * q) SELECT t.* FROM term_data t, term_node r WHERE r.tid = t.tid AND r.nid = 50 ORDER BY weight, name time between queries 0.002629 time for query 0.001088 /home/civicspace82/public_html/ modules/taxonomy.module taxonomy_link * q) SELECT * FROM blocks WHERE status = 1 AND region IN (0) ORDER BY weight, module time between queries 0.009747 time for query 0.002222 /home/civicspace82/public_html/includes/module.inc call_user_func_array * q) SELECT DISTINCT(n.nid), e.event_start FROM event e INNER JOIN node n ON n.nid = e.nid WHERE (n.language ='en' or n.language = '') AND n.status = 1 AND ((e.event_start > 1133395200 AND e.event_start < 1136073599) OR (e.event_end > 1133395200 AND e.event_end < 1136073599) OR (e.event_start < 1133395200 AND e.event_end > 1136073599)) ORDER BY event_start time between queries 0.040751 time for query 0.002103 /home/civicspace82/public_html/ modules/event/event.module event_render_day_single * q) SELECT * FROM blocks WHERE status = 1 AND region IN (1) ORDER BY weight, module time between queries 0.046837 time for query 0.001267 /home/civicspace82/public_html/includes/module.inc call_user_func_array * q) SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1134764124 AND uid = 0 time between queries 0.001107 time for query 0.001587 /home/civicspace82/public_html/includes/module.inc call_user_func_array * q) SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1134764124 AND uid != 0 GROUP BY uid ORDER BY max_timestamp DESC time between queries 0.000474 time for query 0.003134 /home/civicspace82/public_html/includes/module.inc call_user_func_array * q) SELECT locale, name, formula, enabled FROM locales_meta ORDER BY isdefault DESC, enabled DESC, name ASC time between queries 0.000482 time for query 0.00782 /home/civicspace82/public_html/ modules/locale.module locale_get_plural * q) SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1 time between queries 0.002503 time for query 0.001398 /home/civicspace82/public_html/modules/user.module user_block * q) SELECT * FROM location WHERE type = 'user' AND oid = 1 time between queries 0.000929 time for query 0.001389 /home/civicspace82/ public_html/modules/user.module user_module_invoke * q) SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 1 time between queries 0.006245 time for query 0.001019 /home/civicspace82/ public_html/modules/profile.module profile_user * q) INSERT INTO accesslog (title, path, url, hostname, uid, timestamp) values('', 'node', '', '209.217.66.8', 1, 1134766824) time between queries 0.364266 time for query 0.00218 /home/civicspace82/ public_html/includes/module.inc call_user_func_array * q) INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', 'array_multisort() [function.array-multisort]: Array sizes are inconsistent in /home/ civicspace82/public_html/index.php on line 62.', 2, '', '/', '209.217.66.8', 1134766824) time between queries 0.002466 time for query 0.001153 /home/civicspace82/public_html/includes/common.inc error_handler Mike -- Mike Gifford, OpenConcept Consulting Free Software for Social Change -> http://openconcept.ca http://del.icio.us/mgifford/drupal http://flickr.com/photos/mgifford/ sets/1178930/ Latest Drupal Launch -> CLC -> http://action.clc-ctc.ca/

1 1

Issues for 4.7 release cycle (wasDrupal 4.7.0 beta2 / rc?)
by puregin 17 Dec '05

17 Dec '05

On 14-Dec-2005, at 5:54 AM, Dries Buytaert wrote: >> I would think the next beta should be pushed when the only bugs >> left on the critical list are ones that should really have >> normal priority. > May I suggest that everyone bookmarks the following URL: > > http://drupal.org/project/issues? > projects=3060&categories=bug,task&priorities=1&states=1,8,13,14,2 > > It is a list of all critical bugs in core that need attention. > There are approximately 190 critical bugs at the time of this writing. 1) Is there a policy regarding what constitutes critical, normal, minor? It looks to me like some of the given critical issues are not as critical as others. 2) Would it make sense to go through the list of issues and prune them? Then we can encourage people to look at only issues that are truly critical. I'd be happy to take a crack at 2), if someone could answer 1) for me. 3) Also, a number of critical issues relate to versions 4.6 and earlier. How can we figure out which of these are relevant to the 4.7 release candidates? If an issue is reported against version 4.5, but it also applies to CVS, should the version be changed to CVS? Is these some magic that updates issue tagged with CVS once a release is tagged? Djun

3 2

Release critical bugs for December 17, 2005
by drupal-devel＠drupal.org 17 Dec '05

17 Dec '05

/ bug reports Article tag repeating age: 4 weeks 5 days url: http://drupal.org/node/37544 PHP 4.4.1 breaks Article Categories list age: 6 weeks 1 day url: http://drupal.org/node/36245 / bug reports email spam filtering does not "see" email addresses when they are NOT preceded by a word age: 47 weeks 6 days url: http://drupal.org/node/15654 / bug reports Getting Buddylist ready for 4.7 age: 3 weeks 2 days url: http://drupal.org/node/38683 / bug reports No check for loading chatbox with other name age: 3 weeks 5 days url: http://drupal.org/node/38397 / bug reports broken config screen age: 5 weeks 3 days url: http://drupal.org/node/36949 / bug reports Event start and end times not getting saved in database age: 1 day 20 hours url: http://drupal.org/node/41300 event_calendar_data : warning: gmdate() [function.gmdate]: Windows does not support dates prior to midnight (00:00:00), January age: 1 week 1 day url: http://drupal.org/node/40470 Issues with list view for events age: 1 week 5 days url: http://drupal.org/node/39943 Database error keeps popping up age: 2 weeks 3 days url: http://drupal.org/node/39396 Events module bugs adding and changeing events age: 2 weeks 6 days url: http://drupal.org/node/39016 / feature requests Checkbox to disable Ical link age: 1 week 6 days url: http://drupal.org/node/39848 Events only for registered users age: 8 weeks 2 days url: http://drupal.org/node/34640 / support requests Date problem on calendar, off by a day age: 2 weeks 4 days url: http://drupal.org/node/39193 displaying event start info in flexinode tabular view? age: 10 weeks 4 days url: http://drupal.org/node/33019 Event block missing content of many fields age: 12 weeks 6 days url: http://drupal.org/node/31532 / bug reports file size bug age: 27 weeks 1 day url: http://drupal.org/node/24728 / bug reports Latest patch hosed my G2 integration and G2 Standalone age: 2 weeks 4 days url: http://drupal.org/node/39168 problem viewing newly added photos in embedded gallery. age: 3 weeks 5 days url: http://drupal.org/node/38352 problem viewing newly added photos in embedded gallery. assigned: trobison age: 3 weeks 5 days url: http://drupal.org/node/38351 Search results give incorrect links age: 9 weeks 6 days url: http://drupal.org/node/33539 Full screen slideshow in Gallery module is not working (erroring out on the wrong URL) age: 23 weeks 2 days url: http://drupal.org/node/26479 / support requests Gallery Module stopped working age: 1 week 4 days url: http://drupal.org/node/40117 import existing gallery2 user account age: 6 weeks 4 days url: http://drupal.org/node/35920 / feature requests Goofy Forum UI age: 11 weeks 4 days url: http://drupal.org/node/32294 / bug reports Image.module don't work witch drupal 4.7 assigned: Alexey age: 8 hours 3 min url: http://drupal.org/node/41470 By CHanging the following the error changes assigned: walkah age: 1 day 9 hours url: http://drupal.org/node/41353 Deleting Image gallery age: 2 weeks 4 days url: http://drupal.org/node/39290 imagemagick.inc file does not contain the function... age: 4 weeks 6 days url: http://drupal.org/node/37372 Error when Submitting New Image Node age: 4 weeks 6 days url: http://drupal.org/node/37366 only variables can be passed by reference on line 713 age: 6 weeks 2 days url: http://drupal.org/node/36092 image.module 4.6.0 strange actions age: 10 weeks 1 day url: http://drupal.org/node/33292 File copy failed: source file does not exist error after running update-image.php age: 12 weeks 3 days url: http://drupal.org/node/31816 Path for image folder not inserted correctly when nodetype = image age: 15 weeks 3 days url: http://drupal.org/node/30031 image module patch & image_import module age: 16 weeks 5 days url: http://drupal.org/node/29377 image module fails on dual site configuration age: 22 weeks 2 days url: http://drupal.org/node/26657 Cannot upload .jpgs age: 41 weeks 5 days url: http://drupal.org/node/18076 / feature requests Copying original age: 6 weeks 1 day url: http://drupal.org/node/36321 Image deletions? age: 14 weeks 3 days url: http://drupal.org/node/30557 / support requests images not showing2 age: 2 weeks 4 hours url: http://drupal.org/node/39773 Image Folder Permissions age: 8 weeks 15 hours url: http://drupal.org/node/34839 Images are there but not showing assigned: Stepfordtwit age: 20 weeks 2 days url: http://drupal.org/node/27615 Image Module Permissions age: 23 weeks 6 days url: http://drupal.org/node/26280 / bug reports Listhandler caused error in "comment.module on line 996" ? age: 6 weeks 1 day url: http://drupal.org/node/36244 / tasks Correct/Complete Documentation age: 7 weeks 6 days url: http://drupal.org/node/34909 / bug reports Error on retreiving mail age: 2 weeks 4 days url: http://drupal.org/node/39178 / bug reports Fatal error, form_textfield() on fresh drupal 4.7 beta installation age: 1 week 1 day url: http://drupal.org/node/40493 Error when deleting nodes or in the case below - error when deleting a taxonomy term age: 2 weeks 3 hours url: http://drupal.org/node/39781 / feature requests Description as a tag in the theme. age: 2 weeks 3 days url: http://drupal.org/node/39354 / bug reports nodes are being created with no body age: 1 week 2 days url: http://drupal.org/node/40373 missing promote column assigned: Bèr Kessels age: 3 weeks 1 day url: http://drupal.org/node/38836 Naming issues with files and DB tables age: 8 weeks 5 days url: http://drupal.org/node/34298 RSS "no element found at line 1" age: 24 weeks 21 hours url: http://drupal.org/node/26185 Outdated help texts age: 1 year 19 weeks url: http://drupal.org/node/9692 Import doesn't like XML/RSS feeds with no Title element age: 1 year 28 weeks url: http://drupal.org/node/8128 / tasks move XML-parser into an inclde file. age: 25 weeks 4 days url: http://drupal.org/node/25439 / bug reports Notify not playing well with Organic Groups age: 4 days 12 hours url: http://drupal.org/node/40967 / feature requests Notify.module ignores the true submission queue age: 2 years 7 weeks url: http://drupal.org/node/3765 / bug reports Login as an alias gets cached age: 12 weeks 4 days url: http://drupal.org/node/31699 / bug reports support dynamic content? age: 4 weeks 7 hours url: http://drupal.org/node/38181 please explain html2fpdf age: 4 weeks 3 days url: http://drupal.org/node/37748 Management of french charaters age: 5 weeks 5 days url: http://drupal.org/node/36605 / feature requests Internationalization support for PDF assigned: TheLibrarian age: 1 year 37 weeks url: http://drupal.org/node/6795 / bug reports anonymous users can create folders and view all anonymous sent-mail age: 1 day 7 hours url: http://drupal.org/node/41361 error when trying to send private message age: 1 week 13 hours url: http://drupal.org/node/40626 privatemsg not working with current head age: 13 weeks 1 hour url: http://drupal.org/node/31469 Reminder email links don't work age: 25 weeks 1 day url: http://drupal.org/node/25677 / feature requests Simplified Chinese translations age: 4 weeks 5 days url: http://drupal.org/node/37505 / support requests fatal error on line 723 age: 6 days 5 hours url: http://drupal.org/node/40750 / bug reports Issues from multiple projects listed on a single issue's page age: 3 weeks 2 days url: http://drupal.org/node/38704 Get disconnected from server on attempting to add an issue age: 6 weeks 2 days url: http://drupal.org/node/36124 can't select all projects age: 10 weeks 1 day url: http://drupal.org/node/33262 Can't update issue title from issue comment assigned: nedjo age: 10 weeks 5 days url: http://drupal.org/node/32843 Projects not listed and page not complete age: 28 weeks 4 days url: http://drupal.org/node/23956 Date for latest is incorrect age: 35 weeks 2 days url: http://drupal.org/node/20485 / feature requests Need Documentation age: 1 week 1 day url: http://drupal.org/node/40392 Search by Version age: 4 weeks 20 hours url: http://drupal.org/node/38122 Assign Anyone age: 4 weeks 23 hours url: http://drupal.org/node/38107 Allow subscription to individual project issues age: 8 weeks 3 days url: http://drupal.org/node/34496 Implement XML-RPC functionlality for communication between drupal.org and Drupal installations age: 9 weeks 21 hours url: http://drupal.org/node/34108 / support requests Add the project release manually without the scan feature age: 8 weeks 3 days url: http://drupal.org/node/34500 / bug reports Error with URL to recipe age: 15 weeks 5 days url: http://drupal.org/node/29885 / feature requests Request to generate email for all content changes/additions, including comments age: 22 weeks 3 hours url: http://drupal.org/node/26824 / bug reports Wrong URL mask age: 7 weeks 3 days url: http://drupal.org/node/35215 / bug reports Does not work correctly in Internet Explorer age: 10 weeks 1 day url: http://drupal.org/node/33354 Blocks switch and reset when vocabs are modified age: 31 weeks 2 days url: http://drupal.org/node/22631 javascrip downloads square.gif for every category age: 43 weeks 4 days url: http://drupal.org/node/17366 / feature requests A unique page for each category group? age: 8 weeks 2 days url: http://drupal.org/node/34610 / support requests Taxonomy has dissapeared age: 10 weeks 3 days url: http://drupal.org/node/33061 / bug reports Sends trackbacks for unpublished nodes assigned: ankur age: 46 weeks 2 days url: http://drupal.org/node/16239 / bug reports meet age: 4 days 2 hours url: http://drupal.org/node/40996 411 error when upgrading using Firefox 1.5 age: 1 week 22 hours url: http://drupal.org/node/40551 / feature requests A small but effective improvement to Improvement of admin/user accessability suggestion age: 9 weeks 1 day url: http://drupal.org/node/34073 / support requests Fatal Error age: 2 weeks 22 hours url: http://drupal.org/node/39701 Acess denied to login Newly installed and upgraded site that I need up and running A.S.A.P assigned: Johnny age: 3 weeks 6 days url: http://drupal.org/node/38227 / bug reports Resolution appears to be in the cvs version of the linkattach module assigned: hintbw age: 8 weeks 1 day url: http://drupal.org/node/34765

1 0

Postgres- For compatibility reasons we don't drop columns but rename them?
by Neil Drumm 17 Dec '05

17 Dec '05

From the documentation of hook_update_N(): Dropping a column: MySQL: ALTER TABLE {$table} DROP $column Postgres: ALTER TABLE {$table} RENAME $column TO $column_old // For compatibility reasons we don't drop columns but rename them Why do we do this? What compatibility reasons? -- Neil Drumm http://delocalizedham.com/

7 7