SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupalDB.field_data_message_text' [#1843848]

Hello,

just to report that when I update to the latest dev I get the following error:

Computer$ drush dl message_notify-7.x-2.x-dev
Install location Drupal1/sites/all/modules/message_notify already exists. Do you want to overwrite it? (y/n): y
Project message_notify (7.x-2.x-dev) downloaded to Drupal1/sites/all/modules/message_notify.                                                    [success]
Project message_notify contains 2 modules: message_notify_example, message_notify.
Computer$ drush updb
The following updates are pending:

message_notify module : 
  7003 -   Remove the deprecated "Subject" field. 

Do you wish to run all pending updates? (y/n): y
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupalDB_data_message_text' doesn't exist                                                              [error]
Performed update: message_notify_update_7003                                                                                                                            [ok]
Finished performing updates.

I have to uninstall message_notify and delete the folder and install again as a new module.

Then it works, but the update method not.

Comment	File	Size	Author
#2	message_notify-7003_update_error-1843848-2.patch	862 bytes	dooug
#2

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

dooug CreditAttribution: dooug commented 11 March 2015 at 19:17

Issue summary:

View changes

Experiencing a similar issue when updating from message_notify 7.x.2.2 to 7.x-2.5.

$ drush updb  -y -v
Initialized Drupal 7.34 root directory at /var/www/sites/sitename/www                                                                  [notice]
Initialized Drupal site default at sites/default                                                                                            [notice]
The following updates are pending:

message_notify module :
  7003 -   Remove the deprecated "Subject" field.

Do you wish to run all pending updates? (y/n): y
/usr/bin/php /usr/local/drush-5.9.0/drush.php --php=/usr/bin/php  --backend=2 --verbose --yes --root=/var/www/sites/sitename/www       [notice]
--uri=http://default  updatedb-batch-process 262 262 2>&1
Initialized Drupal 7.34 root directory at /var/www/sites/nih-combo.dev/www                                                                  [notice]
Initialized Drupal site default at sites/default                                                                                            [notice]
Executing message_notify_update_7003                                                                                                        [notice]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'default.field_data_' doesn't exist                                            [error]
Performed update: message_notify_update_7003                                                                                             [ok]
Command dispatch complete                                                                                                                   [notice]
Finished performing updates.                                                                                                             [ok]
Command dispatch complete

Error from above:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'default.field_data_' doesn't exist [error}

And the update doesn't finish, so it'll show up next time I run drush updb

Comment #2

dooug CreditAttribution: dooug commented 11 March 2015 at 19:48

Status:

Active

» Needs review

File	Size
message_notify-7003_update_error-1843848-2.patch	862 bytes

Isolated the error to update 7003 trying to update a field that didn't exist. Patch attached that exits if the message_text_subject field doesn't exist.