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.

Can't Add Note in Entries

Gravity Support Forums » Plugin Support » Gravity Forms

  1. gingalley
    Member

    Hello,

    I cannot add a new Note in Notes on any Entries using Gravity Forms 1.6.11 and WordPress 3.5 (tested on Chrome 24.0.1312.52, Firefox 14.0.1, and Safari 6.0.2.). The Add Notes button does nothing when clicked.

    -I activated default Twenty Ten theme and the issue still occurs.

    -I deactivated ALL plugins, activated Gravity Forms and the issue still occurs.

    Also, the CSS is cutting off the "e" on Add Note button. (see screenshot)

    http://i46.tinypic.com/8yb2nc.jpg

    My Client really needs to have the Notes section working. Thanks for any help!

    P.S. I commented on a similar topic - http://www.gravityhelp.com/forums/topic/cant-add-note. Although the issue is over 2 years old, it is the same problem I am having AND the topic was not closed.

    Posted 11 years ago on Friday January 11, 2013 | Permalink

  2. Chris Hajer
    Key Master

    The old topic being open is my fault: sorry about that. Thank you for starting a new one.

    Please send a WordPress administrator login to chris@rocketgenius.com and I will log in and take a look.

    Posted 11 years ago on Saturday January 12, 2013 | Permalink

  3. Chris Hajer
    Key Master

    I tried adding a note and I was unsuccessful. However, I did not have the CSS issue on the button that you did. I logged in to your site and see a lot of theme-related jQuery in the admin on the Gravity Forms page. I also see a google maps API script being loaded in the admin. Any of these can create a problem on the Gravity Forms entry screen.

    Have you already checked for theme and plugin conflicts? I was hesitant to do that since this appears to be a live, active site. http://rkt.gs/testing

    Posted 11 years ago on Saturday January 12, 2013 | Permalink

  4. gingalley
    Member

    Thanks for your effort. You can turn on Maintenance mode to test.

    Like I said, I turned theme and plugins off and it still won't allow me to add notes.

    Posted 11 years ago on Saturday January 12, 2013 | Permalink

  5. Chris Hajer
    Key Master

    Sorry, I missed that you tested for that before. I will continue testing this weekend.

    Posted 11 years ago on Saturday January 12, 2013 | Permalink

  6. gingalley
    Member

    Thanks Chris!

    Maintenance Mode is under Settings > Maintenance Mode. Feel free to turn on. Just remember to turn back off. :)

    Posted 11 years ago on Saturday January 12, 2013 | Permalink

  7. gingalley
    Member

    Any word on this issue?

    Thanks!

    Posted 11 years ago on Wednesday January 16, 2013 | Permalink

  8. Chris Hajer
    Key Master

    Hi Chris. Take a look at your entries and notes now. I added a few notes for form 6, the one test entry that is there.

    The issue was that the database collation was different on the wp_users table and the wp_rg_lead_notes table. I turned on WP_DEBUG after activating maintenance mode for a few minutes, and I saw this error:

    WordPress database error: [Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull']

SELECT n.id, n.user_id, n.date_created, n.value, ifnull(u.display_name,n.user_name) as user_name, u.user_email FROM wp_rg_lead_notes n LEFT OUTER JOIN wp_users u ON n.user_id = u.id WHERE lead_id=651 ORDER BY id

    If you take a look at the database tables, there is quite a mix of collations going on. I made the wp_users and wp_rg_lead_notes collation the same for the fields which mattered and then I was able to see the notes again.

    You might want to have someone more familiar with MySQL look at this and see if the different collations are going to cause a problem in the future. I fixed the issue with the Gravity Forms notes. Let me know if you have any trouble.

    Posted 11 years ago on Thursday January 17, 2013 | Permalink

  9. gingalley
    Member

    Thanks Chris. You rawk. I will take a closer look at db then.

    I have to ask one last question concerning this because I know Client will ask...

    Is there a way to include Notes when you Resend Notification?

    Thanks again!

    Posted 11 years ago on Thursday January 17, 2013 | Permalink

  10. Chris Hajer
    Key Master

    There is no way I know of to send the notes with the resent notification. You can print the notes when you print the entry, and you can send the note when it is added, but there is no option to resend notes with the notification. There is probably a way to custom code it, but I have not looked into that. I'll tag this as a feature request for that portion.

    Posted 11 years ago on Thursday January 17, 2013 | Permalink

  11. nickydef
    Member

    So which field do I need to change collation on if I am experiencing the same issue?

    Actually, I am looking at both tables that you mentioned and they are both set to "utf8_general_ci" collation?

    Posted 11 years ago on Tuesday February 26, 2013 | Permalink

  12. Chris Hajer
    Key Master

    @nickydef, because each of these issues require individualized troubleshooting, I ask that you please open a new topic and state there what the problem is. Additionally, because you're a developer license holder, you can always use the priority support form, as we may need to log in to your installation and have a look at the database as well.

    Posted 11 years ago on Saturday March 2, 2013 | Permalink

This topic has been resolved and has been closed to new replies.