[trendoman]

Try to install from zero. Steps can be found in documentation, miscellaneous: migration to a new server.
1. Generate dump
2. Install new couch with dump
3. Copy all website files.

Let me know if it works.

[KK]

For what it's worth, I had this same issue. I was able to fix it by going to the couch_settings table and manually changing k_couch_version to the version I was updating to.

This would be a completely wrong thing to do and everyone would be strongly advised against doing so - reason being that by manually fudging the version number you'll deceive Couch into thinking that the upgrade is not required and thus make it skip all the necessary changes to the database (which is what seems to be happening with @divian - the columns and tables that would normally be available in a particular version would not be found).

As for the duplicate column error, this has been reported only in a very minuscule number of sites (I've yet to pin-point the exact cause of this). The resolution, unfortunately, would be to manually remove the reported duplicate column from the database.

If someone runs into this issue, and finds it difficult to resolve the issue by yourself, please feel free to PM me your site's access creds (phpMyAdmin included, if possible) and I'll be only happy to do this for you.

Thanks got it working.

A small guide for people struggling towards an upgrade as I think it might come in handy...
Be sure to read through at least once before doing anything!

ALWAYS BE CERTAIN TO CREATE A BACKUP OF YOUR SITE DATA AND DATABASE!!!

moving on...
The easiest way seemed like a mixture of a new install and an upgrade:
0. just in case: CREATE A BACKUP OF SITE AND DATABASE.
1. Log into your current couch admin panel and run "gen_dump.php" from your old release (eg. http://www.mytestsite.com/couch/gen_dump.php) and download the generated file "install_ex.php". more info here
1. download the newest release from couch here
2. rename the couch folder (the latest release you just downloaded) to something like "couch_upgrade"
3. insert "install_ex.php" from step 1 into the folder "couch_upgrade".
4. ftp the folder "couch_upgrade" to the hosting server (next to the current "couch" install folder). As a reminder: The exact name may vary depending if you renamed this.
5. Once all is uploaded, copy the folders: "snippets" and "uploads" and the files: "config.php" and "favicon.ico" from the original and current folder "couch" to the "couch_upgrade" folder. (replace all if asked).
6. rename the current folder "couch" to "couch_old" (tip: You can use the version number as a suffix to keep track if needed for a rollback).
7. rename the "couch_upgrade folder" to "couch" (or whatever name the original folder was).
8. Be sure the "index.php" is renamed as well in case this was called different as a safety measure. (You can double check in the config.php file if needed).

Code: Select all

 // 1b.
    // For security purpose, the 'index.php' file of Couch can be renamed to anything else.
    // If you do so, uncomment the following line and enter the new name.
    define( 'K_ADMIN_PAGE', 'newIndexName.php' );

9. Access the admin section through your browser - http://www.mytestsite.com/couch/
10. Install couch (info here) and a new version will be installed with your old data in the database. CAUTION: It might be you have to delete everything from the database before the new data is added. HOWEVER I advise to create a new clean database with the necessary logindata and alter the config.php towards the new credentials. Doing this, you will be certain you have a fallback towards your old data if you want to change between versions.

Hope it helps, as it seemed the only way for me to get things up and running correctly going from v1.4 towards v1.4.7.


Thanks to KK and trendoman...