Hi
When I try to upgrade from 1.4.7 to 2.0 I get this message when I attempt to log in:

Could not successfully run query: Duplicate column name 'type'

There's no editable with that name in my .../users/index.php template.
Sorry to be a nuisance, but any suggestions?

I'm having the same problem. Googling led me to an older forum post which suggested that this was caused by the update failing and then when trying to re-run some of the fields would already exist and result in this error. The suggested fix was to delete the field. I've tried this but that led to more fields not being found. Trying to find all the fields I need to remove to reset now. Did you ever find an alternate solution?

[KK]

@PMunch,

I'd suggest you please try the following -
edit couch/config.php and find the following setting

/ 7b.
// Needed only if multiple instances of this CMS are to be installed in the same database
// (please use only alphanumeric characters, hyphen or underscore)
define( 'K_DB_TABLES_PREFIX', '' );

Please set it to some arbitrary value e.g. "new_" as follows -

// 7b.
// Needed only if multiple instances of this CMS are to be installed in the same database
// (please use only alphanumeric characters, hyphen or underscore)
define( 'K_DB_TABLES_PREFIX', 'new_' );

Try accessing the admin-folder after this and the installation should start afresh with a new set of tables.

Hope this helps.