Just working on a profile reporting idea and spotted that the following fields appear to have incorrect type definitions:
profile_values.fid = int(11)
profile_values.uid = int(11)

These both appear inconsistant with the rest of the database (that I have seen i.e. user tables) where they are defined as int(10). The profile_fields.fid is defined as int(10) also.

CommentFileSizeAuthor
#1 05_dbprofile.patch582 bytesMorbus Iff
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Morbus Iff’s picture

Component: profile.module » database system
Assigned: Unassigned » Morbus Iff
FileSize
582 bytes

Confirmed and patched.

Morbus Iff’s picture

Title: Database » MySQL profile_values definition doesn't match established integer length.
Dries’s picture

Committed to HEAD. Thanks.

dors’s picture

Shouldn't this also be honored in drupal/database/updates.inc?

Morbus Iff’s picture

My feeling is that the "bug" is a matter of standardization -- NOT fixing it has no ill effect on anything whatsoever. If the consensus is that this SHOULD be in updates.inc, then I'll gen a patch for it.

Anonymous’s picture