Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

1.5.4 to 1.6.3 update error " Error 1060: Duplicate column name 'name'

0 votes
8,041 views
asked Aug 20, 2014 in Q2A Core by loveQA

please help. I'm getting such an error during update:

The current version: 1.5.4

Error:

Running query: LOCK TABLES qa_users WRITE, qa_userlogins WRITE, qa_userprofile WRITE, qa_userfields WRITE, qa_messages WRITE, qa_userfavorites WRITE, qa_usernotices WRITE, qa_userevents WRITE, qa_sharedevents WRITE, qa_cookies WRITE, qa_categories WRITE, qa_pages WRITE, qa_widgets WRITE, qa_posts WRITE, qa_blobs WRITE, qa_words WRITE, qa_titlewords WRITE, qa_contentwords WRITE, qa_tagwords WRITE, qa_posttags WRITE, qa_uservotes WRITE, qa_userpoints WRITE, qa_userlimits WRITE, qa_iplimits WRITE, qa_options WRITE, qa_cache WRITE, qa_usermetas WRITE, qa_postmetas WRITE, qa_categorymetas WRITE, qa_tagmetas WRITE ...

7 upgrade step/s remaining...

Skipping upgrading messages table since it was already upgraded by another Q2A site sharing it.

6 upgrade step/s remaining...

Running query: ALTER TABLE qa_users CHANGE COLUMN flags flags SMALLINT UNSIGNED NOT NULL DEFAULT 0 ...

Running query: LOCK TABLES qa_users WRITE, qa_userlogins WRITE, qa_userprofile WRITE, qa_userfields WRITE, qa_messages WRITE, qa_userfavorites WRITE, qa_usernotices WRITE, qa_userevents WRITE, qa_sharedevents WRITE, qa_cookies WRITE, qa_categories WRITE, qa_pages WRITE, qa_widgets WRITE, qa_posts WRITE, qa_blobs WRITE, qa_words WRITE, qa_titlewords WRITE, qa_contentwords WRITE, qa_tagwords WRITE, qa_posttags WRITE, qa_uservotes WRITE, qa_userpoints WRITE, qa_userlimits WRITE, qa_iplimits WRITE, qa_options WRITE, qa_cache WRITE, qa_usermetas WRITE, qa_postmetas WRITE, qa_categorymetas WRITE, qa_tagmetas WRITE ...

5 upgrade step/s remaining...

Running query: ALTER TABLE qa_posts ADD COLUMN name VARCHAR(40) AFTER tags ...

Question2Answer was unable to perform the installation query below. Please check the user in the config file has CREATE and ALTER permissions:

ALTER TABLE qa_posts ADD COLUMN name VARCHAR(40) AFTER tags

Error 1060: Duplicate column name 'name'

 

 

commented Aug 20, 2014 by pupi1985
"Skipping upgrading messages table since it was already upgraded by another Q2A site sharing it. " => Is that part of the log?? What does it mean?

1 Answer

0 votes
answered Aug 20, 2014 by sama55

This is my imagination, and there are no grounds in particular. But, because there are no problem in my upgrade test, I think it is caused by some addon(e.g. theme, plugin) or interruption of upgrading. I think addon is the most doubtful.

Is there addon (theme, plugin, etc) that adds "name" field to "qa_posts" table?

If my reasoning is right, coping may be difficult a litle. This is because the same name field may be used for the different purpose.

...