Uploaded image for project: 'Jahia Community'
  1. Jahia Community
  2. JAHIA-4420

Constraint errors when creating schema

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • xCM 6.0
    • xCM 6.0
    • None

    Description

      60 r25860
      Sql Server 2008
      Files: db storage
      Bigtexts: filesystem storage

      ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_grps add constraint FK7B24559790F996AC foreign key (grpid_sites_grps) references jahia_grps (key_jahia_grps)
      ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Column 'jahia_grps.key_jahia_grps' is not the same length or scale as referencing column 'jahia_sites_grps.grpid_sites_grps' in foreign key 'FK7B24559790F996AC'. Columns participating in a foreign key relationship must be defined with the same length and scale.
      ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_users add constraint FKEA2BF1BF6CF683C0 foreign key (userid_sites_users) references jahia_users (key_jahia_users)
      ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Column 'jahia_users.key_jahia_users' is not the same length or scale as referencing column 'jahia_sites_users.userid_sites_users' in foreign key 'FKEA2BF1BF6CF683C0'. Columns participating in a foreign key relationship must be defined with the same length and scale.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                cedmail_old Cédric Mailleux (Inactive)
                dsaulnier_old Damien Saulnier
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases

                      Packages

                        Version Package
                        xCM 6.0