Installed Domain Block and All Blocks Not Showing

I'm having the same issue, I install domain block then certain blocks go missing. The if I turn the module off and the missing blocks re-appear.

I am also experiencing the same problem. Any thoughts from the developers?

Figured out the problem (at least for me). I'm using MYSQL and the collation of the fields between the blocks table and the domain_blocks table in the database was different (blocks = utf8_unicode_ci; domain_blocks = utf8_general_ci), making it impossible for mysql to compare values between them. I manually changed the domain_blocks fields to be utf8_unicode_ci and it works now.

It probably won't be exactly the same collation issues for everyone, but something along these lines. My problem was because the project was originally developed in an environment with the default collation set as utf8_unicode_ci, but has since moved to an database that uses utf8_general_ci as it's default. It looks like as of Drupal 6.20, they've introduced a way to set the default collation for drupal tables using $db_collation in the settings.php file:

/**
 * Database default collation.
 *
 * All data stored in Drupal is in UTF-8. Certain databases, such as MySQL,
 * support different algorithms for comparing, indexing, and sorting characters;
 * a so called "collation". The default collation of a database normally works
 * for many use-cases, but depending on the language(s) of the stored data, it
 * may be necessary to use a different collation.
 * Important:
 * - Only set or change this value BEFORE installing Drupal, unless you know
 *   what you are doing.
 * - All database tables and columns should be in the same collation. Otherwise,
 *   string comparisons performed for table JOINs will be significantly slower.
 * - Especially when storing data in German or Russian on MySQL 5.1+, you want
 *   to use the 'utf8_unicode_ci' collation instead.
 *
 * @see http://drupal.org/node/772678
 */
$db_collation = 'utf8_unicode_ci';

Hope this helps someone!

That's an interesting find indeed.

For those who still have these issues and it's not caused by database collation it would help to know which Drupal and Domain version you are running and if you are running any other modules that use db_rewrite_sql().

I'm closing this ticket for now, please re-open if you have any additional info.

i'm having the same problem, though only some of the modules reappear when I disable the module. It's not the database collation.

Newest drupal - 7.16
Domain Access 7.x-3.4

Same here. Also had an error telling me to update block database something afterwords they gone. I`ve tried to choose a domain in block configuration but they haven`t shown.

Which version of Domain Blocks are you using? According to the version of the issue it's 7.x-2.0 but you are using Domain Access 7.x-3.x branch

I am having this happen as well. I installed domain_blocks using drush, then ran the domain-repair command as instructed.

I am using Domain access: 7.x-3.8 and Domain_blocks 7.x-2.0. Drupal is 7.19

Note, when I viewed a block for the first time, I noticed 'Display On...' and then all the blocks were unchecked.

It this not backwards? Or, better yet, can it be programmed to be the other way around? If you enable the module, and it's default on for all domains then you would not have this problem of all the domains disappearing, no?

I say this because after the module is installed and all the blocks disappear from all sites, I can check the boxes and they start to show up again. So, it "works" it's just not very intuitive. Plus, maybe like many other users, going back and turning all the blocks back on is a bit more work than simply hitting the gear to edit the block directly and switch off where needed.

If it's set to the other way around should the instructions on the block not be "DO NOT Display on...." and then we tick which ones each block is not to be displayed on?

For me this is not a collation issue.

Switched this to a bug report, but if this is config related, please let me know and let's change back.

Yeah, I can confirm this bug in drupal 7, setting collation to 'collation' => 'utf8_general_ci', or 'collation' => 'utf8_unicode_ci', yields the same unfavorable results: all blocks disappear, unless you re-save each one by one by changing the domain settings. Ugh.

With Domain Access 7.x-3.x you should be using Domain Blocks in 7.x-3.x branch not 7.x-2.x. Please update to the correct version and let me know if that changes any of the behavior.

The module is intended to show all the enabled blocks by default unless you specify that a block should be only shown on a given domain. It does not control the collation of its own db table not the other tables so it is the developer's responsibility to make sure you are not using different ones for different tables.