Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. Error upgrading database: Duplicate column name 'hit_action'(Errno=1060)

Error upgrading database: Duplicate column name 'hit_action'(Errno=1060)

1 Apr 29, 2014 16:23    

While upgrading from v.4.1.4 to 5.0.8 my internet connection broke down, and I restarted the upgrading after it came back. Now at Upgrading hitlog table I'm always getting to

MySQL error!

Duplicate column name 'hit_action'(Errno=1060)

Your query:

ALTER TABLE evo_hitlog

CHANGE COLUMN hit_referer_type hit_referer_type ENUM( 'search', 'special', 'spam', 'referer', 'direct', 'self', 'admin', 'blacklist' ) NOT NULL,

ADD COLUMN hit_type ENUM('standard','rss','admin','ajax', 'service') DEFAULT 'standard' NOT NULL AFTER hit_ctrl,

ADD COLUMN hit_action VARCHAR(30) DEFAULT NULL AFTER hit_ctrl

how can I fix that? Would emptying that table do the trick? I's quite big with 773 KB, I think.

Back to top

2 Apr 29, 2014 22:29

Hello @koratcat,

Did you make a backup of your 4.1.4? If affirmative, please restore your site and start the upgrade process all over again. Making a clean upgrade is always the easiest way.

Regards!

Back to top

3 Apr 30, 2014 03:18

Of what use could restoring the system files to an earlier state be in fixing an error in the database?

Luckily I have also a backup of the 448 MB database. To move a backup file of that size, if it is in perfect condition, what I don't know, isn't anybody's dream. Looking for a way to fix the present database has preference to restoring it with a backup I can only hope to be in working condition has preference for me.

Back to top


Form is loading...