Hi,
if you check you database via path admin/build/schema/compare, you get the following warning:
"profile_privacy_fields.fid is part of the primary key but is not specified to be 'not null'."
(see attached screenshot as well)
As you can see, attribute 'not null' => TRUE is missing for fid in schema definition:
<?php
function profile_privacy_schema() {
$schema['profile_privacy_fields'] = array(
'fields' => array(
'fid' => array(
'type' => 'int',
'unsigned' => TRUE,
'default' => 0
),
'privacy' => array(
'type' => 'int',
'size' => 'tiny',
'not null' => TRUE,
'default' => 0
)
),
'primary key' => array('fid')
);
?>
Comments
Comment #1
not_Dries_Buytaert commentedSame here (running: schema-6.x-1.7: http://drupal.org/project/schema). The code quoted in the startpost is from the file 'profile_privacy.install'.
Comment #2
cor3huis commentedAdded
Comment #3
cpliakas commentedGreat work discovering this. Marking as "needs work" because a change like this requires an update hook in order to modify the schema. Also, the profile_privacy_values table could use a NOT NULL declaration as well.
Comment #4
cpliakas commentedLooks like the patch posted in #2 is already in the 6.x-1.x branch. The attached patch was committed to the downstream project at #1268256: Schema definition inconsistency.
Comment #5
cpliakas commentedMoving to 6.x-2.x branch. Committed at 44e798c.