[
https://issues.apache.org/jira/browse/JSPWIKI-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alex O'Ree updated JSPWIKI-1373:
--------------------------------
Fix Version/s: 3.0.2
> The HSQL script that creates the user database tables lacks the oldhashes
> column
> --------------------------------------------------------------------------------
>
> Key: JSPWIKI-1373
> URL: https://issues.apache.org/jira/browse/JSPWIKI-1373
> Project: JSPWiki
> Issue Type: Bug
> Reporter: Arturo Bernal
> Priority: Major
> Labels: pull-request-available
> Fix For: 3.0.2
>
>
> JDBCUserDatabase writes the oldhashes column on every new user (since
> JSPWIKI-1234), but hsql.ddl, the script the war ships to create the tables,
> does not define it. With a database created from that script the profile of a
> new user cannot be saved: the INSERT fails with "user lacks privilege or
> object not found: OLDHASHES".
> Checked with HSQLDB 2.7.4: the INSERT statement of JDBCUserDatabase fails
> against the tables created by hsql.ddl and succeeds once the column is added.
> The script of the integration tests had the same gap.
> The PostgreSQL script (postgresql.ddl) has a separate problem: it uses HSQL
> types and a trailing comma, so the users table is not created on PostgreSQL
> 16. It is not part of this issue.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)