The complete message is:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'link' at row 1: INSERT INTO {aggregator_item} (title, link, author, description, guid, timestamp, fid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => Fraunhofer ISE und AZUR SPACE Solar Power bekräftigen langjährige Kooperation - Entwicklung von Hochleistungs-solarzellen aus III-V Halbleitern für die Weltraumanwendung [:db_insert_placeholder_1] => http://www.ise.fraunhofer.de/presse-und-medien/presseinformationen/presseinformationen-2011/fraunhofer-ise-und-azur-space-solar-power-bekraeftigen-langjaehrige-kooperation-entwicklung-von-hochleistungs-solarzellen-aus-iii-v-halbleitern-fuer-die-weltraumanwendung [:db_insert_placeholder_2] => bmoritz [:db_insert_placeholder_3] => Entwicklung und Produktion höchsteffizienter Mehrfachsolarzellen aus III-V Halbleitern verbinden das Fraunhofer-Institut für Solare Energiesysteme ISE und AZUR SPACE Solar Power seit mehr als 15 Jahren. Diese strategische Partnerschaft wurde nun durch einen auf weitere 20 Jahre angelegten Kooperationsvertrag bekräftigt. Das Fraunhofer ISE wird in den kommenden Jahren exklusiv mit AZUR SPACE, Heilbronn an neuen Generationen von Solarzellen für die Anwendung im Weltraum arbeiten. [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => 1321954328 [:db_insert_placeholder_6] => 17 ) in aggregator_save_item() (Zeile 153 von /home/www/cleantech/modules/aggregator/aggregator.processor.inc).

The used RSS feed which causes this error is:
http://www.ise.fraunhofer.de/presse-und-medien/rss-feeds/feeds/aktuelle-presseinformationen-des-fraunhofer-ise/RSS

CommentFileSizeAuthor
#7 link_length-1351534-7.patch504 byteslogaritmisk
#1 link_length-1351534-1.patch827 byteslogaritmisk
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

logaritmisk’s picture

logaritmisk CreditAttribution: logaritmisk commented
FileSize
link_length-1351534-1.patch827 bytes

Created a patch to update link length to 2048 (same as link uses).

Source: http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-...

logaritmisk’s picture

logaritmisk CreditAttribution: logaritmisk commented
Status: Active » Needs review

Forgot to change status.

Status: Needs review » Needs work

The last submitted patch, link_length-1351534-1.patch, failed testing.

philosurfer’s picture

philosurfer CreditAttribution: philosurfer commented

I was getting the error using a Google news feed.

I applied patch and it works. Cron is free to run again :)
The 256 char limit is too small.

Lets take a look at why this failed the test and get this fixed :)

marcingy’s picture

marcingy CreditAttribution: marcingy commented
Status: Needs work » Closed (duplicate)

duplicate of #218004: Allow aggregator feed URLs longer than 255 characters

marcingy’s picture

marcingy CreditAttribution: marcingy commented
Status: Closed (duplicate) » Needs work

My bad - that is for feeds not items from the feed

logaritmisk’s picture

logaritmisk CreditAttribution: logaritmisk commented
Version: 7.9 » 8.x-dev
Status: Needs work » Needs review
FileSize
link_length-1351534-7.patch504 bytes

New patch for 8.x-dev

nikos_sty’s picture

nikos_sty CreditAttribution: nikos_sty commented

#7: link_length-1351534-7.patch queued for re-testing.

Status: Needs review » Needs work

The last submitted patch, link_length-1351534-7.patch, failed testing.

mikhailian’s picture

mikhailian CreditAttribution: mikhailian commented

I had exactly the same problem on 7.15. Solved by changing the column length to 2048, as suggested above.

Cameron Tod’s picture

Cameron Tod CreditAttribution: Cameron Tod commented
Status: Needs work » Closed (duplicate)

This has been fixed in #218004: Allow aggregator feed URLs longer than 255 characters 


@@ -233,10 +229,8 @@ function aggregator_schema() {
         'description' => 'Title of the feed item.',
       ),
       'link' => array(
-        'type' => 'varchar',
-        'length' => 255,
+        'type' => 'text',
         'not null' => TRUE,
-        'default' => '',
         'description' => 'Link to the feed item.',
       ),

That fix needs a backport to d7 and d6.