The setup:
Drupal 6.0, Postgresql 8.1.11, php-5.2.5. Fresh install (no upgrade), no modules or themes, just one role and one user, next to USER1.
The problem: after creating a book page and editing this, an sql error is issued and no more content can be added at all. SQL errors are show below.
Steps to reproduce:
After installation create a new role (and a user afterwards) with following permissions:
Book Modules
Node module:
access content
create book content
delete own book content
edit own book content
revert revisions
view revisions
Path module:
create url aliases
Log in as user, create a book page, outline does not matter (wether new book or none), and save.
Logout
Login again
Edit Test page, try to save it, enjoy the error:
Page not found
• warning: pg_query() [function.pg-query]: Query failed: FEHLER: NULL-Wert in Spalte »log« verletzt Not-Null-Constraint in /home/www/cms/includes/database.pgsql.inc on line 138.
• user warning: query: INSERT INTO node_revisions (nid, uid, title, body, teaser, timestamp, format) VALUES (1, 3, 'First Test Page', 'Some test text. And now edited', 'Some test text. And now edited', 1203429965, 1) in /home/www/cms/includes/common.inc on line 3314.
Book page First Test Page has been updated.
The requested page could not be found.
I do not know how to tell drupal to report errors in english, especially as there is no german translation avaiable for 6.0, but I will try to translate:
Query failed, ERROR: Zero-Value in column "log" violates Not-Zero constraint in /home/www....
Now, for some more fun. Trying to create another, completely new and not related book produces following error upon saving:
Create Book page
• warning: pg_query() [function.pg-query]: Query failed: FEHLER: duplizierter Schlüssel verletzt Unique-Constraint »node_vid_key« in /home/www/cms/includes/database.pgsql.inc on line 138.
• user warning: query: INSERT INTO node (vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) VALUES (0, 'book', '', '2nd Book', 3, 1, 1203430226, 1203430226, 0, 0, 0, 0, 0, 0) in /home/www/cms/includes/common.inc on line 3314.
• The post could not be saved.
Book page 2nd Book has been created.
Which, translated, reads something like: Query failed: ERROR: duplicated Key violates Unique-Constraint "node_vid_key"
But, of course, we are not done here and we log in an USER1 again
First of all, our first book (the first sql error) is still listed below the "book navigation" menu. However, trying to access this produces just a "page not found" site.
Going on to administer -> content management -> content for removing this site, after confirmation for deleting the site, the title is still present. And you can delete again and again, but it won’t go away.
So the system is basically completely fubar, as you cannot remove the rogue site and cannot create any new, too. Did not happen with drupal5 (so far).
I will gladly reconfigure drupal to report english messages, if told how to or attach an sql dump, if helpful.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
A lot of work went into psql for D7 in the past 24 months.
This has for sure been resolved in Drupal core 7.94, book tests are all passing green now. All tests green, have a look here:
PHP 8.2 & pgsql-13.5 2,110 pass tested on commit →
Please upgrade your core to Drupal core 7.94.