Details

    • Branch Version/s:
      6.1.x
    • Backported to Branch:
      Committed
    • Similar Issues:
      Show 4 results 

      Description

      If there are SQL Server System Tables present in a database, Liferay will sometimes try to upgrade the pseudo-system database table and will throw an error.

      Steps to reproduce:
      1. Need pseudo-system tables in the database System Tables section
      This can be done by setting up some kind of system database mail.
      2. Upgrade

      Liferay will try to upgrade it and get a messaged like:

      15:38:03,231 INFO [VerifySQLServer:130] Updating sysmail_mailitems.recipients to use nvarchar
      15:38:03,262 ERROR [VerifySQLServer:88] java.sql.SQLException: Incorrect syntax near ')'.
      java.sql.SQLException: Incorrect syntax near ')'.

      sysmail_mailitems is not a Liferay table.

      depending on the tables present, other sys tables will be upgraded.

      Possible solution is to update the filter that determines which tables to alter and have it include 'AND (sysobjects.category != 2)' as pseudo-system tables have that category value.

      http://social.msdn.microsoft.com/Forums/zh/sqlreplication/thread/135ec547-2214-4da3-bd42-5c458759e144

        Issue Links

          Activity

            People

            • Assignee:
              Pani Gui (Inactive)
              Reporter:
              Jonas Choi
              Recent user:
              Randy Zhu
              Participants of an Issue:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 46 weeks, 3 days ago

                Development

                  Structure Helper Panel