Database Migration Fails on SQL Server 2012 in 2008 compat mode

XMLWordPrintable

    • Type: Bug
    • Resolution: Timed out
    • Priority: Low
    • N/A
    • Affects Version/s: 2.10.4
    • Component/s: None
    • Severity 3 - Minor

      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));

              Assignee:
              Unassigned
              Reporter:
              James Slater
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: