roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Glen Mazza (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (ROL-1067) Upgrade script for MySQL has a wrong value for "bit" columns
Date Mon, 07 Jan 2013 01:27:11 GMT

     [ 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

Mime
View raw message