TracForms - form details retrieved but forms still empty
|Reported by:||anonymous||Owned by:||Steffen Hoffmann|
After migrating my Trac instance from SQLite to Postgres and upgrading TracForms from 0.3 to 0.4.1, forms created prior to the migration are not displayed on the wiki page. When the 'Form details' link is clicked, all of the old 'Saved Values' are present and correct, but none of that data shows up on the wiki page itself. I have already run 'trac-admin /path/to/env upgrade', and there are no errors in the logs (PG or Trac).
If I update the same form by adding a value to, for example, a textarea, it saves correctly and is visible upon reload, but it does (erroneously?) create a new form id in the database (in the forms table) instead of using the existing one. After adding a value, if I click on the 'Form details' link again, I'm shown two available records:
Forms in MyFormPage Available records Form 69 (subcontext = 'None') Form 76
Form id 69 has all of the old data in the DB and on the 'Form details' (Saved Values) page, but the actual wiki page shows no form data. Form id 76 only has the one new value in a separate DB entry and 'Form details' page, and the actual wiki page shows only the one value. In the forms table in the database, both entries have nothing in the 'subcontext' column. In fact, both entries are essentially identical except for the form id and the form state (as detailed above).
Since the plugin works perfectly fine for new forms & form data, I'm guessing there is something less conspicuous (such as an index or sequence or something like that) which is causing the issue, but I'm not quite sure what that 'thing' is. The priority is set to 'high' because the plugin partially works (new entries), but all pre-migration data is not displaying (though it is in the DB and the 'Form details' page).