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: