When updating to 6.x-10-beta2 running on Drupal 6.6 on PostgreSQL 8.3 the following query could not be executed.
ALTER TABLE {activitystream_accounts} CHANGE COLUMN `lastfetch` `lastfecth` timestamp NOT NULL default 0

I looked and it seems that the correct PGSQL syntax for this query should be
ALTER TABLE {activitystream_accounts} ALTER COLUMN lastfetch SET DEFAULT 'epoch'

I do have more failed query when using the module but I don't know if it is because a bad earlier installation (I first installed a customized 6.x-1.x-dev before switching to 6.x-10-beta2). I may report more failed query once I re-installed it.

Comments

eojthebrave’s picture

eojthebrave
he/him
Primary language English
Location Minneapolis, MN
commented

I don't know anything about PostgreSQL, but if someone could confirm the syntax needed to modify the lastfetch column I would be happy to roll a patch for it.

akalsey’s picture

akalsey commented
Status: Active » Closed (fixed)

The usage of the schema system for installation in D6 should take care of this issue now.