Cannot add content in HTML Custom Field

This topic contains 13 replies, has 4 voices, and was last updated by  Stiofan O’Connor 5 years, 6 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #448343

    Sam Kneller
    Expired Member
    Post count: 38

    Hello,
    On this page http://wordpressmu-139094-403467.cloudwaysapps.com/travel/france/ile-de-france/paris/train-stations/gare-de-paris-saint-lazare-train-station/
    I cannot add content to the last 2 fields: Luggage Storage, Lost and Found

    I have other pages with this same difficulty. They are rather lengthy and I’m wondering if there’s a character limit in the database or something like that.

    Thanks for your help.
    Sam

    #448345

    Sam Kneller
    Expired Member
    Post count: 38
    This reply has been marked as private.
    #448346

    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
    SFTP/FTP:
    FTP Host:
    FTP Port:
    FTP User:
    FTP Password:

    #448365

    Sam Kneller
    Expired Member
    Post count: 38
    This reply has been marked as private.
    #448374

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    #448382

    Sam Kneller
    Expired Member
    Post count: 38
    This reply has been marked as private.
    #448448

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    #448473

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    #448507

    Sam Kneller
    Expired Member
    Post count: 38
    This reply has been marked as private.
    #448594

    Kiran
    Moderator
    Post count: 7069

    Hi Sam,

    After doing some debugging i found following error in error log:

    WordPress database error Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

    This happens when submitting & inserting large size of data.

    Contact your server admin about this error. Here solution that may help you: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te/#answer-25373052

    Let us know.

    Thanks,
    Kiran

    #448704

    Sam Kneller
    Expired Member
    Post count: 38
    This reply has been marked as private.
    #448752

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Sam,

    I tried going over a few things with the live chat guys but to no avail.
    The problem persists from their DB manager (phpMyAdmin type thing) so its not specific to GD or even WP, i belive they have opened a ticket for you and will update you there.
    Please let us know how it goes and what they find.

    FYI i found if i entered 155 chars it saved but 156+ it failed

    Thanks,

    Stiofan

    #448860

    Sam Kneller
    Expired Member
    Post count: 38

    Stiofan, you and your team did it again. The issue is solved. Awesome, want to thank you for contacting the hosting company directly and taking the time to sort this out. I can now add whatever I need to the pages. I have let the host know that all is well. http://wordpressmu-139094-403467.cloudwaysapps.com/travel/france/ile-de-france/paris/train-stations/gare-de-paris-saint-lazare-train-station/

    I’m not sure if you know what solution they applied so here’s what they wrote to me:

    Cloudways Tech Support Yesterday at 14:35
    Hii there,

    We would like to inform you that the issue has been resolved.

    We had to set the following parameter on MYSQL

    innodb_file_per_table
    innodb_file_format = Barracuda

    and had to alter your table by using this command

    ALTER TABLE wp_geodir_gd_train_station_detail ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
    we request you to kindly check and let us know if you are still facing any issue in this regards.

    We will be happy to assist you.

    Thanks

    Besr Regards
    Anas Moiz

    #448881

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    That’s great news! 🙂

    Thanks for sharing their reply, it will speed things up if we ever come across this again (i hope we don’t haha) 🙂

    Have a good weekend!

    Thanks,

    Stiofan

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