Hi,
I'm trying to upgrade from limesurvey 2.0.6 with mysql 5.1 to limesurvey 2.5+ with mariadb-server-5.5.44-2.el7.centos.x86_64
The upgrade failed with error :
CDbCommand n'a pas pu exécuter la commande SQL : SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'ico'
In my database, the lime_boxes table contains :
DROP TABLE IF EXISTS `lime_boxes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lime_boxes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`position` int(11) DEFAULT NULL,
`url` text COLLATE utf8_unicode_ci,
`title` text COLLATE utf8_unicode_ci,
`img` text COLLATE utf8_unicode_ci,
`desc` text COLLATE utf8_unicode_ci,
`page` text COLLATE utf8_unicode_ci,
`ico` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;