Copied to clipboard

Flag this post as spam?

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


  • Levente Kosa 119 posts 305 karma points
    Jul 01, 2015 @ 06:54
    Levente Kosa
    0

    Save problem after 100 images

    Hi, I have a big problem. When I reach the limit (100 images) using multiple media picker, I can't save anymore. I got some errors:

    http://domain.com/umbraco/backoffice/UmbracoApi/Content/PostSave 500 (Internal Server Error)
    TypeError: data.indexOf is not a function
    

    How can I turn the limitation off?

    Thanks, L

  • Alex Skrypnyk 5791 posts 22065 karma points MVP 4x admin c-trib
    Jul 01, 2015 @ 13:55
    Alex Skrypnyk
    0

    Hi Levente,

    Did you look at datatype settings?

    Thanks

  • Levente Kosa 119 posts 305 karma points
    Jul 01, 2015 @ 14:17
    Levente Kosa
    0

    Hi Alex,

    I don't think is there any settings for this field. Or is there somewhere else? Where should be?

    Thanks, Leventeenter image description here

  • Levente Kosa 119 posts 305 karma points
    Jul 02, 2015 @ 11:34
    Levente Kosa
    0

    Any advice?

  • Simon Dingley 1414 posts 3291 karma points c-trib
    Jul 14, 2015 @ 11:22
    Simon Dingley
    0

    I don't think there is a limit in terms of the number of items you can pick, if you look at the error in detail it is to do with truncating of data when trying to save to the database. I am investigating this issue myself at the moment.

  • Simon Dingley 1414 posts 3291 karma points c-trib
    Jul 14, 2015 @ 11:36
    Simon Dingley
    101

    Can you try changing the dbType value in the database for this propertyEditor from Nvarchar to Ntext. This should remove the limit and with a bit of luck allow you to save larger amounts of data with the property editor.

    WARNING: Backup your database first and DO NOT perform straight on your live site as there is a possibility of data loss as I've not tested this myself yet.

  • Levente Kosa 119 posts 305 karma points
    Jul 14, 2015 @ 20:18
    Levente Kosa
    1

    Hi Simon,

    It worked perfectly, thank you very much. If anybody needs the query:

    UPDATE cmsDataType
    SET dbType = 'Ntext'
    FROM [Umbraco].[dbo].[cmsDataType] WHERE propertyEditorAlias = 'Umbraco.MultipleMediaPicker'
    

    Cheers, Levente

  • Simon Dingley 1414 posts 3291 karma points c-trib
    Jul 14, 2015 @ 20:31
    Simon Dingley
    0

    Glad it helped. I think you will also need to script migration of data that was previously saved as Nvarchar because it is stored in a different column of the [cmsPropertyData] table.

  • Levente Kosa 119 posts 305 karma points
    Jul 14, 2015 @ 20:33
    Levente Kosa
    0

    Sorry, I don't really understand. Do I need to run another script?

  • Simon Dingley 1414 posts 3291 karma points c-trib
    Jul 14, 2015 @ 20:40
    Simon Dingley
    0

    Is your previously saved data still available since the change? I suspect that changing the dbType to Ntext means that the data previously saved to the Nvarchar column will not be copied over to the Ntext column of the [cmsPropertyData] table. I don't have an example to hand at the moment but if your existing data is still ok its perhaps not an issue.

  • Levente Kosa 119 posts 305 karma points
    Jul 14, 2015 @ 20:46
    Levente Kosa
    0

    I tested it, and it seems right. Old and new images are working. I can delete, add new images as well. I tested more than 200 images. I think will be ok.

    Many thanks!

Please Sign in or register to post replies

Write your reply to:

Draft