SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'rid' cannot be null

I'm experiencing the same problem, only the include_path is a bit different:
(include_path='.:/usr/share/php:/usr/share/pear')

This means that the panopoly_theme module isn't found in your Drupal directory. If you installed OA2 via the -dev version and the build.sh script, then it should be found in sites/all/modules/panopoly/panopoly_theme. If you download the distribution from Drupal.org then you should find it in profiles/openatrium/modules/panopoly/panopoly_theme.

Also, be sure to drop the entire database before trying to reinstall to clear out anything that might be pointing to the old directory. For example, if you first install via the Drupal.org and then download the -dev version and run the build.sh the panopoly files will move but the system table in the database will still point to the old location.

Problem is that drupal.org doesn't support the inherited profile distribution we are using in the -dev version.

OK. I had switched from alpha5 to the dev version without clearing the db so this time I dropped all tables in the database, went through the reinstall, got the AJAX HTTP error with regards to Mailhandler, went to the error page, got redirected to the next step: Site Configuration, Verified Apps installation, on next screen got WSOD and this in the error log: [Mon Jun 17 13:39:49 2013] [error] PHP Fatal error: require_once(): Failed opening required '/panopoly_theme.profile.inc' (include_path='.:/pear/lib:/var/www/pear/lib') in /htdocs/openatrium-7.x-2.x-dev/profiles/openatrium/openatrium.profile on line 17

For some reason drupal_get_path is not finding that module even though I see it located in profiles/openatrium/modules/panopoly/panopoly_theme. Now what?

I hardcoded the path in openatrium.profile this time and WSOD again, at the same installation step, but later in the execution.

[Mon Jun 17 14:04:38 2013] [error] PHP Fatal error: require_once(): Failed opening required '/panopoly_core.profile.inc' (include_path='.:/pear/lib:/var/www/pear/lib') in /htdocs/openatrium-7.x-2.x-dev/profiles/openatrium/modules/features/oa_core/oa_core.profile.inc on line 19

Edited line 19 of oa_core.profile.inc... Installation finished but going to the front page gives WSOD. And I gotta dig more bc there's nothing this time in the error log.

Back at this...

Still can't find an error even though PHP error reporting is E_ALL | E_STRICT. Drupal runs, but not the front page. I tried setting the default theme to Bartik. Then I went to /user and got the admin's user page. There's a message about needing to rebuild content access permissions. I try to run that but the batch doesn't really run. There's no progress bar. If I go to /admin, the admin page shows up, but the theme is messed up.

Some other stuff. On the status report page I'm seeing...

Notice: Undefined index: name in system_requirements() (line 39 of /htdocs/projects/modules/system/system.install).
Notice: Undefined index: version in system_requirements() (line 41 of /htdocs/projects/modules/system/system.install).
The content access permissions need to be rebuilt.

And

"Date iCal iCalcreator library could not be found, check the installation instructions for the Date iCal module.
The error message was: not found
The iCalcreator library could not be found."

Well, I downloaded the iCalcreator library, put it in profiles/openatrium/libraries/iCalcreator, verified that it could be found, and am now wiping the installation and re-installing.

Well, there's progression but not solution. Front page is still WSOD. When I click on /user I get different errors now.

The content access permissions need to be rebuilt. Rebuild permissions.
Notice: Undefined variable: realname in include() (line 19 of /htdocs/projects/profiles/openatrium/modules/openatrium/oa_dashboard/oa_user_badge.tpl.php).
Notice: Undefined variable: picture in include() (line 20 of /htdocs/projects/profiles/openatrium/modules/openatrium/oa_dashboard/oa_user_badge.tpl.php).
Notice: Undefined variable: links in include() (line 24 of /htdocs/projects/profiles/openatrium/modules/openatrium/oa_dashboard/oa_user_badge.tpl.php).
Notice: Undefined variable: links in include() (line 25 of /htdocs/projects/profiles/openatrium/modules/openatrium/oa_dashboard/oa_user_badge.tpl.php).
Notice: Undefined variable: links in include() (line 26 of /htdocs/projects/profiles/openatrium/modules/openatrium/oa_dashboard/oa_user_badge.tpl.php).

I have a random question (although I'm not sure it has anything to do with anything): What PHP version are you using?

5.3.14

I installed Panopoly as a test and everything worked ok.

I tried to do an installation by cloning the git repo and using the build.sh script. I get the AJAX HTTP error related with MailHandler, don't get any errors related to the location of panopoly_theme and panopoly_core (because they are in sites/all/modules instead of the profile directory?), but the front page still doesn't work and all those other errors I see related to rebuilding content permissions and undefined variables are still there. iCalcreator library not downloaded either.

Side note: I noticed that build.sh created a bunch of symlinks to directories outside of the webroot and even to a directory that is non-existant on my system (/opt). I had to delete those and create the actual directories. My Apache runs in a chroot jail. I don't know why the build script would be doing stuff like this rather than keeping the installation self-contained. I also had to comment out the drush verify-makefile line from build.sh because for whatever reason that command is not found even though I have 5.8 installed.

This is the primary culprit somewhere: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'rid' cannot be null

This error is caused by the openatrium profile having a status of 0 in the system table: Notice: Undefined index: name in system_requirements() (line 39 of /htdocs/projects/modules/system/system.install) I suspect that is due to the SQL constraint violation error causing the profile to never be enabled. And probably the reason the path to panopoly_theme was not being found in the profile directory was due to the profile having status 0.

As for the WSOD on the front page, it is due to this error: Notice: Undefined index: theme in panels_renderer_standard->render_layout() (line 396 of /htdocs/projects/sites/all/modules/contrib/panels/plugins/display_renderers/panels_renderer_standard.class.php). Which appears when looking at the Home panel. It cannot find the layout or the layout is bad for some reason. Again, I suspect it goes back to the SQL constraint violation.

The constraint violation occurs in the AJAX HTTP message right after it says it has rebuilt content permissions. The first glaring status report says content permissions need rebuilding yet the batch hangs and cannot be completed.

Just noticing that there are more modules with status 0 in the systems table yet are listed as dependencies in openatrium.info, like og_access.

oa_permissions and a few other modules make reference to administrator and editor roles. Where do these roles get created? I am not finding that. The only roles existing are authenticated user and anonymous user.

New test:
Download the dev release and install on a completely different server.

Old server: OpenBSD 5.2 with Apache 1.3.29, php 5.3.14 in chroot jail
New server: Pretty vanilla CentOS 6.4 64 bit release. Apache 2.2.15, PHP 5.4.16.

Same error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'rid' cannot be null

(and Apps doesn't seem to work with PHP 5.4. Warning: Illegal string offset 'name' in apps_profile_apps_select_form() (line 101 of /var/www/html/oa/profiles/openatrium/modules/contrib/apps/apps.profile.inc).)

Raising to major priority cuz, well, who can install this distribution and on what kind of system? I'm trying to use it for a team project. I'm about to give up and install the Drupal 6 version instead.

I'm able to install on a Debian Squeeze system hosted in Rackspace Cloud (server with 1Gb RAM).

Here are the relavant versions:

Apache - 2.2.16
PHP - 5.3.3
MySQL - 5.1.49

But if you're considering this for a real project right now - I honestly don't think OA 2.0 is ready. Things are changing so fast, and there aren't upgrade paths being created between the -alpha versions, so there is no guaranty that you'll be able to keep your data as new version come out.

However, once the real 2.0 release is made, an upgrade path will be provided from Drupal 6. So, using the Drupal 6 version for now might actually be safer. :-)

I'm not sure how far off the Phase II team sees release, but things should really start to stabilize once there are -beta and -rc releases.

I hope that helps!

i just tried to install locally on my macbook, and get the same "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'rid' cannot be null" error. How did you install it? was it via the dev release? i tried that and it didnt work.

@Sborsody
To get verify-makefile to work you need to put this file http://drupalcode.org/project/drupalorg_drush.git/blob/refs/heads/master... in the .drush folder in your users home directory.

I'm getting the same error:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'rid' cannot be null

during the install. Also the WSOD on front-end pages.

Ubuntu 12.04 /w

Apache 2.2.22
MySQL 5.5.31
PHP 5.3.10

I'm using the dev version and build.sh script.

the same problem for me :(

Same error for me:

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://d7openatrium2.local/install.php?profile=openatrium&locale=en&id=1&op=do StatusText: OK ResponseText: Drupal @import url("http://d7openatrium2.local/profiles/openatrium/openatrium.css?0"); Installation tasksChoose profile(done)Choose language(done)Verify requirements(done)Set up database(done)Install profile(active)Configure siteVerify Apps supportInstall AppsChoose a themeFinished Warning message The image resize filter has been installed. Before this does anything, the image resize filter needs to be added to one or more text formats. Visit the text format administration to set up this filter. You have enabled Mailhandler, but not any modules providing retrieval plugins (such as the Mailhandler PHP IMAP module). Without a retrieval plugin, Mailhandler is basically useless. Status message Now that you've enabled Mailhandler, you need to add a mailbox corresponding to an IMAP/POP3/mbox mailbox. To use menu blocks, find the "Add menu block" link on the administer blocks page. Content permissions have been rebuilt. SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'rid' cannot be null 

When I click on the "the error page" the installation continues and I end in this error

Fatal error: require_once(): Failed opening required '/panopoly_theme.profile.inc' (include_path='.:/Applications/MAMP/bin/php/php5.4.10/lib/php') in /Applications/MAMP/htdocs/Testing/openatrium-7.x/profiles/openatrium/openatrium.profile on line 17

From the apache log I get

[Sat Jun 29 15:45:19 2013] [error] [client 127.0.0.1] File does not exist: /Applications/MAMP/htdocs/Testing/openatrium-7.x/favicon.ico

I changed my MAMP-Settings to PHP 5.3.20 an the installation worked fine.
My environment: MAMP Pro 2.1.4 on OS X 10.8.4 with PHP 5.3.20 with APC, mySQL 5.5.29.

But finally when I visit the site:

The content access permissions need to be rebuilt. Rebuild permissions.
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT ogr.rid AS rid, ogr.name AS name FROM {og_role} ogr WHERE (group_type = :db_condition_placeholder_0) AND (group_bundle = :db_condition_placeholder_1) AND (gid = :db_condition_placeholder_2) ORDER BY rid ASC; Array ( [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => oa_group [:db_condition_placeholder_2] => 0 ) in og_roles() (line 2558 of /Applications/MAMP/htdocs/Testing/openatrium-7.x/profiles/openatrium/modules/contrib/og/og.module).

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/database/database.inc:2168 Stack trace: #0 /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/database/database.inc(2168): PDOStatement->execute(Array) #1 /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/database/database.inc(680): DatabaseStatementBase->execute(Array, Array) #2 /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/database/database.inc(2347): DatabaseConnection->query('SELECT expire, ...', Array, Array) #3 /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/lock.inc(167): db_query('SELECT expire, ...', Array) #4 /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/lock.inc(146): lock_may_be_available('schema:runtime:...') #5 /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/bootstrap.inc(420): lock_acquire('schema:runtime:...') #6 /Applications/MAMP/htdocs/Testing/openatrium-7.x/inc in /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/database/database.inc on line 2168
Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 209 of /Applications/MAMP/htdocs/Testing/openatrium-7.x/includes/session.inc).

See #2008762-1: Panopoly Pages has missing dependencies

Will mark as fixed after confirmation that that is the issue

Applied the patch after the same error with 'rid' column, but I am now getting:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null

Use against the the latest code; had a missing depedency in oa also

(edit: or apply one of the patches in features for that issue)

Built using the make file out of latest git repo and works like a charm, thanks!

xgmorkx any anyone else could you comment on/review the panopoly issue so it can get rtbc?

Ofcourse, I'll have a look at it tonight and see if I can help.

Installed the latest dev (zip-download on drupal.org) but still get these errors.

i got a different error.

Drush command terminated abnormally due to an unrecoverable error. Error: Maximum execution time of 240 seconds exceeded in /var/aegir/platforms/7/servers/openatrium-7.x-2.x-dev/includes/menu.inc, line 347

It's an error during install, and this was an error during install, but other than that, they sound unrelated.

I used the July 5 version of oa that has the patch included
I tried to install using aegir and I got the following:

Trying to get property of non-object panopoly_pages.module:172

DRUPAL_INSTALL_FAILED

PDOException Object ( [message:protected] => SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'rid' cannot be null [string:Exception:private] =>

Has the issue in #16 been addressed. Where are the roles actually created? that might be the overarching issue.

Please make a new issue for aegir. My guess is aegir is not enabling modules in a correct order

I don't think this is related to aegir

guessing here but if you look in oa_permissions.install you'll see this comment:
Grant Panelizer roles that cannot be featurized

It then grants in an oddly verbose way:

$permissions = array(
    'administer panelizer node oa_section content',
    'administer panelizer node oa_section layout',
    'administer panelizer node oa_space content',
    'administer panelizer node oa_space layout',
  );

but if you search the rest of the files in this feature you'll find that it's still exporting and attempting to import these via featurization methods. There are certain ways permissions are created / delegated in D7 that the module listed as owning a permissions doesn't match what's exported. In this instance, you need to manually produce the permission and NOT export it via features. I found this solution just yesterday when I had this nagging issue in the distros I manage (bc of permissions allocated dynamically by https://drupal.org/project/regions).

Try removing these exported permissions from the feature and leave them in the install routine and I'm hoping this will work.

It's running fine via install.php now, so it does some specific to however aegier installs it. there's now a new issue for that

I haven't actually tested this in this particular case, but I just wanted to point out that install.php will run to completion even if errors occur during installation. However, Aegir will refuse to move forward if there are any errors at all! This difference has come up many times as I've been testing OpenAtrium 2.0, because I also use Aegir.

Don´t know if these problems are related, but in my case (Installation fails with "Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]") was 1 number in the mySQL-Config !!!

To fix it, change the max_allowed_packet value in your my.cnf file (that's your MySQL configuration file) to 20:

max_allowed_packet = 20M

- See more at: http://chrisshattuck.com/blog/drupal-7-dealing-additional-uncaught-excep...

Same issue here. I have installed and enabled all the modules of Open Atrium on existing drupal 7.22. I was able to enable all the modules but not "Open Atrium Permissions". I am using Barracuda Aegir hosting environment.

Same problem here.

I have related problem too, this is the output after a fresh install:

Notice: Undefined property: SearchApiServer::$status in _entity_defaults_rebuild() (line 831 of /var/www/openatrium-7.x-2.0-beta3/profiles/openatrium/modules/contrib/entity/entity.module).
Notice: Undefined property: SearchApiServer::$status in _entity_defaults_rebuild() (line 831 of /var/www/openatrium-7.x-2.0-beta3/profiles/openatrium/modules/contrib/entity/entity.module).
Notice: Trying to get property of non-object in SearchApiDbService->postUpdate() (line 76 of /var/www/openatrium-7.x-2.0-beta3/profiles/openatrium/modules/contrib/search_api_db/service.inc).
Notice: Trying to get property of non-object in search_api_search_api_server_update() (line 435 of /var/www/openatrium-7.x-2.0-beta3/profiles/openatrium/modules/contrib/search_api/search_api.module).
Notice: Undefined property: SearchApiIndex::$status in _entity_defaults_rebuild() (line 831 of /var/www/openatrium-7.x-2.0-beta3/profiles/openatrium/modules/contrib/entity/entity.module).
Notice: Undefined property: SearchApiIndex::$status in _entity_defaults_rebuild() (line 831 of /var/www/openatrium-7.x-2.0-beta3/profiles/openatrium/modules/contrib/entity/entity.module).

Warning message

The following views were using the index Database Node Index: panopoly_database_search. You should disable or delete them.
The following views were using the index Solr Node Index: panopoly_search. You should disable or delete them.

Congratulations, you installed Open Atrium 2!