parse error in bio or notes field

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: not resolved

Tagged: , , ,

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • 03/25/2016 at 7:24 am #370493
    dominic loiacono
    Participant

    I had issues with a subscriber getting an error when they were submitting their form “an error adding entry has occurred”

    I discovered the issue was in the notes or bio field(I renamed them so not sure which is which) they were pasting their text and it contained a wink “😉”.

    Once I removed the wink from the form, it was submitted correctly.

    Not sure what can be done, but thought you should be aware.

    Thanks

    dom

    03/25/2016 at 11:27 am #370524
    Steven Zahm
    Keymaster

    @ dominic

    Hmmm… I just tried it and I was unable to replicate the error. Can you check to see what the Collation is set to in the wpdbprefix_connnections table for the bio and notes columns? It should be utf8mb4_unicode_ci.

    Let me know what you find out.

    03/25/2016 at 6:54 pm #370559
    dominic loiacono
    Participant

    Hi Steven,

    my connections table looks like:

    27 bio longtext utf8_general_ci
    28 notes longtext utf8_general_ci

    when i tried to change to utf8mb4_unicode_ci I get:

    Query error:

    <h1>1283 – Column ‘bio’ cannot be part of FULLTEXT index</h1>

    thanks for all the great support.

    dom

    03/28/2016 at 11:43 am #370773
    Steven Zahm
    Keymaster

    @ dominic

    You need to first remove the FULLTEXT index before you can change the collation. The easy way to do this is go to the Connections : Settings admin page and click the Search tab and disable the FULLTEXT option. After you do, should be able to change the collation and then re-enable the FULLTEXT search option.

    Hope that helps!

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

You must be logged in to reply to this topic.