Reindexing ca_storage_locations blows up because of bad sql?
When I try to reindex ca_storage_locations, it blows up because of bad sql.
It appears that field_row_id is being set (from an array?) so that it sometimes has two semicolon separated values...and that blows up the sql.
INSERT INTO ca_sql_search_word_index ( table_num, row_id, field_table_num, field_num, field_container_id, field_row_id, word_id, boost, access, rel_type_id )
VALUES (89, 646, 89, 'A22', NULL, 646, 31502, 1, 0, 0),... ,(89,649,88,'I4',NULL,665;666,26875,1,0,0)
Any ideas where to start looking?