Can't add facet block to any region: Duplicate entry 'pro_5-apachesolr_facetbuilder-sm_facetbuilder_search_by_projec' for key 2

Hmm... looks like the automatically generated block names are getting too long for the table field. I'll try to find a way to make sure the names generated are shorter (maybe use an acronym instead of the full module name if I can). In the mean time you may be able to mitigate this by using a shorter machine name for your view.

My logs show the same issue as well.

Same for me :

user warning: Duplicate entry 'garland-apachesolr_facetbuilder-sm_facetbuilder_filter_by_freshn' for key 2 query: INSERT INTO blocks (module, delta, theme, status, weight, region, custom, throttle, visibility, pages, title, cache) VALUES ('apachesolr_facetbuilder', 'sm_facetbuilder_filter_by_freshness', 'garland', 0, 0, '', 0, 0, 0, '', '', 4) in [...]

I'll try with a shorter name, as I can see this one is 3 chars too long.

FWIW I fixed this in the short term by allowing delta values of up to 64 chars in the blocks table:

ALTER TABLE `blocks` CHANGE `module` `module` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT;

Confirming this issue with 6.x-1.x-dev of 2010-Jul-11

In my case the block can not be move to any regions with a Views machine name 22 characters long

The same block can be move to any regions with a Views machine name 7 characters long

Confirming & Subscribing.