activity.install has 3 update functions defined the last of which is activity_update_3()

function activity_update_3() {
  $ret = array();
  $ret[] = update_sql("ALTER TABLE {activity} ADD COLUMN scope int(11) AFTER timestamp");
  return $ret;
}

There are no references in the code to SQL that refers to the 'scope' column so I can't be sure if this is a needed column.

- If it is needed then the activity_install() function needs to be updated
- There is no column 'timestamp' so attempting to add the column after the 'timestamp' column will fail
- The update function to add the column in PostgreSQL will require different syntax

If this column does need to be added, I can patch up activity.install to fix this.

Comments

sirkitree’s picture

sirkitree commented

mmm, thanks for catching this. scope as been replaced with the activity_target table so it is not needed. This was probably just missed when robert added the activity_target piece.

jaydub’s picture

jaydub commented
Status: Active » Fixed

removed the update. not sure but possibly may want to make next
update be #4 for consistency sake.

Anonymous’s picture

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

Automatically closed -- issue fixed for two weeks with no activity.