Ok… I grabbed 2.0.3-b3, went through the update guide, so I backed up my config file and uploaded the new files, overwriting the old ones.
File integrity check was Ok (no errors that I could notice, filezilla ftp was set to ‘binary’ instead of ‘auto’ to make sure it does upload only in binary).
Clicked update to start updating the database (had v2.0.2 before this) and quickly it came up with this error:
Critical Error during the update process:
XXX/piwik/core/Updates/2.0-b3.php:
Error trying to execute the query 'ALTER TABLE piwik_log_visit ADD COLUMN visit_total_events SMALLINT(5) UNSIGNED NOT NULL AFTER visit_total_searches'.
The error was: SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '129' for key 'PRIMARY'
Looks like an sql error or a php error.