Updating errors from 6.x-1.0 [#1835122]

I tried updating first to 6.x-1.2 and then to 6.x-2.1 and both created errors in the database. I updated 3 other modules at the same time and they updated just fine, but when I updated Zen, I got these error messages:

• user warning: Duplicate key name 'comment_count' query: ALTER TABLE node_comment_statistics ADD INDEX comment_count (comment_count) in /home/xxxx/xxxx/includes/database.mysql-common.inc on line 443.

• user warning: Duplicate key name 'comment_uid' query: ALTER TABLE comments ADD INDEX comment_uid (uid) in /home/xxxx/xxxx/includes/database.mysql-common.inc on line 443.

• user warning: Duplicate key name 'last_comment_uid' query: ALTER TABLE node_comment_statistics ADD INDEX last_comment_uid (last_comment_uid) in /home/xxxx/xxxx/includes/database.mysql-common.inc on line 443.

• user warning: Can't DROP 'view_php'; check that column/key exists query: ALTER TABLE views_view DROP view_php in /home/xxxx/xxxx/includes/database.mysql-common.inc on line 331.

• user warning: Can't DROP 'is_cacheable'; check that column/key exists query: ALTER TABLE views_view DROP is_cacheable in /home/xxxx/xxxx/includes/database.mysql-common.inc on line 331.

• user warning: Duplicate column name 'core' query: ALTER TABLE views_view ADD `core` INT DEFAULT 0 in /home/xxxx/xxxx/includes/database.mysql-common.inc on line 307.

When I restored the database, I received no errors on update, but Zen still says it's using version 6.x-1.0.

Comments

Comment #1

JoyceD commented 9 November 2012 at 05:47

No one has responded. I tried updating just to the security release 6.x-1.1, but still got the same error messages. I'm not using drush; I'm just using ftp and expanding on the server outside the root and then moving it to where the old zen directory used to be. I looked at the database.mysql-common.inc but I didn't see anything there I could edit.

I suppose I need to edit the actual database? I'd need directions about how to do that.

I appreciate any help I can get.