PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Paragraph text not displaying full text with post_submission_handler

Gravity Support Forums » Plugin Support » Gravity Forms

  1. Strada
    Member

    Here is the form :
    http://www.strada-dici.com/ajoutez-votre-strada-date/

    The fields "Coordonnées des organisateurs" and "Description de la manifestation" are not displaying the full text entered.

    It is important to note that I am using the following custom post_submission_handler to fill the content of the generated article.
    http://www.pastie.org/1330590

    Also when confirming the entry the form displays the full text. However once in the post_submission_handler my print that you can see line 73 does not display the full text.

    Any idea ?
    Is it related to that issue ?
    http://forum.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us

    Thanks,
    Erwan

    Posted 13 years ago on Sunday November 28, 2010 | Permalink

  2. Strada
    Member

    Hi all,
    I would need this to work by Wednesday, I have got a deadline that is quite rigid : )
    Could anyone from support please give me a lead ?
    If you need more information feel free to tell me !

    Thanks,
    Erwan

    Posted 13 years ago on Monday November 29, 2010 | Permalink

  3. Carl Hancock
    Administrator

    Your problem is going to be related to how lead data is stored. Long values are stored in the rg_lead_detail_long table. Anything over 200 characters is stored in the rg_lead_detail_long table so that the rg_lead_detail performs well on quick look ups and searches on the entry list page.

    So you need to query data from both tables and for fields you know are 150 characters or more (better to use vs. 200 characters) you would pull from the rg_lead_detail_long table instead of the rg_lead_detail.

    So in your query you will need to join the rg_lead_detail_long table and then pull from that where appropriate.

    Posted 13 years ago on Monday November 29, 2010 | Permalink

  4. Strada
    Member

    Thanks a lot Carl.
    I thought it would something like that.
    I hope I'll manage with the join table thing.

    Erwan

    Posted 13 years ago on Monday November 29, 2010 | Permalink

  5. Strada
    Member

    Hi again Carl
    I can't quite get my head around this mysql query (last time I did one was 10 years ago)
    Here is what I did :
    http://www.pastie.org/1333171
    But that doesn't work.

    What fields in rg_lead_detail_long shall I select (I don't know which field do exist) ?

    Thanks,
    erwan

    Posted 13 years ago on Monday November 29, 2010 | Permalink

  6. Carl Hancock
    Administrator

    I'll have to have one of our developers look at this to determine what you need to do. Keep in mind this is a customization so it might be a little while before he responds as he has higher priority development on Gravity Forms he is working on.

    Posted 13 years ago on Monday November 29, 2010 | Permalink

  7. Strada
    Member

    okay thanks !

    Posted 13 years ago on Monday November 29, 2010 | Permalink

  8. Strada
    Member

    Hi Carl,

    In my sql environment I can see that "wp_stradarg_lead_detail_long" has got two fields :
    * lead_detail_id
    * value
    Do I have to join using lead_detail_id

    Like that : http://www.pastie.org/1336223
    ??

    But that doesn't work : )
    Regards,
    Erwan

    Posted 13 years ago on Tuesday November 30, 2010 | Permalink

  9. Strada
    Member

    Hello again,
    I finally remembered how mysql works : )
    here is the working code for those interested:
    http://www.pastie.org/1336326

    Thanks for your help Carl !
    --
    Erwan

    Posted 13 years ago on Tuesday November 30, 2010 | Permalink