Sign in Register
Go to solution
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 136 posts 352 karma points
    Jul 01, 2015 @ 06:54
    Levente Kosa
    0

    Save problem after 100 images

    Questions about runway and modules
    Umbraco 7

    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

    Copy Link
  • Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib
    Jul 01, 2015 @ 13:55
    Alex Skrypnyk
    0

    Hi Levente,

    Did you look at datatype settings?

    Thanks

    Copy Link
  • Levente Kosa 136 posts 352 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

    Copy Link
  • Levente Kosa 136 posts 352 karma points
    Jul 02, 2015 @ 11:34
    Levente Kosa
    0

    Any advice?

    Copy Link
  • Simon Dingley 1470 posts 3427 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.

    Copy Link
  • Simon Dingley 1470 posts 3427 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.

    Copy Link
  • Levente Kosa 136 posts 352 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

    Copy Link
  • Simon Dingley 1470 posts 3427 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.

    Copy Link
  • Levente Kosa 136 posts 352 karma points
    Jul 14, 2015 @ 20:33
    Levente Kosa
    0

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

    Copy Link
  • Simon Dingley 1470 posts 3427 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.

    Copy Link
  • Levente Kosa 136 posts 352 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!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft