[development] Drupal 7 fails to install on PostgreSQL

[Randy Fay]

Hi Thom -

The proper place for this is not in either mailing list - it's in the issue
queue <http://drupal.org/project/issues/drupal>. You'll find a number of
"installation fails" issues, and you should find the one that matches, or
create a new one. And you should read the ones that are there to get clues
about what the problem might be Many people are very anxious to make
installs as good as they can be, so please work with them in the queue. You
can become one of them, helping to resolve this problem.

If you create a new issue <http://drupal.org/node/add/project-issue/drupal>,
(or if you just chime in on an existing one) please make sure to give
complete information, as it suggests there, so somebody can understand and
repeat exactly what you've done.

You should mention, for example, whether this is a new install or an
upgrade, whether you dropped the database and recreated it before
installing, and whether you have any non-core modules installed (I hope
not).

-Randy

On Sun, Feb 13, 2011 at 4:37 AM, Thom Brown <thom at linux.com> wrote:

> On 11 February 2011 14:15, Thom Brown <thom at linux.com> wrote:
> > Hi,
> >
> > I've tried to install Drupal 7 on 2 separate systems using a
> > PostgreSQL 9.0 database backend, and both times it has failed at the
> > same point.  The error message in the PostgreSQL logs both times is:
> >
> > ERROR:  null value in column "rid" violates not-null constraint
> > STATEMENT:  INSERT INTO role_permission (rid, permission, module)
> > VALUES (NULL, 'administer blocks', 'block')
> >
> > I followed the instructions in INSTALL.pgsql.txt, and everything else
> > installs up to this point.
> >
> > The actual error message returned on the installation page is:
> >
> > An AJAX HTTP error occurred.
> > HTTP Result Code: 200
> > Debugging information follows.
> > Path:
> http://bison:8089/install.php?profile=standard&locale=en&id=1&op=do
> > StatusText: OK
> > ResponseText:
> > Home | Drupal
> > @import url("http://bison:8089/modules/system/system.theme.css?0");
> > @import url("http://bison:8089/modules/system/system.messages.css?0");
> > @import url("http://bison:8089/modules/system/system.menus.css?0");
> > @import url("http://bison:8089/modules/system/system.base.css?0");
> > @import url("http://bison:8089/modules/comment/comment.css?0");
> > @import url("http://bison:8089/modules/field/theme/field.css?0");
> > @import url("http://bison:8089/modules/node/node.css?0");
> > @import url("http://bison:8089/modules/search/search.css?0");
> > @import url("http://bison:8089/modules/user/user.css?0");
> > @import url("http://bison:8089/modules/system/system.admin.css?0");
> > @import url("http://bison:8089/modules/system/system.maintenance.css?0
> ");
> > @import url("http://bison:8089/themes/seven/reset.css?0");
> > @import url("http://bison:8089/themes/seven/style.css?0");
> > Home
> > Installation tasksChoose profile(done)Choose language(done)Verify
> > requirements(done)Set up database(done)Install
> > profile(active)Configure siteFinished
> > SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current
> > transaction is aborted, commands ignored until end of transaction
> > block
> >
> > Is this a bug?
>
> Forwarding to development list as no response on support list.
>
> --
> Thom Brown
> Twitter: @darkixion
> IRC (freenode): dark_ixion
> Registered Linux user: #516935
>



-- 
Randy Fay
Drupal Module and Site Development
randy at randyfay.com
+1  970.462.7450
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20110213/99aa0fc3/attachment.html