When upgrading from D6 to D7, a longtext (text_long) field with widget autocomplete_widgets_flddata is not properly migrated, resulting in a PDO exception due to bad SQL syntax ('VARCHAR()' with no size).

Related issue with suggested fix strategy: http://drupal.org/node/1417626#comment-6262340

CommentFileSizeAuthor
#2 autocomplete_widgets-migrate-fix-1790758-2.patch2.02 KBjromine
#1 autocomplete_widgets-migrate-fix-1790758-1.patch642 bytesjromine

Comments

jromine’s picture

jromine commented
Status: Active » Needs review
StatusFileSize
new autocomplete_widgets-migrate-fix-1790758-1.patch642 bytes

Patch attached

jromine’s picture

jromine commented
StatusFileSize
new autocomplete_widgets-migrate-fix-1790758-2.patch2.02 KB

Sorry, the earlier patch set the field type to longtext, which is not compatible with the autocomplete widget.

This patch changes the (longtext) field type to 'text', and also fixes migrating fields using the allowed values autocomplete widget.

bleen’s picture

bleen commented

I'll be honest, I'm not sure Ill ever really have the opportunity to test this patch out. I'd consider including it if someone else could offer a review and verify that it works.

presleyd’s picture

presleyd commented

The function worked for me. It needs to be rerolled for the current version though. The line numbers are off.

bleen’s picture

bleen commented
Status: Needs review » Fixed

thanks for reviewing ....

committed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.