1. Installed phpBB mod and patch (phpBB version 3.09)
2. Installed drupal 7.4 (upgraded to 7.7).
3. Configured drupal to point to phpBB location
4. Go to Drupal's Modules->phpBBforum->Configure

Error message:

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'uid' cannot be null: UPDATE {sessions} SET uid=:db_update_placeholder_0, cache=:db_update_placeholder_1, hostname=:db_update_placeholder_2, session=:db_update_placeholder_3, timestamp=:db_update_placeholder_4 WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => 0 [:db_update_placeholder_2] => 18.42.1.107 [:db_update_placeholder_3] => batches|a:1:{i:3;b:1;}updates_remaining|a:0:{} [:db_update_placeholder_4] => 1312398325 [:db_condition_placeholder_0] => yipvYBiRzqKxvylFggrIqLxZ8coEcPZcjauERp_xaq0 [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 203 of /var/www/relaxtest/drupal/includes/session.inc).
CommentFileSizeAuthor
#3 README.txt17.37 KBalmirsarajcic
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

ves’s picture

Priority: Normal » Major

I think i have struggling with the same issue. Went through same procedure, installed Drupal 7.7 and phpBB3 v. 3.09, the mod and patch. When directing to phpbb in drupal module settings i get this error:

PhpbbVBridgeException: exit in phpbb_hook_exit_handler() (line 129 of C:\wamp\www\avinet\phpBB3\includes\phpbbdrupalbridge\phpbb_api_hooks.php).

followed by a lot of information in the background:

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'uid' cannot be null: UPDATE {sessions} SET uid=:db_update_placeholder_0, cache=:db_update_placeholder_1, hostname=:db_update_placeholder_2, session=:db_update_placeholder_3, timestamp=:db_update_placeholder_4 WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => 0 [:db_update_placeholder_2] => 127.0.0.1 [:db_update_placeholder_3] => batches|a:1:{i:1;b:1;}phpbbforum_result|a:4:

(and it just goes on)

danscott’s picture

Title: Drupal 7.7 and phpBB 3.09 "Integrity constraing violation » Drupal 7.7 and phpBB 3.09 "Integrity constraint violation"
almirsarajcic’s picture

FileSize
17.37 KB

I've had the same issue. The problem is that I didn't read whole README.txt file :)
Before installing Drupal I had moved phpBB3 forum from other domain. I just had to change domain in phpBB administration -> General -> Server Settings. I didn't have to change $base_url in Drupal, but if you encounter any problems you should uncomment it and change it to the same domain as on phpBB3. If the domain name in phpBB3 is example.com then $base_url should be http://example.com or www.example.com and http://www.example.com.

Shalrath’s picture

I've noticed that this seems to happen as soon as I set "display phpbb" as "In the Drupal page. (Except for ACP)". In frame, or in separate window seem to work fine though.

samgreco’s picture

I am seeing this too. My server settings and base_URL are the same.

Any guidance?

jonathanunai’s picture

The same happens to me, has anybody found a fix for this?

cheers

j0rd’s picture

I have the same problem and I'm not using PHPBB or the related module. Something else is going on here. I think it's some bad code some where.

TT1’s picture

Have the same thing. It only occurs when using the "In the Drupal page. (Except for ACP)" option.

HighHo’s picture

Had the same issue, make sure you clear browser cache and run "Purge the cache" from phpbb, its displayed on the home adm screen. I originally skipped the step as i was expecting it in maintenance . :)

chiappa’s picture

Same error but my problem was that I forgot to delete the install directory...

chiappa’s picture

Same error but my problem was that I forgot to delete the install directory...

fizk’s picture

Status: Active » Closed (fixed)

Please reopen if this is still an issue.

guidolavespa’s picture

I uncomment the $base_url = in the settings.php

and changed it to the my domain as on where phpBB3 is installed.

www.xxxxxxxxxxx.be

Valera Tumash’s picture

Version: 7.x-1.0-alpha1 » 7.x-1.x-dev

If I uncomment $base_url in settings.php - the error will be reproduced again.