[ 
https://issues.apache.org/jira/browse/JSPWIKI-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated JSPWIKI-1373:
------------------------------------
    Labels: pull-request-available  (was: )

> 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)

Reply via email to