id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,difficulty
1562,Add default value for entities.last_action,kkawahara,,"trying to setup a new 1.7RC1 installation.  After filling out system settings and clicking next, the following error appears:

Field 'last_action' doesn't have a default value

QUERY: INSERT into elgg_entities
(type, subtype, owner_guid, site_guid, container_guid, access_id, time_created, time_updated) values
('site',0, 0, 0, 0, 2, 1267356443, 1267356443) 

Checking the SQL create script (mysql.sql) shows this table with an additional column (last_action) and it does not have a default value assigned.

The update SQL in the entity class does not include this column:
(from entities.sql)
return insert_data(""insert into {$CONFIG->dbprefix}entity_subtypes (type, subtype, class) values ('$type','$subtype','$class')"");



Upgrading from a 1.6.1 installation seems to work fine.",Defect,closed,normal,Elgg 1.7,Core,1.7,minor,fixed,,brettp,