[
https://issues.apache.org/jira/browse/ROL-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Glen Mazza closed ROL-1067.
---------------------------
Resolution: Won't Fix
Roller 2.x too old and unsupported; please try with a more recent version of
Roller.
> Upgrade script for MySQL has a wrong value for "bit" columns
> ------------------------------------------------------------
>
> Key: ROL-1067
> URL: https://issues.apache.org/jira/browse/ROL-1067
> Project: Roller
> Issue Type: Bug
> Components: Installation
> Affects Versions: 2.1
> Environment: MySQL 5, all platforms
> Reporter: Łukasz Rżanek
> Assignee: Roller Unassigned
> Priority: Minor
>
> MySQL migration script called "200-to-210-migration.sql" has a bug:
> According to http://dev.mysql.com/doc/refman/5.0/en/bit-field-values.html
> every BIT value should be in format "b'value'".
> In script there is a notation:
> alter table roller_comment add column approved bit default '1' not null;
> ...
> (in 3 additional lines as well).
> The corect notation should be:
> alter table roller_comment add column approved bit default b'1' not null;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
