trying to summarize a table

I have an sql line that is failing. 


$sql='INSERT INTO weekly_summary_activities (email,campaign, admin_email, type, year, week, business_comp, project,  activity, hours) SELECT email, campaign, admin_email, type, year, week, business_comp, project, activity, SUM(hours) FROM activity_log GROUP BY email,  campaign,  project, business_comp, activity';
$query=$this->db->query($sql);

weekly_summary_activities has an autoinc field called id. What do I do about that? Of course I don't have the id field in my query. when I run this is phpmyadmin I get:

#1467 - Failed to read auto-increment value from storage engine

proof that an old dog can learn new tricks