https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen Gravity Support Forums Topic: problem with Notes field in View screen en-US Mon, 20 Apr 2026 01:40:25 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2799 Sun, 17 Jan 2010 16:35:29 +0000 kmstirtz 2799@https://legacy.forums.gravityhelp.com/ <p>Thanks Carl! </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2789 Sun, 17 Jan 2010 13:10:02 +0000 Carl Hancock 2789@https://legacy.forums.gravityhelp.com/ <p>We haven't encountered this issue before so I guess it is possible, although with such a large number of users using Gravity Forms over the 9 months (including beta testing and release versions) i'm sure if it was wider problem that this wouldn't have been the first time that this issue occurred. </p> <p>We have made a change that will be introduced in the next release of Gravity Forms that forces any new tables to be created using the same collation as the WordPress install it is being activated on. This won't impact existing sites, but will curb the issue in new installs. </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2770 Sat, 16 Jan 2010 13:47:39 +0000 kmstirtz 2770@https://legacy.forums.gravityhelp.com/ <p>My wp_rg_lead_notes.user_name field has utf8_general_ci as the collation but the wp_users.display_name has utf8_unicode_ci as the collation. So - are you saying I should change the wp_users.display_name field collation to utf8_general_ci ?</p> <p>BTW - all my WP created tables have utf8_unicode_ci for their collation while, as you know, the rg tables are utf8_general_ci</p> <p>However...</p> <p>On my site hosted at Cartika, all the WP tables are utf8_latin_swedish_ci while the plugins, including rg, of course) are utf8_general_ci</p> <p>Bottom line...</p> <p>Matching the wp_rg_lead_notes.user_name collation and the wp_users.display_name collation (both using utf8_general_ci) worked - problem solved.</p> <p>Thanks!</p> <p>But - is it a problem having different collations in the other fields? (It would seem not but I'm no expert.) </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2756 Fri, 15 Jan 2010 12:29:48 +0000 Alex Cancado 2756@https://legacy.forums.gravityhelp.com/ <p>It looks like there is a difference in collation between the wp_users.display_name column and wp_rg_lead_notes.user_name column.<br /> This probably was caused by the fact that Gravity Forms only specify the character set (utf8) when creating its tables and your server defaults to something that is different that WordPress' tables.</p> <p>We will adjust our installation script so that the collation matches WordPress' tables. Meanwhile, you could change the collation on the wp_rg_lead_notes.user_name to match wp_users.display_name. </p> <p>Assuming wp_users.display_name has the collation "utf8_general_ci" (please double check that), you can run the following command on your database:</p> <pre><code>ALTER TABLE wp_rg_lead_notes MODIFY user_name VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci</code></pre> <p>Let me know how it goes </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2749 Fri, 15 Jan 2010 11:12:03 +0000 kmstirtz 2749@https://legacy.forums.gravityhelp.com/ <p>More complete error from HG (when they tried to enter a note in the View Entries screen):</p> <p>[Thu Jan 14 07:06:45 2010] [error] [client 76.17.223.200] WordPress database error Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' for query SELECT n.id, n.user_id, n.date_created, n.value, ifnull(u.display_name,n.user_name) as user_name, u.user_email\r, referer: <a href="http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1" rel="nofollow">http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1</a><br /> [Thu Jan 14 07:06:45 2010] [error] [client 76.17.223.200] FROM wp_rg_lead_notes n\r, referer: <a href="http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1" rel="nofollow">http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1</a><br /> [Thu Jan 14 07:06:45 2010] [error] [client 76.17.223.200] LEFT OUTER JOIN wp_users u ON n.user_id = u.id\r, referer: <a href="http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1" rel="nofollow">http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1</a><br /> [Thu Jan 14 07:06:45 2010] [error] [client 76.17.223.200] WHERE lead_id=2 made by do_action, call_user_func_array, RGForms-&gt;all_leads_page, GFEntryDetail-&gt;lead_detail_page, RGFormsModel-&gt;get_lead_notes, referer: <a href="http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1" rel="nofollow">http://amazingserviceu.com/asu/wp-admin/admin.php?page=gf_entries&amp;view=entry&amp;id=1&amp;lid=2&amp;paged=1</a> </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2748 Fri, 15 Jan 2010 10:56:54 +0000 kmstirtz 2748@https://legacy.forums.gravityhelp.com/ <p>correction - should be:</p> <p>[Fri Jan 15 08:25:44 2010] [error] [client 216.110.94.227] WordPress database error Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' for query SELECT n.id, n.user_id, n.date_created, n.value, ifnull(u.display_name,n.user_name) as user_name, u.user_email, referer: <a href="http://amazingserviceu.com/as/wp-admin/admin.php?page=gf_entries" rel="nofollow">http://amazingserviceu.com/as/wp-admin/admin.php?page=gf_entries</a> </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2747 Fri, 15 Jan 2010 10:56:17 +0000 kmstirtz 2747@https://legacy.forums.gravityhelp.com/ <p>Carl - maybe you have this already...but here is an error the tech guys at HG found:</p> <p>[Fri Jan 15 08:25:44 2010] [error] [client 216.110.94.227] WordPress database error Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' for query SELECT n.id, n.user_id, n.date_created, n.value, ifnull(u.display_name,n.user_name) as user_name, u.user_email, referer: <a href="http://http://amazingserviceu.com/as/wp-admin/admin.php?page=gf_entries" rel="nofollow">http://http://amazingserviceu.com/as/wp-admin/admin.php?page=gf_entries</a></p> <p>Thanks for your help!</p> <p>KS </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2740 Fri, 15 Jan 2010 01:16:38 +0000 kmstirtz 2740@https://legacy.forums.gravityhelp.com/ <p>I'm online with HG suppot via chat. Can they help? </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2736 Fri, 15 Jan 2010 00:41:53 +0000 Carl Hancock 2736@https://legacy.forums.gravityhelp.com/ <p>I will be in touch later on Friday with additional details. </p> <p>We are going to need you to test a query in PHPMyAdmin. What is happening is your MySQL database is not returning the results for the select query that is used to display Notes. </p> <p>It's highly unusual and nobody else has reported anything remotely similar to this issue. </p> https://legacy.forums.gravityhelp.com/topic/problem-with-notes-field-in-view-screen#post-2735 Fri, 15 Jan 2010 00:36:47 +0000 kmstirtz 2735@https://legacy.forums.gravityhelp.com/ <p>Update: I deactivated ALL plugins (except GF of course) and tried it. Same problem. </p>