Hello,

Upgrading to 1.32.0, I get an error during update.php process :

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my-site.cache_book' doesn't exist: TRUNCATE {cache_book} ; Array ( )

It never happened before.

The website seems to work fine after upgrading. If I run the update.php process again, it says "No pending updates. All caches cleared" but it displays the error message again.

I restored yesterday's daily backup of the site and ran the upgrade again, reproducing the same error.

How can I solve the problem ?

Thanks in advance.

Versions

  • Debian 12
  • Apache  2.4.65
  • PHP  8.4.13
  • Backdrop CMS 1.32.0

Modules

  • Global Redirect 1.x-1.6.0
  • Mail System 1.x-3.0.8
  • Metatag 1.x-1.22.7
  • Mime Mail 1.x-1.1.8
  • Site Map 1.x-1.3.1
  • XML sitemap 1.x-1.0.11

Accepted answer

Until the official new release (coming soon), the error will ALSO show up when you clear caches, unless you fix this manually as above.

Comments

If you want to try to fix it yourself now, I think you can manually set the schema version for the book module (in the system table) to 7000, and then try running the updates again. Test on a dev site first. 

Until the official new release (coming soon), the error will ALSO show up when you clear caches, unless you fix this manually as above.

Thank you very much for your fast answers and clear explanations !

I understand that the site is not corrupted and that there is no danger in leaving the code and the database in their state.

Since I'm not comfortable with updating manually the system table, I'll wait for the fix, in the next release.