https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail Gravity Support Forums Topic: [BUG] double qoutes in confirmation message and redirect cause migration to fail en-US Wed, 22 Apr 2026 16:33:16 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-15537 Wed, 05 Jan 2011 22:08:31 +0000 Alex Cancado 15537@https://legacy.forums.gravityhelp.com/ <p>I have created a plugin that helps fixing the serialized meta when the lengths get out of sync (which seems to be your problem). Shoot me an email to <a href="mailto:alex@rocketgenius.com">alex@rocketgenius.com</a> and I will send it your way. </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-15500 Wed, 05 Jan 2011 13:53:32 +0000 m4change 15500@https://legacy.forums.gravityhelp.com/ <p>Thanks for the link to BackupBuddy, I'll look into it. I'm also looking into the following library:</p> <p><a href="http://spectacu.la/search-and-replace-for-wordpress-databases/" rel="nofollow">http://spectacu.la/search-and-replace-for-wordpress-databases/</a> </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-15497 Wed, 05 Jan 2011 13:45:51 +0000 Chris Hajer 15497@https://legacy.forums.gravityhelp.com/ <p>I've had this happen before with WordPress serialized data. After the first time it happened, I was careful to use domain names with the same number of characters in them for dev and production, so I could do the simple search and replace and not corrupt the serialized data.</p> <p>So, now I use ww2.example.com for development and www&#46;example.com for production (or example.org and example.com). With the same length domain names, the length of the values in the serialized database entries does not get corrupted.</p> <p>I think maybe the <a href="http://pluginbuddy.com/purchase/backupbuddy/" rel="nofollow">BackupBuddy plugin</a> took care of this as well, but I never tried it to confirm.</p> <blockquote><p> <strong>Migrate</strong></p> <ul> <li>Develop on one server &amp; launch on another in minutes.</li> <li>Easily change your site’s domain name.</li> <li>Rapid deployment of your favorite default environment.</li> </ul></blockquote> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-15491 Wed, 05 Jan 2011 13:32:47 +0000 Carl Hancock 15491@https://legacy.forums.gravityhelp.com/ <p>The issue isn't a bug in Gravity Forms, it's an issue with the migration process itself. We have seen this occur with export and imports in PHPMyAdmin. If the data was exact, you wouldn't be encountering errors. But things get changed. I'll have Alex respond with more information, however he is currently traveling so there may be a slight delay in his response. </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-15488 Wed, 05 Jan 2011 13:23:20 +0000 m4change 15488@https://legacy.forums.gravityhelp.com/ <p>okay... so this number appears to be a length indicator of sorts and that's where the confusion seems to be happening when the urls are different lengths.</p> <p>Found this out when trying the name:</p> <p>s:17:\"http://unique.com\"<br /> echo "http://unique.com" |wc -c<br /> 18</p> <p>Other than making the local domain the same exact length or using maths to calculate the new length during the sed process... is there anyway I can compensate for a difference in length? </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-15482 Wed, 05 Jan 2011 12:54:59 +0000 m4change 15482@https://legacy.forums.gravityhelp.com/ <p>Again, I experienced this issue in migration in a different way but it helped me get closer to understanding the cause of this issue.</p> <p>The table that breaks during migration is 'rg_form_meta'. The way it breaks is interesting and illusive. My migration process is as follows:</p> <p>1. Dump local database<br /> 2. use sed to replace the url for the production site<br /> 3. rsync the sql dump to the server<br /> 4. drop old database, import the new one</p> <p>For some reason, when I change the value of the url in the gravity forms rg_form_meta table, it's auto-incrementing the ID of that field and causing the 'oops form not found' error.</p> <p>Here is a screenshot of the diff of the database after the aforementioned process takes place:</p> <p><a href="http://i.imgur.com/3Lx7k.png" rel="nofollow">http://i.imgur.com/3Lx7k.png</a></p> <p>This baffles my mind. Please any advice about this is appreciated, it's an extremely annoying bug to work around.</p> <p>The basic code I use:</p> <p>1. mysqldump -u USER -pPASSWORD DB &gt; db-dump.sql<br /> 2. sed -i 's#http://www.site.loc#http://www.site.com#g' db-dump.sql<br /> 3. rsync -avzh db-dump.sql RUSER@RSERVER:RDIR<br /> 4. mysql -u USER -pPASSWORD</p> <p>xml test form:<br /> <a href="http://pastebin.com/2CqDVChP" rel="nofollow">http://pastebin.com/2CqDVChP</a> </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-14492 Wed, 15 Dec 2010 16:05:31 +0000 m4change 14492@https://legacy.forums.gravityhelp.com/ <p>Alright, I understand. Hopefully we can work through the bugs in the current SQL migration. </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-14489 Wed, 15 Dec 2010 15:40:45 +0000 Carl Hancock 14489@https://legacy.forums.gravityhelp.com/ <p>id's are database specific. The import/export tool isn't designed to be a database clone tool. It's just a simple way to import/export form settings. It's an export of the form setup, not the specific form data. </p> <p>If you need to keep the id's intact then you would have to do a manual import/export using SQL database tools to maintain the exact database setup. </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-14486 Wed, 15 Dec 2010 15:30:06 +0000 m4change 14486@https://legacy.forums.gravityhelp.com/ <p>Can't there be a check for if the id already exists or perhaps an option to reference forms by an english name? This becomes an issue when hooking into forms because the functions are then separated from a form if they are imported with a new id. </p> https://legacy.forums.gravityhelp.com/topic/bug-double-qoutes-in-confirmation-message-and-redirect-cause-migration-to-fail#post-14485 Wed, 15 Dec 2010 15:11:32 +0000 Carl Hancock 14485@https://legacy.forums.gravityhelp.com/ <p>We'll look into these issues. So you are aware, form id's are not carried over when doing an import/export because form id's are database specific and you could be importing a form into a site that already has forms. </p>