Please help us help you and fill where relevant:
LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
LimeSurvey Community Edition
Versión 6.17.7+260610
Own server or LimeSurvey Cloud: Own server OpenSuse 15.6, mariadb-10.11.15, php php8-8.2.30
Survey theme/template:
==================
I've maintaining a installation of LimeSurvey for several years and I've been update from various versions to the actual 6.17.7
I've downloaded and installed (as always) the new 7.0.1 version and start the admin page of our installation, since there is an version upgrade I've had a confirmation request for the database upgrade
Actualización de la estructura de la base de datosAsegúrate de guardar una copia de seguridad de la base de datos antes de continuar.Por favor verifique la siguiente información antes de continuar con la actualización de la estructura de la base de datos:Tipo de base de datos:mysqlNombre de la base de datos:limesurveyPrefijo de las tablas:lime_Nombre del sitio:xxxxxURL raíz:xxxxxxVersión de base de datos actual:651Versión objetivo de la base de datos:708
After confirmation the update seems to start but the process crash with the error:
CDbCommand falló al ejecutar la sentencia SQL: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'lime_responses_113543' already exists. The SQL statement executed was: CREATE TABLE `lime_responses_113543` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`submitdate` datetime DEFAULT NULL,
`lastpage` int(11) DEFAULT NULL,
`startlanguage` varchar(20) NOT NULL,
`seed` varchar(31) DEFAULT NULL,
`startdate` datetime NOT NULL,
`datestamp` datetime NOT NULL,
`ipaddr` text DEFAULT NULL,
`Q31490_S31528` varchar(5) DEFAULT NULL,
`Q31490_S31530` varchar(5) DEFAULT NULL,
`Q31494` text DEFAULT NULL,
...
This table exists on the current database and I don't kown why is triying to create it (I can't see a previous name change of this table)