Update 7040: 38900 records to examine. [status] The external command could not be executed due to an application error. ( 7.x-1.11) [#2658808]

Update db after updating module with drush failed. I can see this link https://www.drupal.org/node/2573869, is this is same problem in new version or I am doing something wrong. please suggest ?

Thanks!

Comment	File	Size	Author
#34	metatag-n2658808-34.patch	775 bytes	tommik
#34	7.x-1.x: PHP 5.3 & MySQL 5.5, D7 118 pass PHP 5.6 & MySQL 5.5, D7 118 pass
#13	metatag-n2658808-13.patch	748 bytes	DamienMcKenna
#13	7.x-1.x: PHP 5.3 & MySQL 5.5, D7 106 pass PHP 5.6 & MySQL 5.5, D7 106 pass

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

29 January 2016 at 10:55

jas1988 created an issue. See original summary.

Comment #2

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 10:56

Issue summary:

View changes

Comment #3

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 11:08

Title:

Update 7040: 38900 records to examine. [status] The external command could not be executed due to an

» Update 7040: 38900 records to examine. [status] The external command could not be executed due to an application error.

Comment #4

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 11:09

Title:

Update 7040: 38900 records to examine. [status] The external command could not be executed due to an application error.

» Update 7040: 38900 records to examine. [status] The external command could not be executed due to an application error. ( 7.x-1.11)

Comment #5

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 12:38

Are there any errors logged in Watchdog?

Comment #6

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 12:43

Thanks for your reply, but there are no such errors I can see but there I one post related to this I think http://drupal.stackexchange.com/questions/28824/error-when-updating-modu... Is this may be reason, what are your thoughts ?

Comment #7

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 12:47

there is info in logs which just say :

Update 7040: 38900 records to examine

but noting else. please suggest ?

Comment #8

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 12:47

Can you please try running "drush updatedb -y -v" and then paste in what is output?

Comment #9

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 12:52

Please check this is what it shows:

using host to connect to db
Initialized Drupal 7.41 root directory at /var/www/mysite                                                                                                                                  [notice]
Initialized Drupal site default at sites/default                                                                                                                                                    [notice]
Executing: mysql --defaults-extra-file=/tmp/drush_VDakMh --database=mysite --host=db --port=3306 --silent  < /tmp/drush_VOZSaU
Executing: mysql --defaults-extra-file=/tmp/drush_TXaO12 --database=mysite --host=db --port=3306 --silent  < /tmp/drush_Dnr3oF
 Metatag                7040  Fix robots meta tags that might have been broken when they were imported  from Nodewords.                   
 Metatag                7041  Rerun update 7018 that was fixed to run correctly when using Entity  Translation. This may take some time.  
 Metatag                7100  Delete a deprecated variable and clear all Metatag caches.                                                  
 Metatag                7101  Update i18n strings for all meta tags to use the new format.                                                
 Metatag                7102  Re-run update 7101.                                                                                         
 Metatag                7103  Clear all metatag caches so the new entity caching structure takes over.                                    
 Metatag                7104  Remove the entity revision ID from the translation strings.                                                 
 Metatag                7105  Fix the output translation strings.                                                                         
 Metatag                7106  The output translation strings were renamed to something shorter, so rerun  update 7105.                    
 Metatag_opengraph      7103  Change og:video to og:video:url in all metatags.                                                            
 Metatag_opengraph      7104  Rename the 'og:video' meta tag to 'og:video:url' in the configs.                                            
 Metatag_opengraph      7105  Clear the Metatag cache to pick up changes to og:video.                                                     
 Metatag_opengraph      7106  Clear the Metatag cache to pick up changes to og:audio:secure_url.                                          
 Metatag_twitter_cards  7100  Rename the 'twitter:image:src' meta tag back to 'twitter:image'. Sorry.                                     
 Metatag_twitter_cards  7101  Rename the 'twitter:image:src' meta tag back to 'twitter:image', part 2.                                    
 Metatag_twitter_cards  7102  Clear the Metatag cache.
Do you wish to run all pending updates? (y/n): y
env COLUMNS=204 /usr/local/bin/drush  --backend=2 --verbose --yes --root=/var/www/mysite --uri=http://default  updatedb-batch-process 1109 1109 -u 0 2>&1                                          [notice]
Initialized Drupal 7.41 root directory at /var/www/mysite                                                                                                                                       [notice]
Initialized Drupal site default at sites/default                                                                                                                                                    [notice]
Executing: mysql --defaults-extra-file=/tmp/drush_WK1m0d --database=mysite --host=db --port=3306 --silent  < /tmp/drush_xZrpYL
Executing: mysql --defaults-extra-file=/tmp/drush_zIoM67 --database=mysite --host=db --port=3306 --silent  < /tmp/drush_tCXy3F
Executing metatag_update_7040                                                                                                                                                                       [notice]
WD metatag: Update 7040: 38928 records to examine.                                                                                                                                                    [info]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Executing metatag_update_7040                                                                                                                                                                       [notice]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Update 7040: 38928 records to examine.                                                                                                                                                           [status]
Command dispatch complete                                                                                                                                                                           [notice]
The external command could not be executed due to an application error.                                                                                                                          [error]
env COLUMNS=204 /usr/local/bin/drush  --backend=2 --verbose --yes --root=/var/www/mysite --uri=http://default  cache-clear all 2>&1                                                                [notice]
Initialized Drupal 7.41 root directory at /var/www/mysite                                                                                                                                          [notice]
Initialized Drupal site default at sites/default                                                                                                                                                    [notice]
Executing: mysql --defaults-extra-file=/tmp/drush_r4xMGH --database=mysite--host=db --port=3306 --silent  < /tmp/drush_KGBhn9
Executing: mysql --defaults-extra-file=/tmp/drush_zuejPO --database=mysite--host=db --port=3306 --silent  < /tmp/drush_3jJ1fg
WD actions: 5 orphaned actions (views_bulk_operations_archive_action, views_bulk_operations_argument_selector_action, views_bulk_operations_delete_item, views_bulk_operations_delete_revision,       [info]
views_bulk_operations_modify_action) exist in the actions table. Remove orphaned actions

Comment #10

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 13:05

What version of Drush are you using? And just to confirm it, did you upgrade from D6 to D7 with this site and then run the importer to convert Nodewords records?

Comment #11

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 13:20

using host to connect to db
 Drupal version                  :  7.41                                            
 Site URI                        :  http://default                                  
 Database driver                 :  mysql                                           
 Database hostname               :  db                                              
 Database port                   :  3306                                            
 Database username               :  mysite                                          
 Database name                   :  mysite                                          
 Drupal bootstrap                :  Successful                                      
 Drupal user                     :                                                  
 Default theme                   :  news                                            
 Administration theme            :  seven                                           
 PHP configuration               :  /usr/local/etc/php/php.ini /etc/drush/drush.ini 
 PHP OS                          :  Linux                                           
 Drush script                    :  /usr/local/bin/drush                            
 Drush version                   :  8.0.1                                           
 Drush temp directory            :  /tmp                                            
 Drush configuration             :                                                  
 Drush alias files               :                                                  
 Install profile                 :  standard                                        
 Drupal root                     :  /var/www/mysite                               
 Site path                       :  sites/default                                   
 File directory path             :  sites/default/files                             
 Temporary file directory path   :  tmp

Above are details having Drush version 8.0.1 and Drupal version 7.41. I have not done upgrade from 6 to 7. Site is running in D7 from 2 years.

PHP_VERSION 5.5.30

Thanks!

Comment #12

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 13:26

For more information I just did update of metatag module from Version: 7.x-1.7 to 7.x-1.11

Comment #13

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 13:55

Version:	7.x-1.11	» 7.x-1.x-dev
Status:	Active	» Needs review

File	Size
metatag-n2658808-13.patch	748 bytes
7.x-1.x: PHP 5.3 & MySQL 5.5, D7 106 pass PHP 5.6 & MySQL 5.5, D7 106 pass

See if this helps - it changes the main query in update 7040 to exclude properly formatted robots values.

Comment #14

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 13:55

Parent issue:

» #2657108: Plan for Metatag 7.x-1.12 release

Comment #15

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 13:58

Thanks for you all help but it seems like some problem or restriction with my server environment as on my local mac dev environment updates went very well with drush. I tried again with setting up same site on my local from backups.

Comment #16

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 14:02

@jas1988: Could you please test the patch? It ought to avoid the problem as it won't insist in updating the 39,000 records.

Comment #17

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 14:11

Is that ok so that I can test it at production site. Please suggest!

Comment #18

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 14:15

Yes, because that update isn't necessary for your site anyway.

Comment #19

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 14:16

Thanks I will do now and let you know!

Comment #20

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 14:24

I am getting same error, patch did not helped.

ate: metatag_update_7040                                                                                                                                                            [ok]
Performed update: metatag_update_7040                                                                                                                                                            [ok]
Update 7040: 38989 records to examine.                                                                                                                                                           [status]
The external command could not be executed due to an application error.                                                                                                                          [error]
^[[B'all' cache was cleared.                                                                                                                                                                         [success]
Finished performing updates.                                                                                                                                                                     [ok]

Please suggest but I am not getting that why its working on local environment.

Comment #21

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 14:32

Can you please try running this query in mysql?

SELECT COUNT(*) FROM metatag WHERE data LIKE '%:6:"robots";%' AND data NOT LIKE '%:6:"robots";a:1:{s:5:"value";%';

Comment #22

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 14:34

I got 0 records :

mysql> SELECT COUNT(*) FROM metatag WHERE data LIKE '%:6:"robots";%' AND data NOT LIKE '%:6:"robots";a:1:{s:5:"value";%';
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.08 sec)

We have blocked nodes access in robots.txt like:

Disallow: /node/

Comment #23

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 14:34

Ok, because the patch should have resulted in metatag_update_7040 saying "Update 7040: No robots meta tags need to be fixed." instead of "Update 7040: 38989 records to examine."

Comment #24

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 14:37

So what should I need to do now as my status reports keep saying database updates are required. Thanks!

Comment #25

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 29 January 2016 at 18:21

Given that update 7040 doesn't actually affect your site, you could just add "return;" to the top of the function.

Comment #26

jas1988 CreditAttribution: jas1988 as a volunteer commented 29 January 2016 at 18:43

thanks managed like this to stop performing updates related to 7040 but I tried again with full content on local and it worked including 7040 updates as well. However those are not required in my case. Thanks again!

Comment #27

30 January 2016 at 10:41

DamienMcKenna committed ae85f18 on 7.x-1.x

Issue #2658808 by DamienMcKenna: Improved query to skip update 7040 if...

Comment #28

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 30 January 2016 at 10:42

Status:

Needs review

» Fixed

Comment #29

interestingaftermath CreditAttribution: interestingaftermath as a volunteer commented 5 February 2016 at 01:29

I am also having this issue. I've applied the patch but still seeing the same results:

With drush:

Performed update: metatag_update_7040                                [ok]
Performed update: metatag_update_7040                                [ok]
Performed update: metatag_update_7040                                [ok]
Update 7040: 102385 records to examine.                              [status]
The external command could not be executed due to an application     [error]
error.
'all' cache was cleared in self                                      [success]
Finished performing updates.                                         [ok]

Although it says success, it still shows database updates and re-running `drush updatedb` confirms that these are still pending. Any ideas?

Comment #30

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 5 February 2016 at 02:28

If anyone is still having the problem can they please update to 7.x-1.13 and try again? Thanks.

Comment #31

interestingaftermath CreditAttribution: interestingaftermath as a volunteer commented 5 February 2016 at 13:53

Upgraded to 7.x-1.13 and no change unfortunately

Performed update: metatag_update_7040                                [ok]
Performed update: metatag_update_7040                                [ok]
Update 7040: 102423 records to examine.                              [status]
The external command could not be executed due to an application error.     [error]
'all' cache was cleared in self                                      [success]
Finished performing updates.                                         [ok]

Comment #32

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 5 February 2016 at 13:55

Priority:	Critical	» Major
Status:	Fixed	» Needs work

@interestingaftermath: Can you please try adding the "-v" argument to Drush to get more output and paste it in here, i.e. "drush updatedb -v"? Thanks.

Comment #33

interestingaftermath CreditAttribution: interestingaftermath as a volunteer commented 5 February 2016 at 14:31

@DamienMcKenna: Adding the -v argument and it worked. Even though I had run `drush updatedb` twice just before, adding `-v` took forever and finished successfully with no error. I'm thinking that it was a memory issue combined by the number of records it was attempting to update. By running it multiple times, it continued to cut down on the total number of records that needed update. Maybe I just got lucky that the same time I tried `-v` the number of records was down enough to work within the 512M php memory_limit. Crazy?

Comment #34

tommik CreditAttribution: tommik at Avoltus Oy commented 24 March 2016 at 12:44

Status:

Needs work

» Needs review

File	Size
metatag-n2658808-34.patch	775 bytes
7.x-1.x: PHP 5.3 & MySQL 5.5, D7 118 pass PHP 5.6 & MySQL 5.5, D7 118 pass

I got the "The external command could not be executed due to an application" error while updating Metatag module from version 1.6 to 1.13.

After changing the db_query() to db_select() with same conditions I managed to run database update successfully with drush 6.20.

Attached is a patch of the changes.

Comment #35

24 March 2016 at 13:38

DamienMcKenna committed c7f1527 on 7.x-1.x authored by tommik

Issue #2658808 by tommik: Rewrote query in update 7040 so it works...

Comment #36

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 24 March 2016 at 13:38

Status:

Needs review

» Fixed

Oh, that's just awesome, thanks tommik!

Comment #37

DamienMcKenna

NH, USA

CreditAttribution: DamienMcKenna at Mediacurrent commented 24 March 2016 at 13:39

Comment #38

7 April 2016 at 13:44

Status:

Fixed

» Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

Update 7040: 38900 records to examine. [status] The external command could not be executed due to an application error. ( 7.x-1.11)

Comments

Parent issue

Related issues