1. Home
  2. Community
  3. Installation and Upgrade
  4. The MySQL database server has returned 1060: Duplicate column name 'newsfile_status' while executing

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

The MySQL database server has returned 1060: Duplicate column name 'newsfile_status' while executing

Installation and Upgrade 27 This topic was started by ,


avatar
cosmin 269
From: -
When upgrading from 2.1.16 to 2.1.17.
I have to say I am really disappointed in the way this application has been going...

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: The MySQL database server has returned 1060: Duplicate column name 'newsfile_status' while executing
avatar
Administrator
1340
From: Vienna, Austria
Look like your news table has been already modified. Did you refresh or clicking next during upgrade? You should leave the upgrade script alone and clicking only the next button if the installer hangs for some reason.

There are five database alterations in CT 2.1.17:
/cadmin/content/sql_mysql_upgrade_contentfiles.php
/cadmin/news/sql_mysql_upgrade_newsfiles.php
/cadmin/articles/sql_mysql_upgrade_articlesfiles.php
/cadmin/files/sql_mysql_upgrade_filesfiles.php
/cadmin/knowledgebase/sql_mysql_upgrade_knowledgebasefiles.php

In your case just remove both /cadmin/content/sql_mysql_upgrade_contentfiles.php and /cadmin/news/sql_mysql_upgrade_newsfiles.php. Then run the upgrade script again but don't refresh Winking Face

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.