[ 
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)
  • [jira] [Commented] (JSPWIKI... ASF subversion and git services (Jira) via dev

Reply via email to