Testing server : Windows XP, SP 2, Apache 2.0.59, PHP 5.1.4, MySQL 5.0.

I installed the beta 2 version from scratch. I did NOT update from any version. I did not import a database definition. I used an empty database.

I have version 5 beta 1 and version 4.7.4 working perfectly in different directories in the same htdocs root, same computer. This problem only concerns beta 2, as far as I can tell.

When I install I get this page of warnings although the installation is said to be succesful :

   Warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (module,delta,theme,status) VALUES('user', 0, 'garland', 1) in F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc on line 167

    Warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (module,delta,theme,status) VALUES('user', 1, 'garland', 1) in F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc on line 167

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\bootstrap.inc on line 735

    Warning: Cannot modify header information - headers already sent by (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\bootstrap.inc on line 413

    Warning: Cannot modify header information - headers already sent by (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\bootstrap.inc on line 414

    Warning: Cannot modify header information - headers already sent by (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\bootstrap.inc on line 415

    Warning: Cannot modify header information - headers already sent by (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\bootstrap.inc on line 416

    Warning: Cannot modify header information - headers already sent by (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\bootstrap.inc on line 417
    Drupal installation complete

    * warning: Cannot modify header information - headers already sent by (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\common.inc on line 141.
    * warning: Cannot modify header information - headers already sent by (output started at F:\htdocs\drupal-5.0-beta2\includes\database.mysql.inc:167) in F:\htdocs\drupal-5.0-beta2\includes\common.inc on line 141.

    Congratulations, Drupal has been successfully installed.

    Please review the messages above before continuing on to your new site.

After successfully creating an admin account, I experience this other bug when trying to add content : http://drupal.org/node/100850

CommentFileSizeAuthor
#2 mysql-strict-pages_0.patch984 byteswebchick
#1 mysql-strict-pages.patch984 byteswebchick
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
CreditAttribution: webchick commented
Status: Active » Needs review
FileSize
mysql-strict-pages.patch984 bytes

I think this should do it. Could you try creating a new Drupal installation with this patch?

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
CreditAttribution: webchick commented
FileSize
mysql-strict-pages_0.patch984 bytes

Here's one without a typo which should work a little better. ;)

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
CreditAttribution: webchick commented

Btw, for anyone who might come across this and reasonably wonder, "Why don't we fix this at the source by adding a default value to the pages column?" it turns out that MySQL doesn't allow default values for "text" type. See also http://drupal.org/node/100850 for some discussion about node module's log field.

Chill35’s picture

Chill35 CreditAttribution: Chill35 commented
Status: Needs review » Reviewed & tested by the community

You rock, perfectionist webchick !

I added the patch and reinstalled Drupal beta 2 with it. This time, I had no warning messages.

I changed the status to RTBC, please change it back if you feel it needs more reviewing.

Bonne journée!

neil.h’s picture

neil.h CreditAttribution: neil.h commented

Creating content will give u this....

user warning: Field 'log' doesn't have a default value query: INSERT INTO node_revisions (nid, vid, title, body,

teaser, timestamp, uid, format) VALUES (1, 1, 'testing 5.0 test page', 'testing on page5', 'testing on page5',

1165345432, 1, 1) in D:\eclipse\workspace\drupal_5\includes\database.mysql.inc on line 167.

Issue is we are trying to insert a record and not supplying info for field: log // Table: node_revisions

u will need to change the create table to reflect such // system.install - for mysyl

db_query("CREATE TABLE {node_revisions} (
nid int unsigned NOT NULL '0', // null was not set
vid int unsigned NOT NULL '0', // null was not set
uid int NOT NULL default '0',
title varchar(128) NOT NULL default '',
body longtext NOT NULL,
teaser longtext NOT NULL,
log longtext, // REMOVE: NOT NULL,
timestamp int NOT NULL default '0',
format int NOT NULL default '0',
PRIMARY KEY (vid),
KEY nid (nid),
KEY uid (uid)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");

how will this impact the log??

from node.module
*********************

/**
* Implementation of hook_form().
*/
function node_content_form($node) {
$type = node_get_types('type', $node);
$form = array();

if ($type->has_title) {
$form['title'] = array(
'#type' => 'textfield',
'#title' => check_plain($type->title_label),
'#required' => TRUE,
'#default_value' => $node->title,
'#weight' => -5,
);
}

if ($type->has_body) {
$form['body_filter']['body'] = array(
'#type' => 'textarea',
'#title' => check_plain($type->body_label),
'#default_value' => $node->body,
'#rows' => 20,
'#required' => TRUE);
$form['body_filter']['format'] = filter_form($node->format);
}

// START PATCH ********************
$form['log'] = array(
'#type' => 'textarea',
'#title' => t('Log message'),
'#weight' => 5,
'#description' => t('An explanation of the additions or updates being made to help other authors understand your motivations.')
);
// END PATCH ********************

return $form;
}

cheers,
neil.h

Chill35’s picture

Chill35 CreditAttribution: Chill35 commented

neil,

I think there's a patch for that problem : http://drupal.org/node/100850

I too had that problem.

What do you think ? Have you tried that other patch ?

Let me know.

neil.h’s picture

neil.h CreditAttribution: neil.h commented

thanks for bring this to my attn,

works much better..

and was able to change the create table {node_revisions} back to [ log longtext NOT NULL, ]

works ok,

adding content without ne problems..

cheers,
neil

Dries’s picture

Dries CreditAttribution: Dries commented
Status: Reviewed & tested by the community » Fixed

Committed to CVS HEAD. Thanks.

Anonymous’s picture

(not verified) CreditAttribution: commented
Status: Fixed » Closed (fixed)