When installing Boost on servers with certain versions of MySQL, the 'boost_cache' and 'boost_crawler' tables aren't created. This is a result of these versions of MySQL not allowing default values for text columns.

I've created a patch that removes the default values from the database schema for the three columns that prevent these tables from being created. There is also an update function that removes the default values on existing installations to prevent data loss if someone upgrades to a version of MySQL that doesn't permit default text values. The update function doesn't address existing installations that are missing tables or columns.

I doubt it's a common issue, but anyone who has an undiagnosed issue should check their log entries for php errors due to these tables missing.

Version info:
MySQL 5.1.30
PHP 5.2.10
Apache 2.2.11
Drupal 6.15

CommentFileSizeAuthor
boost-install.patch1.87 KBCybergarou
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mikeytown2’s picture

Status: Needs review » Reviewed & tested by the community
mikeytown2’s picture

Status: Reviewed & tested by the community » Fixed

committed

Status: Fixed » Closed (fixed)

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