image media library error with 742 upgrade - Using Umbraco and getting started

jeff mayer 122 posts 200 karma points

Mar 31, 2016 @ 21:06

Image Media Library Error with 7.42 Upgrade

Hello,

Upgraded recently to U 7.42 from 7.35, everything seems to be working except for the media library., When I click on a folder this error is displayed

Request error: The URL returned a 404 (not found): /umbraco/backoffice/UmbracoApi/ContentType/GetPropertyTypeScaffold

Copy Link

Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq

Mar 31, 2016 @ 21:13

From version...?

Please read this blog post: https://cultiv.nl/blog/how-to-diagnose-umbraco-upgrade-problems/

Copy Link

jeff mayer 122 posts 200 karma points

Mar 31, 2016 @ 21:15

Upgrade from 7.35

Copy Link

jeff mayer 122 posts 200 karma points

Mar 31, 2016 @ 21:16

Have to do a manual upgrade in this instance..

Copy Link

jeff mayer 122 posts 200 karma points

Apr 01, 2016 @ 20:29

thanks. Still debugging but I have read your overview which is great.

Copy Link

jeff mayer 122 posts 200 karma points

Apr 08, 2016 @ 15:07

bump

Copy Link

Marco 13 posts 109 karma points

Apr 16, 2016 @ 12:38

I had the same problem. After some research, I found that some database entries for Umbraco ListView were missing in the tables umbracoNode and cmsDataType. Something must have gone wrong in the recent upgrade, in my case from 7.1.8 which succeeded on my dev-environment but apparently failed on acceptance and production.

In the error message, there should be an id of the datatype that is missing. In my case, the url that returned the 404 was:

/umbraco/backoffice/UmbracoApi/ContentType/GetPropertyTypeScaffold?id=-96

I didn't find a method to let Umbraco check the database-schema and data, so I could fix the error with adding the missing values manually withe the following sql script:

  SET IDENTITY_INSERT umbracoNode ON
  INSERT into umbracoNode (id, trashed, parentId, nodeUser, [level], [path], sortOrder, uniqueID, [text], nodeObjectType, createDate) VALUES (-95, 0, -1, 0, 1, '-1,-95', 2, 'C0808DD3-8133-4E4B-8CE8-E2BEA84A96A4', 'List View - Content', '30A2A501-1978-4DDB-A57B-F7EFED43BA3C', '2016-04-16 14:15:00')
  INSERT into umbracoNode (id, trashed, parentId, nodeUser, [level], [path], sortOrder, uniqueID, [text], nodeObjectType, createDate) VALUES (-96, 0, -1, 0, 1, '-1,-96', 2, '3A0156C4-3B8C-4803-BDC1-6871FAA83FFF', 'List View - Media', '30A2A501-1978-4DDB-A57B-F7EFED43BA3C', '2016-04-16 14:15:00')
  INSERT into umbracoNode (id, trashed, parentId, nodeUser, [level], [path], sortOrder, uniqueID, [text], nodeObjectType, createDate) VALUES (-97, 0, -1, 0, 1, '-1,-97', 2, 'AA2C52A0-CE87-4E65-A47C-7DF09358585D', 'List View - Members', '30A2A501-1978-4DDB-A57B-F7EFED43BA3C', '2016-04-16 14:15:00')
  SET IDENTITY_INSERT umbracoNode OFF

  SET IDENTITY_INSERT cmsdataType ON
  insert into cmsDataType (pk, nodeId, dbType, propertyEditorAlias) VALUES (-26, -95, 'Nvarchar', 'Umbraco.ListView')
  insert into cmsDataType (pk, nodeId, dbType, propertyEditorAlias) VALUES (-27, -96, 'Nvarchar', 'Umbraco.ListView')
  insert into cmsDataType (pk, nodeId, dbType, propertyEditorAlias) VALUES (-28, -97, 'Nvarchar', 'Umbraco.ListView')
  SET IDENTITY_INSERT cmsdataType OFF

Copy Link

jeff mayer 122 posts 200 karma points

Apr 19, 2016 @ 15:57

You are a genius. It seems to be working now.

Copy Link

almir 9 posts 29 karma points

May 11, 2017 @ 09:28

THANK YOU TO THE MOON :)

Copy Link

M N 125 posts 212 karma points

Jan 02, 2018 @ 17:30

Thank you, this worked on 7.7.2 as well.

Copy Link

Nicholas Westby 2054 posts 7103 karma points c-trib

Apr 19, 2016 @ 15:08

FYI, to anybody interested, this has apparently resumed on a new thread here: https://our.umbraco.org/forum/using-umbraco-and-getting-started/76713-upgrade-to-743-still-no-media-listing

Copy Link

Keith R Hubbard 175 posts 403 karma points

Apr 19, 2016 @ 22:48

@Nicholas would this cause images to just disappear in Media? I just started having this problem.

Copy Link

Nicholas Westby 2054 posts 7103 karma points c-trib

Apr 19, 2016 @ 22:57

I have no idea. I just cross-linked two posts that were about the same topic.

Copy Link

Keith R Hubbard 175 posts 403 karma points

Apr 19, 2016 @ 23:02

what table did you run the script in?

Copy Link

Nicholas Westby 2054 posts 7103 karma points c-trib

Apr 19, 2016 @ 23:28

FYI, not sure that question makes much sense. SQL scripts are typically run in the context of a database. Notice the script mentions a number of tables.

Copy Link

Stas 13 posts 63 karma points

Jul 22, 2016 @ 10:15

Hi Guys,

Just want to share my own experience regarding this issue... cause marked as solution doesn't work for me at all!!!

So, in order:

I had 7.2.4 which is now updated to 7.4.3
I wasn't able to use that magic SQL script to insert items in umbracoNode, cause of this:

Cannot insert duplicate key row in object 'dbo.umbracoNode' with unique index 'IX_umbracoNode_uniqueID'. The duplicate key value is (c0808dd3-8133-4e4b-8ce8-e2bea84a96a4).

As U could guess I already got 'List View%' items, with another Ids, here are mine: http://screencast.com/t/pdmqyevAjYKo
So, the logical question is - what's the heck , and why 404 for 'GetPropertyTypeScaffold' with id=-96 (inside Media section), while I have another Ids for those items?
And the answer is just amazing :) - http://screencast.com/t/jVPFSzLaMaJ0

P.S. and it's just not to mention broken xpath placeholders ($current, $root) which don't work as it used to be :)

Looking forward for future updates! Good luck!

Copy Link

Bojan 16 posts 131 karma points

Aug 12, 2016 @ 18:31

Hi to all,

I can't believe that these kind of errors are happening to me also, this whole week I was working on some project and just to finish the last template I encountered this error and luckily found this post.

I looked at Marco's post about missing table row with id '-96', and figured out what I have done previous to create this type of error.

Just to mention, I installed clean and latest 7.4.3 version via nugget, everything seems ok till this:

My last template is named "Media" and it contains some media files for download, nothing spectacular. At the point of creation document type for this page, I thought why I didn't name all my document types with some safe suffix like "Page" - I'm using Umbraco models builder, maybe it will collide with something named 'media' in Umbraco. Well, I thought, I will do it at the end when I finish this template, models builder and ReSharper will do that dirty job quickly for me.

After creating Media page, I wanted to turn on List View for media download items. I clicked on 'create custom ListView' and suggested name was generic 'List View - media'. I saved my "Media" doctype and here comes the trouble.

The first issue was that main "Content" tab and list view "Child items" got the same tab number #tab25 and whenever I click I got the same content, sometimes from original "Media" page and sometimes from "Child items". I deleted both doctypes, created them again, changed list view tab number, nothing helped.

Finally, I gave up and went to Media section to check something and saw this JS error

/umbraco/backoffice/UmbracoApi/ContentType/GetPropertyTypeScaffold?id=-96

This is what I have found in my DB umbraco<em>db</em>screenshot<em>table</em>umbracoNode

It looks like that my custom accidentally named 'List View - media' for Media document type has overridden default 'List View - Media' node with default id -96 !?!?

This may be a bug, I will try now to return default Media node as Marco suggested, and I hope it will help or .... :(

Definitely, I will start to add suffix 'Page' to all my document types.

Cheers, Bojan

++++++++++++++++++++++++++++

It works, I have added missing overridden default 'List View - Media' node with id -96 as Marco suggested and I'm super happy :-)

Copy Link

is working on a reply...

Flag this post as spam?

Image Media Library Error with 7.42 Upgrade