Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I get following error 3 times while viewing the blocks.
user warning: Duplicate entry 'hellosap-apachesolr_search-ssfield_cck_field_profile_relati' for key 2 query: drupal_write_record /* admin : drupal_write_record */ INSERT INTO blocks (module, delta, theme, status, weight, region, custom, throttle, visibility, pages, title, cache) VALUES ('apachesolr_search', 'ssfield_cck_field_profile_relation', 'hellosap', 0, 0, '', 0, 0, 0, '', '', 1) in C:\xampp\htdocs\hellosap\includes\common.inc on line 3324.
Comment | File | Size | Author |
---|---|---|---|
#6 | 32-char-delta-344249-6.patch | 2.89 KB | pwolanin |
#5 | 32-char-delta-344249-5.patch | 1.77 KB | pwolanin |
#4 | 32-char-delta-344249-4.patch | 1.75 KB | pwolanin |
Comments
Comment #1
jp.stacey CreditAttribution: jp.stacey commentedWe get this error too: it's because the delta being created (ssfield_cck_field_profile_relation) is too long for the 32-char field in the database, so it gets truncated and conflicts with existing records. It'd be better if the delta were some sort of hash UUID instead of a field name.
Actually, it'd be better if we could just not have these blocks. The many automated blocks are a bit of a pain, especially on a complex site: most of them we don't need, and we've had to rebuild the others to match what our client wanted. Any way of putting in an option to turn them all off, or move them out into a sub-module?
Comment #2
jp.stacey CreditAttribution: jp.stacey commentedWe get this error too: it's because the delta being created (ssfield_cck_field_profile_relation) is too long for the 32-char field in the database, so it gets truncated and conflicts with existing records. It'd be better if the delta were some sort of hash UUID instead of a field name.
Actually, it'd be better if we could just not have these blocks. The many automated blocks are a bit of a pain, especially on a complex site: most of them we don't need, and we've had to rebuild the others to match what our client wanted. Any way of putting in an option to turn them all off, or move them out into a sub-module?
Comment #3
jp.stacey CreditAttribution: jp.stacey commented(sorry for duplicate comment: I got a "you do not have access to any projects" error from d.o first time round!)
Comment #4
pwolanin CreditAttribution: pwolanin commentedThe CCK field name can be a full 32 chrs, so it seems like we must use just that as the delta.
Comment #5
pwolanin CreditAttribution: pwolanin commentedcan cut a couple more lines.
Note - there is no upgrade path here - you'll have to manually reconfigure your blocks.
Comment #6
pwolanin CreditAttribution: pwolanin commentednow with update function. Please test.
Comment #7
JacobSingh CreditAttribution: JacobSingh commentedLooks good.
Comment #8
pwolanin CreditAttribution: pwolanin commentedcommitted to 6.x
Comment #9
pwolanin CreditAttribution: pwolanin commentedComment #10
pwolanin CreditAttribution: pwolanin commented