You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Anil Gangolli <an...@busybuddha.org> on 2006/05/24 17:30:06 UTC

Note about Roller on MySQL version 5.0.3 or higher

Roller 2.3 is still in release candidacy and has not yet officially released 
but is expected to release officially in the next few days.

Starting with the official Roller 2.3 release, the MySQL schema scripts will 
define boolean fields using TINYINT(1) instead of BIT.  This is to avoid an 
issue that many of you have hit with using the BIT type for boolean fields 
in MySQL versions 5.0.3 and higher.

If you are trying to run earlier released versions of Roller on MySQL 
version 5.0.3 or higher, you should change the boolean fields in the scripts 
from BIT to TINYINT(1) in order to get things to work.  Several users have 
noted this on this list already.

If you are running earlier versions  of Roller with MySQL version 5.0.2 or 
lower, BIT in these versions is a synonym for TINYINT(1), and you need not 
do anything.

--a.