Column change failed, you may have too many columns

This topic contains 12 replies, has 3 voices, and was last updated by  Stiofan O’Connor 7 years, 1 month ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • February 27, 2018 at 2:41 pm #419532

    shanker
    Full Member
    Post count: 31

    Hello,

    “Column change failed, you may have too many columns”

    I absolutly need to increase database storage volume to save custom fields.

    I need more than 300 custom fields for one CPT and can’t be splited.

    I saw in the support forum all the comments and that it’s limided, and i can’t split it into more CPT to be more specific.

    I need a solution and the solution is not to reduce the numbers of custom fields.

    Looking forward to your reply.

    Best regards

    Shanker

    February 27, 2018 at 2:47 pm #419538

    Alex Rollin
    Moderator
    Post count: 27815

    We would be happy to take a look at your settings to see if we can find the problem.

    Please be sure to have completed all the steps for configuration, and do check to see that your plugins are all up to date.

    https://wpgeodirectory.com/docs/installing-addons/#updates

    To allow us to examine the site, please create a private reply and include all the information listed below so we can make a complete diagnosis.

    Add listing URL where we can see the issue:

    WordPress Credentials
    WP Admin Login URL:
    WP Admin Username:
    WP Admin Password:

    FTP Credentials
    FTP Host:
    FTP Port:
    FTP User:
    FTP Password:

    February 28, 2018 at 10:37 am #419674

    shanker
    Full Member
    Post count: 31
    This reply has been marked as private.
    February 28, 2018 at 4:19 pm #419755

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hello,

    Can you explain what you are doing and why you need so many fields and i will be better able to advise a solution.

    Thanks,

    Stiofan

    February 28, 2018 at 5:20 pm #419767

    shanker
    Full Member
    Post count: 31
    This reply has been marked as private.
    February 28, 2018 at 5:24 pm #419770

    shanker
    Full Member
    Post count: 31
    This reply has been marked as private.
    March 1, 2018 at 12:29 pm #419864

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    I still don’t really understand why you have so many fields, why not just have a multiselect custom field called “features” and add options to that rather than having different options for each?

    Stiofan

    March 1, 2018 at 12:32 pm #419865

    shanker
    Full Member
    Post count: 31

    Can you send me some examples

    Sam

    March 1, 2018 at 12:47 pm #419870

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    You can see features at the bottom of the sidebar here:
    https://wpgeo.directory/starter/property/united-states/pennsylvania/philadelphia/commercial/hotel-alpina/

    And you can see them under advanced search here: https://wpgeo.directory/starter/property/

    Stiofan

    March 1, 2018 at 1:10 pm #419876

    shanker
    Full Member
    Post count: 31
    This reply has been marked as private.
    March 1, 2018 at 1:36 pm #419877

    shanker
    Full Member
    Post count: 31

    Stiofan,

    I can change MySQL field type from VARCHAR to TEXT as https://wpgeodirectory.com/support/topic/geodirectory-multi-select-field-cannot-handle-many-select-options/

    Will this solve my request

    Sam

    March 1, 2018 at 2:38 pm #419885

    shanker
    Full Member
    Post count: 31

    Not working,
    Waiting for a solution
    Thank you

    Sam

    March 1, 2018 at 6:53 pm #419912

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    If you are not going to be adding each hall as an individual listing then maybe its just best to have a textarea input for “Hall details”?

    Stiofan

  • Author
    Posts
Viewing 13 posts - 1 through 13 (of 13 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