Field 'lastfetch' doesn't have a default value

What database server are you using. What's the version of that server?

I can't think of any reason that lastfetch actually needs a default value, but this might be a requirement of your DB server.

I'm using MySQL 5.0.67-community-nt . I actually did a fresh install yesterday of MySQL, php-5.2.5-win32, and drupal-6.5. The table is setup as follows.

mysql> show columns from activitystream_accounts;
+-----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| uid | int(10) unsigned | NO | | 0 | |
| module | varchar(255) | YES | | NULL | |
| userid | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| feed | varchar(255) | YES | | NULL | |
| lastfetch | datetime | NO | | NULL | |
+-----------+------------------+------+-----+---------+-------+
6 rows in set (0.03 sec)

Run this database command and tell me if it solves the problem...

ALTER TABLE activitystream_accounts CHANGE COLUMN `lastfetch` `lastfecth` timestamp NOT NULL default 0;

If you're using database table prefixes, you'll need to change the table name in that query to include the prefix.

Fixed in Beta 2. You'll need to uninstall the module (using the uninstall tab on the modules page) and install Beta 2 from scratch.

Excellent. Beta 2 is working great. Thanks

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