Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-4664

Database Migration Fails on SQL Server 2012 in 2008 compat mode

    XMLWordPrintable

Details

    • Bug
    • Resolution: Timed out
    • Low
    • N/A
    • 2.10.4
    • None

    Description

      In "fecru-2.10.4\sql\SQLSERVER2008\schema" tables_81.sql: the following line creates a PK index (of 1128 bytes) 228 bytes larger than SQL Server's limit of 900 bytes.

      create table cru_recently_visited (cru_user_name nvarchar(255) not null, cru_item_type nvarchar(80) not null, cru_entity_id nvarchar(255) not null, cru_last_viewed numeric(19,0) not null, primary key (cru_user_name, cru_item_type, cru_entity_id));

      Attachments

        Activity

          People

            Unassigned Unassigned
            1aace75ac32b James Slater
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: