[
https://issues.apache.org/jira/browse/JSPWIKI-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18147911#comment-18147911
]
ASF subversion and git services commented on JSPWIKI-1373:
----------------------------------------------------------
Commit b5454e101fddb8830c6009cccd09709e46a40b63 in jspwiki's branch
refs/heads/master from Arturo Bernal
[ https://gitbox.apache.org/repos/asf?p=jspwiki.git;h=b5454e101 ]
JSPWIKI-1373 Define the oldhashes column in the HSQL user database script
JDBCUserDatabase writes the oldhashes column for every new user, but the
script the war ships to create the tables did not define it, so the
profile of a new user could not be saved in a database created from it.
> 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
>
> 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)