Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-15972

Table nonexistent is cousing error: 'notification_filter_prefs'.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • Major
    • None
    • 10.10
    • Notifications
    • None
    • PostgreSQL
    • Easy

    Description

      After Upgrade to version 10.10, the message listed below on the user's profile page and the notification bell occurred:

      Failed to execute the [velocity] macro. Cause: [DefaultNotificationFilterPreference is not mapped [select nfp from DefaultNotificationFilterPreference nfp where nfp.owner =: owner order by nfp.id]]. Click on this message for details.

      After searching, identified need to insert the <mapping resource = "notification-filter-preferences.hbm.xml" /> line into the hibernate.cfg file, however, another error occurred:

      Failed to execute the [velocity] macro. Cause: [ERROR: relation "notification_filter_prefs" does not exist Position: 539]. Click on this message for details.

      After new search, it was identified that it would be necessary to change the name of the 'notification_filter_preferences' table to another, 'notification_filter_prefs', due to change in version 10.8 (https://www.xwiki.org/xwiki/bin/view/ReleaseNotes/Data/XWiki/10.8/#HIssuesspecifictoXWiki10.8).

      The problem is that the notification_filter_preferences table doesn't exist!

       

      What can I do? Create a new installation and rely on it to create the table, or is there another way to fix it?

      Attachments

        Activity

          People

            tmortagne Thomas Mortagne
            luiz_fernando Luiz Fernando Casagrande
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: