Okay
  Public Ticket #2366118
Multiline Editor
Closed

Comments

  • Dermod Wood started the conversation

    Issue with the multiline editor is back.  We fixed it using your 2017 support ticket, but this has to be done for each new release.

  •   Dermod Wood replied privately
  •   Dermod Wood replied privately
  •  2,507
    Aleksandar replied

    Hello again Dermod

    I'm not sure about the multi-line issue without taking a look, so other than the info found in that ticket - there's not much I can do without admin-level access.

    I took a look at your table, and it looks like the "Codes" column is saved as VARCHAR(4) in the database. I've tested it, and it accepts anything as long as it's 4 characters long. As soon as you exceed 4 characters, it doesn't accept changes.

    So, you need to take a look at this column's settings in the database, and check what the character limit is.

    For multi-line, please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. 

    Just a reminder, since the ticket is public - please make sure to enable the private response, like you already did before.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Dermod Wood replied privately
  •   Dermod Wood replied privately
  •   Aleksandar replied privately
  • Dermod Wood replied

    Hi Alek - Thanks very much.  I recreated the table which solved the problem.  One thing that would be helpful would be to have the title and column header as separate items in the editor.  As it is, once you change the title and change the order a bit it's very difficult to be sure you have the right mapping.  Also a real oddity, which we have found a good work-around, but would be nice to understand what is going on.

  •  2,507
    Aleksandar replied

    Hi again Dermod

    You're welcome, glad I could help.

    When you're writing your own queries, please keep this in mind:

    You don't need the table name in the query, so items_item is too much.

    Also, from version 2.3 we've implemented a feature that you can use multiple separate DB connections for MySQL, MSSQL and PostgreSQL. For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query. If you were to delete them, searching and filtering should work just fine.

    If it doesn't work, then you may need to create a view in the database, and to pull that view in.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables