Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Problem/Motivation
When upgrading from 7.x-1.0-beta2 to 7.x-2.0-beta3 the following error occurs:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.temp_fix_better_formats' doesn't exist
Here is the full output of the updates:
Performed update: better_formats_update_7101 [ok]
Performed update: better_formats_update_7101 [ok]
Prepped 300 records for these fields: ### REDACTED ###
Performed update: better_formats_update_7101 [ok]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.temp_fix_better_formats' doesn't exist [error]
Performed update: better_formats_update_7102 [ok]
'all' cache was cleared. [success]
Finished performing updates. [ok]
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | 3340025-2.patch | 994 bytes | daniel korte |
Issue fork better_formats-3340025
Show commands
Start within a Git clone of the project using the version control instructions.
Or, if you do not have SSH keys set up on git.drupalcode.org:
changes
Comments
Comment #2
daniel korteComment #3
daniel korteComment #4
daniel korteComment #5
anybodySame here, correct fix @Daniel Korte!
@Maintainers please merge this and create a new release ASAP, as it breaks the update hook on all projects using table prefixes!
A hotfix release would make a lot of sense here, I guess :)
Comment #6
philyPatch #2 also works for me updating better_formats from 7.x-1.0-beta2 to 7.x-1.0-beta5 using Drupal 7.95 (locked to 1.x because of PHP requirements).
Thanks
Comment #7
anybodyThis was caused in #3340025: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.temp_fix_better_formats' doesn't exist and needs a fix in 7.x-2.x and 7.x-1.x
Comment #8
anybodySetting priority to critical, like the issue where this change was introduced, as this currently makes it impossible to run the database updates.
Comment #9
catalano commentedJust experience this issue when updating an older D7 site. Can someone explain how to implement Daniel's patch above? Thank You.
Comment #10
anybody@catalano I think it might be best if you could contat the maintainer of this project to commit this fix. Would make a lot of sense. and is less complicated than patching for you.
Comment #11
catalano commented@Anybody - I contacted him directly. No reply yet.
Comment #13
mandclu commentedThanks for the work here. I have merged in the change, and will roll a new release.
Comment #14
anybodyThank you very very much @mandclu!
Comment #15
catalano commented@mandclu This appears to only have been fixed in the 7.x-2.x release. Can you also update the 7.x-1.x release as well? Thank You.
Comment #17
anybodySee #3358197: Updating to 7.x-1.0-beta5 causes database update failure for #15. Still an issue in 7.x-1.x!
Comment #18
anybodyLet's switch this over to 7.x-1.x-dev!
Comment #19
anybodyComment #22
anybodyFixed in 7.x-1.x!