[
https://issues.apache.org/jira/browse/ROL-1855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dave Johnson reassigned ROL-1855:
---------------------------------
Assignee: Dave Johnson (was: Roller Unassigned)
> Automatic table creation fails on HSQLDB
> ----------------------------------------
>
> Key: ROL-1855
> URL: https://issues.apache.org/jira/browse/ROL-1855
> Project: Roller
> Issue Type: Bug
> Components: Database Access & Data Model
> Affects Versions: 5.0
> Environment: Ubuntu 8.04 LTS, Sun JDK 1.6, Tomcat 6.0.20, HSQLDB 2.0
> RC8
> Reporter: Juergen Kellerer
> Assignee: Dave Johnson
> Priority: Minor
> Fix For: 5.0
>
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> When Tomcat and Roller is set up with HSQLDB, I get a complaint when Roller
> tries to create its tables.
> The exact message is "Unexpected token 'DEFAULT'" and comes up during the
> execution of the create table script for the table "webpage".
> The bug is caused by a mistake in the keyword order and can be fixed by
> replacing:
> action varchar(16) not null default 'custom'
> with:
> action varchar(16) default 'custom' not null
> After this change all tables are created just fine.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
