Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • amag 4 posts 74 karma points
    1 week ago
    amag
    0

    Problem with upgrade 7.12.4 to 7.13: Invalid column name 'controlId'

    I'm trying to upgrade a project from 7.12.4 to 7.13.3 or 7.13.0, but I keep getting error:

    Invalid column name 'controlId'.
    

    I tried all described solutions but nothing worked. I used SQL Server Profiler and located the problem in query:

    SELECT [cmsDataType].[controlId], [umbracoNode].[text]
    FROM [cmsDataType]
    INNER JOIN [umbracoNode]
    ON [cmsDataType].[nodeId] = [umbracoNode].[id]
    

    I don't have column controlId in table cmsDataType:

    enter image description here

    I upgraded Umbraco from 7.4.3 to 7.12.4 without major problem. Can I fix this in any simple way?

  • Alex Skrypnyk 5178 posts 18868 karma points MVP 2x admin c-trib
    1 week ago
    Alex Skrypnyk
    0

    Hi Amag

    Did you upgrade from 7.4.3 directly to 7.12.4?

    I think you had to upgrade to 7.6 first.

    Alex

  • amag 4 posts 74 karma points
    1 week ago
    amag
    0

    Hi Alex.

    My current Umbraco is 7.12.4. I got project in old version and I try upgrade it.

    Amag

  • Alex Skrypnyk 5178 posts 18868 karma points MVP 2x admin c-trib
    1 week ago
    Alex Skrypnyk
    0

    Hi Amag

    Did you solve the issue?

    Alex

  • amag 4 posts 74 karma points
    1 week ago
    amag
    0

    Hi Alex.

    Unfortunately not but I have plan to do this :-)

    Amag

  • Dave Woestenborghs 3159 posts 10354 karma points MVP 3x admin c-trib
    1 week ago
    Dave Woestenborghs
    0

    Hi Amag,

    I checked my Umbraco installations. I none of them if see a column controlId on the cmsDataType table.

    Also had a look at the migrations (db changes) that are run on umbraco upgrades. I don't see anything that would remove this column.

    So my question is? Do you have any custom packages installed. And can you figure out when this query is executed.

    Dave

  • amag 4 posts 74 karma points
    1 week ago
    amag
    0

    Hi Dave.

    The problem is in the old project that I got. There are no custom packages in it except one requiring a rewrite but I think this is not it.

    After publishing version 7.13.x , I have to log in and click on the Continue button. Query is executed right after clicking.

    I found some trace in the code in the MajorVersion7UpgradeReport.cs file that is not currently in the Umbraco Git repository but is available at the address https://searchcode.com/codesearch/view/95375889/ (lines 84-93).

    Now I have no time for this but I will investigate it later.

    Amag

Please Sign in or register to post replies

Write your reply to:

Draft