Hello,

Our site is running both the Link and Radioactivity modules.
We use the Link module to add "Related Links" to nodes ("segments" content type) on our site, and have found that these often disappear after addition.

Inspecting the log, we discovered an error message relating to Radioactivity checks:

Location: radioactivity_ajax.php
Details:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1: INSERT INTO {field_data_field_rel_links} (entity_type, entity_id, revision_id, bundle, delta, language, field_rel_links_url, field_rel_links_title, field_rel_links_attributes) 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, :db_insert_placeholder_7, ); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 6357 [:db_insert_placeholder_2] => 55781 [:db_insert_placeholder_3] => segments [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => book/recipes/potatoes [:db_insert_placeholder_7] => L'Etoile's Tips For Great Mashed Potatoes ) in field_sql_storage_field_storage_write() (line 424 of /mnt/www/html/wpr/docroot/modules/field/modules/field_sql_storage/field_sql_storage.module).

It appears that Link is throwing a MySQL error when Radioactivity examines nodes with link fields.

Laura

Comments

dqd’s picture

Laura, thanks for the report. But please provide more info: exact Drupal version, related modules version, turn related modules on/off behaviour etc...

thanks 4 understanding.

btw: project page says it is recommended to use latest dev before reporting back to keep in the line of commits ...

dqd’s picture

Status: Active » Postponed (maintainer needs more info)
lzimmerman’s picture

No problem - thanks for your response.
I've updated the Link module to the latest dev version, and confirmed that the error is still occurring.

Modules/versions in use:
Core: 7.8
Link: 7.x-1.x-dev
Radioactivity: 7.x-1.x-dev

This is an older version of Radioactivity, so I'm working on updating that as well.

Laura