Suddenly unable to sort custom fields

This topic contains 13 replies, has 4 voices, and was last updated by  Stiofan O’Connor 9 years, 1 month ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • August 9, 2015 at 4:57 am #48729

    jkirker
    Lifetime Member
    Post count: 298

    Sorting was working earlier however I’ve added quite a few new custom fields to a category and the sort is no longer working.

    Can anyone give me any advice as to what to look for?

    Database is not being updated after dragging and dropping to resort.

    Thanks,
    John

    August 9, 2015 at 5:11 am #48731

    Guust
    Moderator
    Post count: 29970

    Dragging and dropping the custom fields in the “custom field” tab for your custom post type will only re-sort them on the Add Listing pages usually.
    Dragging and dropping the fields in the “sorting order” will not work if one of them is set as default, you would have to review them again.
    I am not really sure what sort you are talking about and where you expect the sort to show up etc, a few more details and URLs and login would be handy.

    August 9, 2015 at 11:10 am #48740

    jkirker
    Lifetime Member
    Post count: 298

    When I drag and drop them it is not changing the order on the add listing page or the custom field management page.

    It’s also not updating the sort_order field in the database.

    August 9, 2015 at 11:12 am #48741

    jkirker
    Lifetime Member
    Post count: 298
    This reply has been marked as private.
    August 9, 2015 at 11:34 am #48744

    Guust
    Moderator
    Post count: 29970

    Stumped 🙁
    Let’s get the clever guys.

    August 9, 2015 at 12:01 pm #48747

    jkirker
    Lifetime Member
    Post count: 298

    BTW – sorting is still working in other CPT’s. It’s just not working in the group which I linked to. It was working before I added the last 10 fieldsets and fields if that leads to any hints or clues. There are now a total of 105 custom fields for this CPT. Could there be a limit set on the select?

    August 9, 2015 at 1:55 pm #48760

    jkirker
    Lifetime Member
    Post count: 298

    I’m going to manually edit the db table – perhaps there’s a select top 100 or something in the code. I don’t know… Just wanted to point it out. Feel free to play with it and test. In the event it does start working, please re-order as they were.

    August 10, 2015 at 6:30 pm #48881

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    far too many custom fields for your database to handle them and that’s a hard limit, there are a few things we could try to optimise it but it would likely only give you a few extra.

    Stiofan’s suggestion is to try and reduce the number of custom fields by grouping everthing that you can group.

    Let us know,

    Thanks

    August 10, 2015 at 7:51 pm #48899

    jkirker
    Lifetime Member
    Post count: 298

    Ha – I can appreciate that and it does drive me nuts – however due to the way the data is currently structured/organized and the inability to properly relate items to a listing there is no other way for me to accomplish what I need to without the massive number of custom fields. I did bring this up an an early post () and now we’re here. 😉

    Now seeing where I’m at as it relates to the link above I’m curious to get your thoughts?

    August 12, 2015 at 11:05 pm #49176

    jkirker
    Lifetime Member
    Post count: 298

    I wish there were a solution to this. BTW – here’s that link: https://wpgeodirectory.com/support/topic/split-custom-fields-based-on-place-categories/

    August 13, 2015 at 6:01 am #49204

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hay John,

    Get me on skype and i’ll spend some time with you finding a solution.

    Thanks,

    Stiofan

    August 14, 2015 at 9:49 pm #49465

    jkirker
    Lifetime Member
    Post count: 298

    .

    August 14, 2015 at 10:38 pm #49470

    jkirker
    Lifetime Member
    Post count: 298

    I was able to make some progress. The limit is with the blob size of the row. I didn’t realize you were allocating VARCHAR 500 for every custom field. When I manually reduce the size of the fields to that which is necessary (often less than 100 for the granularity of things – I’m able to get closer to where I need to go. 😉

    August 15, 2015 at 2:50 pm #49554

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Thanks john, it does need a bit of optimisation, i’ll get on to it soon, i’ll set a task and update you when done.

    Thanks,

    Stiofan

  • Author
    Posts
Viewing 14 posts - 1 through 14 (of 14 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount