bcmiller

from group_members view, and members by role:


mysql> explain SELECT users.uid AS uid,
    ->    users.name AS users_name,
    ->    users.picture AS users_picture,
    ->    og_rap_og_rap_uid.name AS og_rap_og_rap_uid_name
    ->  FROM users users 
    ->  INNER JOIN og_rap_uid og_rap_uid ON users.uid = og_rap_uid.uid
    ->  INNER JOIN og_rap og_rap_og_rap_uid ON og_rap_uid.rid = og_rap_og_rap_uid.rid

bcmiller

http://pdup.allplayers.com/g/group-86938/node/86938/edit

this took 26 seconds:


/* admin : execute */ SELECT DISTINCT node.nid AS nid, node.title AS node_title, og.og_description AS og_og_description, users.name AS users_name, users.uid AS users_uid, (SELECT COUNT(*) FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE ou.nid = og.nid AND u.status > 0 AND ou.is_active >= 1 AND ou.is_admin >= 0 ) AS member_count, node_data_field_nodeorder.field_nodeorder_value AS node_data_field_nodeorder_field_nodeorder_value, node.type AS node_type, node.vid AS node_vid, node_data_field_group.field_group_nid AS node_data_field_group_field_group_nid FROM node node LEFT JOIN og og ON node.nid = og.nid INNER JOIN users users ON node.uid = users.uid LEFT JOIN content_field_nodeorder node_data_field_nodeorder ON node.vid = node_data_field_nodeorder.vid LEFT JOIN content_field_group node_data_field_group ON node.vid = node_data_field_group.vid WHERE (node.status <> 0) AND (node.type IN ('group','association','league','team'

bcmiller

Reading mysql slow query log from /var/run/mysqld/mysqld-slow.log
Count: 2  Time=38237.01s (76474s)  Lock=0.00s (0s)  Rows=0.0 (0), apci[apci]@loc
alhost
  SELECT DISTINCT users.uid AS uid,
  users.picture AS users_picture,
  users.name AS users_name
  FROM users users 
  INNER JOIN og_rap_uid og_rap_uid ON users.uid = og_rap_uid.uid
  INNER JOIN og_rap og_rap_og_rap_uid ON og_rap_uid.rid = og_rap_og_rap_uid.rid
  INNER JOIN og_rap_uid og_rap_og_rap_uid__og_rap_uid ON og_rap_og_rap_uid.rid =

bcmiller

root@pdup:/mnt/apci/main/www#  /mnt/apci/main/www/sites/all/modules/allplayers/apci_aldt_migrate_group_dep/enable_apci_groups
The following updates are pending:

 apci_rules module                                 
 6000 - Install Activity Rules comment integration 

 apci_defaults module                                                          
 6001 - Installing transliteration module                                      
 6002 - Installing loadcache module                                            
 6003 - Installing path_redirect module to redirect   old team urls to groups. 

bcmiller

root@pdup:/mnt/apci/main/www# /mnt/apci/main/www/sites/all/modules/allplayers/apci_aldt_migrate_group_dep/enable_apci_groups
The following updates are pending:

 apci_rules module                                 
 6000 - Install Activity Rules comment integration 

 apci_updates module                                                    
 6051 - Hide Activities from primary links, it's becoming a views block 
 'Groups'.  Hide Home link, per mockup.                                 
 6052 - Remove title from primary-links block.                          

bcmiller

Executing feedback_update_6100                                       [success]
WD php: Incorrect table definition; there can be only one auto column[error]
and it must be defined as a key
query: ALTER TABLE feedback DROP PRIMARY KEY in
/mnt/apci/main/www/includes/database.mysql-common.inc on line 386.
WD php: Multiple primary key defined                                 [error]
query: ALTER TABLE feedback CHANGE `fid` `fid` INT unsigned NOT NULL
auto_increment, ADD PRIMARY KEY (fid) in
/mnt/apci/main/www/includes/database.mysql-common.inc on line 520.
ALTER TABLE {feedback} DROP PRIMARY KEY                              [error]

bcmiller

cvs diff: Diffing .
Index: content_profile.module
===================================================================
RCS file: /cvs/drupal-contrib/contributions/modules/content_profile/Attic/content_profile.module,v
retrieving revision 1.1.2.41
diff -u -p -r1.1.2.41 content_profile.module
--- content_profile.module	5 Aug 2009 14:08:34 -0000	1.1.2.41
+++ content_profile.module	2 Jun 2010 15:14:06 -0000
@@ -24,6 +24,14 @@ function content_profile_ctools_plugin_d
 }

bcmiller

Index: content_profile.module
===================================================================
RCS file: /cvs/drupal-contrib/contributions/modules/content_profile/Attic/content_profile.module,v
retrieving revision 1.1.2.48
diff -u -p -r1.1.2.48 content_profile.module
--- content_profile.module	7 Apr 2010 15:09:17 -0000	1.1.2.48
+++ content_profile.module	2 Jun 2010 15:50:55 -0000
@@ -24,6 +24,14 @@ function content_profile_ctools_plugin_d
 }
 

bcmiller

    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /mnt/apci/main/www/update.php on line 174.

bcmiller

> +++ includes/views/handlers/content_plugin_style_php_array_ac.inc	4 May 2010 23:22:02 -0000
23,60d21
< @@ -21,14 +26,16 @@ class content_plugin_style_php_array_ac 
<      $this->view->row_index = 0;
<      foreach ($sets as $title => $records) {
<        foreach ($records as $label => $row) {
< -        $results[$row->{$base_field}] = array(
< -          'title' => $row->{$title_field_alias},
< -          'rendered' => $this->row_plugin->render($row),
< -        );