Great theme, BTW.

I'm using the TB Methys subtheme, but I get this error on both TBM and the core Nucleus theme. I run two websites (on two different servers) using this theme and I have this issue on one site, but not the other.

I get this error when I try to make changes to the layout:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'region' cannot be null: UPDATE {block} SET region=:db_update_placeholder_0, weight=:db_update_placeholder_1, status=:db_update_placeholder_2 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => [:db_update_placeholder_2] => 1 [:db_condition_placeholder_0] => 668 ) in nucleus_form_system_theme_settings_submit() (line 480 of /var/www/websites/xxx/sites/all/themes/nucleus/nucleus/theme-settings.php).

Wow, that's a mouthful! :)

I see that "PDOException: SQLSTATE[23000]" all over drupal.org, so it may well be a core issue, but odd that of two websites, one has the issue but the other doesn't. Still, I'm personally only seeing it on the Nucleus theme and nowhere else. If the issue isn't with Nucleus, let me know and I'll look elsewhere.

Comments

shaisamuel’s picture

shaisamuel commented

I have almost the same:
DOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'region' cannot be null: UPDATE {block} SET region=:db_update_placeholder_0, weight=:db_update_placeholder_1, status=:db_update_placeholder_2 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => [:db_update_placeholder_2] => 1 [:db_condition_placeholder_0] => 147 ) in nucleus_form_system_theme_settings_submit() (line 480 of /home/p2wt/public_html/sites/all/themes/nucleus/nucleus/theme-settings.php).

ericinwisconsin’s picture

ericinwisconsin commented

Mine turned out to be caused by the Meta Tags Quick module. Any page that used them was causing an error.

Unfortunately, Meta Tags Quick embeds itself into the website fairly deep and it's difficult to remove.

shaisamuel’s picture

shaisamuel commented

Eric, I have meta tag and meta tag quick, both are disabled. I just updated to latest version 7.x-1.0-alpha6, flash caches, re-enter the theme setting, and problem was gone.

kastas’s picture

kastas commented

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'region' cannot be null: UPDATE {block} SET region=:db_update_placeholder_0, weight=:db_update_placeholder_1, status=:db_update_placeholder_2 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => [:db_update_placeholder_2] => 1 [:db_condition_placeholder_0] => 107 ) in nucleus_form_system_theme_settings_submit() (line 480 of /home/papa/domains/mousegames.lt/public_html/themes/nucleus/nucleus/theme-settings.php).

have no clue how to fix that, was starting to like nucleus theme thingy.

jobnomade’s picture

jobnomade commented

Hi kastas,

this is a problem of Nucleus, we will release it in the stable version.
Thanks for the reporting!

themebrain’s picture

themebrain commented
Version: 7.x-1.1-beta2 » 7.x-1.1
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.