Bill C. Miller bcmiller
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> select n.nid,title,delta,field_date_value, from_unixtime(n.created) FROM content_type_vevent ctv LEFT JOIN content_field_date cfd ON ctv.nid = cfd.nid JOIN node n ON ctv.nid = n.nid WHERE field_date_value IS NULL AND n.nid IS NOT NULL; | |
| +--------+----------------------------+-------+------------------+--------------------------+ | |
| | nid | title | delta | field_date_value | from_unixtime(n.created) | | |
| +--------+----------------------------+-------+------------------+--------------------------+ | |
| | 137758 | @ Waukesha West | 0 | NULL | 2010-09-21 15:08:45 | | |
| | 137778 | 18 White Practice | 0 | NULL | 2010-09-21 15:43:00 | | |
| | 145088 | Tryout | 0 | NULL | 2010-10-07 16:29:42 | | |
| | 145098 | Tryout | 0 | NULL | 2010-10-07 16:32:40 | | |
| | 145328 | PTO Meeting | 0 | NULL | 2010-10-10 20:11:27 | | |
| | 145338 | PTO Meeting |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Jun 2 12:59:15 ip-172-19-125-2 drupal: http://10.10.210.201|1307037555|content|10.10.110.4|http://10.10.210.201/api/rest/node/171545||1|view|book: updated Send a broadcast message. | |
| Jun 2 12:59:15 ip-172-19-125-2 drupal: http://10.10.210.201|1307037555|services|10.10.110.4|http://10.10.210.201/api/rest/node/171545||1||Array#012(#012 [values] => Array#012 (#012 [nid] => 171545#012 [vid] => 180165#012 [uid] => 1#012 [created] => 1305670099#012 [type] => book#012 [language] => en#012 [changed] => 1307036731#012 [title] => Send a broadcast message#012 [teaser_js] => #012 [teaser_include] => 1#012 [body] => #015#012#015#012As a group administrator, you can send one message to all of your group members at once using our Broadcast tool.#015#012#015#012Your message will be sent to your members via either email or SMS text. Each member decides the method that is best and most efficient fo |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ubuntu@ip-172-19-125-34:/mnt/apci/main$ git diff mainline/master --numstat1 1 bin/drush | |
| 1 1 bin/pivotalphp | |
| 7 1 www/sites/all/modules/allplayers/apci_group_operations/apci_plugin_argument_default_group_ | |
| 3 1 www/sites/all/modules/allplayers/og_rap/handlers/og_rap_handler_filter_roles.inc | |
| 8 125 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.features | |
| 0 23 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.module | |
| 0 13 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.rules.in | |
| 16 0 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.views.in | |
| 0 1 www/sites/all/modules/apci_features/spaces_og_registration/spaces_og_registration.views_de | |
| 2 2 www/sites/default/default_env_settings.php |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Filesort | |
| +- TEMPORARY | |
| table temporary(nr,n,na) | |
| +- JOIN | |
| +- Distinct/Not-Exists | |
| | +- Filter with WHERE | |
| | +- Bookmark lookup | |
| | +- Table | |
| | | table na | |
| | | possible_keys PRIMARY |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@stats01:~# ps -ef|grep convert | |
| www-data 7371 2723 0 07:37 ? 00:00:00 sh -c /usr/bin/convert 'sites/default/files/group_content_logo/thunder.gif' -crop 720x3000+-267+-1433! -quality '75' 'sites/default/files/imagecache/spaces_photos_photo/group_content_logo/thunder.gif' | |
| www-data 7372 7371 77 07:37 ? 02:00:54 /usr/bin/convert sites/default/files/group_content_logo/thunder.gif -crop 720x3000+-267+-1433! -quality 75 sites/default/files/imagecache/spaces_photos_photo/group_content_logo/thunder.gif | |
| root 14838 9290 0 10:13 pts/1 00:00:00 grep convert | |
| root@stats01:~# ps -ef|grep 2723 | |
| www-data 2723 2700 0 07:10 ? 00:00:10 /usr/sbin/apache2 -k start | |
| www-data 7371 2723 0 07:37 ? 00:00:00 sh -c /usr/bin/convert 'sites/default/files/group_content_logo/thunder.gif' -crop 720x3000+-267+-1433! -quality '75' 'sites/default/files/imagecache/spaces_photos_photo/group_content_logo/thunder.gif' | |
| root 14840 9290 0 10:13 pts/1 00:00:00 grep 2723 | |
| root@stats01:~# |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE menu_links SET options='a:0:{}', module='book' WHERE menu_name LIKE 'book%'; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@ip-172-19-1-3:/mnt/apci/main/www/sites/all# drush updatedb | |
| The following updates are pending: | |
| apci_media_mover module | |
| 6010 - Add cloudfront on media mover configs for Image node image to S3 | |
| Do you wish to run all pending updates? (y/n): y | |
| Executing apci_media_mover_update_6010 [success] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@ip-172-19-1-3:/mnt/apci/main/www/sites/all# drush updatedb | |
| The following updates are pending: | |
| apci_media_mover module | |
| 6010 - Add cloudfront on media mover configs for Image node image to S3 | |
| Do you wish to run all pending updates? (y/n): y | |
| Executing apci_media_mover_update_6010 [success] |
bcmiller
/ harvest issues
Created
October 14, 2010 02:50
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Oct 13 21:44:34 stats01 crontab[6318]: (root) LIST (root) | |
| Oct 13 21:44:46 stats01 drupal: http://www.allplayers.com|1287024286|FeedsScheduler|127.0.0.1|http://www.allplayers.com/cron.php||0||Finished processing schedule after 0 sec. | |
| Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6340]: (root) CMD (/mnt/apci/main/www/sites/scripts/feature-check 2>&1 >/dev/null) | |
| Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6341]: (root) CMD ([ -x /usr/lib/sysstat/sa1 ] && { [ -r "$DEFAULT" ] && . "$DEFAULT" ; [ "$ENABLED" = "true" ] && exec /usr/lib/sysstat/sa1 $SA1_OPTIONS 1 1 ; }) | |
| Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6368]: (root) CMD (/mnt/apci/main/scripts/phpwarn.pl 2>&1 >/dev/null) | |
| Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6369]: (www-data) CMD (/mnt/apci/default_profile-grab.sh 2>&1 >/dev/null) | |
| Oct 13 21:45:26 stats01 drupal: http://www.allplayers.com|1287024326|php|127.0.0.1|http://www.allplayers.com/cron.php||0||User warning: S3::deleteObject(): [NoSuchBucket] The specified bucket does not exist in S3::deleteObject() (line 738 of /mn |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid INNER JOIN node node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN content_field_date node_data_field_date2 ON node.vid = node_data_field_date2.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 9735 AND na.realm = 'statusbook_friend') OR (na.gid = 9805 AND na.realm = 'statusbook_friend') OR (na.gid = 9835 AND na.realm = 'statusbook_friend') OR (na.gid = 9855 AND na.realm = 'statusbook_friend') OR (na.gid = 9865 AND na.realm = 'statusbook_friend') OR (na.gid = 9895 AND na.realm = 'statusbook_friend') OR (na.gid = 9925 AND na.realm = 'statusbook_friend') OR (na.gid = 9935 A |