[
https://issues.apache.org/jira/browse/JSPWIKI-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18147912#comment-18147912
]
ASF subversion and git services commented on JSPWIKI-1373:
----------------------------------------------------------
Commit bce4cff0b20502197d4fd2bbbcad02478c3dd63d in jspwiki's branch
refs/heads/master from spyhunter99
[ https://gitbox.apache.org/repos/asf?p=jspwiki.git;h=bce4cff0b ]
Merge pull request #639 from arturobernalg/fix-ddl-oldhashes
JSPWIKI-1373 Define the oldhashes column in the HSQL user database script
> 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)