When creating a simple note type with an Adress field, i got an SQL error on the 'zip' field ADD COLUMN query (sorry, i did not copy it), resulting in the {content_type_<node-type-name>} table to not have a 'field_<cck-address-field-name>_zip' field.

The solution is to modify line 193 in cck_address.module (function cck_address_field_settings):

        'zip' => array('type' => 'varchar', 'length' => 15, 'not null' => TRUE, 'default' => "''", 'sortable' => TRUE),

(added : 'length' => 15,).

Comments

rconstantine’s picture

rconstantine commented
Assigned: Unassigned » rconstantine
Status: Needs review » Fixed

You're right. Not sure how I missed that. I've uploaded the change. Look for another dev release once cron runs.

You'll notice in the install file, update 2, I did add length 15 to zip, but that's only for existing installs. Your patch is for new installs.

Thanks.

Anonymous’s picture

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