Hi,

I just updated Couch from 1.4RC1 to the new 1.4.5 version. I followed the update instructions, but after the upload was finished I get this error when I go to the admin panel and the main site as well in the browser:

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

Do you have any idea what this might be? It is pretty urgent as my website currently isn't being displayed. URL is http://sistestopp.com/

I really really hope the database is still intact

I went back to version 1.4RC1 and it seems to be working well again.

I would have liked to update though as the new feature that ask if you want to leave the page without saving is great

[KK]

Hi,

What you are seeing is an unexpected result.
I tested once again after your report and the transition from 1.4RC1 to 1.4.5 goes without a hitch.

Perhaps not all files were overwritten during the upgrade?
I'd request to please take a database backup (gen_dump will also do) and then try once again by overwriting all existing files with 1.4.5.

In case you get this error again, please PM me your site's FTP+Couch creds and I'll take a look into this myself.

Thanks.

Hi thanks KK.

I have tried to delete all the couch files from the server (except for the uploads and snippets folders, and the config.php file), and reupload all the 1.4.5 couch files, but the same error happens. In phpMyAdmin I can see creation_ip just once. I have messaged you my ftp details.

Another problem I have now is that all richtext editors comes up as just a white box and I am unable to write anything. Screenshot here: http://gyazo.com/9a9a453efdecc97d83c88e2164d3b7ea

Have you had this problem before?

[KK]

Thanks for the creds.
I had to delete the 'duplicate' column manually from the database and now 1.4.5 is installed.

As for the richtext problem, I couldn't see that in my browser. The editors are showing fine.
Please hard refresh your browser and it should help.

Thanks KK, whatever you did fixed the problems so thanks a lot.

I think we will buy a licence now because support is really really good

I was updating to 1.4.5 on a local machine and ran into the same issue, except the duplicate column was 'searchable'. I found the column in the MYSQL table, deleted it (there was only one indicated), and the problem was corrected.

Could there be something about v1.4.5, or is this just a random glitch?

[KK]

@tim, the problem, it appears, is that if the installation fails for some reason the DDL queries (e.g. those creating new fields) cannot be rolled back - this is normal behavior for MySQL.

So when one tries to install once again, the install routine finds the existing fields and stops.

This is not a 1.4.5 specific thing but I think I need to put some more checks to handle this situation gracefully.

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.

@KK's note: This solution is not recommended under any condition!

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.

I had the same issues going from 1.4 to 1.4.7.

After changing this in the database itself it seemed ok at first, but after submitting new content I get from within the cms (after saving):

Code: Select all

Could not successfully run query: Unknown column 'creation_IP' in 'field list'

When altering new content via the cms it saves but I still get false results when going deeper into my site. When I click on a product view, I seem to get the following error now:

Code: Select all

Could not successfully run query: Unknown column 'searchable' in 'field list'

It really seems a pain to update couch (I followed the upgrade descriptions that came with the package)... I've retried a couple of times while reuploading the backups once again. Anyone some proper advice?