Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Migration from limesurvey 2.0.6 (mysql5.1) to limesurvey 2.5 (mariadb5.5) failed

  • gabriel01
  • gabriel01's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 8 months ago #138351 by gabriel01
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 */;


Regards,
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose